Get started with Dreamdata
What is Dreamdata? [VIDEO]
Setting Up 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.
The Onboarding Process
Onboarding process for free customers [VIDEO]
Onboarding for paying customers [VIDEO]
Single sign-on
How to invite your colleagues to Dreamdata
How to validate your data
Dashboards
Home
Engagement
Performance
Content Performance
Setup Content Reporting
Content Performance - Dashboard Options
What KPI should you use to measure the effect of B2B content?
Measuring influenced pipeline for B2B content - the true conversion metric
What content generates pipeline?
Which channel performs best for different content?
Paid
Overview
Return on Ads Spend (ROAS)
Google Search Ads
Google Display Ads
LinkedIn Ads
Bing Ads
Facebook Ads
YouTube Ads
Capterra Ads
G2 Crowd
Organic
Acquisition
ROI
Performance vs. Revenue attribution: A guide on when to use what
Journeys
Revenue Analytics
Data Platform
Sources
Intent Data
Albacross
Snitcher
6sense
RollWorks
Dealfront Leadfeeder
ZoomInfo WebSights
Clearbit
Triblio ABM platform
Paid
Setting up Facebook Ads
Setting up AdRoll
Setting up Twitter Ads
Setting up Bing Ads
Setting up LinkedIn Ads
Setting up Google Ads
Setting up G2
Setting up Capterra
CRM
Marketing Automation
Import Other
Import fixed cost data using Google Sheet
Import Events data using Google Sheet
Import cost data using Google Sheet
Custom data
Setting up Outreach
Setting up Zapier integration & Zaps for Lead Ads
Setting up Google Search
Setting up Intercom
Destinations
Ad Network
LinkedIn Offline Conversion (CAPI)
Google Ads Offline Conversion
Google Ads Offline Conversion: Salesforce vs Dreamdata
Google Ads Offline Conversion: Hubspot vs Dreamdata
Data Warehouse
Google BigQuery
Connect to AWS Redshift using AWS Glue
Connect your Dreamdata data to Snowflake
Connect your Dreamdata data to Amazon Redshift
Cloud Storage
Business Intelligence
Guides for Looker Studio Reporting
Getting Started with Looker Studio Templates
Google Connected Sheets
Setting up Data Export to BigQuery of CRM Properties
Overview
Company Data Enrichment
Table Schema
Intent data
General Settings
Tracking
Segment
Dreamdata Cookies
Form Tracking
Reduce impact from ad-blockers and Apple ITP 2.x
Pardot iframe form tracking
Anonymizing IP
Tracking using Sleeknote or Drift
How to track your emails?
Cookie Bar
How does Dreamdata track all relevant on-site customer data?
Cookie Retention
Tracking Hubspot Forms with auto-identify script
Server Side Analytics APIs
URL query parameters
Calendly
Tracking iframes with auto-identify script
Intercom Tracking
Tracking SPAs (Single Page Applications)
Across domain & device tracking
Advanced Identification of users and companies
Tracking Dynamics 365 Marketing Forms
Attribution Models
Stage Models
Setup Guide: All Salesforce Opportunities entering specific Stage
Setup Guide: All Microsoft Dynamics Opportunities in a specific Stage
Setup Guide: All Pipedrive Deals entering specific Stage
Setup Guide: Creation of Opportunities/Deals
Setup Guide: Tracked sign-up events
How Dreamdata Handles Currency Exchange in Stage Models
Setup Guide: All Hubspot Deals entering specific Stage
Stage Models - Customization
Menu: Settings
Allowed Domains
UTM Mapping
Learn more about the 'Branded Search' filter
CRM-Based Channel and Source in the Absence of Tracking Activity
CRM filters
FAQ
Glossary
Conversions
What is a company?
Some of my deals are flagged with "Unknown". What does it mean?
Data retention and deletion
How is anonymous traffic linked to companies?
Can I exclude content or websites from being tracked?
Influenced vs Attributed Leads and Value
Understanding the Difference: Conversions vs. Stages
What does Visitors, Contacts and Companies mean?
What is a session?
Roles and Permissions
What is the reporting Time Zone?
Why are my dashboards empty?
Agency Partners
Welcome Partner!
Partner Tiers
Referral Guide and UTM tracking
Partner Material
Intro Template for your new clients
Ideal Customer Profile
Co-marketing and account mapping
Contact
Quick learning videos!
Find the content that generates most pipeline
How to set up content categories on Dreamdata
Do you know how your company is generating money?
How to see the value of B2B Google Ads in pipeline and revenue generated
How Content Analytics tracks the influence of content of pipeline and revenue
How to easily build a retargeting audience with Dreamdata
Are you using G2?
Performance vs. Revenue Analytics reports- when to apply them best!
What attribution really is and why you should care!
Helping BDRs break through to the hottest accounts
Dreamdata Content Analytics: Discover the real value of your content
Do you know which of your Marketing activities had the biggest impact on pipeline and revenue?
Which of your emails produce pipeline and revenue?
See the value of SEO in pipeline and revenue generated
How to cut the cost of your Google Search Ads
- All Categories
- Data Platform
- Sources
- Import Other
- Import Events data using Google Sheet
Import Events data using Google Sheet
Updated
by Andreea Oprea
If you have data that is not available in your CRM but that you would like to see in Dreamdata's platform we have enabled a solution to upload data using Google Sheets (following this template). This could be data from any field marketing activities (e.g. webinars, conferences, in-person events and trade shows).
Dreamdata will connect the uploaded events (such as webinars, conferences, etc.) to stages and the reports available in the App.
Follow these steps to setup:
- Download the template.
- Insert your events data (see explanation below) and share the sheet with google-sheets@dreamdata.io
- Paste the sharing link of the Google Sheet into the empty field found under Sources -> Import Events data and click Upload Link. You can add as many sheets as you need.
Where do I see the result of adding events data?
The shared events data will be visible in the Event report (found under the Engagement section) and any new data added to the sheet will be automatically included. The events are then used throughout the App as filters in all the relevant reports.
How do I use the template?
The event data is imported using the schema as shown in the template.
Please do not: add new tabs to the sheet, add extra columns, rename or rearrange any of the columns as the data will not be uploaded correctly.
One sheet can have maximum 250 000 rows, if you have more relevant data please split it in multiple sheets

Required columns:
event: the name of the event (any names are accepted and there is no limit for how many names can be added)
email: email address of someone that attended the event (attendee)
timestamp: the date and time when the event happened (format YYYY-MM-DD hh:mm:ss)
Optional columns:
event_id: can be used for debugging
user_id: if data comes from a platform that provides this information
company_id: if data comes from a platform that provides this information
website: website of the company where the event attendee is employed
company_name: company where the event attendee is employed
url: used for online events only, if the event is accessed through a url
referrer: from where the above url was accessed
source: some examples are webinar and conference. This should match a sources shown in the Dreamdata platform (case sensitive)
channel: can be the same as the source or a group of sources. This should match a channels shown in the Dreamdata platform (case sensitive)
region: region of the country of the event attendee
country: country of the event attendee
city: city of the event attendee
browser: used for online events only, where the url was accessed
browser_version: version of above browser
os: used for online events only, operating system through which the browser was accessed
os_version: version of above operating system
device: used for online events only, one of the following choices: desktop, mobile, tablet and tv