Google Analytics
This page describes how to use Census with Google Analytics

๐Ÿƒโ€โ™€๏ธ Getting Started

In this guide, we will show you how to connect Google Analytics to Census and create your first sync.

Prerequisites

Step 1: Configure Your Google Analytics Account

Prior to adding Google Analytics as a Service Connection in Census you'll need to:

1A: Custom Dimension Set Up

  • Navigate to your Google Analytics account. Click into Admin Settings-->Custom Definitions-->Custom Dimensions
Create a Custom Dimension
  • Create a new custom dimension or view existing ones. If creating a new one click "New Custom Dimension" then provide a name and scope it to the User.

1B: Create the Data Set

  • Navigate to the Data Import tab within the Settings to view existing data sets or Create a new one.
  • If creating a new Data Set start by setting the Data Set type to User Data
  • Under Data Set Details provide a name and select the views that will use the data in the Data Set
  • Finally, under Data Set schema Select a key from your dimensions and then select the data you'll import.

Step 2: Create the Census Connection

  • Navigate to the Census Connections page and click Add Service
  • Select Google Analytics from the drop down list
  • Follow the Google OAuth flow to connect your Google Analytics account and allow Census the appropriate permissions
  • Once redirected back to Census select the Google Analytics account you want to sync to
Select a Google Analytics account

Step 3: Create your first sync

The sync will move data from your warehouse to your Google Analytics account. In this step, you'll define how that will work.
  1. 1.
    From inside your Census account, navigate to the Syncs page and click Add Sync.
  2. 2.
    Under What data do you want to sync?, choose your data warehouse as the Connection and your source: either a Model from the Census Models tab or a database table.
  3. 3.
    Under Where do you want to sync data to?, choose the Google Analytics account you created in Step 2 as the Connection.
    • Under Object select one of the data sets you created in Step 1.
  4. 4.
    Under How should changes to the source be synced?, Mirror will be automatically selected. This is the only supported sync behavior for Google Analytics.
  5. 5.
    Under Which properties should be updated? Add the fields from your data set you'd like to send to Google Analytics
  6. 6.
    Click the Next button to see the final preview which will have a recap of what will happen when you start the sync. If you're happy, check the Sync Now checkbox and save the sync.
  7. 7.
    Confirm the data arrives in Google Analytics!
If you need any help configuring Google Analytics, contact the Census support team to get some help.

๐Ÿ—„ Supported Objects

The available Objects for the Google Analytics destination are the data sets associated with your selected Google Analytics account.
โ€‹Contact us if you want Census to support more objects for Google Analytics.

๐Ÿ”„ Supported sync behaviors

Behavior
Supported
Objects
Mirror
โœ…
All
Learn about all of our sync behaviors in Core Concepts.
โ€‹Let us know if you want Census to support additional sync behaviors for Google Analytics.

๐Ÿ’ก Things to know

  • Google Analytics has limits to how frequently properties are updated per day so you may want to avoid continuous syncs, especially if youโ€™re importing data through other mechanisms
  • For many Google Analytics reports, data imported this way will only shows up if the User ID has been used as a visitor to the property in the last 30 days.
  • Data takes up to 24 hours to be fully indexed by google
  • The Google Analytics destination currently uses the Universal Analytics API
โ€‹Contact us if your use cases don't work with these limitations. We'd love to hear how we can make this connection better in the future!