Data Source - Google Ads

Prev Next

summary

This is a help page for ETL Configuration of Google Ads (Google Ads) Track Record and Data Setting.

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

  1. Fields Segments Metrics must be available for the specified "Resource Type (Report Type)".
  2. 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'

How to verify field specifiable values using Google Ads Query Builder

  1. From the "List of all resources" in the Google Ads Query Builder, click on the item you wish to designate as the resource type.
  2. 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.
  3. 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