Google Analytics Source Component

The Google Analytics Source Component is an SSIS data flow pipeline component that can be used to read/retrieve data from Google Analytics.

The component includes the following two pages to configure how you want to read data from Google Analytics.

  • General
  • Filters
  • Columns

General page

The General page of Google Analytics Source Component allows you to specify the general settings of the component.

SSIS google analytics source

Connection Manager
The Google Analytics Source Component requires a connection in order to connect to Google Analytics. The Connection Manager drop-down will show a list of all connection managers that are available to your current SSIS packages.
Analytics View
The Analytics View option specifies the Google Analytics view to select. Click the eclipse button (‘…’) to open up a Google Analytics Web Profile dialog to select a view.
Metadata Mode
The Metadata Mode drop-down contains a list of commonly-used queries in Google Analytics, each mode indicates a configuration that defines a combination of Metrics, Dimensions, Filters and Sort parameters, so you can select and use them directly. 
Date Range
The Date Range option allows you to specify a date range to retrieve data from Google Analytics. The Date value can be for a specific date period by using the DateTimePicker controls or can be selected from the drop-down list, which contains several pre-defined date range, including Yesterday, Last Month or LastXdays, etc. This option is required.
Metrics
The Metrics option allows you to specify the metrics from Google Analytics. This option is required.
Dimensions
The Dimensions option allows you to specify the dimensions to break down the metrics you specified. This option is optional.
Sort By
The Sort By option contains a list of metrics and dimensions indicating the sorting order for the returned data. Specify the sorting fields and directions so the result will be sorted. This option is optional.
Segment
The Segment option allows you to choose segment in Google Analytics from the drop-down. This option is optional.
Sampling Mode
The Sampling Mode option specifies the sampling level to query data from Google Analytics. There are three types:
  • Default – Returns response with a sample size that balances speed and accuracy.
  • FASTER – Returns a fast response with a smaller sample size.
  • HIGHER_PRECISION – Returns a more accurate using a large sample size, but this may result in the response being slower.
Page Size
The Page Size option allows you to specify how many records you want to retrieve each time.
Include Empty Rows
If the Include Empty Rows option is disabled, rows where all metric values are zero will be omitted. This option is enabled by default.

Filters page

The Filters page of the Google Analytics Source Component allows you to build the filter condition when retrieving data from Google Analytics.

SSIS google analytics source - Filers Page

Metrics Filters
The Metrics Filters grid allows you to specify the filtering condition for metrics.
Dimensions Filters
The Dimensions Filters grid allows you to specify the filtering condition for dimensions.
Filters
The Filters option shows the filter query that is auto-generated by the Metrics Filters and Dimensions Filters.

Column page

The Columns page of the Google Analytics Source Component shows you all available fields from the metrics and dimensions that you specified on the General page.

SSIS google analytics source - columns page

On the top left of the grid, you can see a checkbox, which can be used to toggle the selection of all available fields. This is a productive way to check or uncheck all available fields.

The Columns Page grid consists of:

  • Google Analytics Field – Column that will be retrieved from Google Analytics.
  • Data Type – The data type of this field.
  • Properties window for the field listed
    • Name – specify the column name.
    • Data type – the data type can be changed according.
    • Length – Specify the Length of the fields. If the data type specified is a string, the length specified here would be the maximum size. If the data type is not a string, the length will be ignored.
    • Precision – Specify the number of digits in a number.
    • Scale – Specify the number of digits to the right of the decimal point in a number.
    • CodePage: Specify the Code Page of the field.
  • Refresh Component – Clicking the Refresh Component button causes the component to retrieve the latest metadata and update each field to its most recent metadata.