Zoomdata Version

Connecting to Google Analytics

CAVEATS

  • This connector is based on Core Reporting API Version 3.0.
  • Parametrized (XX) metrics are not supported.
  • DoubleClick Campaign Manager category is not supported.
  • Check Google Analytics limitations before beginning setup.

BEFORE YOU BEGIN

You need to complete the following tasks before you start configuring the connector:

  1. Create a project in your Google Analytics developer account . When a project is created, click its name in the projects table.
  2. Enable Analytics API. To do this, on the project settings page, expand the APIs & auth section and click APIs . In the Advertising APIs section, click Analytics API .

Figure 1

  1. On the Analytics API page, click Enable API .
  2. Create new client ID. To do this, in the APIs & auth section, click Credentials . After this, in the OAuth section, click Create new Client ID .

Figure 2

In the Create Client ID window, select the Web application type.
In the Authorized Javascript origins field, specify the URLs to the environments, which you want to connect to.
In the Authorized redirect URIs field, specify URI, that consists of the address of your environment and  the /oauth/connection/callback/GOOGLE_ANALYTICS part.
For example:
https://env.zoomdata.com:443/zoomdata /oauth/connection/callback/GOOGLE_ANALYTICS

Figure 3

Click Create Client ID .

  1. The client ID for your app will be created and Client ID and Client Secret will be generated.

CONFIGURING THE CONNECTOR

To configure the connector, perform the following steps:

  1. Log into Zoomdata.
    Administrators and users with appropriate access privileges can connect data sources in Zoomdata.
  2. Click the Sources menu item.

Figure 4

  1. Click the Google Analytics connector icon.
  2. Specify the name of your source and add a description (if desired).

Figure 5

  1. Click Next .

Figure 6

  1. On the Connection page, define the connection source. You can use an existing connection, if available, or create a new one.
    To create a new connection, select the Input New Credentials option button and specify the connection name. Copy your client ID and client secret from your Google analytics developer account and paste the credentials into the corresponding fields. Click Validate . When your credentials are verified, click Authorize .
    On the confirmation page, click Accept to allow Zoomdata to view your Google Analytics data.

Figure 7

  1. On the Connection page, click Next .
  2. On the Profiles page, select the account, property, and profile. Click Next .

Figure 8

  1. On the Categories page, select Google Analytics categories and select up to 7 dimensions and up to 10 metrics to be queried. Specify the time period for the data to be imported.
    Click Preview to verify if the selected dimensions and metrics and be queried together. After successful verification, click Next .
  2. On the Fields page, create unique label names for the available fields in your data source. These labels will be displayed in the charts. Specify the required name in the Label field. If necessary, change the Type and Default options. Select the checkboxes in the Distinct Count column to enable this option. Click Next to continue.

Figure 9

  1. On the Refresh page, you can schedule asynchronous jobs to refresh fields in your data source. Refer to Using the Zoomdata Scheduler article for more information.
  2. On the Charts page, you can:
  • Edit Global Default Settings
  • Select the Standard and, if available, Custom chart styles to be used with the data source
  • Set default parameters  (group-bys, colors, sorting, etc.) for each chart style
Learn more about how to customize a chart .


Figure 10

  1. ​Click Finish to save your changes.