Altair® Panopticon

 

Google Analytics

The Google Analytics connector allows you to track and report website traffic using the Google Analytics service.

Before using this connector, the following steps must be performed:

  1. Configure the Google Analytics Service Account Authentication

  2. Enable the Analytics API

  3. Set Edit Permissions to the Service Account ID

  4. Extract the Profile ID from the URL

1. Configuring Service Account Authentication for the Google Analytics Connector

The authentication mode needs to be enabled from the account email that you will use.

  1. Go to http://console.developers.google.com and log-on using your credentials.

The APIs & Services section is displayed.

The Google Analytics connector works on a service account authentication mode. To create a service account, you must first create a project.

  1. On the APIs & Services section, click Credentials.

  1. Click CREATE and choose Service Account Key to create credentials for the service account authentication.

The Credentials page is refreshed to display:

  1. Create a Service Account credentials by selecting New Service Account.

  1. Enter the Service Account Name. This is appended in the Service Account ID box. Select the P12 Key Type and click Create.

A Service Account Has No Role prompt is displayed. You may opt to select a role or add one or more later in the IAM & Admin section. For now, click Create without a role.

Once the service account is created, it will download a file that contains the private key. NOTE: You need to save a copy of this key file.

 

2. Enabling Analytics API

  1. On the APIs & Services section, click Library to display the API Library page and select Google Analytics API.

 

The Google Analytics API page is displayed.

 

  1. Click ENABLE.

 

3. Setting Edit Permissions to the Service Account ID

Before using the Google Analytics connector, users must request for their service provider account access from the administrator.

  1. Send the generated service account ID to the Google Analytics administrator.

  2. The administrator grants permissions to the user in the Admin > User Management page in their Google Analytics account.

 

  1. The administrator must ensure to give Edit permission to the user.

 

4. Extracting Profile ID from the URL

Aside from the Service Account ID and the key file, you also need to extract the Profile ID from the URL in order to connect to the Google Analytics connector in Panopticon Designer (Desktop) (Desktop).

  1. Go to http://analytics.google.com and sign in.

The Google Analytics account page is displayed.

NOTE: Initially, there is no data displayed on the dashboard.

  1. Check the URL. For example: https://analytics.google.com/analytics/web/#/report-home/a141137636w202161341p196007843

All of the digits that follow p is the Profile ID (e.g., 196007843)

 

Using Google Analytics

The Google Analytics connector allows you to track and report website traffic using the Google Analytics service.

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

The Google Analytics Connection dialog displays.

  1. Provide the following information:

    • Service Account Email

The Service Account ID that is generated while creating credentials for the service account authentication.

    • Key File Path

The path of the key file. You can also click Browse to select the path of the key file.

    • Profile ID

The Profile ID of the page you want to access in Google Analytics.

  1. Enter the Start Date and End Date.

  2. Click Fetch Dimensions and Metrics.

This populates the Categories, Dimensions, and Metrics list boxes.

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

 

  1. Click to delete a selected column in the list.

  2. Click OK to confirm the selection and retrieve the record set into Panopticon Designer (Desktop).

The record set is returned from the source service and displayed in the Edit Data Table view with the fields in the Data Source Preview.

LIMITATIONS:

    • You can’t select more than 7 dimensions and 10 metrics.

    • Some dimensions and metrics combinations do not work together. Currently there is no way out to know the compatible combinations. For information on compatible dimensions and metrics, please go to https://developers.google.com/analytics/devguides/reporting/core/dimsmets. Selecting any dimension/metric will disable non-compatible dimensions/metrics.