Google Analytics

Google Analytics

This document provides instructions for integrating Google Analytics data into Panoply. The following items will be covered:

Before beginning data integration, ensure you have necessary permissions in place to access Google Analytics data for the desired account. To be detected by Panoply, profiles must have Read & Analyze permission.

Google Analytics Data Integration

To integrate Google Analytics data into Panoply using default selections, complete the following steps. For more advanced options, complete the following and refer to the subsequent sections for detailed information.

  1. From the Home page in the Panoply dashboard, click Data Sources. Then, click the Add Data Source button.
  2. In the Data Sources – Choose Source Type window, select Google Analytics. Google Analytics is listed under both Most Popular and APIs.
  3. In the Data Sources – Google Analytics screen, click Login With Google.
  4. In the Google prompt, select the Google account tied to the data you would like to add to Panoply.

    If you do not see the profile you want in this list, we recommend that you double-check the permission settings.
  5. A Google Account Authorization window confirms whether you want to allow Panoply to access your Google Analytics data. Click Allow to continue.

    Note: If the account selected does not have permission to access the Google Analytics data, or if there is no Google Analytics account tied to the selected profile, an error message like the following appears in Panoply:

    If the account access and authorization are confirmed, you will return to the Panoply Data Sources – Google Analytics screen.
  6. In the Data Sources – Google Analytics screen, select the Google Analytics View from which to import data.
  7. Once the desired view is selected, the Data Sources – Google Analytics window expands, listing the specific data that can be ingested into Panoply. Once you have reviewed or selected your desired options, click Collect.

The Data Sources – Google Analytics window will appear grayed out while the data integration is pending. A small green progress bar appears below Google Analytics.

You will be prompted to set up the integration of another data source. You can set up multiple data integrations without impacting the ingestion of the already scheduled or pending data integrations.

From the Data Sources main menu, you can monitor the data ingestion status of the scheduled and pending data integrations. Once the data ingestion is complete, you can clean or transform your data in the Tables menu.

Default Selections

Within the Data Sources – Google Analytics window, the following options are selected by default.

Metrics

Default Selection Description
ga:users Total number of users for the time period specified in Date Range.
ga:newUsers Number of sessions specified as the first session by a user.
ga:sessions Total number of sessions.
ga:bounces Total number of single interactions per session for the site.
ga:avgSessionDuration Average amount of time (in seconds) spent by the user at the site during the session.
ga:organicSearches Number of organic searches by a user in a session.
ga:pageviews Number of total page views for the site.
ga:uniquePageviews Number of sessions the specified page was viewed at least once.
ga:timeOnPage Total amount of time (in seconds) spent on a particular page.
ga:avgTimeOnPage Average amount of time (in seconds) users spent viewing page(s).

Dimensions

Default Selection Description
ga:source Source of referrals.
ga:medium Type of referrals.
ga:browser The browser versions used by user.
ga:deviceCategory The type of device from which the site was accessed.
ga:country The user’s country.
ga:dateHour The date and hour the users accessed the site.

Date Range

Default Selection Description
Last 30 days Defines the relative date range to pull data.

Additional Available Selections in Metrics, Dimensions, and Date Range

Review the Google Analytics Dimensions & Metrics Explorer website for a detailed list and description of the standard Google Analytics Dimensions and Metrics options.

Note that any Dimension or Metric you customized in Google Analytics will also appear in the Metrics and Dimensions fields in Panoply. Simply select or deselect the items you wish to include in the current data integration.

The additional Date Range options available are as follows:

  • Last Day
  • Last 3 Days
  • Last 7 Days
  • Last 30 Days (default)
  • Last 3 Months
  • Last 6 Months
  • Last Year
  • As much as possible

Advanced Data Integration Options

Clicking Show next to Advanced will expand the Data Sources - Google Analytics window to include Destination, Primary Key, Exclude, Parse string, and Truncate table.

See the following table for descriptions and examples for refining data using these categories.

  Description Example
Destination Name of the table target where you wish to save the data. Default: “google-analytics”
Primary Key Define a primary key for the destination table for de-duplication with a pattern. By default, the primary key is a concatenation of the selected dimensions. {hello}_{world}
Exclude List of attributes to exclude from the collection process, such as personally identifiable information like credit card numbers. ga:timeOnPage
Parse string List of JSON text attributes to parse as objects.  
Truncate table Delete the data from the table before collecting the source.