Google Analytics Tool

The Google Analytics tool downloads data from Google Analytics directly into your Alteryx workflow, allowing non-technical business users to utilize the Google Analytics API.

Gallery tool

This tool is not automatically installed with Alteryx Designer. To use this tool, download it from the Alteryx Analytics Gallery.

Configure the tool

  1. In the Configuration window, select a sign-in method.
    • Online: Use this method for ad-hoc workflows. Sign in using Google account credentials. This option requires re-entering credentials every 60 minutes or any time a new workflow is opened. This method will not work for scheduled workflows.
    • Offline: This method is required for scheduled workflows. Sign in using Google API credentials. This option requires a Client ID, Client Secret, and Refresh Token and does not require re-entering credentials to run a workflow.
  2. Select an account, web property, and profile.
    • Available Accounts is determined by your login account.
    • Available WebProperties is determined by your account selection.
    • Available Profiles is determined by your WebProperties selection. This is a unique table ID associated with the data query.
  3. Select a date range. Select either a preset range (for example, Today, Last Month, Year to Date) or Custom to specify a start and end date.
  4. Select at least one metric and a maximum of ten metrics and goals.

    Metrics are the aggregated statistics for user activity to your site, such as clicks and page views, while goals represent completed activities. Most combinations of metrics can be used together, provided no dimensions are specified. Only valid combinations of metrics and dimensions can be used.

  5. (Optional) Select a maximum of seven dimensions.

    Dimensions break down metrics by common criteria. Only valid combinations of metrics and dimensions can be used.

  6. (Optional) Select a maximum of four segments. Selecting multiple segments limits the results to data included in all selected segments.

    Maximum Results: The maximum number of rows to include in the response.

  7. On the Configuration Summary screen, review your selections.

View the output

  • D anchor: The selected data from your query.
  • S anchor: Summary information from your query.