(warning) The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.

Google Analytics Connector Documentation

User Persona: Paxata User - Paxata Admin - Data Source Admin

*Note: This document covers all configuration fields available during Connector setup. Some fields may have already been filled out by your Admin at an earlier step of configuration and may not be visible to you. For more information on Paxata’s Connector Framework, please see here.

Also: Your Admin may have named this Connector something else in the list of Data Sources.

Configuring Paxata

This connector allows you to connect to Google Analytics for browsing and importing available data. The following parameters are used to configure the connection.


  • Name: Name of the data source as it will appear to users in the UI.
  • Description: Description of the data source as it will appear to users in the UI.

Something to consider: You may connect Paxata to multiple Google Analytics Accounts and having a descriptive name can be a big help to users in identifying the appropriate data source.

Google Analytics Configuration

  • OAuth Verifier Key: The verifier key used to authenticate with Google Analytics. To obtain the verifier key, click ''Test Data Source'' and follow the link to grant access to Google Analytics. After allowing access, you will be redirected to a page that displays an access code. Copy the code into this field.
  • Profile: The Google Analytics profile or view to connect to. This can be set to either the Id or website URL for the profile.

Web Proxy

Select the web proxy options for connecting to Google Analytics.

  • Web Proxy: 'None' if no proxy is required or 'Proxied' if the connection to Google Analytics should be made via a proxy server. If a web proxy server is required, the following fields are required to enable a proxied connection.
  • Proxy Host: The hostname or IP address of the proxy server.
  • Proxy Port: The port of the proxy server.
  • Proxy Username and Proxy Password: User credentials for an authenticated proxy connection. Leave these blank for an unauthenticated proxy connection.

Data Import Information

Via Browsing

  • Browse a list of pre-defined datasets in Google Analytics and select a dataset, click Select for import.

  • Pre-defined datasets:

    • Accounts: Lists all Accounts to which the user has access.
    • AdWords: Retrieves AdWords data.
    • Ecommerce: Retrieves Ecommerce data.
    • Events: Retrieves Event data.
    • GoalCompletions: Retrieves Goal Completion data.
    • Profiles: Lists all Profiles to which the user has access.
    • Segments: Lists all Segments to which the user has access.
    • SiteContent: Retrieves internal Site Content data.
    • SiteSearch: Retrieves internal Site Search data.
    • SiteSpeed: Retrieves internal Site Speed data.
    • Traffic: Retrieves all Traffic data.
    • WebProperties: Lists Web Properties to which the user has access.
  • Export is not supported.

Via SQL Query

  • Using a SQL Select query.
  • The default behavior of the CData JDBC Driver is to retrieve data for the last 7 days. In order to customize the time window you can set the StartDate and EndDate values in your query directly. The supported inputs for StartDate and EndDate in the Google Analytics API are 'today', 'yesterday', 'NdaysAgo' (where N is some number), and an exact date.