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
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