Data Source - Google Ads

Overview

Help page extracting and setting up a data transfer for your Google Ads reports.

Supported Protocol

• trocco uses the Google Ads API to extract your reports.

Settings

STEP 1: General Settings

Field Name	Required	Default Value	Description
Google Ads API Connection Configuration	Yes	-	From the Google Ads API Connection Configurations created in advance, select the one with the necessary permissions for this transfer. If you have not previously created any Connection Configurations, click the Add Connection Configuration button to set up a new one.
Customer ID	Yes	-	You can find your Custom ID from the drop down list in your Google Ads account page.
Resource Type	Yes	-	A list of report types can be found in the following Google Ads API official documentation.
Fields	Yes	-	Specify the field names inside the report you wish to transfer. See the following Google Ads API documentation, for a list of fields you can set for each resource type.
Extraction Date Range	Yes	-	Enter the date range for the data you wish to extract. Please enter both the start and end dates. Here you can use custom variables to embed a value that will dynamically set the extraction date range, relative to when the job executes.

Money Fields in Reports

In Google Ads, the Money field types are returned in micro currency units (i.e. multiplied by 1,000,000). For example: 123 (yen), will be turned into 123,000,000 (123 x 1,000,000).
Within trocco, the Money field is treated as a normal unit by internally dividing the value (1/1,000,000), i.e. the target field will be loaded as 123.
For more information, please refer to the following Google Ads documentation.

Money Fields List

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

Additional Information

See the here if you wish to migrate from Google Adwords.