Yahoo! Japan Display Ads data warehouse table groups

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

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_delivery_settings
Display name Ad delivery settings
Description The delivery setting of the ad
Field type dimension
Data type string.text.value
ad__ad_distribution
Display name Ad distribution
Description Ad distribution
Field type dimension
Data type string.text.value
ad__ad_id
Display name Ad ID
Description An unique ID provided for each ad
Field type dimension
Data type string.text.value
ad__ad_labels
Display name Ad labels
Description The labels of the ad
Field type dimension
Data type string.text.value
ad__ad_layout
Display name Ad layout
Description The layout of the ad
Field type dimension
Data type string.text.value
ad__ad_name
Display name Ad Name
Description A name to identify the ad. For banner and responsive ad types, the media name of your image or video appears as default. You can change the ad name afterward
Field type dimension
Data type string.text.value
ad__ad_title
Display name Ad title
Description The title of the ad
Field type dimension
Data type string.text.value
ad__ad_type
Display name Ad Type
Description It shows the device and number of characters in the ad. You can set this type when creating ads. You can check it on the list of ads viewed
Field type dimension
Data type string.text.value
ad__adgroup_delivery_settings
Display name Ad group delivery settings
Description The delivery setting of the ad group
Field type dimension
Data type string.text.value
ad__adgroup_id
Display name Ad Group ID
Description An unique ID provided for each ad group
Field type dimension
Data type string.text.value
ad__adgroup_labels
Display name Ad group labels
Description The labels 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__age
Display name Age
Description Age of the person who viewed the ad
Field type dimension
Data type string.person.age
ad__all_conversion
Display name Conversions (all)
Description The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad or visited your website after viewing the paid video for 10 seconds or more. This metric counts regardless of the conversion-counting setting. When the counting type is One per click, the multiple conversions brought by one conversion action count one while Many per click count all conversions
Field type metric
Data type int.number.value
ad__all_conversion_value
Display name Conv. value (all)
Description The value of sales, etc. brought by Conversion (all). The sum of Value per conv. set for conversion tracking tag is shown
Field type metric
Data type float.currency.value
ad__app_id
Display name App ID/Package name
Description App ID/ package name set for the campaign
Field type dimension
Data type string.text.value
ad__app_name
Display name App name
Description App name set for the campaign
Field type dimension
Data type string.text.value
ad__app_os
Display name App OS
Description App OS set for the campaign
Field type dimension
Data type string.text.value
ad__atom
Display name Datetime
Field type dimension
Data type string.time.datetime
ad__campaign_buying_type
Display name Campaign buying type
Description The buying type of the campaign
Field type dimension
Data type string.text.value
ad__campaign_delivery_settings
Display name Campaign delivery settings
Description The delivery settings of the campaign
Field type dimension
Data type string.text.value
ad__campaign_delivery_type
Display name Campaign delivery type
Description The campaign delivery type
Field type dimension
Data type string.text.value
ad__campaign_goals
Display name Campaign goals
Description The campaign's goal set to achieve your business goal appears. NONE appears when a campaign doesn't have a goal
Field type dimension
Data type string.text.value
ad__campaign_id
Display name Campaign ID
Description An unique ID provided for each campaign
Field type dimension
Data type string.text.value
ad__campaign_labels
Display name Campaign labels
Description The campaign labels
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_type
Display name Campaign type
Description The campaign type
Field type dimension
Data type string.text.value
ad__carrier
Display name Carrier
Description Name of the carrier
Field type dimension
Data type string.text.value
ad__city_id
Display name City ID
Description The ID of the city
Field type dimension
Data type string.text.value
ad__city_name
Display name City name
Description City where the event happened
Field type dimension
Data type string.geo.city
ad__clicks
Display name Clicks
Description The number of times your ad was clicked by internet users. This indicates the traffic to your website
Field type metric
Data type int.number.value
ad__content_keyword
Display name Content keyword
Description Performance per content keyword appears. The content keyword column will be blank for the performance of the ad group if the content keyword targeting isn't set up or only the Exclude content keyword is associated
Field type dimension
Data type string.text.value
ad__content_keyword_id
Display name Content keyword ID
Description The ID of the content keyword
Field type dimension
Data type string.text.value
ad__conv_value_via_ad_click
Display name Conv. value (via click)
Description The value of sales, etc. generated per Conversion (via click). The sum of Value per conv. set for conversion tracking tag appears
Field type metric
Data type int.number.value
ad__conversion_value
Display name Conv. value
Description The value of sales, etc. generated by Conversions. The sum of Value per conversion set for conversion tracking tag is shown
Field type metric
Data type float.currency.value
ad__conversions
Display name Conversions
Description The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad or visited your website after viewing the paid video for 10 seconds or more. This metric counts regardless of the conversion-counting setting. When the counting type is One per click, the multiple conversions resulted from one conversion action count one while Many per click count all conversions. This value doesn't include view-through conversions
Field type metric
Data type int.number.value
ad__conversions_via_ad_click
Display name Conversions (via click)
Description The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad and visited your website. When the counting type is One per click, the multiple conversions resulted from one conversion action count one while Many per click count all conversions
Field type metric
Data type int.number.value
ad__cost
Display name Cost
Description Total amount of advertising cost, 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 Cross-device conv.
Description A number of valuable actions (purchase, membership registry, document request, etc.) using the different device from the ad click
Field type metric
Data type int.number.value
ad__date
Display name Date
Field type dimension
Data type string.time.date
ad__description_1
Display name Description 1
Description The first description of the ad
Field type dimension
Data type string.text.value
ad__description_2
Display name Description 2
Description The second description of the ad
Field type dimension
Data type string.text.value
ad__destination_url
Display name Destination URL
Description The destination URL of the ad
Field type dimension
Data type string.text.url
ad__destination_url_campaign_banner
Display name Destination URL (campaign banner)
Description The destination URL when user clicks campaign banner
Field type dimension
Data type string.text.url
ad__destination_url_id
Display name Destination URL ID
Description The ID of the ad URL
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__dynamic_image_extensions
Display name Dynamic image extensions
Description The dynamic image extensions option of the ad
Field type dimension
Data type string.text.value
ad__gender
Display name Gender
Description Gender of person who viewed the ad
Field type dimension
Data type string.person.gender
ad__impressions
Display name Impressions
Description The number of times your ads appear. It includes ad appearances outside of a user's visible area
Field type metric
Data type int.number.value
ad__main_media_format
Display name Main media format
Description the main media format of the ads
Field type dimension
Data type string.text.value
ad__measured_impressions
Display name Measured impressions
Description The number of impressions that can be counted as viewable impressions. Depending on ad places, viewable impressions may not be counted. The impressions are counted with client-side measurement
Field type metric
Data type int.number.value
ad__media_file_name
Display name Media file name
Description A name to identify the media file attached to ads
Field type dimension
Data type string.text.value
ad__media_id
Display name Media ID
Description An unique ID provided for each media (image, video)
Field type dimension
Data type string.text.value
ad__media_name
Display name Media name
Description A name to identify the media (image, video) set to ads
Field type dimension
Data type string.text.value
ad__os
Display name OS
Description OS of the device used
Field type dimension
Data type string.text.value
ad__package_name
Display name Package name
Description Name of the package
Field type dimension
Data type string.text.value
ad__paid_video_views
Display name Paid video views (CPV)
Description Number of paid video view
Field type metric
Data type int.number.value
ad__pixel_size
Display name Pixel size
Description Pixel size (length x width) for media (image, video) set to ads
Field type dimension
Data type string.text.value
ad__prefecture
Display name Prefectures
Description A region or area where the event happened
Field type dimension
Data type string.geo.region
ad__prefecture_id
Display name Prefecture ID
Description The region/area ID
Field type dimension
Data type string.text.value
ad__responsive_ads_type
Display name Responsive ads type
Description Responsive ad types appear. Assets (multiple elements): this ad type changes the contents of your ads by using multiple images and titles you uploaded. Fixed: this ad type shows fixed contents
Field type dimension
Data type string.text.value
ad__search_keyword
Display name Search keyword
Description Performance per search keyword appears. The search keyword column will be blank for the performance of the ad group if the search keyword targeting isn't set up
Field type dimension
Data type string.text.value
ad__search_keyword_id
Display name Search keyword ID
Description The ID of the search keyword
Field type dimension
Data type string.text.value
ad__video_views
Display name Video views
Description Number of video view started. Includes short views that are not charged
Field type metric
Data type int.number.value
ad__video_views_to_10_sec
Display name 10 sec video views
Description The number of video viewed longer than 11 seconds. If the video is shorter than 11 seconds, the video view is counted when the video is watched to the end. For CPV, the number of paid video view has the same value with this 10 sec video views
Field type metric
Data type int.number.value
ad__video_views_to_100
Display name 100% video views
Description The number of times the video is viewed to 100% of total time
Field type metric
Data type int.number.value
ad__video_views_to_25
Display name 25% video views
Description The number of times the video is viewed to 25% of total time
Field type metric
Data type int.number.value
ad__video_views_to_3_sec
Display name 3 sec video views
Description Number of video views for 3 seconds or more
Field type metric
Data type int.number.value
ad__video_views_to_50
Display name 50% video views
Description The number of times the video is viewed to 50% of total time
Field type metric
Data type int.number.value
ad__video_views_to_75
Display name 75% video views
Description The number of times the video is viewed to 75% of total time
Field type metric
Data type int.number.value
ad__video_views_to_95
Display name 95% video views
Description The number of times the video is viewed to 95% of total time
Field type metric
Data type int.number.value
ad__view_through_conv
Display name View-through conversions
Description The number of actions (purchase, membership registry, document request, etc.) by users who didn't click ads nor view videos appear. They reached your site with a different path
Field type metric
Data type int.number.value
ad__viewable_clicks
Display name Viewable clicks
Description The number of clicks for ad appearance that are counted as viewable impressions
Field type metric
Data type int.number.value
ad__viewable_impressions
Display name Viewable impressions
Description The number of ad appearances in a user's visible area appears. To check the number of ad appearances outside of a user's visible area, see Impressions
Field type metric
Data type int.number.value
ad__viewable_impressions_per_panel
Display name Viewable impressions per panel
Description Number of viewable impressions per panel
Field type metric
Data type int.number.value
ad__ward_id
Display name Ward ID
Description The ward ID
Field type dimension
Data type string.text.value
ad__ward_name
Display name Ward name
Description The ward name
Field type dimension
Data type string.text.value
ad__web_app
Display name Web/App
Description Web/app set for the campaign
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: CONVERSION

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__all_conversion
Display name Conversions (all)
Description The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad or visited your website after viewing the paid video for 10 seconds or more. This metric counts regardless of the conversion-counting setting. When the counting type is One per click, the multiple conversions brought by one conversion action count one while Many per click count all conversions
Field type metric
Data type int.number.value
ad__all_conversion_value
Display name Conv. value (all)
Description The value of sales, etc. brought by Conversion (all). The sum of Value per conv. set for conversion tracking tag is shown
Field type metric
Data type float.currency.value
ad__conv_value_via_ad_click
Display name Conv. value (via click)
Description The value of sales, etc. generated per Conversion (via click). The sum of Value per conv. set for conversion tracking tag appears
Field type metric
Data type int.number.value
ad__conversion_id
Display name Conversion ID
Description The ID of the conversion
Field type dimension
Data type string.text.value
ad__conversion_name
Display name Conversion name
Description Name of conversion
Field type dimension
Data type string.text.value
ad__conversion_value
Display name Conv. value
Description The value of sales, etc. generated by Conversions. The sum of Value per conversion set for conversion tracking tag is shown
Field type metric
Data type float.currency.value
ad__conversions
Display name Conversions
Description The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad or visited your website after viewing the paid video for 10 seconds or more. This metric counts regardless of the conversion-counting setting. When the counting type is One per click, the multiple conversions resulted from one conversion action count one while Many per click count all conversions. This value doesn't include view-through conversions
Field type metric
Data type int.number.value
ad__conversions_via_ad_click
Display name Conversions (via click)
Description The number of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad and visited your website. When the counting type is One per click, the multiple conversions resulted from one conversion action count one while Many per click count all conversions
Field type metric
Data type int.number.value
ad__cross_device_conversion
Display name Cross-device conv.
Description A number of valuable actions (purchase, membership registry, document request, etc.) using the different device from the ad click
Field type metric
Data type int.number.value
ad__date
Display name Date
Field type dimension
Data type string.time.date
ad__objective_of_conversion_tracking
Display name Objective of conversion tracking
Description The Objective of Conversion Tracking
Field type dimension
Data type string.text.value
ad__view_through_conv
Display name View-through conversions
Description The number of actions (purchase, membership registry, document request, etc.) by users who didn't click ads nor view videos appear. They reached your site with a different path
Field type metric
Data type int.number.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