Google Ads Connector > Mappings and mapping tasks with Google Ads Connector > Google Ads sources in mappings
  

Google Ads sources in mappings

To read data from Google Ads, configure a Google Ads object as the Source transformation in a mapping or mapping task.
Specify the name and description of the Google Ads source. Configure the source, query options, and advanced properties for the source object.
The following table describes the source properties that you can configure for a Google Ads source:
Property
Description
Connection
Name of the Google Ads source connection.
Source Type
Type of the Google Ads source objects available.
You can read data from a single Google Ads source object or parameterize the object.
Object
Name of the Google Ads source object based on the selected source type.
Filter
Configure a simple filter or an advanced filter to filter rows from the source based on a filter condition. You can improve efficiency by filtering early in the data flow.
A simple filter includes a field name, operator, and value. Use an advanced filter to define a more complex filter condition, which can include multiple conditions using the AND or OR logical operators.
The following table describes the advanced properties that you can configure for a Google Ads source:
Property
Description
Customer ID
Required. Specifies the Google Ads client customer ID associated with the Google Ads manager account.
OrderByClause
Comma-separated list of field names for a Google Ads object and the order in which the data appear in the field mapping.
To specify the order of rows for a field from a Google Ads object, specify the following format:
"<objname>.<field_name1>=<ASC or DESC>,<objname>.<field_name2>=<ASC or DESC>"
The following example shows the OrderByClause that you can use to group the data in the ad_group object:
“ad_group.name=DESC,ad_Group.id=ASC”
Limit
Species the number of rows to read from a Google Ads source object.
You can set the tracing level in the advanced properties session to determine the amount of details that logs contain.
The following table describes the tracing levels that you can configure:
Property
Description
Terse
The Secure Agent logs initialization information, error messages, and notification of rejected data.
Normal
The Secure Agent logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes session results, but not at the level of individual rows.
Verbose Initialization
In addition to normal tracing, the Secure Agent logs additional initialization details, names of index and data files used, and detailed transformation statistics.
Verbose Data
In addition to verbose initialization tracing, the Secure Agent logs each row that passes into the mapping. Also notes where the Secure Agent truncates string data to fit the precision of a column and provides detailed transformation statistics.
When you configure the tracing level to verbose data, the Secure Agent writes row data for all rows in a block when it processes a transformation.

Data filters

You can create simple or advanced data filters. You can also create a set of data filters for each object included in a mapping task. Each set of data filters act independently of the other sets.

Simple data filters

You can create one or more simple data filters. When you create multiple simple data filters, the associated task creates an AND operator between the filters and loads rows that apply to all simple data filters.
You can use the other_resource_filter field for an object to specify a filter condition on a field of another Google Ads object. You can specify multiple filter conditions for an object using the other_resource_filter field.
For example, you can create a data filter for the ad_group object and use the other_resource_filter field to specify a filter condition on a field of the campaign object.
To specify a value for the other_resource_filter field, use the following format:
<objectName>.<fieldName>|=|<value>
The following image shows how you can create a data filter using the other_resource_filter field for a Google Ads object:The image shows how to configure other resource filter for the ad_group object

Advanced data filters

You can create an advanced data filter to create complex expressions that use AND, OR, or nested conditions. The expression that you enter becomes the WHERE clause in the Google Ads Query Language (GAQL) query used to retrieve records from the source.
Use the following format to define a filter field in an advanced data filter:
SELECT <objectName>.<fieldName1>, <objectName>.<fieldName2> FROM <objectName> WHERE <conditional expression>
To specify an advanced data filter on a field of the ad_group object, see the following example to filter data from the ad_group object using a GAQL query:
SELECT ad_group.campaign, ad_group.name FROM ad_group WHERE ad_group.id = 50