Yahoo! Japan Search Ads fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Yahoo! Japan Search Ads data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

93 metrics154 dimensions

ACCOUNT

campaign__account_id
Field label Account ID
Description A number that identifies your account. It will be automatically assigned when the account is created
Field type dimension
Data type string.text.value
campaign__account_name
Field label Account name
Description Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked
Field type dimension
Data type string.text.value
ad__account_id
Field label Account ID
Description A number that identifies your account. It will be automatically assigned when the account is created
Field type dimension
Data type string.text.value
ad__account_name
Field label Account name
Description Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked
Field type dimension
Data type string.text.value
keywords__account_id
Field label Account ID
Description A number that identifies your account. It will be automatically assigned when the account is created
Field type dimension
Data type string.text.value
keywords__account_name
Field label Account name
Description Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked
Field type dimension
Data type string.text.value
geo__account_id
Field label Account ID
Description A number that identifies your account. It will be automatically assigned when the account is created
Field type dimension
Data type string.text.value
geo__account_name
Field label Account name
Description Name of the account. The account name must be the same as the website owner (company name, trade name, etc.) that can be seen on the site that is displayed when the ad is clicked
Field type dimension
Data type string.text.value

AD

ad__ad_id
Field label Ad ID
Description The ID of the ad
Field type dimension
Data type string.text.value
ad__ad_name
Field label Ad Name
Description The name of the ad
Field type dimension
Data type string.text.value
ad__ad_type
Field label Ad Type
Description The type of the ad
Field type dimension
Data type string.text.value
ad__ad_distribution_settings
Field label Ad distribution settings
Description The distribution settings of the ad
Field type dimension
Data type string.text.value
ad__ad_editorial_status
Field label Ad editorial status
Description The editorial status of the ad
Field type dimension
Data type string.text.value
ad__ad_tracking_id
Field label Ad tracking ID
Description The tracking ID of the ad
Field type dimension
Data type string.text.value
ad__display_url
Field label Display URL
Description The display URL of the ad
Field type dimension
Data type string.text.url
ad__destination_url
Field label Destination URL
Description The destination URL of the ad
Field type dimension
Data type string.text.url
ad__title_1
Field label Title1
Description The title 1 of the ad
Field type dimension
Data type string.text.value
ad__title_2
Field label Title2
Description The title 2 of the ad
Field type dimension
Data type string.text.value
ad__title_3
Field label Title3
Description The title 1 of the ad
Field type dimension
Data type string.text.value

AD GROUP

ad__adgroup_id
Field label Ad group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
ad__adgroup_name
Field label Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value

ADGROUP

keywords__adgroup_id
Field label Ad Group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
keywords__adgroup_name
Field label Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
keywords__adgroup_bid
Field label Adgroup bid
Description Bid price for adgroup
Field type dimension
Data type float.currency.value
geo__adgroup_id
Field label Ad Group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
geo__adgroup_name
Field label Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value

BID STRATEGY

campaign__portfolio_bidding_id
Field label Portfolio bidding ID
Description The ID of the portfolio bidding
Field type dimension
Data type string.text.value
campaign__portfolio_bidding_name
Field label Portfolio bidding name
Description The name of the portfolio bidding
Field type dimension
Data type string.text.value
campaign__bid_strategy_type
Field label Bid strategy type
Description The type of the bid strategy
Field type dimension
Data type string.text.value

CAMPAIGN

campaign__campaign_id
Field label Campaign ID
Description A number to identify the campaign. It will be automatically assigned when the campaign is created
Field type dimension
Data type string.text.value
campaign__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_distribution_settings
Field label Distribution settings
Description The distribution settings of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_distribution_status
Field label Distribution status
Description The distribution status of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_type
Field label Campaign type
Description This is one of the setting items when creating a campaign in Search Ads. You can manage the campaign according to the purpose by setting the campaign type
Field type dimension
Data type string.text.value
campaign__tracking_url
Field label Tracking URL
Description The tracking URL of the campaign
Field type dimension
Data type string.text.url
campaign__campaign_start_date
Field label Start date
Description The start date of the campaign
Field type dimension
Data type string.time.date
campaign__campaign_end_date
Field label End date
Description The end date of the campaign
Field type dimension
Data type string.time.date
campaign__daily_spending_limit
Field label Daily spending limit
Description The daily budget set for each campaign
Field type dimension
Data type float.currency.value
ad__campaign_id
Field label Campaign ID
Description A number to identify the campaign. It will be automatically assigned when the campaign is created
Field type dimension
Data type string.text.value
ad__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
keywords__campaign_id
Field label Campaign ID
Description A number to identify the campaign. It will be automatically assigned when the campaign is created
Field type dimension
Data type string.text.value
keywords__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
geo__campaign_id
Field label Campaign ID
Description A number to identify the campaign. It will be automatically assigned when the campaign is created
Field type dimension
Data type string.text.value
geo__campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value

CONVERSIONS

campaign__conversion_name
Field label Conversion name
Description The name of the conversion
Field type dimension
Data type string.text.value
campaign__objective_of_conversion_tracking
Field label Objective of conversion tracking
Description The Objective of Conversion Tracking
Field type dimension
Data type string.text.value
ad__conversion_name
Field label Conversion name
Description The name of the conversion
Field type dimension
Data type string.text.value
ad__objective_of_conversion_tracking
Field label Objective of conversion tracking
Description The Objective of Conversion Tracking
Field type dimension
Data type string.text.value
keywords__conversion_name
Field label Conversion name
Description The name of the conversion
Field type dimension
Data type string.text.value
keywords__objective_of_conversion_tracking
Field label Objective of conversion tracking
Description The Objective of Conversion Tracking
Field type dimension
Data type string.text.value
geo__conversion_name
Field label Conversion name
Description The name of the conversion
Field type dimension
Data type string.text.value
geo__objective_of_conversion_tracking
Field label Objective of conversion tracking
Description The Objective of Conversion Tracking
Field type dimension
Data type string.text.value
campaign__conversions
Field label Conversions
Description A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad
Field type metric
Data type int.number.value
campaign__conversion_rate
Field label Conversion rate
Description The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks
Field type metric
Data type float.number.ratio
campaign__conversion_value
Field label Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
campaign__cost_per_conv
Field label Cost per conversion
Description Cost per conversion. It is calculated by Cost / Conversion
Field type metric
Data type float.currency.value
campaign__value_per_conv
Field label Value per conversion
Description Value per conversion. It is calculated by Conversion Value / Conversion
Field type metric
Data type float.currency.value
campaign__conversion_value_per_cost
Field label Conversion value per cost
Description Conversion value per cost. It is calculated by Conversion Value / Cost
Field type metric
Data type float.currency.value
campaign__all_conversion
Field label Conversions (all)
Description The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available)
Field type metric
Data type int.number.value
campaign__all_conversion_rate
Field label Conversion rate (all)
Description The rate of all conversion. It is calculated by All conversion / clicks
Field type metric
Data type float.number.ratio
campaign__all_conversion_value
Field label Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
campaign__cost_per_all_conv
Field label Cost per conversion (all)
Description The cost per all conversion. It is calculated by Cost / All conversion
Field type metric
Data type float.currency.value
campaign__value_per_all_conv
Field label Value per conversion (all)
Description The value per all conversion
Field type metric
Data type float.currency.value
campaign__all_conversion_value_per_cost
Field label Conversion value per cost (all)
Description All conversion value per cost. It is calculated by All conversion value / Cost
Field type metric
Data type float.currency.value
campaign__cross_device_conversion
Field label Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value
ad__conversions
Field label Conversions
Description A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad
Field type metric
Data type int.number.value
ad__conversion_rate
Field label Conversion rate
Description The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks
Field type metric
Data type float.number.ratio
ad__conversion_value
Field label Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
ad__cost_per_conv
Field label Cost per conversion
Description Cost per conversion. It is calculated by Cost / Conversion
Field type metric
Data type float.currency.value
ad__value_per_conv
Field label Value per conversion
Description Value per conversion. It is calculated by Conversion Value / Conversion
Field type metric
Data type float.currency.value
ad__conversion_value_per_cost
Field label Conversion value per cost
Description Conversion value per cost. It is calculated by Conversion Value / Cost
Field type metric
Data type float.currency.value
ad__all_conversion
Field label Conversions (all)
Description The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available)
Field type metric
Data type int.number.value
ad__all_conversion_rate
Field label Conversion rate (all)
Description The rate of all conversion. It is calculated by All conversion / clicks
Field type metric
Data type float.number.ratio
ad__all_conversion_value
Field label Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
ad__cost_per_all_conv
Field label Cost per conversion (all)
Description The cost per all conversion. It is calculated by Cost / All conversion
Field type metric
Data type float.currency.value
ad__value_per_all_conv
Field label Value per conversion (all)
Description The value per all conversion
Field type metric
Data type float.currency.value
ad__all_conversion_value_per_cost
Field label Conversion value per cost (all)
Description All conversion value per cost. It is calculated by All conversion value / Cost
Field type metric
Data type float.currency.value
ad__cross_device_conversion
Field label Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value
keywords__conversions
Field label Conversions
Description A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad
Field type metric
Data type int.number.value
keywords__conversion_rate
Field label Conversion rate
Description The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks
Field type metric
Data type float.number.ratio
keywords__conversion_value
Field label Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
keywords__cost_per_conv
Field label Cost per conversion
Description Cost per conversion. It is calculated by Cost / Conversion
Field type metric
Data type float.currency.value
keywords__value_per_conv
Field label Value per conversion
Description Value per conversion. It is calculated by Conversion Value / Conversion
Field type metric
Data type float.currency.value
keywords__conversion_value_per_cost
Field label Conversion value per cost
Description Conversion value per cost. It is calculated by Conversion Value / Cost
Field type metric
Data type float.currency.value
keywords__all_conversion
Field label Conversions (all)
Description The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available)
Field type metric
Data type int.number.value
keywords__all_conversion_rate
Field label Conversion rate (all)
Description The rate of all conversion. It is calculated by All conversion / clicks
Field type metric
Data type float.number.ratio
keywords__all_conversion_value
Field label Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
keywords__cost_per_all_conv
Field label Cost per conversion (all)
Description The cost per all conversion. It is calculated by Cost / All conversion
Field type metric
Data type float.currency.value
keywords__value_per_all_conv
Field label Value per conversion (all)
Description The value per all conversion
Field type metric
Data type float.currency.value
keywords__all_conversion_value_per_cost
Field label Conversion value per cost (all)
Description All conversion value per cost. It is calculated by All conversion value / Cost
Field type metric
Data type float.currency.value
keywords__cross_device_conversion
Field label Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value
geo__conversions
Field label Conversions
Description A number of accomplishment (conversion) on the site, where users visited to the site by clicking an ad took an action such as purchasing a product, registering as a member, asking for materials, etc. Conversions refers to the first conversion that resulted of the period from 7 days to 90 days (counting period setting available) any of 1 click of an ad
Field type metric
Data type int.number.value
geo__conversion_rate
Field label Conversion rate
Description The ratio of conversion amount that occurred to ad clicks. Calculated by number of conversion / number of clicks
Field type metric
Data type float.number.ratio
geo__conversion_value
Field label Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
geo__cost_per_conv
Field label Cost per conversion
Description Cost per conversion. It is calculated by Cost / Conversion
Field type metric
Data type float.currency.value
geo__value_per_conv
Field label Value per conversion
Description Value per conversion. It is calculated by Conversion Value / Conversion
Field type metric
Data type float.currency.value
geo__conversion_value_per_cost
Field label Conversion value per cost
Description Conversion value per cost. It is calculated by Conversion Value / Cost
Field type metric
Data type float.currency.value
geo__all_conversion
Field label Conversions (all)
Description The number of Conversions (all) counts all of conversions occurred within the period from 1 to 90 days (the period setting available)
Field type metric
Data type int.number.value
geo__all_conversion_rate
Field label Conversion rate (all)
Description The rate of all conversion. It is calculated by All conversion / clicks
Field type metric
Data type float.number.ratio
geo__all_conversion_value
Field label Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
geo__cost_per_all_conv
Field label Cost per conversion (all)
Description The cost per all conversion. It is calculated by Cost / All conversion
Field type metric
Data type float.currency.value
geo__value_per_all_conv
Field label Value per conversion (all)
Description The value per all conversion
Field type metric
Data type float.currency.value
geo__all_conversion_value_per_cost
Field label Conversion value per cost (all)
Description All conversion value per cost. It is calculated by All conversion value / Cost
Field type metric
Data type float.currency.value
geo__cross_device_conversion
Field label Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEPRECATED

geo__adgroup_tracking_id
Field label Adgroup tracking ID
Description The tracking ID of the Adgroup.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2025-08-26
keywords__campaign_tracking_id
Field label Campaign tracking ID
Description The ID of campaign tracking.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2025-08-26
keywords__adgroup_tracking_id
Field label Adgroup tracking ID
Description The tracking ID of the Adgroup.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2025-08-26
ad__campaign_tracking_id
Field label Campaign tracking ID
Description The ID of campaign tracking.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2025-08-26
ad__adgroup_tracking_id
Field label Adgroup tracking ID
Description The tracking ID of the Adgroup.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2025-08-26
campaign__enhanced_cpc_enabled
Field label Enhanced CPC
Description When Enhanced CPC is set, the keyword bid will be automatically adjusted to achieve as many conversion as possible.
Field type dimension
Data type bool
🚫 Deprecated Deprecated on 2025-07-19
campaign__campaign_tracking_id
Field label Campaign tracking ID
Description The ID of campaign tracking.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2025-08-26
geo__campaign_tracking_id
Field label Campaign tracking ID
Description The ID of campaign tracking.
Field type dimension
Data type string.text.value
🚫 Deprecated Deprecated on 2025-08-26

DEVICE

geo__network
Field label Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value
geo__device
Field label Device
Description Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices
Field type dimension
Data type string.text.value

GEO

geo__country_territory
Field label Country/territory
Description Country/territory where the event happened
Field type dimension
Data type string.geo.country
geo__city
Field label City
Description City where the event happened
Field type dimension
Data type string.geo.city
geo__prefecture
Field label Prefecture
Description A region or area where the event happened
Field type dimension
Data type string.geo.region
geo__location_type
Field label Location type
Description Location type
Field type dimension
Data type string.text.value
geo__most_specific_location
Field label Location
Description The location where the event happened
Field type dimension
Data type string.text.value
geo__metro_area
Field label Metro area
Description The metropolitan area where the event happened
Field type dimension
Data type string.geo.metro

KEYWORD

keywords__keyword
Field label Keyword
Description The keyword used to describe the ad
Field type dimension
Data type string.text.value
keywords__keyword_id
Field label Keyword ID
Description The ID of the keyword
Field type dimension
Data type string.text.value
keywords__match_type
Field label Match type
Description The keyword match type
Field type dimension
Data type string.text.value
keywords__keyword_distribution_settings
Field label Keyword distribution settings
Description The distribution settings of keyword
Field type dimension
Data type string.text.value
keywords__keyword_editorial_status
Field label Keyword editorial status
Description The editorial status of keyword
Field type dimension
Data type string.text.value
keywords__keyword_tracking_id
Field label Keyword tracking ID
Description The tracking ID of the keyword
Field type dimension
Data type string.text.value

MAIN METRICS

campaign__impressions
Field label Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
campaign__clicks
Field label Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
campaign__cost
Field label Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
campaign__cost_usd
Field label Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
campaign__cost_eur
Field label Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
campaign__cost_gbp
Field label Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
campaign__ctr
Field label CTR
Description Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions
Field type metric
Data type float.number.ratio
campaign__avg_cpc
Field label Avg. CPC
Description Average cost-per-click. It is calculated by Cost / Clicks
Field type metric
Data type float.currency.value
campaign__cpm
Field label CPM
Description Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions
Field type metric
Data type float.currency.value
campaign__roas
Field label ROAS
Description The effect you get on the advertising costs you invest, calculated by Conversion value / total cost
Field type metric
Data type float.currency.value
campaign__invalid_clicks
Field label Invalid clicks
Description Clicks that we determine to be malicious, such as clicks by known malicious programs, specific duplicate clicks, or other abnormal clicks. These are “invalid clicks” or “suspected invalid clicks” and are excluded from billing
Field type metric
Data type int.number.value
ad__impressions
Field label Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
ad__clicks
Field label Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
ad__cost
Field label Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
ad__cost_usd
Field label Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
ad__cost_eur
Field label Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
ad__cost_gbp
Field label Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
ad__ctr
Field label CTR
Description Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions
Field type metric
Data type float.number.ratio
ad__avg_cpc
Field label Avg. CPC
Description Average cost-per-click. It is calculated by Cost / Clicks
Field type metric
Data type float.currency.value
ad__cpm
Field label CPM
Description Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions
Field type metric
Data type float.currency.value
ad__roas
Field label ROAS
Description The effect you get on the advertising costs you invest, calculated by Conversion value / total cost
Field type metric
Data type float.currency.value
keywords__impressions
Field label Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
keywords__clicks
Field label Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
keywords__cost
Field label Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
keywords__cost_usd
Field label Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
keywords__cost_eur
Field label Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
keywords__cost_gbp
Field label Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
keywords__ctr
Field label CTR
Description Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions
Field type metric
Data type float.number.ratio
keywords__avg_cpc
Field label Avg. CPC
Description Average cost-per-click. It is calculated by Cost / Clicks
Field type metric
Data type float.currency.value
keywords__cpm
Field label CPM
Description Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions
Field type metric
Data type float.currency.value
keywords__roas
Field label ROAS
Description The effect you get on the advertising costs you invest, calculated by Conversion value / total cost
Field type metric
Data type float.currency.value
geo__impressions
Field label Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
geo__clicks
Field label Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
geo__cost
Field label Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
geo__cost_usd
Field label Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
Services Currency conversion
geo__cost_eur
Field label Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
geo__cost_gbp
Field label Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
geo__ctr
Field label CTR
Description Click Through Rate, the ratio of clicks on the ad to the number of times the ad was viewed. It is calculated by Clicks / Impressions
Field type metric
Data type float.number.ratio
geo__avg_cpc
Field label Avg. CPC
Description Average cost-per-click. It is calculated by Cost / Clicks
Field type metric
Data type float.currency.value
geo__cpm
Field label CPM
Description Cost Per Thousand impressions, using the Latin “Mille” instead of thousand. Average cost for displaying your ad 1000 times. Calculated by 1000 x total cost (or budget) / impressions
Field type metric
Data type float.currency.value
geo__roas
Field label ROAS
Description The effect you get on the advertising costs you invest, calculated by Conversion value / total cost
Field type metric
Data type float.currency.value

OTHER

campaign__network
Field label Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value
campaign__click_type
Field label Click type
Description The type of click
Field type dimension
Data type string.text.value
campaign__device
Field label Device
Description Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices
Field type dimension
Data type string.text.value
campaign__labels
Field label Labels
Description Custom label specifies character strings to group page URLs
Field type dimension
Data type string.text.value
ad__click_type
Field label Click type
Description The type of click
Field type dimension
Data type string.text.value
ad__network
Field label Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value
ad__device
Field label Device
Description Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices
Field type dimension
Data type string.text.value
ad__labels
Field label Labels
Description Custom label specifies character strings to group page URLs
Field type dimension
Data type string.text.value
keywords__click_type
Field label Click type
Description The type of click
Field type dimension
Data type string.text.value
keywords__network
Field label Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value
keywords__device
Field label Device
Description Devices to which advertisements are delivered, such as PCs, smartphones, and tablets, are called devices
Field type dimension
Data type string.text.value
keywords__labels
Field label Labels
Description Custom label specifies character strings to group page URLs
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
campaign__year
Field label Year
Field type dimension
Data type string.time.year
campaign__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
campaign__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
campaign__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
campaign__month
Field label Month
Field type dimension
Data type string.time.month
campaign__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
campaign__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
campaign__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
campaign__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
campaign__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
campaign__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
campaign__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
campaign__date
Field label Date
Field type dimension
Data type string.time.date
campaign__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
ad__year
Field label Year
Field type dimension
Data type string.time.year
ad__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
ad__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
ad__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
ad__month
Field label Month
Field type dimension
Data type string.time.month
ad__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
ad__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
ad__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
ad__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
ad__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
ad__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
ad__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
ad__date
Field label Date
Field type dimension
Data type string.time.date
ad__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
keywords__year
Field label Year
Field type dimension
Data type string.time.year
keywords__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
keywords__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
keywords__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
keywords__month
Field label Month
Field type dimension
Data type string.time.month
keywords__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
keywords__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
keywords__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
keywords__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
keywords__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
keywords__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
keywords__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
keywords__date
Field label Date
Field type dimension
Data type string.time.date
keywords__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
geo__year
Field label Year
Field type dimension
Data type string.time.year
geo__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
geo__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
geo__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
geo__month
Field label Month
Field type dimension
Data type string.time.month
geo__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
geo__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
geo__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
geo__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
geo__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
geo__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
geo__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
geo__date
Field label Date
Field type dimension
Data type string.time.date
geo__atom
Field label Datetime
Field type dimension
Data type string.time.datetime