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.

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.