◄Show Table of Contents

Google Analytics Tool

A newer version of the Google Analytics Tool is available from the Alteryx Analytics Gallery.

The Google Analytics tool returns statistics derived from the data collected by a Google Analytics tracking code. You use the Core Reporting API to query for dimensions and metrics in order to build customized reports.

Configure the tool

There are two tabs to configure, Authentication and Search.

Authentication

Specify the following Google Analytics credentials:

  1. Client ID: The client ID obtained from the Google Developers Console.
  2. Client Secret:  The client secret obtained from the Google Developers Console.
  3. Refresh Token:  The refresh token returned from the authorization code exchange on the OAuth 2.0 Playground.

Disable for Testing: When checked, you can test your query without making a call to the Analytics API.

Search

Profile (View) ID:  The unique table ID for which your query will retrieve the data. Ask your Web Admin for the list of Profile IDs available to you, or get them here.

Metrics (max 10): The aggregated statistics for user activity to your site, such as clicks or pageviews.

Date Range:  All Analytics data requests must specify a date range. Date format must be yyyy-mm-dd (e.g., 2014-01-01). Choose from the following options:

ClosedOptional parameters

Dimensions (max 7):  Breaks down metrics by common criteria.

Segments (max 1):  Segments the data returned for your request.

Filter:  An expression that acts like a filter; restricting the data returned for your request.

  • Start Index:  The first row of data to retrieve, defaults to 1.
  • Max Results:  The maximum number of rows to include in the response, defaults to 1000.

    • ClosedGetting Started with Google Analytics

    There are several things you need in order to use the Google Analytics macro:

    1. A Google account. This can be obtained by creating a gmail account.

    2. Authorized Access to an existing Google Analytics account. See your web administrator to gain approval.

    3. ClosedA Client ID, Client Secret, and Refresh Token

      Register your application by creating a new project using the Google developer's console.

      1. Browse to the Google Developers Console
      2. From there, choose Create Project
      3. In the sidebar of the left, select APIs & auth. Make sure the status for the Analytics API is on.

      Generate your Client ID and Client Secret

    4. In the sidebar on the left, select Credentials.
    5. Under OAuth select, Create New Client ID.
    6. From the Create Client ID pop-up window:
      •  Make sure the Application type selection is Web application.
      • Change the Authorized redirect URI to
        https://developers.google.com/oauthplayground
      • Hit Create Client ID and wait a few seconds for Google to create your new project.

      Acquire your Refresh Token

    7. Before we move on make sure your Client ID and Client Secret are readily available (we’ll be using them soon)

      1. Browse to Google’s OAuth Playground (https://developers.google.com/oauthplayground)

      2. Click the button near the upper-right  corner of your monitor

      3. Check the box Use your own OAuth credentials and make sure Access type is set to Offline.

        1. Paste in your Client ID in OAuth Client ID.

        2. Paste in your Client Secret in OAuth Client Secret.

        3. Click Close.

      4. In the sidebar on the left, scroll down to the Google Analytics API v3 under Step 1: Select & authorize APIs

        1. Click the little grey triangle on the left and select

          https://www.googleapis.com/auth/analytics.readonly

        2. Hit Authorize APIs to be directed to another page.

        3. When prompted, hit Accept to be redirected back to the OAuth 2.0 Playground.

      5. Once you’ve been redirected back to the OAuth 2.0 Playground hit the Exchange authorization code for tokens button.

      6. Your Refresh Token will be contained in a JSON object towards the bottom of the Request / Response section.

      Keep a copy of your Refresh Token, Client ID, and Client Secret somewhere safe but easily accessible.

    ClosedCommon Queries

    According to Google, these are several of the most common queries made to the Analytics API.

    These examples are meant to highlight the Metrics, Dimensions, and Filter parameters. Anyone using these queries should set the Date Range, Max Results, and Start Index in a manner suitable to their own needs.

    General

    Visitors and Pageviews Over Time

    To return the total visitors and pageviews for the specified time period, select the Metrics:

    This query doesn't require any dimensions.

    Revenue Generating Campaigns

    To return campaign and site usage data for campaigns that led to more than one purchase through your site, select the Metrics:

    Select the Dimensions:

    The Google developer guide provides more general queries.

    Visitors

    Browser and Operating System

    To return a breakdown of visits by the Operating System, web browser, and browser version used, select the Metrics:

    Select the Dimensions:

    The Google developer guide provides more visitor queries.

    Traffic Sources

    Referring Sites

    To return a list of domains and how many visits each referred to your site, select the Metrics:

    Select the Dimensions:

    Select Filter, then select Dimension. Under Filter=, enter ga:medium==referral.

    The Google developer guide provides more traffic source queries.

    Content

    Top Exit Pages

    To return your most common exit pages, select the Metrics:

    Select the Dimensions:

    The Google developer guide provides more content queries.

     

    Alteryx.com | Community | Customer Support | Documentation Feedback

    ©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.