--- title: "Data Source - Google Ads" slug: "data-source-google-ads" updated: 2025-07-23T08:51:44Z published: 2025-07-23T08:51:44Z canonical: "documents.trocco.io/data-source-google-ads" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Source - Google Ads ## 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](https://developers.google.com/google-ads/api/fields/v20/segments). 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](/docs/en/data-source-google-ads#google-ads-query-builder%E3%82%92%E5%88%A9%E7%94%A8%E3%81%97%E3%81%9F%E3%83%95%E3%82%A3%E3%83%BC%E3%83%AB%E3%83%89%E6%8C%87%E5%AE%9A%E5%8F%AF%E8%83%BD%E5%80%A4%E3%81%AE%E6%A4%9C%E8%A8%BC%E6%96%B9%E6%B3%95). ## Setting items ### STEP1 Basic settings | item name | indispensable | default value | Contents | | --- | --- | --- | --- | | Google Ads Connection Configuration | Yes | - | Select the preregistered [Google Ads Connection](/docs/connection-configuration-google-ads) 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.](https://developers.google.com/google-ads/api/fields/v20/overview#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](/docs/en/data-source-google-ads#%E5%88%B6%E7%B4%84) and [How to Validate Field Specifiable Values Using the Google Ads Query Builder](/docs/en/data-source-google-ads#google-ads-query-builder%E3%82%92%E5%88%A9%E7%94%A8%E3%81%97%E3%81%9F%E3%83%95%E3%82%A3%E3%83%BC%E3%83%AB%E3%83%89%E6%8C%87%E5%AE%9A%E5%8F%AF%E8%83%BD%E5%80%A4%E3%81%AE%E6%A4%9C%E8%A8%BC%E6%96%B9%E6%B3%95). | | 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](https://developers.google.com/google-ads/api/fields/v20/overview_query_builder#list-of-all-resources), 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`