Page Operations
Browse SpaceDescription
This document provides you with information about the Google Analytics plug-in for Pentaho Data Integration (PDI), version 3.2. The Google Analytics plug-in is a PDI input step that allows you to access your Google analytics data to generate reports or to populate your BI data warehouse.
Prerequisites
You must have a Google Analytics account, an installation of PDI 3.2, and the Google Analytics plug-in.
Note: The Google Analytics plug-in is available to Pentaho enterprise customers only. The plug-in can be downloaded from the Pentaho FTP site and must be installed in your ...\plugins\steps directory.
Authorization
| Option | Description |
|---|---|
| Username | Your Google Analytics account user name |
| Password | Your Google Analytics account password |
Note: To make querying easier, a link provides you with quick access to the Google Analytics API documentation.
Query
| Option | Description |
|---|---|
| Domain Table ID | Specifies the domain associated with Google Analytics that must be queried. Click Lookup to display the list of available domains. |
| Start Date | Specifies the start date associated with the query - date must be entered in the following format: year, month, and date (for example, 2009-03-01) |
| End Date | Specifies the end date associated with the query - date must be entered in the following format: year, month, and date (for example, 2009-03-31) |
| Dimensions | Specifies the dimension fields for which you want to query - the Google Analytics API documentation provides you with a list of valid inputs and metrics that can be combined |
| Metrics | Specifies the metrics fields you want returned |
| Filters | Specifies the filter (described in the Google Analytics API documentation) for example, 'ga:country==Algeria' |
| Sort | Specifies a field on which to sort, for example, 'ga:city' |
Fields
Click Get Fields to retrieve a list of possible fields based on the query you defined on the Query tab.
Click Preview Rows to preview data based on the defined query.
Sandra:
You must contact Pentaho support to get access to the Google plug-ins.
MBaker