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.
ABSOLUTE_TOP_IMPRESSION_PERCENTAGE Search absolute top impression rate Metric
The percentage of impressions that appear in the absolute top position of search results.
ACCOUNT_ID Account ID Dimension
The unique identifier for the advertiser account.
ACCOUNT_NAME Account Name Dimension
The name of the advertiser account.
ADGROUP_BID Ad group bid Metric
The bid amount set for the ad group.
ADGROUP_ID Ad group ID Dimension
The unique identifier for the ad group.
ADGROUP_NAME Ad group name Dimension
The name of the ad group.
ADGROUP_TRACKING_ID Ad group tracking ID Dimension
The unique identifier for the ad group.
AD_EDITORIAL_STATUS Editorial Status Dimension
The editorial status of the ad or keyword.
AD_KEYWORD_ID Keyword ID Dimension
The unique identifier for the keyword associated with an ad.
ALL_CONV Conversions (all) Metric
The total number of all conversions, including cross-device conversions.
ALL_CONV_RATE Conv. rate (all) Metric
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.
ALL_CONV_VALUE Conv. value (all) Metric
The total value of all conversions, including cross-device conversions.
AVG_CPC Avg. CPC Metric
The average cost-per-click (CPC) for your ads.
BID Bid (JPY) Metric
The bid amount set for the keyword or ad group.
BUDGET_LOST_IMPRESSION_SHARE Lost impression share (budget) Metric
The estimated percentage of impressions that your ads didn't receive due to insufficient budget.
CAMPAIGN_END_DATE End Date Dimension
The end date of the campaign in YYYYMMDD format.
CAMPAIGN_ID CampaignID Metric
The unique identifier for the campaign.
CAMPAIGN_NAME Campaign name Dimension
The name of the campaign.
CAMPAIGN_START_DATE Start Date Dimension
The start date of the campaign in YYYYMMDD format.
CAMPAIGN_TRACKING_ID Campaign tracking ID Dimension
A unique identifier for a specific campaign in Yahoo! JAPAN Ads. This ID is used to track and report on campaign performance.
CAMPAIGN_TYPE Campaign type Dimension
The type of the campaign, such as Standard, Dynamic Ads for Search, etc.
CLICKS Clicks Metric
The number of clicks on your ads.
CLICK_RATE CTR Metric
The click-through rate (CTR), calculated as Clicks / Impressions.
CONVERSIONS Conversions Metric
The number of conversions recorded for your ads.
CONVERSION_NAME Conversion name Dimension
The name of the conversion.
CONV_RATE Conv. rate Metric
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.
CONV_VALUE Conv. value Metric
The total value of all conversions recorded.
COST Cost Metric
The total cost of your ad clicks.
CROSS_DEVICE_CONVERSIONS Cross-device conv. Dimension
The number of conversions that originated from a click on one device and completed on another device.
DAILY_SPENDING_LIMIT Daily Spending Limit Metric
The maximum amount an ad campaign is allowed to spend per day. Ad delivery is controlled to stay within this limit.
DAY Day Dimension
The date for the reported data in YYYYMMDD format.
DAY_OF_WEEK Day of the week Dimension
Represents the day of the week for performance data, allowing users to analyze ad campaign performance by specific days. For example, Monday, Tuesday, etc.
DEVICE Device Dimension
The type of device on which the ad was shown (e.g., PC, smartphone, tablet).
EXACT_MATCH_IMPRESSION_SHARE Exact match impression share Metric
The impression share for keywords that exactly matched the search query.
FINAL_URL Final URL Dimension
The landing page URL that users are directed to after clicking an ad.
FINAL_URL_SMARTPHONE Smartphone final URL Dimension
The final URL for smartphones.
FIRST_PAGE_BID_ESTIMATE First page bid estimate Metric
An estimate of the bid needed for an ad to appear on the first page of search results.
IMPRESSION_SHARE Impression share Metric
The percentage of impressions that your ads received compared to the total number of impressions your ads were eligible to receive.
IMPS Impressions Metric
The number of times your ad was shown.
INVALID_CLICKS Invalid clicks Metric
The number of invalid clicks.
INVALID_CLICK_RATE Invalid Click Rate Metric
The rate of invalid clicks.
KEYWORD Keyword Dimension
The keyword text that triggered your ad.
KEYWORD_MATCH_TYPE Match Type Dimension
The match type of the keyword (e.g., Broad, Phrase, Exact).
KEYWORD_TRACKING_ID Keyword tracking ID Metric
The unique identifier for the keyword.
LABELS Label Dimension
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.
MONTH Month Dimension
Represents the month in which the ad campaign performance data was recorded. This field allows for monthly aggregation and analysis of campaign metrics. For example, January, February, etc.
NEGATIVE_KEYWORD Negative Keywords Dimension
The negative keyword associated with the ad group.
QUALITY_INDEX Quality index Metric
The Quality Index of your keyword, which measures the relevance and quality of your ads, keywords, and landing page.
QUALITY_LOST_IMPRESSION_SHARE Lost impression share (rank) Metric
The estimated percentage of impressions that your ads didn't receive due to low Ad Rank (quality score and bid).
QUARTER Quarter Dimension
The quarter of the year when the advertising data was recorded, e.g., Q1, Q2, Q3, or Q4.
SEARCH_ABSOLUTE_TOP_IMPRESSION_SHARE Search absolute top impression share Metric
The impression share that appears in the absolute top position of search results.
SEARCH_BUDGET_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE Search absolute top impression share (budget) Metric
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.
SEARCH_BUDGET_LOST_TOP_IMPRESSION_SHARE Search top impression share (budget) Metric
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.
SEARCH_RANK_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE Search absolute top lost impression share (rank) Metric
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.
SEARCH_RANK_LOST_TOP_IMPRESSION_SHARE Search top lost impression share (rank) Metric
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.
SEARCH_TOP_IMPRESSION_SHARE Search top impression share Metric
The percentage of your ad impressions that were shown anywhere above the organic search results.
SYSTEM_SERVING_STATUS Keyword status Dimension
The serving status of the keyword, such as active, paused, or ended.
TOP_IMPRESSION_PERCENTAGE Search top impression rate Metric
The percentage of impressions that appear in the top position of search results.
TOP_OF_PAGE_BID_ESTIMATE Top of page bid estimate Metric
An estimate of the bid needed for an ad to appear in any of the top positions on the first page of search results.
TRACKING_URL Tracking URL Dimension
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.
WEEK Week (Mon-Sun) Dimension
Represents the week (Monday to Sunday) when the ad campaign performance data was collected, facilitating weekly performance reviews and trend identification.
YEAR Year Metric
Represents the calendar year in which the ad campaign performance data occurred, used for annual reporting and long-term trend analysis.