Yahoo! Japan Search Ads data warehouse table groups

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

Table: CAMPAIGN

campaign__account_id
Display name 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
Display name 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
campaign__all_conversion
Display name 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_value
Display name Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
campaign__bid_strategy_type
Display name Bid strategy type
Description The type of the bid strategy
Field type dimension
Data type string.text.value
campaign__campaign_distribution_settings
Display name Distribution settings
Description The distribution settings of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_distribution_status
Display name Distribution status
Description The distribution status of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_end_date
Display name End date
Description The end date of the campaign
Field type dimension
Data type string.time.date
campaign__campaign_id
Display name 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
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign__campaign_start_date
Display name Start date
Description The start date of the campaign
Field type dimension
Data type string.time.date
campaign__campaign_tracking_id
Display name Campaign tracking ID
Description The ID of campaign tracking. Please note that this field will be removed on 2025-08-26
Field type dimension
Data type string.text.value
campaign__campaign_type
Display name 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__click_type
Display name Click type
Description The type of click
Field type dimension
Data type string.text.value
campaign__clicks
Display name Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
campaign__conversion_value
Display name Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
campaign__conversions
Display name 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__cost
Display name Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
campaign__cost_eur
Display name Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
campaign__cost_gbp
Display name Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
campaign__cost_usd
Display name Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
campaign__cross_device_conversion
Display name Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value
campaign__daily_spending_limit
Display name Daily spending limit
Description The daily budget set for each campaign
Field type dimension
Data type float.currency.value
campaign__date
Display name Date
Field type dimension
Data type string.time.date
campaign__enhanced_cpc_enabled
Display name Enhanced CPC
Description When Enhanced CPC is set, the keyword bid will be automatically adjusted to achieve as many conversion as possible. Please note that this field will be removed on 2025-07-19
Field type dimension
Data type bool
campaign__impressions
Display name Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
campaign__invalid_clicks
Display name 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
campaign__labels
Display name Labels
Description Custom label specifies character strings to group page URLs
Field type dimension
Data type string.text.value
campaign__network
Display name Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value
campaign__portfolio_bidding_id
Display name Portfolio bidding ID
Description The ID of the portfolio bidding
Field type dimension
Data type string.text.value
campaign__portfolio_bidding_name
Display name Portfolio bidding name
Description The name of the portfolio bidding
Field type dimension
Data type string.text.value
campaign__tracking_url
Display name Tracking URL
Description The tracking URL of the campaign
Field type dimension
Data type string.text.url
dataSourceName
Display name 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

Table: AD

ad__account_id
Display name 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
Display name 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_distribution_settings
Display name Ad distribution settings
Description The distribution settings of the ad
Field type dimension
Data type string.text.value
ad__ad_editorial_status
Display name Ad editorial status
Description The editorial status of the ad
Field type dimension
Data type string.text.value
ad__ad_id
Display name Ad ID
Description The ID of the ad
Field type dimension
Data type string.text.value
ad__ad_name
Display name Ad Name
Description The name of the ad
Field type dimension
Data type string.text.value
ad__ad_tracking_id
Display name Ad tracking ID
Description The tracking ID of the ad
Field type dimension
Data type string.text.value
ad__ad_type
Display name Ad Type
Description The type of the ad
Field type dimension
Data type string.text.value
ad__adgroup_id
Display name Ad group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
ad__adgroup_name
Display name Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
ad__adgroup_tracking_id
Display name Adgroup tracking ID
Description The tracking ID of the Adgroup. Please note that this field will be removed on 2025-08-26
Field type dimension
Data type string.text.value
ad__all_conversion
Display name 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_value
Display name Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
ad__campaign_id
Display name 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
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
ad__campaign_tracking_id
Display name Campaign tracking ID
Description The ID of campaign tracking. Please note that this field will be removed on 2025-08-26
Field type dimension
Data type string.text.value
ad__click_type
Display name Click type
Description The type of click
Field type dimension
Data type string.text.value
ad__clicks
Display name Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
ad__conversion_value
Display name Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
ad__conversions
Display name 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__cost
Display name Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
ad__cost_eur
Display name Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
ad__cost_gbp
Display name Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
ad__cost_usd
Display name Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
ad__cross_device_conversion
Display name Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value
ad__date
Display name Date
Field type dimension
Data type string.time.date
ad__destination_url
Display name Destination URL
Description The destination URL of the ad
Field type dimension
Data type string.text.url
ad__device
Display name 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__display_url
Display name Display URL
Description The display URL of the ad
Field type dimension
Data type string.text.url
ad__impressions
Display name Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
ad__labels
Display name Labels
Description Custom label specifies character strings to group page URLs
Field type dimension
Data type string.text.value
ad__network
Display name Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value
ad__title_1
Display name Title1
Description The title 1 of the ad
Field type dimension
Data type string.text.value
ad__title_2
Display name Title2
Description The title 2 of the ad
Field type dimension
Data type string.text.value
ad__title_3
Display name Title3
Description The title 1 of the ad
Field type dimension
Data type string.text.value
dataSourceName
Display name 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

Table: KEYWORD

dataSourceName
Display name 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
keywords__account_id
Display name 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
Display name 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__adgroup_bid
Display name Adgroup bid
Description Bid price for adgroup
Field type dimension
Data type float.currency.value
keywords__adgroup_id
Display name Ad Group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
keywords__adgroup_name
Display name Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
keywords__adgroup_tracking_id
Display name Adgroup tracking ID
Description The tracking ID of the Adgroup. Please note that this field will be removed on 2025-08-26
Field type dimension
Data type string.text.value
keywords__all_conversion
Display name 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_value
Display name Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
keywords__campaign_id
Display name 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
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
keywords__campaign_tracking_id
Display name Campaign tracking ID
Description The ID of campaign tracking. Please note that this field will be removed on 2025-08-26
Field type dimension
Data type string.text.value
keywords__click_type
Display name Click type
Description The type of click
Field type dimension
Data type string.text.value
keywords__clicks
Display name Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
keywords__conversion_value
Display name Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
keywords__conversions
Display name 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__cost
Display name Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
keywords__cost_eur
Display name Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
keywords__cost_gbp
Display name Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
keywords__cost_usd
Display name Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
keywords__cross_device_conversion
Display name Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value
keywords__date
Display name Date
Field type dimension
Data type string.time.date
keywords__device
Display name 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__impressions
Display name Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
keywords__keyword
Display name Keyword
Description The keyword used to describe the ad
Field type dimension
Data type string.text.value
keywords__keyword_distribution_settings
Display name Keyword distribution settings
Description The distribution settings of keyword
Field type dimension
Data type string.text.value
keywords__keyword_editorial_status
Display name Keyword editorial status
Description The editorial status of keyword
Field type dimension
Data type string.text.value
keywords__keyword_id
Display name Keyword ID
Description The ID of the keyword
Field type dimension
Data type string.text.value
keywords__keyword_tracking_id
Display name Keyword tracking ID
Description The tracking ID of the keyword
Field type dimension
Data type string.text.value
keywords__labels
Display name Labels
Description Custom label specifies character strings to group page URLs
Field type dimension
Data type string.text.value
keywords__match_type
Display name Match type
Description The keyword match type
Field type dimension
Data type string.text.value
keywords__network
Display name Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value

Table: GEO

dataSourceName
Display name 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
geo__account_id
Display name 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
Display name 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__adgroup_id
Display name Ad Group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
geo__adgroup_name
Display name Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
geo__adgroup_tracking_id
Display name Adgroup tracking ID
Description The tracking ID of the Adgroup. Please note that this field will be removed on 2025-08-26
Field type dimension
Data type string.text.value
geo__all_conversion
Display name 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_value
Display name Conversion value (all)
Description The value of all conversion
Field type metric
Data type float.currency.value
geo__campaign_id
Display name 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
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
geo__campaign_tracking_id
Display name Campaign tracking ID
Description The ID of campaign tracking. Please note that this field will be removed on 2025-08-26
Field type dimension
Data type string.text.value
geo__city
Display name City
Description City where the event happened
Field type dimension
Data type string.geo.city
geo__clicks
Display name Clicks
Description Number of times an ad was clicked
Field type metric
Data type int.number.value
geo__conversion_value
Display name Conversion value
Description The value of conversion
Field type metric
Data type float.currency.value
geo__conversions
Display name 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__cost
Display name Cost
Description The charge generated by clicking, default currency is in JPY
Field type metric
Data type float.currency.value
geo__cost_eur
Display name Cost (EUR)
Description Cost converted to EUR
Field type metric
Data type float.currency.value
geo__cost_gbp
Display name Cost (GBP)
Description Cost converted to GBP
Field type metric
Data type float.currency.value
geo__cost_usd
Display name Cost (USD)
Description Cost converted to USD
Field type metric
Data type float.currency.value
geo__country_territory
Display name Country/territory
Description Country/territory where the event happened
Field type dimension
Data type string.geo.country
geo__cross_device_conversion
Display name Conversion across devices
Description The number of conversion across devices
Field type metric
Data type int.number.value
geo__date
Display name Date
Field type dimension
Data type string.time.date
geo__device
Display name 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__impressions
Display name Impressions
Description Number of times an ad was displayed
Field type metric
Data type int.number.value
geo__location_type
Display name Location type
Description Location type
Field type dimension
Data type string.text.value
geo__metro_area
Display name Metro area
Description The metropolitan area where the event happened
Field type dimension
Data type string.geo.metro
geo__most_specific_location
Display name Location
Description The location where the event happened
Field type dimension
Data type string.text.value
geo__network
Display name Network
Description The network the ad is shown on
Field type dimension
Data type string.text.value
geo__prefecture
Display name Prefecture
Description A region or area where the event happened
Field type dimension
Data type string.geo.region