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


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 in your current SSIS package.

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 Ranges (v8.0)

The Date Ranges option allows you to specify start date and end date for fetching Google Analytics data. The Date value can be for a specific date by using the DateTimePicker controls or can be selected from the drop-down list, which contains several pre-defined date value, including Today, Yesterday, NDaysAgo, Beginning/End of Current/Last Week/Month/Year.


The Metrics option allows you to specify the metrics from Google Analytics. This option is required.


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.


The Segments option allows you to choose a 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 available for a V3 connection:

  • 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.

There are three types available for a V4 connection:

  • SMALL: Returns a fast response with a smaller sampling size.
  • LARGE: Returns a more accurate but slower response.
  • DEFAULT: Returns a response that balances speed and accuracy.
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.

Refresh Component

Clicking the Refresh Component button causes the component to retrieve the latest metadata and update each field to its most recent metadata.

Expression fx Button

Click the fx button to launch SSIS Expression Editor to enable dynamic update of the property at run time.

Generate Documentation Button

Click the Generate Documentation button to generate a Word document which describes the component's metadata including relevant mapping, and so on.


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.


The Filters option shows the filter query that is auto-generated by the Metrics Filters and Dimensions Filters.


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, the checkbox 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.