Connector Dialog for Google Analytics

Enter values into the dialog box to connect and fetch data from your Google Analytics source. You will need the following to fetch Google Analytics data:

• Service Account e-mail

• Key File

• Profile ID

Note that some date/time data imports from Google Analytics may display differently in Monarch Data Prep Studio. For example, average time values (under Metrics), such as Avg. Session Duration and Avg. Time on page, display in Google Analytics in HH:MM:SS format but display in Monarch Data Prep Studio in SS (seconds) format . You can use the date/time formatting options of Monarch Data Prep Studio to format the necessary fields after import these data into the application.

Options

Field	Description
Service Account E-mail	The Service Account ID that is generated while creating credentials for the service account authentication.
Key File Path	Location of the Key File furnished by Google Analytics when you created the Service Account. You can also click Browse to select the path of the key file.
Get Accounts	Click to fetch accounts associated with the Service Account E-mail.
Accounts	Select your Google Analytics Account from the drop-down.
Properties	Select the Property defined for your account.
Views	Select a corresponding view for the Property.
Start Date/End Date	Select the data range that will be used to filter the Google Analytics rows.
Fetch Dimension and Metrics	Click to select the Dimensions and  Metrics valid for the Google Account you have specified. This populates the Categories, Dimensions and Metrics list boxes.
Categories	Click to navigate and select a Google Analytics Category.
Dimensions	Double click to select a Google Analytics Dimension.
Metrics	Double-click to select a Metric.
Selected Columns	Displays the columns that have been fetched.
Validate Selection	Validate the Dimensions and Metrics you have selected.
Preview Data	Click to fetch data using the credentials and criteria you have specified. 10 records are displayed to allow you to verify that you are selecting the correct data.

 

Steps:

1. Launch the Connect to Data dialog and then select Google Analytics.

   The Google Analytics Connection dialog displays.

2. Provide the following information:

   • Service Account Email

   • Key File Path

   • Accounts, Properties, and Views.

3. Click Get Accounts and then select Accounts, Properties, and Views.

4. Enter the Start Date and End Date.

5. Click Fetch Dimensions and Metrics.

   This populates the Categories, Dimensions and Metrics list boxes.

6. Double-click on any field from these list boxes. They are selected and displayed in the Selected Columns list.

7. Click X to delete a selected column in the list.

8. Click OK to confirm the selection and retrieve the record set into Monarch Data Prep Studio.

 

Notes:

• You cannot select more than 7 dimensions and 10 metrics.

• Some dimension and metric combinations do not work together. At present, no list of compatible combinations is available. For more information on compatible dimensions and metrics, to this site  and filter on "segment only" data to obtain valid combinations for segmented data.

• Selecting any dimension/metric will disable non-compatible dimensions/metrics.

• Google Analytics error report definitions and system limits may be found here.

• Information on how to configure service account authentication for Google Analytics is provided here.