Documentation

Documentation

  • Getting Started
  • Core Concepts
  • Using Fivetran
  • Usage-Based Pricing
  • Connectors
  • Applications
    • Application Reports
    • Lite Connectors
    • 15Five
    • 360Learning
    • 6sense
    • ActiveCampaign
    • Acumatica
    • Ada
    • Adjust
    • Adobe Analytics
    • Adobe Analytics Data Feed
    • Adobe Commerce
    • ADP Workforce Now
    • AdRoll
    • Affinity
    • Afterpay
    • Aha
    • Aircall
    • Airtable
    • Alchemer
    • Algolia
    • Amazon Ads
    • Amazon Attribution
    • Amazon Cloudfront
    • Amazon Selling Partner
    • Amplitude
    • Anaplan
    • Appcues
    • Appfigures
    • Apple App Store
    • Apple Search Ads
    • AppsFlyer
    • Asana
    • Assembled
    • Attentive
    • Attio
    • Aumni
    • Auth0
    • Autodesk BIM 360
    • AvantLink
    • Awin
    • AWS CloudTrail
    • AWS Cost Explorer
    • AWS Inventory
    • Azure Boards
    • Azure Devops
    • BallotReady
    • BambooHR
    • BigCommerce
    • BillingPlatform
    • Birdeye
    • Bitly
    • Blackboard
    • Braintree
    • Branch
    • Braze
    • Brevo
    • Brex
    • Buildkite
    • Buzzsprout
    • Calabrio
    • Calendly
    • Campaign Monitor
    • Canny
    • Canvas
    • Care Quality Commission
    • Castor EDC
    • Ceridian Dayforce
    • Chameleon
    • ChannelAdvisor
    • Chargebee
    • ChargeDesk
    • ChartMogul
    • Checkout.com
    • Chorus
    • Churnkey
    • ChurnZero
    • Cimis
    • Cin7
    • CircleCI
    • Clari
    • ClickUp
    • Close
    • Coassemble
    • Codefresh
    • Collibra
    • Column
    • commercetools
    • Confluence
    • Contrast Security
    • Copper
    • Coupa
    • Criteo
    • Crossbeam
    • crowd.dev
    • Customer.io
    • Cvent
    • D2L Brightspace
    • dbt Cloud
    • DCL Logistics
    • DEAR
    • Delighted
    • Deputy
    • Destini
    • Dixa
    • Docebo
    • Drata
    • Drift
    • Drip
    • Dropbox Sign
    • Duoplane
    • e-conomic
    • EasyPost
    • Ellucian Banner
    • Eloqua
    • Employment Hero
    • Epicor Prophet 21
    • Eventbrite
    • Everhour
    • Expensify
    • EZOfficeInventory
    • Facebook Ads
    • Facebook Pages
    • FinancialForce
    • Flexport
    • Float
    • Fone Dynamics
    • Forj Community
    • Fountain
    • Freightview
    • FreshBooks
    • Freshchat
    • Freshdesk
    • Freshdesk Contact Center
    • Freshservice
    • Freshsuccess
    • Freshteam
    • Friendbuy
    • Front
    • FullStory
    • Gainsight Customer Success
    • Gem
    • GetFeedback
    • GitHub
    • Gladly
    • GlobalMeet
    • GoCardless
    • Gong
    • Google Ad Manager
    • Google Ads
    • Google Analytics
      • Setup Guide
      • Prebuilt Reports
      • Google Analytics Troubleshooting
      • Release Notes
    • Google Analytics (MCF)
    • Google Analytics 360
    • Google Analytics 4
    • Google Analytics 4 Export
    • Google Calendar
    • Google Campaign Manager 360
    • Google Display & Video 360
    • Google Play
    • Google Search Ads 360
    • Google Search Console
    • Google Tasks
    • Gorgias
    • Greenhouse
    • GreenPowerMonitor
    • Grepsr
    • GRIN
    • Guru
    • HappyFox
    • Harvest
    • Heap
    • Height
    • Help Scout
    • Helpshift
    • HiBob
    • Hopin
    • HubSpot
    • iLevel
    • Impact
    • incident.io
    • Infobip
    • Insightly
    • Instagram Business
    • Integral Ad Science
    • Integrate
    • Intercom
    • Ironclad
    • ironSource
    • Iterable
    • Ivanti
    • Jira
    • Jira Align
    • Jotform
    • JustCall
    • Kandji
    • Katana
    • KeyPay
    • Khoros Care
    • Kissmetrics
    • Klarna
    • Klaviyo
    • Konnect Insights
    • Kustomer
    • Lattice
    • LaunchDarkly
    • LearnUpon
    • Lessonly
    • Lever
    • Liftoff
    • Lightspeed Retail
    • Linear
    • LinkedIn Ad Analytics
    • LinkedIn Company Pages
    • LinkSquares
    • LiveChat
    • Loaded Commerce
    • Lob
    • Looker
    • Loop
    • Loopio
    • Luma
    • Magento
    • Mailchimp
    • Mailgun
    • Mandrill
    • Marin Software
    • Marketo
    • Mavenlink
    • Maxio Chargify
    • Medallia
    • Megaphone
    • Meltwater
    • Mention
    • Microsoft Advertising
    • Microsoft Dynamics
    • Microsoft Lists
    • Microsoft Teams
    • Mixmax
    • Mixpanel
    • MNTN
    • Mode
    • Monday.com
    • Mux
    • Namely
    • Navan
    • nCino
    • NetSuite SuiteAnalytics
    • Notion
    • Nylas
    • Okta
    • Ometria
    • Open Data DC
    • Open Exchange Rates
    • Opsgenie
    • Optimizely
    • Oracle Business Intelligence Publisher
    • Oracle E-Business Suite
    • Oracle Fusion Cloud Applications
    • Oracle Moat Analytics
    • Oracle PeopleSoft
    • Oracle Siebel CRM
    • Orbit
    • Ordway
    • Ortto
    • OsCommerce
    • Outbrain
    • Outreach
    • PagerDuty
    • Papershift
    • Pardot
    • PartnerStack Vendor
    • PayPal
    • Pendo
    • Persona
    • Personio
    • Pingdom
    • Pinpoint
    • Pinterest Ads
    • Pipe17
    • Pipedrive
    • Pivotal Tracker
    • Piwik PRO
    • Playvox
    • PostHog
    • PowerReviews Enterprise
    • PowerSchool
    • PrestaShop
    • Prive
    • Productboard
    • Qualaroo
    • Qualtrics
    • QuickBooks
    • Ramp
    • Rarible
    • Recharge
    • Recurly
    • Reddit Ads
    • Reltio
    • Reply
    • RetailNext
    • Retently
    • Revel Systems
    • RevOps
    • RevX
    • RingCentral
    • Rippling
    • Rollbar
    • Rootly
    • RTB House
    • Sage HR
    • Sage Intacct
    • Sailthru
    • Salesforce
    • Salesforce Commerce Cloud
    • Salesforce Marketing Cloud
    • Salesloft
    • Salsify
    • Samsara
    • SAP Business ByDesign
    • SAP Business One
    • SAP Concur
    • SCORM
    • Security Journey
    • SendGrid
    • Sensor Tower
    • ServiceNow
    • ServiceTitan
    • Sharetribe
    • ShipHero
    • ShipStation
    • Shopify
    • Shopware
    • Short.io
    • Shortcut
    • Simplecast
    • Simplesat
    • Skilljar
    • SkuVault
    • Slab
    • Slack
    • Smadex
    • Smartwaiver
    • Snapchat Ads
    • SonarQube
    • Split
    • Splunk
    • Spotify Ads
    • Spree Commerce
    • Square
    • Squarespace
    • StackAdapt
    • Standard Metrics
    • Statsig
    • Statuspage
    • Stripe
    • Stylight
    • Subscript
    • SurveyMonkey
    • Survicate
    • Swoogo
    • Tableau
    • Taboola
    • Talkdesk
    • Talkwalker
    • Teamwork
    • Tempo
    • The Trade Desk
    • Thinkific
    • TikTok Ads
    • Toggl Track
    • Transcend
    • Trello
    • Trisolute
    • Twilio
    • Twitter Ads
    • Twitter Organic
    • Typeform
    • Unicommerce
    • Upland Software
    • UpPromote
    • UserVoice
    • Veeva
    • Verizon Media
    • Vitally
    • Vonage
    • VWO
    • Web Scraper
    • When I Work
    • Wherefour
    • WooCommerce
    • WordPress
    • Workable
    • Workday Financial Management
    • Workday HCM
    • Workday RaaS
    • Workday Strategic Sourcing
    • WorkflowMax
    • WorkRamp
    • Wrike
    • Xero
    • Xray
    • Yahoo DSP
    • Yahoo Search Ads on Yahoo Japan
    • Yotpo
    • YouTube Analytics
    • Zen Cart
    • Zendesk Chat
    • Zendesk Sell
    • Zendesk Sunshine
    • Zendesk Support
    • Zenefits
    • Zingtree
    • Zoho Books
    • Zoho Campaigns
    • Zoho CRM
    • Zoho Desk
    • Zoom
    • Zuora
  • Databases
  • Files
  • Events
  • Functions
  • Destinations
  • Partner-Built
  • Transformations
  • Logs
  • Security
  • REST API
  • Local Data Processing (HVR 6)
  • Release Notes
RSS
Release notes RSS
HVR 5 Documentation
HVR 5 Documentation
  • Support
  • Sign In
Edit on GitHub

Google Analytics link

Updated November 17, 2023

Google Analytics lets you analyze data about customer engagement with your website or application.

Google Analytics only allows us to connect to the reporting layer of their API, so we can't access all the raw data like we can for many of our other connectors. Instead, Google requires that it must be queried via a pre-defined report. Each time you go through the setup form, you'll be creating at least one new report.


Featureslink

Feature NameSupportedNotes
Capture deletes
Custom data
Data blockingcheck Column level and table level
Column hashingcheck
Re-synccheck Connector and table level
History
API configurablecheckAPI configuration
Priority-first sync
Fivetran data models
Private networking

Setup guidelink

Follow our step-by-step Google Analytics setup guide to connect Google Analytics with your destination using Fivetran connectors.


Sync overviewlink

2-day rollback synclink

During every sync for our Google Analytics connectors, we sync data from the last 2 days due to processing latency in Google Analytics. The processing latency depends on how many sessions a Google Analytics account sends and may be up to 48 hours.

7-day and 30-day trailing synclink

By default, Google Analytics gives you a lookback window of 30 days to track conversion-related data. A conversion takes place when a visitor to your website takes a relevant action and converts to a customer. This can be through completing a purchase, filling out a form, or by simply showing a high level of engagement with your website.

For example, let's say a customer makes a purchase on your website, and the goal of your analytics is to track completed purchases:

Historical sync

Day 1 - your website visitor adds several items to the cart and decides to not take any action.

Day 4 - the visitor adds a few other items to the cart but is still not ready to purchase.

Day 25 - the visitor goes back to the website and pays for the purchase.

Thus, the conversion goal is achieved on Day 25. A lookback window describes how far back you want to trace the data of your customers. The window considers conversion-related data from 30 days before the ultimate conversion.

We use a 7-30 trailing window approach to get your conversion-related data for the last 30 days. Once a day, we sync 1 day's worth of data from both 7 days ago and 30 days ago.

This approach allows us to fetch all of your important data using fewer API calls than a rollback sync. We don't use a rollback sync for the entire 30-day period because every sync would take a long time and exceed the API quotas that are limited in the Google Analytics API.

When you sync Google Analytics with Fivetran, the following three features affect the nature of your connector:

  • Sampling
  • Segments
  • Filter

Samplinglink

Users who aren't on the Google Analytics 360 tier of Google Analytics get sampled data when their reporting query exceeds Google's pre-defined compute threshold. The query's computational load is driven by both the volume of data that needs to be queried and by the complexity of the aggregations. Fivetran minimizes sampling by querying for data in single-day increments. You can find more information on sampling in Google Analytics' documentation.

Google Analytics 360 users may also get sampled data, however, they can have all the raw row-level data loaded into their Google Cloud Storage, which we also sync with your warehouse.

Segmentslink

A segment is a subset of your analytics data. For example, of your entire set of users, one segment might be users from a particular country or city. Another segment might be users who purchase a particular line of products or who visit a specific part of your site. Some dimensions and metrics reports cannot be queried together, and in this case our setup form will display an error. You can find more information about choosing dimensions that don't clash in our setup instructions.

Filterlink

The filters query string parameter restricts the data returned from your request. To use the filters parameter, supply a dimension or metric on which to filter, followed by the filter expression. For example, ga:country==United States&ga:browser==Firefox, given the request will return data only for the country United States and browser Firefox. The filter expression should contain only those dimensions and/or metrics which you have chosen in your setup form.

Potential data mismatchlink

Metric values returned by Google Analytics strongly depend on which dimensions are included in a report. The values you see in your Google Analytics dashboard versus your destination table may not match if the dimensions in the dashboard and the dimensions requested by the Fivetran connector do not match.

IMPORTANT: We strongly recommend using the UA Query Explorer provided by Google Analytics to compare your source and destination values. This tool uses the Core Reporting API, which better imitates connector reports. Make sure you specify the exact same dimensions, metrics, and filters in the Query Explorer as you configured in your Fivetran setup form.

Another important factor that affects metric values (numbers and values of conversions) is a lookback window. The Google Analytics User Interface lets you adjust the lookback window from 1 to 90 days, while the Google Analytics API utilized by Fivetran connector uses a non-adjustable 30-day lookback window. If you set the lookback window in your Google Analytics UI to anything other than 30 days, you may observe data mismatch.

The connector syncs conversion-related data using the trailing window of 7-30 days so that fresh data for the last 30 days is delivered to the destination.

API versionlink

The connector uses the Google Analytics Reporting API v4 to access the source.

MAR Impactlink

Google Analytics provides a lookback window of 30 days to track conversion-related data. To capture this data, along with syncing data for the last 2 days during every sync, we also sync 1 day's worth of data from both 7 days ago and 30 days ago once a day. As a result, we capture two months' worth of data per month. This means your Monthly Active Rows (MAR) are double the number of new rows added in your Google Analytics source. For example, if one million new rows are added to your source per month, the MAR usage for your Google Analytics connector is two million.


Schema informationlink

We provide the following types of reports:

  • Prebuilt Report
  • Custom Report

Fivetran will deliver tables with the date, profile, and unique_id fields for either kind of report. A Prebuilt Report syncs a pre-defined set of fields. See the full list of our Prebuilt Reports. For a Custom Report, you can add up to six additional dimension fields and ten additional metric fields.

columntypenotes
dateDATEstandard field
profileSTRINGstandard field
unique_idSTRINGstandard field
dimension\custom field
metric\custom field

Updating datalink

Because the Google Analytics data is delivered in a cube, changing the way that the cube is formatted is difficult; adding in (or removing) fields changes the way the data is aggregated and synced. This would require that we alter the data in your existing warehouse to ensure consistency.

To ensure that the data you're receiving is reliable, we require that you create an entirely new connector for the updated version of your Google Analytics report. You must either:

  • Name this new/modified report something different than the previous version. Or
  • Keep the name of the new/modified report and sync it into a different schema.

NOTE: Google Analytics delivers optimal performance in the context of intraday data refreshes. For more information, see Google's Enhanced Data Freshness documentation.


Limits on querieslink

The date dimension is required because the reports are synced by day.

Not all dimensions and metrics can be queried together. Only certain dimensions and metrics can be used together to create valid combinations. Our connector setup form will ensure combinations are valid. However, checking yourself beforehand will avoid any surprises.

Use these Google resources to pick your metrics and dimensions:

  • Review dimension or metric description with GA4 Dimensions & Metrics Explorer.

  • Use the GA4 Query Explorer to review the report yielded by a given combination of dimensions and metrics.


Questions?

We're always happy to help with any other questions you might have! Send us an email.

    Thanks for your feedback!
    Was this page helpful?