Get started with Dreamdata
How to invite your colleagues to Dreamdata
How to set up Dreamdata Web tracking (analytics.js) manually
How to set up up Dreamdata web tracking (analytics.js) using Google Tag Manager
How to track forms adding the auto-identify script via Google Tag Manager.
Onboarding for paying customers [VIDEO]
Onboarding process for free customers [VIDEO]
Setting Up Dreamdata
Single sign-on
The Onboarding Process
What is Dreamdata? [VIDEO]
Dashboards
Home
Engagement
Content Reporting
Analytics
Performance
Content Performance - Dashboard Options
Which channel performs best for different content?
Which content generates pipeline?
Measuring influenced pipeline for B2B content - the true conversion metric
Setup Content Reporting
What KPI to measure the effect of B2B content?
Performance
Paid
Ad Spend
Bing Ads
Capterra Ads
Facebook Ads
G2 Crowd
Google Display Ads
Google Search Ads
LinkedIn Ads
Overview
Return on Ads Spend
YouTube Ads
Organic
Acquisition
Conversions
Performance vs. Revenue attribution: A guide on when to use what
Web Traffic
Journeys
Revenue Analytics
Data Platform
Sources
Albacross
Clearbit Reveal
Custom Integration
Import cost data using Google Sheet
Importing historical data to Dreamdata using Google Sheets
RollWorks Site Traffic Revealer
Setting up AdRoll
Setting up Bing Ads
Setting up Capterra
Setting up Close
Setting up Data Export to BigQuery of CRM Properties
Setting up Facebook Ads
Setting up G2 Crowd
Setting up Google Ads
Setting up Google Search
Setting up HubSpot
Setting up Intercom
Setting up LinkedIn Ads
Setting up Marketo
Setting up Microsoft Dynamics
Setting up Pardot
Setting up Pipedrive
Setting up Salesforce
Setting up Twitter Ads
Setting up Zapier integration & Zaps for Lead Gen forms/Lead Ads
Setting up Zendesk Sell
Setting up Zoho CRM
Triblio ABM platform
Destinations
Connect to AWS Redshift using AWS Glue
Connect your Dreamdata data to Amazon Redshift
Connect your Dreamdata data to Snowflake
Getting Started with Google Data Studio Templates
Google BigQuery
Google Cloud Storage
Google Connected Sheets
Guides for Google Data Studio Reporting
LinkedIn Offline Conversion
Data Enrichment
Intent data
Overview
Table Schema
General Settings
Tracking
Segment
Advanced Identification of users and companies
Anonymizing IP
Calendly
Cookie Bar
Cookie Retention
Dreamdata Cookies
Form Tracking
How does Dreamdata track all relevant on-site customer data?
How to track your emails?
Pardot iframe form tracking
Query parameters
Reduce impact from ad-blockers and Apple ITP 2.x
Server Side Analytics APIs
Tracking Hubspot Forms with auto-identify script
Tracking SPAs (Single Page Applications)
Tracking iframes with auto-identify script
Tracking using Sleeknote or Drift
Allowed Domains
Menu: Settings
Setting up your customised Stage Models
Setting up your default Stage Models
UTM Mapping
FAQ
Can I exclude content or websites from being tracked?
Categories
Roles and Permissions
Some of my deals are flagged with "no-tracking". What does it mean?
What does Visitors, Contacts and Companies mean?
What is a Stage Model?
What is a company in Dreamdata?
What is a session?
Why are my dashboards empty?
Agency Partners
Contact
Ideal Customer Profile
Intro Template for your new clients
Partner Material
Partner Tiers
Referral Guide and UTM tracking
Welcome Partner!
Quick learning videos!
Are you using G2?
Do you know how your company is generating money?
Do you know which of your Marketing activities had the biggest impact on pipeline and revenue?
Dreamdata Content Analytics: Discover the real value of your content
Find the content that generates most pipeline
Helping BDRs break through to the hottest accounts
How Content Analytics tracks the influence of content of pipeline and revenue
How to cut the cost of your Google Search Ads
How to easily build a retargeting audience with Dreamdata
How to see the value of B2B Google Ads in pipeline and revenue generated
How to set up content categories on Dreamdata
Performance vs. Revenue Analytics reports- when to apply them best!
See the value of SEO in pipeline and revenue generated
What attribution really is and why you should care!
Which of your emails produce pipeline and revenue?
- All Categories
- Data Platform
- Sources
- Setting up Data Export to BigQuery of CRM Properties
Setting up Data Export to BigQuery of CRM Properties
Updated
by Iker Camara
Dreamdata pulls information from standard objects in your CRM.
Properties on these objects can be made available in Dreamdata's Data Product in BigQuery (or connected cloud buckets).
Example of properties could be custom dates, amount fields, account status or in general any field available on the main CRM objects.
You can select the properties that you want to be exported on the integrations page of your CRM. The path inside the app is Data Platform > Sources.
At the moment, the export feature is supported for HubSpot and Salesforce.

Why is this useful?
The information that you have stored in your CRM will be available in Dreamdata's Data Product, which removes the need to use external tables to perform analysis.
Where will I find my custom fields?
Once you have selected the data you want to be exported, we will add an extra column custom_properties in one of the tables: companies, contacts and revenue, depending on which object you selected properties from.
Every object in the CRM has a corresponding Dreamdata table where we add the field. For example, properties of Deals in HubSpot or Opportunities in Salesforce will be added to the revenue table.
How do I use custom_properties?
First, you will need to extract them as the custom_properties column is of type JSON string. Here is a SQL query as an example.
It is a good practice to cast those properties that represent a date or a numeric value for later use.
SELECT
*,
JSON_EXTRACT_SCALAR(custom_properties, "$.[property_name]") AS property_name,
CAST(
JSON_EXTRACT_SCALAR(custom_properties, "$.[property_date]") AS TIMESTAMP
) AS property_date
FROM
`dreamdata.[company_name].revenue`
Second, if you want to add the new fields to one of our activity tables like revenue_attribution or session_performance you will have to perform a join between the tables.
To join with an activity table the following join keys should be used to be sure that you pass the information correctly:
- revenue: dealId and revenueModel
- companies: companyId
- contacts: email and companyId
Example:
1) The query below passes field_1 to the events table, so we can do a segmentation analysis based on the classification in field_1.
WITH custom_companies AS (
SELECT
companyId
, JSON_EXTRACT_SCALAR(custom_properties, "$.field_1") AS field_1
FROM
`dreamdata.[company_name].companies`
)
SELECT
r.*
, c.field_1
FROM
`dreamdata.[company_name].events` AS r
LEFT JOIN custom_companies AS c ON r.companyId = c.companyId
2) To add a property from an opportunity to the data available in the revenue_attribution table, we join the property from the revenue table where the opportunities using the join key's dealId and revenueModel
WITH opps_property AS (
SELECT
dealId
, revenueModel
, JSON_EXTRACT_SCALAR(custom_properties, "$.field_1") AS field_1
FROM
`dreamdata.[company_name].revenue`
)
SELECT
r.*
, c.field_1
FROM
`dreamdata.[company_name].revenue_attribution` AS r
LEFT JOIN opps_property AS c
ON r.dealId = c.dealId
AND r.revenueModel = c.revenueModel