Google Ads Source Component

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

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

  • General
  • Columns

General Page

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

Google Ads Source Component

Connection Manager

The Google Ads Source Component requires a connection in order to connect to Google Ads. The Connection Manager drop-down will show a list of all connection managers that are available in your current SSIS package.

Customer Account Id (since v23.1)

Specify customer account id here. Click on the ellipsis to get the account hierarchy of your manager account.

Google Ads Resource

The Google Ads Resource drop-down contains a list of available resources in Google Ads.

Google Ads Filters

Specify the filter conditions in Google Ads Filters when working with Google Ads API.

Google Ads Sort

The Google Ads Sort option contains a list of attributes indicating the sorting order for the returned data. Specify the sorting fields and directions so the result will be sorted. This option is optional.

Page Size

The Page Size option allows you to specify how many records you want to retrieve for each service call.

Maximum Records

The Maximum Records option allows you to limit the number of rows returned.

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 updates of the property at run time.

Generate Documentation Button

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

Columns Page

The Columns page of the Google Ads Source Component shows you all available fields from the report type that you specified on the General page.

SSIS Google Ads Source - Columns

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 Ads Field: Column that will be retrieved from Google Ads.
  • Display Name: The human-readable name of this field.
  • Data Type: The data type of this field.