Get started with Dreamdata
Dashboards
Revenue Analytics
Journeys
Performance
Paid
Bing Ads
Capterra Ads
Cost
Facebook Ads
G2 Crowd
Google Display Ads
Google Search Ads
LinkedIn Ads
Overview
Return on Ads Spend
YouTube Ads
Organic
Acquisition
Conversions
Web Traffic
Real-Time View
Tracking
Anonymizing IP
Calendly
Cookie Bar
Cookie Retention
Dreamdata Cookies
Emails
Google Tag Manager
How does Dreamdata track all relevant on-site customer data?
Load analytics.js from your own domain
Pardot iframe form tracking
Query parameters
Server Side Analytics APIs
Setting up Dreamdata Web tracking (analytics.js)
Setting up tracking with Segment
Tracking Forms
Guides
Allowed Domains
How to invite Sales team members to Dreamdata
Shared Reports
Single sign-on
UTM Mapping
FAQ
Can I exclude content or websites from being tracked?
Categories
Conversions
Some of my deals are flagged with "no-tracking". What does it mean?
Stage models in Dreamdata Free
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?
Attribution Models
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?
Data Platform
Sources
Custom Integration
Setting up AdRoll
Setting up Agile CRM
Setting up Bing Ads
Setting up Capterra
Setting up Close
Setting up Facebook Ads
Setting up G2 Crowd
Setting up Google Ads
Setting up Google Search
Setting up Google Sheets
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
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
Data Enrichment
Overview
Table Schema
Settings
- All Categories
- Data Platform
- Destinations
- Google Connected Sheets
Google Connected Sheets
Updated
by Steen Voersaa
If spreadsheets is your preferred business intelligence tool, then Google Connected Sheets is perfect for you.
With Connected Sheets, you can access, analyze, visualize, and share billions of rows of BigQuery data from your Sheets spreadsheet.
You can also do the following:
- Collaborate with partners, analysts, or other stakeholders in a familiar spreadsheet interface.
- Ensure a single source of truth for data analysis without additional spreadsheet exports.
- Streamline your reporting and dashboard workflows.
Connected Sheets runs BigQuery queries on your behalf either upon your request or on a defined schedule. Results of those queries are saved in your spreadsheet for analysis and sharing.
Google Cloud Platform
To use Connected Sheets you need Google Cloud Platform account and configure access to your Dreamdata BigQuery database. 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.
Connecting your Google Sheet to BigQuery
Connecting your Google sheet to your BigQuery dataset is easy and can be accomplished in only a few steps.
- Create or open a Sheets spreadsheet
- Click Data, click Data connectors, and then click Connect to BigQuery
- Click Get connected
- Select a project and a dataset
- Click Connect
- Start your analysis
Working with Connected Sheets
Once connected, you have full access to all Dreamdata data models. Using familiar Sheets techniques, you can create charts, pivot tables, formulas, calculated columns and subsequently extract your analysis to sheet.
Connected Sheets have taken spreadsheets to a whole new level.
Tutorials
Google has created a series of very useful video tutorials to get you started with Connected Sheets. You find them here.