Yahoo! Japan Display Ads fields

52 metrics90 dimensions

Search fields

ACCOUNT

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

ad__ad_id

Field label	Ad ID
Description	An unique ID provided for each ad
Field type	dimension
Data type	string.text.value

ad__ad_name

Field label	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

Field label	Ad title
Description	The title of the ad
Field type	dimension
Data type	string.text.value

ad__ad_type

Field label	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__responsive_ads_type

Field label	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__ad_delivery_settings

Field label	Ad delivery settings
Description	The delivery setting of the ad
Field type	dimension
Data type	string.text.value

ad__ad_layout

Field label	Ad layout
Description	The layout of the ad
Field type	dimension
Data type	string.text.value

ad__ad_labels

Field label	Ad labels
Description	The labels of the ad
Field type	dimension
Data type	string.text.value

ad__ad_distribution

Field label	Ad distribution
Description	Ad distribution
Field type	dimension
Data type	string.text.value

ad__description_1

Field label	Description 1
Description	The first description of the ad
Field type	dimension
Data type	string.text.value

ad__description_2

Field label	Description 2
Description	The second description 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_id

Field label	Destination URL ID
Description	The ID of the ad URL
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__dynamic_image_extensions

Field label	Dynamic image extensions
Description	The dynamic image extensions option of the ad
Field type	dimension
Data type	string.text.value

ad__final_url

Field label	Final URL
Description	Enter a URL that appears when a user clicks your ad
Field type	dimension
Data type	string.text.url

ad__tracking_url

Field label	Tracking URL
Description	To track your ads, add a tracking URL. You don't need this setting when you don't
Field type	dimension
Data type	string.text.url

AD GROUP

ad__adgroup_id

Field label	Ad Group ID
Description	An unique ID provided for each 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

ad__adgroup_delivery_settings

Field label	Ad group delivery settings
Description	The delivery setting of the ad group
Field type	dimension
Data type	string.text.value

ad__adgroup_labels

Field label	Ad group labels
Description	The labels of the ad group
Field type	dimension
Data type	string.text.value

ALL CONVERSIONS

ad__all_conversion

Field label	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__cost_per_all_conv

Field label	Cost/conv. (all)
Description	Advertising cost per all conversion. It is calculated by Cost / All conversion
Field type	metric
Data type	float.currency.value

ad__all_conversion_value

Field label	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__all_conv_value_per_all_conv

Field label	Conv. value (all)/conv. (all)
Description	The value of sales, etc. generated per Conversion (all). Calculated by Conv. value (all) / conv.(all)
Field type	metric
Data type	float.currency.value

ad__all_conversion_value_per_cost

Field label	Conv. value (all)/cost
Description	This indicates how much you earned in relation to your advertising cost. When you set sales amount as a conversion value, it is called return on ad spend (ROAS). It is calculated by All conversion value / Cost
Field type	metric
Data type	float.currency.value

ad__all_conversion_rate

Field label	Conversion rate (all)
Description	Ratio of clicks and 10 second video views that resulted in one or more conversions. Calculated by all conversions / (clicks + 10 second video views)
Field type	metric
Data type	float.number.ratio

APP

ad__app_name

Field label	App name
Description	App name set for the campaign
Field type	dimension
Data type	string.text.value

ad__app_os

Field label	App OS
Description	App OS set for the campaign
Field type	dimension
Data type	string.text.value

ad__app_id

Field label	App ID/Package name
Description	App ID/ package name set for the campaign
Field type	dimension
Data type	string.text.value

ad__web_app

Field label	Web/App
Description	Web/app set for the campaign
Field type	dimension
Data type	string.text.value

AUDIENCE

ad__gender

Field label	Gender
Description	Gender of person who viewed the ad
Field type	dimension
Data type	string.person.gender

ad__age

Field label	Age
Description	Age of the person who viewed the ad
Field type	dimension
Data type	string.person.age

CAMPAIGN

ad__campaign_id

Field label	Campaign ID
Description	An unique ID provided for each campaign
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

ad__campaign_delivery_settings

Field label	Campaign delivery settings
Description	The delivery settings of the campaign
Field type	dimension
Data type	string.text.value

ad__campaign_type

Field label	Campaign type
Description	The campaign type
Field type	dimension
Data type	string.text.value

ad__campaign_delivery_type

Field label	Campaign delivery type
Description	The campaign delivery type
Field type	dimension
Data type	string.text.value

ad__campaign_labels

Field label	Campaign labels
Description	The campaign labels
Field type	dimension
Data type	string.text.value

ad__campaign_goals

Field label	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_buying_type

Field label	Campaign buying type
Description	The buying type of the campaign
Field type	dimension
Data type	string.text.value

ad__destination_url_campaign_banner

Field label	Destination URL (campaign banner)
Description	The destination URL when user clicks campaign banner
Field type	dimension
Data type	string.text.url

CONVERSION

ad__conversion_id

Field label	Conversion ID
Description	The ID of the conversion
Field type	dimension
Data type	string.text.value

ad__conversion_name

Field label	Conversion name
Description	Name of 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

ad__conversion_group_id

Field label	Conversion group ID
Description	The ID of conversion group
Field type	dimension
Data type	string.text.value

ad__conversion_group_name

Field label	Conversion group name
Description	The name of conversion group
Field type	dimension
Data type	string.text.value

CONVERSIONS

ad__conversions

Field label	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__cost_per_conv

Field label	Cost/conv.
Description	Advertising cost per conversion. It is calculated by Cost / Conversions
Field type	metric
Data type	float.currency.value

ad__conversion_value

Field label	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__value_per_conv

Field label	Conv. value/conv.
Description	The value of sales, etc. generated per “Conversion.”. It is calculated by Conversion Value / Conversions
Field type	metric
Data type	float.currency.value

ad__conversion_value_per_cost

Field label	Conv. value/cost
Description	This indicates how much you earned in relation to your advertising cost. When you set sales amount as a conversion value, it is called return on ad spend (ROAS). It is calculated by Conversion Value / Cost
Field type	metric
Data type	float.currency.value

ad__cross_device_conversion

Field label	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__view_through_conv

Field label	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__conv_rate

Field label	Conversion rate
Description	The ratio of clicks and 10 second video views that resulted in a conversion. Calculated by Conversions / (Clicks + 10 second Video Views)
Field type	metric
Data type	float.number.ratio

CONVERSIONS VIA CLICK

ad__conversions_via_ad_click

Field label	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__conversion_rate_via_ad_click

Field label	Conv. rate (via click)
Description	A ratio of valuable actions (purchase, membership registry, document request, etc.) by users who clicked your ad and visited your website. Calculated by Conversions (via click) / clicks
Field type	metric
Data type	float.number.ratio

ad__cost_per_conv_via_ad_click

Field label	Cost/conv. (via click)
Description	Advertising cost per “Conversion”. Calculated by Cost / conversions (via click)
Field type	metric
Data type	float.number.ratio

ad__conv_value_via_ad_click

Field label	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__value_per_conv_via_ad_click

Field label	Conv. value (via click)/conv. (via click)
Description	The value of sales, etc. generated per Conversion (via click). Calculated by Conv. value (via click) / conversions (via click)
Field type	metric
Data type	float.number.ratio

ad__conv_value_via_ad_click_per_cost

Field label	Conv. value (via click)/cost
Description	This indicates how much you earned in relation to your advertising cost. When you set sales amount as a conversion value, it is called return on ad spend (ROAS). Calculated by Conv. value (via ad click) / cost
Field type	metric
Data type	float.number.ratio

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

DEVICE

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__os

Field label	OS
Description	OS of the device used
Field type	dimension
Data type	string.text.value

ad__carrier

Field label	Carrier
Description	Name of the carrier
Field type	dimension
Data type	string.text.value

ad__package_name

Field label	Package name
Description	Name of the package
Field type	dimension
Data type	string.text.value

GEO

ad__prefecture_id

Field label	Prefecture ID
Description	The region/area ID
Field type	dimension
Data type	string.text.value

ad__prefecture

Field label	Prefectures
Description	A region or area where the event happened
Field type	dimension
Data type	string.geo.region

ad__city_id

Field label	City ID
Description	The ID of the city
Field type	dimension
Data type	string.text.value

ad__city_name

Field label	City name
Description	City where the event happened
Field type	dimension
Data type	string.geo.city

ad__ward_id

Field label	Ward ID
Description	The ward ID
Field type	dimension
Data type	string.text.value

ad__ward_name

Field label	Ward name
Description	The ward name
Field type	dimension
Data type	string.text.value

ad__radius_target

Field label	Target radius
Description	Target radius where the event happened
Field type	dimension
Data type	string.text.value

ad__radius_distance

Field label	Distance from target location
Description	Distance from target location where the event happened
Field type	dimension
Data type	string.text.value

KEYWORD

ad__search_keyword_id

Field label	Search keyword ID
Description	The ID of the search keyword
Field type	dimension
Data type	string.text.value

ad__search_keyword

Field label	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__content_keyword_id

Field label	Content keyword ID
Description	The ID of the content keyword
Field type	dimension
Data type	string.text.value

ad__content_keyword

Field label	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

MAIN METRICS

ad__impressions

Field label	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__clicks

Field label	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__cost

Field label	Cost
Description	Total amount of advertising cost, 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 your ad received to the number of times your ad is shown. 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__avg_cpm

Field label	Avg. CPM
Description	The average advertising cost per 1,000 impressions. Calculated by total cost (or budget) / impressions x 1000
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

MEDIA

ad__media_id

Field label	Media ID
Description	An unique ID provided for each media (image, video)
Field type	dimension
Data type	string.text.value

ad__media_name

Field label	Media name
Description	A name to identify the media (image, video) set to ads
Field type	dimension
Data type	string.text.value

ad__media_file_name

Field label	Media file name
Description	A name to identify the media file attached to ads
Field type	dimension
Data type	string.text.value

ad__main_media_format

Field label	Main media format
Description	the main media format of the ads
Field type	dimension
Data type	string.text.value

ad__pixel_size

Field label	Pixel size
Description	Pixel size (length x width) for media (image, video) set to ads
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

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

VIDEO

ad__video_views

Field label	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_3_sec

Field label	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_10_sec

Field label	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_25

Field label	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_50

Field label	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

Field label	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

Field label	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__video_views_to_100

Field label	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__paid_video_views

Field label	Paid video views (CPV)
Description	Number of paid video view
Field type	metric
Data type	int.number.value

ad__video_views_to_25_rate

Field label	25% video views rate
Description	The rate at which videos are viewed to 25% of their total length relative to the total number of videos initiated appears. Calculated by 25% video views/ Video views
Field type	metric
Data type	float.number.ratio

ad__video_views_to_50_rate

Field label	50% video views rate
Description	The rate at which videos are viewed to 50% of their total length relative to the total number of videos initiated appears. Calculated by 50% video views/ Video views
Field type	metric
Data type	float.number.ratio

ad__video_views_to_75_rate

Field label	75% video views rate
Description	The rate at which videos are viewed to 75% of their total length relative to the total number of videos initiated appears. Calculated by 75% video views/ Video views
Field type	metric
Data type	float.number.ratio

ad__video_views_to_95_rate

Field label	95% video views rate
Description	The rate at which videos are viewed to 95% of their total length relative to the total number of videos initiated appears. Calculated by 95% video views/ Video views
Field type	metric
Data type	float.number.ratio

ad__video_view_through_rate

Field label	Video view through rate
Description	The rate at which videos are viewed to the end (100% of their total length) relative to the total number of videos initiated appears. Calculated by 100% video views/ Video views
Field type	metric
Data type	float.number.ratio

ad__paid_video_views_rate

Field label	Paid video views rate (CPV)
Description	The rate at which paid videos are viewed relative to the total number of videos initiated appears. Calculated by Paid video views/ Video views
Field type	metric
Data type	float.number.ratio

VIEWABILITY

ad__viewable_impressions

Field label	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_rate

Field label	Viewable impressions rate
Description	The ratio of viewable impressions to measured impressions. Viewable impression rate = Viewable impressions / measured impressions
Field type	metric
Data type	float.number.ratio

ad__viewable_clicks

Field label	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_ctr

Field label	Viewable CTR
Description	A ratio showing the number of viewable clicks to the viewable impressions. Viewable CTR = viewable clicks / viewable impressions
Field type	metric
Data type	float.number.ratio

ad__measured_impressions

Field label	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__measured_impressions_rate

Field label	Measured impression rate
Description	The ratio of impressions that can be counted as viewable impressions. Depending on ad places, viewable impressions may not be counted. Measured impression rate = measured impressions / impressions
Field type	metric
Data type	float.number.ratio

ad__viewable_impressions_per_panel

Field label	Viewable impressions per panel
Description	Number of viewable impressions per panel
Field type	metric
Data type	int.number.value