Google Analytics Connector for Data Prep¶
User Persona: Data Prep User, Data Prep Admin, or Data Source Admin
This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.
Configure Data Prep¶
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.
You can connect Data Prep to multiple Google Analytics accounts. Using 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.
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¶
Browse a list of pre-defined datasets in Google Analytics and select a dataset, click Select for import.
- 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.
SELECT * FROM Traffic WHERE StartDate=`2020-01-01` AND EndDate=`5daysAgo`
See http://cdn.cdata.com/help/DAE/jdbc/pg_table-sitecontent.htm for more details.