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]
How to invite your colleagues to Dreamdata
Which channel performs best for different content?
Which content influenced the MQLs created in a time period?
Content Performance - Dashboard Options
Which content generates pipeline?
Measuring influenced pipeline for B2B content - the true conversion metric
What KPI to measure the effect of B2B content?
Setup Content Reporting
Content Analytics - Dashboard Options
Return on Ads Spend
Google Search Ads
Google Display Ads
Performance vs. Revenue attribution: A guide on when to use what
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
Import fixed cost data using Google Sheet
Importing data not in your CRM (using Google Sheets)
Import cost data using Google Sheet
Setting up Outreach
Setting up Zapier integration & Zaps for Lead Ads
Setting up Google Search
Setting up Intercom
Connect to AWS Redshift using AWS Glue
Connect your Dreamdata data to Snowflake
Connect your Dreamdata data to Amazon Redshift
Guides for Looker Studio Reporting
Getting Started with Looker Studio Templates
Google Connected Sheets
Setting up Data Export to BigQuery of CRM Properties
Company Data Enrichment
Reduce impact from ad-blockers and Apple ITP 2.x
Pardot iframe form tracking
Tracking using Sleeknote or Drift
How to track your emails?
How does Dreamdata track all relevant on-site customer data?
Tracking Hubspot Forms with auto-identify script
Server Side Analytics APIs
URL query parameters
Tracking iframes with auto-identify script
Tracking SPAs (Single Page Applications)
Across domain & device tracking
Advanced Identification of users and companies
Setup Guide: All Salesforce Opportunities entering specific Stage
Setup Guide: Creation of Opportunities/Deals
Setup Guide: Tracked sign-up events
Setup Guide: All Hubspot Deals entering specific Stage
Stage Models - Customization
Branded Search filter
CRM-Based Channel and Source in the Absence of Tracking Activity
Some of my deals are flagged with "Unknown". What does it mean?
Can I exclude content or websites from being tracked?
How are activity mapped to companies?
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?
Referral Guide and UTM tracking
Intro Template for your new clients
Ideal Customer Profile
Co-marketing and account mapping
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
Updated by Steen Voersaa
By default, at Dreamdata we build your database on Google BigQuery. However, through our Google Cloud Storage Integration you can connect the raw dataset of your Dreamdata database and easily connect it to Amazon S3 and then on to Redshift.
Google Cloud Platform
To use Google Cloud Storage you first need an Google Cloud Platform account.
Dreamdata is an Google Cloud Partner, and if you have not already signed up to Google Cloud Platform you can do it here and get $500 of free credits. If you are not familiar with Google Cloud Storage and want to learn more, take a look at these how-to guides.
After you have acquired a Google Cloud Platform account, go here to set up the necessary access integration details. Once the integration is configured, we will begin to generate your raw datasets on 6-hour schedule.
Some key points:
- This data will be hosted in the region of your choosing
- Dreamdata will pay the data storage costs
- You will pay for exporting costs
We will want to know the following:
- The region/zone of your Google Cloud Platform.
- You Google Cloud Platform service account.
- A list of emails of users that should have access to the exported dataset.
- A list of Google group email addresses that should have access to the dataset.
Note: Either (3) or (4) is required.
Exporting your data to AWS
After you have configured the Google Cloud Storage integration and gained access to your files, any one of the following methods can be used to transfer data from Google Cloud Storage to AWS S3 from where it can be loaded into Redshift.
- AWS Glue: This article describes how to query data from AWS Redshift using AWS Glue.
- Amazon EMR: This article describes how to copy the raw files from Google Cloud Storage directly to AWS S3 using Amazon EMR and how to run the task on a schedule.
- Apache Airflow: This article describes how to programmatically author, schedule and monitor workflows.
- CLI: This article describes how to connect data using CLI (an approach will work between any two cloud storage providers).
Once connected, you can run your own queries on our data models, as well as copy, manipulate, join and use the data within other tools connected to Redshift.