Data Source - Google Ads

constraints

For fields that can be specified

The specified value of a field from which data can be retrieved must satisfy the following two conditions

Fields Segments Metrics must be available for the specified "Resource Type (Report Type)".
When multiple values are specified for a field, the values must be compatible with the Segments in the specified value (values that can be retrieved at the same time).
For compatible values for each Segments, please refer to the "Selectable With" column of each item in the Segments list in the official documentation.

Whether a field is specifiable or not can be verified using the official tool "Google Ads Query Builder".
See how to validate field specifiable values using Google Ads Query Builder.

Setting items

STEP1 Basic settings

item name	indispensable	default value	Contents
Google Ads Connection Configuration	Yes	-	Select the preregistered Google Ads Connection Configuration that has the necessary permissions for this ETL Configuration.
Customer ID	Yes	-	Please check your customer ID in your Google Ads account list. The candidate list will show the customer IDs that can be accessed with the Google account used in the connection setup.
Resource Type (Report Type)	Yes	-	Select the resource type (report type). For a list of resource types, please refer to the official Google Ads API documentation - List of all resources. Some resource types are not supported for acquisition. In this case, please contact our Customer Success.
field	Yes	-	Select the items (fields) you want to include in the report. For more information on the fields that can be specified, see Constraints and How to Validate Field Specifiable Values Using the Google Ads Query Builder.
Data acquisition period	Yes	-	If some resource types are selected, specify start and end dates. The data to be retrieved will be filtered based on the specified time period.
condition	No	-	By entering record conditions, you can narrow down the rows to be retrieved. Input example: `campaign.status = 'PAUSED'`

item name

indispensable

default value

Contents

Google Ads Connection Configuration

Yes

Select the preregistered Google Ads Connection Configuration that has the necessary permissions for this ETL Configuration.

Customer ID

Yes

Please check your customer ID in your Google Ads account list.
The candidate list will show the customer IDs that can be accessed with the Google account used in the connection setup.

Resource Type (Report Type)

Yes

Select the resource type (report type).
For a list of resource types, please refer to the official Google Ads API documentation - List of all resources.
Some resource types are not supported for acquisition. In this case, please contact our Customer Success.

field

Yes

Select the items (fields) you want to include in the report.
For more information on the fields that can be specified, see Constraints and How to Validate Field Specifiable Values Using the Google Ads Query Builder.

Data acquisition period

Yes

If some resource types are selected, specify start and end dates.
The data to be retrieved will be filtered based on the specified time period.

condition

By entering record conditions, you can narrow down the rows to be retrieved.
Input example: campaign.status = 'PAUSED'

How to verify field specifiable values using Google Ads Query Builder

From the "List of all resources" in the Google Ads Query Builder, click on the item you wish to designate as the resource type.

On the SELECT tab of Choose a Clause to Select From, place a checkmark in the field you wish to designate from``Attribute Resource Fields, Segments, Metrics, Attributed Resource Fields Select the field you want to specify.

Values that are incompatible with the checkmarked values will be struck through.
The following capture is for the resource type ad_group with a check mark in segments.ad_destination_type.

supplementary information

About the value of the Money field

In Google Ads, some amount fields are managed in micro units.
Therefore, some fields have their values multiplied by 1,000,000.
TROCCO internally multiplies the value held by 1,000,000 times by 1/1000000 during transfer.

List of fields covered by this case

metrics.cost_micros
metrics.average_cpc
metrics.cost_per_all_conversions
metrics.active_view_cpm
metrics.active_view_measurable_cost_micros
metrics.average_cost
metrics.average_cpm
metrics.cost_per_conversion
metrics.benchmark_average_max_cpc
ad_group_criterion.effective_cpc_bid_micros
ad_group_criterion.effective_cpm_bid_micros
ad_group_criterion.position_estimates.estimated_add_cost_at_first_position_cpc
ad_group.cpc_bid_micros
ad_group.effective_target_cpa_micros
bidding_strategy.target_cpa.cpc_bid_ceiling_micros
bidding_strategy.target_cpa.cpc_bid_floor_micros
bidding_strategy.target_roas.cpc_bid_ceiling_micros
bidding_strategy.target_roas.cpc_bid_floor_micros
bidding_strategy.target_spend.cpc_bid_ceiling_micros
bidding_strategy.target_spend.target_spend_micros
campaign_budget.amount_micros
campaign_budget.recommended_budget_amount_micros