Yahoo! JAPAN Ads: Most-used fields

The table below gives information about most-used fields that you can import from Yahoo! JAPAN Ads. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
ABSOLUTE_TOP_IMPRESSION_PERCENTAGE	Search absolute top impression rate	The percentage of impressions that appear in the absolute top position of search results.	metric
ACCOUNT_ID	Account ID	The unique identifier for the advertiser account.	dimension
ACCOUNT_NAME	Account Name	The name of the advertiser account.	dimension
ADGROUP_BID	Ad group bid	The bid amount set for the ad group.	metric
ADGROUP_ID	Ad group ID	The unique identifier for the ad group.	dimension
ADGROUP_NAME	Ad group name	The name of the ad group.	dimension
ADGROUP_TRACKING_ID	Ad group tracking ID	The unique identifier for the ad group.	dimension
AD_EDITORIAL_STATUS	Editorial Status	The editorial status of the ad or keyword.	dimension
AD_ID	Ad ID	The unique identifier for the ad.	dimension
AD_KEYWORD_ID	Keyword ID	The unique identifier for the keyword associated with an ad.	dimension
AD_NAME	Ad Name	The name of the ad.	dimension
AD_TYPE	Ad Type	The type of the ad, such as text ad, responsive search ad, etc.	dimension
ALL_CONV	Conversions (all)	The total number of all conversions, including cross-device conversions.	metric
ALL_CONV_RATE	Conv. rate (all)	The ratio of clicks and 10-second video views that resulted in one or more valuable actions by users, such as a purchase or membership registration. It is calculated by dividing ‘all conversions’ by the sum of clicks and 10-second video views.	metric
ALL_CONV_VALUE	Conv. value (all)	The total value of all conversions, including cross-device conversions.	metric
AVG_CPC	Avg. CPC	The average cost-per-click (CPC) for your ads.	metric
Ad Group ID	Ad Group ID	The unique identifier for the ad group.	metric
Ad Group Name	Ad Group Name	The name of the ad group.	dimension
All Conv.	All Conv.	The total number of all conversions, including cross-device conversions.	metric
All Conv. Value	All Conv. Value	The total value of all conversions, including cross-device conversions.	metric
BID	Bid (JPY)	The bid amount set for the keyword or ad group.	metric
BUDGET_LOST_IMPRESSION_SHARE	Lost impression share (budget)	The estimated percentage of impressions that your ads didn’t receive due to insufficient budget.	metric
Budget Lost Impression Share	Budget Lost Impression Share	The estimated percentage of impressions that your ads didn’t receive due to insufficient budget.	metric
CAMPAIGN_END_DATE	End Date	The end date of the campaign in YYYYMMDD format.	metric
CAMPAIGN_ID	CampaignID	The unique identifier for the campaign.	dimension
CAMPAIGN_NAME	Campaign name	The name of the campaign.	dimension
CAMPAIGN_START_DATE	Start Date	The start date of the campaign in YYYYMMDD format.	dimension
CAMPAIGN_TRACKING_ID	Campaign tracking ID	A unique identifier for a specific campaign in Yahoo! JAPAN Ads. This ID is used to track and report on campaign performance.	metric
CAMPAIGN_TYPE	Campaign type	The type of the campaign, such as Standard, Dynamic Ads for Search, etc.	dimension
CLICKS	Clicks	The number of clicks on your ads.	metric
CLICK_RATE	CTR	The click-through rate (CTR), calculated as Clicks / Impressions.	metric
CONVERSIONS	Conversions	The number of conversions recorded for your ads.	metric
CONVERSION_NAME	Conversion name	The name of the conversion.	dimension
CONV_RATE	Conv. rate	The ratio of clicks and 10-second video views that resulted in a conversion. It is calculated by dividing ‘conversions’ by the sum of clicks and 10-second video views. This metric does not include view-through conversions.	metric
CONV_VALUE	Conv. value	The total value of all conversions recorded.	metric
COST	Cost	The total cost of your ad clicks.	metric
COST_PER_ALL_CONV	Cost/conv. (all)	The cost per all conversions. This metric is calculated by dividing the total cost by the total number of all conversions.	metric
CROSS_DEVICE_CONVERSIONS	Cross-device conv.	The number of conversions that originated from a click on one device and completed on another device.	dimension
Campaign Name	Campaign Name	The name of the campaign.	dimension
DAILY_SPENDING_LIMIT	Daily Spending Limit	The maximum amount an ad campaign is allowed to spend per day. Ad delivery is controlled to stay within this limit.	dimension
DAY	Day	The date for the reported data in YYYYMMDD format.	dimension
DEVICE	Device	The type of device on which the ad was shown (e.g., PC, smartphone, tablet).	dimension
EXACT_MATCH_IMPRESSION_SHARE	Exact match impression share	The impression share for keywords that exactly matched the search query.	metric
FINAL_URL	Final URL	The landing page URL that users are directed to after clicking an ad.	dimension
FINAL_URL_SMARTPHONE	Smartphone final URL	The final URL for smartphones.	dimension
FIRST_PAGE_BID_ESTIMATE	First page bid estimate	An estimate of the bid needed for an ad to appear on the first page of search results.	metric
IMPRESSION_SHARE	Impression share	The percentage of impressions that your ads received compared to the total number of impressions your ads were eligible to receive.	metric
IMPS	Impressions	The number of times your ad was shown.	metric
INVALID_CLICKS	Invalid clicks	The number of invalid clicks.	metric
INVALID_CLICK_RATE	Invalid Click Rate	The rate of invalid clicks.	metric
Impression Share	Impression Share	The percentage of impressions that your ads received compared to the total number of impressions your ads were eligible to receive.	metric
KEYWORD	Keyword	The keyword text that triggered your ad.	dimension
KEYWORD_MATCH_TYPE	Match Type	The match type of the keyword (e.g., Broad, Phrase, Exact).	dimension
KEYWORD_TRACKING_ID	Keyword tracking ID	The unique identifier for the keyword.	dimension
LABELS	Label	Labels are custom tags that users can apply to their advertising campaigns and their components (such as ad groups, ads, and criteria) for organization and filtering. They provide a flexible way to categorize and manage different parts of an advertising account, enabling users to group related items for reporting or bulk operations.	dimension
MONTH	Month	A dimension for reporting that allows grouping or filtering data by month.	dimension
NEGATIVE_KEYWORD	Negative Keywords	The negative keyword associated with the ad group.	dimension
NETWORK	Show ads on	The network where your ad was shown (e.g., Search Network, Content Network).	dimension
Network	Network	The network where your ad was shown (e.g., Search Network, Content Network).	dimension
QUALITY_INDEX	Quality index	The Quality Index of your keyword, which measures the relevance and quality of your ads, keywords, and landing page.	metric
QUALITY_LOST_IMPRESSION_SHARE	Lost impression share (rank)	The estimated percentage of impressions that your ads didn’t receive due to low Ad Rank (quality score and bid).	metric
Quality Index	Quality Index	The Quality Index of your keyword, which measures the relevance and quality of your ads, keywords, and landing page.	metric
Quality Lost Impression Share	Quality Lost Impression Share	The estimated percentage of impressions that your ads didn’t receive due to low Ad Rank (quality score and bid).	metric
SEARCH_ABSOLUTE_TOP_IMPRESSION_SHARE	Search absolute top impression share	The impression share that appears in the absolute top position of search results.	metric
SEARCH_BUDGET_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE	Search absolute top impression share (budget)	The estimated percentage of eligible impressions your ads did not receive in the absolute top position due to an insufficient budget. This metric indicates how often your ad was not the very first ad above the organic search results because of budget limitations.	metric
SEARCH_BUDGET_LOST_TOP_IMPRESSION_SHARE	Search top impression share (budget)	The estimated percentage of eligible impressions your ads did not receive in any of the top positions (above organic search results) due to an insufficient budget. This metric indicates how often your ad did not show anywhere above the organic search results because of budget limitations.	metric
SEARCH_RANK_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE	Search absolute top lost impression share (rank)	The estimated percentage of eligible impressions your ads did not receive in the absolute top position due to a low Ad Rank. This metric indicates how often your ad was not the very first ad above the organic search results because of a low Ad Rank.	metric
SEARCH_RANK_LOST_TOP_IMPRESSION_SHARE	Search top lost impression share (rank)	The estimated percentage of eligible impressions your ads did not receive in any of the top positions (above organic search results) due to a low Ad Rank. This metric indicates how often your ad did not show anywhere above the organic search results because of a low Ad Rank.	metric
SEARCH_TOP_IMPRESSION_SHARE	Search top impression share	The percentage of your ad impressions that were shown anywhere above the organic search results.	metric
SYSTEM_SERVING_STATUS	Keyword status	The serving status of the keyword, such as active, paused, or ended.	dimension
TOP_IMPRESSION_PERCENTAGE	Search top impression rate	The percentage of impressions that appear in the top position of search results.	metric
TOP_OF_PAGE_BID_ESTIMATE	Top of page bid estimate	An estimate of the bid needed for an ad to appear in any of the top positions on the first page of search results.	metric
TRACKING_URL	Tracking URL	The URL used to track ad performance. This URL is optional and can be used to redirect users to a tracking service before reaching the final landing page.	dimension
YEAR	Year	A dimension for reporting that allows grouping or filtering data by year.	dimension