Google Analytics

Establish Connection Between Kodda and Google Analytics

1. Create API Project

Create or use an existing project in the Google Developers Console as a first step.

Go to https://console.developers.google.com/project and sign in to your Google/Gmail account. Once signed in, you'll see a list of existing projects (if there are any) or you can click Create project to create a new one.

2. Enable APIs

The following api's are required in order to retrieve Google Analytics data.

  • Universal Analytics

    • Google Analytics API

    • Google Analytics Reporting

  • Google Analytics 4

    • Google Analytics Data API

    • Google Analytics Admin API

To enable APIs after account is created, select "Explore and enable APIs"

Search for the "Google Analytics Reporting API" and select Enable. Follow same steps for the Google Analytics API.

3. Generate A Service Account

This section shows you how to generate Service account credentials which will allow Kodda access your Google Analytics data.

From the left navigation, click Credentials. Click Create credentials and select the Service account option. Enter name. Role is optional.

After service account is created, select the account and create a key and download the JSON file.

4. Grant Service Account GA Access

Go to your google analytics account > admin > account user management and add the service account email address as a user.

5. Create Connection in Kodda

See manage connections

Integrate Data from GA

Select Source

To move data from Google Analytics, you'll generate a new mapping and select your google analytics connection as the source and point to the target of your choosing.

Select account, property, and views you would like to use, these will be populated automatically and the choices will depend on the configuration of your Google Analytics account(s) If not sure which to use, reference google's documentation for additional information.

Select Query Parameters

Select the start date, metrics, dimensions, filters, segment. For a full list available choices reference Google's Dimension and Metrics explorer.

Field

Description

Start Date

Per googles documentation all GA mappings must specify a date range. The minimum value allowed for the start date is 2005-01-01. Kodda will always use the current date as the end date.

Metrics

Choose the metrics you would like to include in your Google Analytics report. See google analytics documentation on metrics for more information. All mappings must include a minimum of 1 metric and a maximum of 10.

Dimensions

Date is added by default and will be needed if you intend on loading your data incrementally to your target. If you intend to use a load pattern that does not incrementally load data than you may remove the default ga:date selection. See google analytics documentation on dimensions for more information. All mappings must include at least 1 dimension and a maximum of 7.

Filters (Universal Analytics Only)

This parameter is an optional expression that is used to filter the result set. Mappings are not required to have filters applied. See filters

Segment (Universal Analytics Only)

This is an optional value that can be specified to limit the result set to a single segment. Mappings are not required to have a segment selected. See segment

Select Target Schema

Select the schema to place the target table object. You may select an existing schema from the drop down list or type your own schema name and press enter.

Select Target Table

Select the target table you would like to write the data. You may select an existing table from the drop down list or type your own table and press enter.

Available Activities

  • Generate Mapping

  • Preview

Mapping Options

For a full reference of run-time options available on a mapping see Generate Mapping/Options. There is one Run-time option that is unique to Google Analytics connections.

Toggle

Description

Use Daily Extract

When toggled on, Kodda will pull each day as a API separate call. This will reduce sampling on free google analytics accounts.

Last updated