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_PERCENTAGESearch absolute top impression rateMetric
The percentage of impressions that appear in the absolute top position of search results.
ACCOUNT_IDAccount IDDimension
The unique identifier for the advertiser account.
ACCOUNT_NAMEAccount NameDimension
The name of the advertiser account.
ADGROUP_BIDAd group bidMetric
The bid amount set for the ad group.
ADGROUP_IDAd group IDDimension
The unique identifier for the ad group.
ADGROUP_NAMEAd group nameDimension
The name of the ad group.
ADGROUP_TRACKING_IDAd group tracking IDDimension
The unique identifier for the ad group.
AD_EDITORIAL_STATUSEditorial StatusDimension
The editorial status of the ad or keyword.
AD_KEYWORD_IDKeyword IDDimension
The unique identifier for the keyword associated with an ad.
ALL_CONVConversions (all)Metric
The total number of all conversions, including cross-device conversions.
ALL_CONV_RATEConv. 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_VALUEConv. value (all)Metric
The total value of all conversions, including cross-device conversions.
AVG_CPCAvg. CPCMetric
The average cost-per-click (CPC) for your ads.
BIDBid (JPY)Metric
The bid amount set for the keyword or ad group.
BUDGET_LOST_IMPRESSION_SHARELost impression share (budget)Metric
The estimated percentage of impressions that your ads didn't receive due to insufficient budget.
CAMPAIGN_END_DATEEnd DateDimension
The end date of the campaign in YYYYMMDD format.
CAMPAIGN_IDCampaignIDDimension
The unique identifier for the campaign.
CAMPAIGN_NAMECampaign nameDimension
The name of the campaign.
CAMPAIGN_START_DATEStart DateDimension
The start date of the campaign in YYYYMMDD format.
CAMPAIGN_TRACKING_IDCampaign tracking IDDimension
A unique identifier for a specific campaign in Yahoo! JAPAN Ads. This ID is used to track and report on campaign performance.
CAMPAIGN_TYPECampaign typeDimension
The type of the campaign, such as Standard, Dynamic Ads for Search, etc.
CLICKSClicksMetric
The number of clicks on your ads.
CLICK_RATECTRMetric
The click-through rate (CTR), calculated as Clicks / Impressions.
CONVERSIONSConversionsMetric
The number of conversions recorded for your ads.
CONVERSION_NAMEConversion nameDimension
The name of the conversion.
CONV_RATEConv. rateMetric
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_VALUEConv. valueMetric
The total value of all conversions recorded.
COSTCostMetric
The total cost of your ad clicks.
CROSS_DEVICE_CONVERSIONSCross-device conv.Dimension
The number of conversions that originated from a click on one device and completed on another device.
DAILY_SPENDING_LIMITDaily Spending LimitMetric
The maximum amount an ad campaign is allowed to spend per day. Ad delivery is controlled to stay within this limit.
DAYDayDimension
The date for the reported data in YYYYMMDD format.
DAY_OF_WEEKDay of the weekDimension
Represents the day of the week for performance data, allowing users to analyze ad campaign performance by specific days. For example, Monday, Tuesday, etc.
DEVICEDeviceDimension
The type of device on which the ad was shown (e.g., PC, smartphone, tablet).
EXACT_MATCH_IMPRESSION_SHAREExact match impression shareMetric
The impression share for keywords that exactly matched the search query.
FINAL_URLFinal URLDimension
The landing page URL that users are directed to after clicking an ad.
FINAL_URL_SMARTPHONESmartphone final URLDimension
The final URL for smartphones.
FIRST_PAGE_BID_ESTIMATEFirst page bid estimateMetric
An estimate of the bid needed for an ad to appear on the first page of search results.
IMPRESSION_SHAREImpression shareMetric
The percentage of impressions that your ads received compared to the total number of impressions your ads were eligible to receive.
IMPSImpressionsMetric
The number of times your ad was shown.
INVALID_CLICKSInvalid clicksMetric
The number of invalid clicks.
INVALID_CLICK_RATEInvalid Click RateMetric
The rate of invalid clicks.
KEYWORDKeywordDimension
The keyword text that triggered your ad.
KEYWORD_MATCH_TYPEMatch TypeDimension
The match type of the keyword (e.g., Broad, Phrase, Exact).
KEYWORD_TRACKING_IDKeyword tracking IDMetric
The unique identifier for the keyword.
LABELSLabelDimension
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.
MONTHMonthDimension
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_KEYWORDNegative KeywordsDimension
The negative keyword associated with the ad group.
QUALITY_INDEXQuality indexMetric
The Quality Index of your keyword, which measures the relevance and quality of your ads, keywords, and landing page.
QUALITY_LOST_IMPRESSION_SHARELost impression share (rank)Metric
The estimated percentage of impressions that your ads didn't receive due to low Ad Rank (quality score and bid).
QUARTERQuarterDimension
The quarter of the year when the advertising data was recorded, e.g., Q1, Q2, Q3, or Q4.
SEARCH_ABSOLUTE_TOP_IMPRESSION_SHARESearch absolute top impression shareMetric
The impression share that appears in the absolute top position of search results.
SEARCH_BUDGET_LOST_ABSOLUTE_TOP_IMPRESSION_SHARESearch 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_SHARESearch 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_SHARESearch 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_SHARESearch 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_SHARESearch top impression shareMetric
The percentage of your ad impressions that were shown anywhere above the organic search results.
SYSTEM_SERVING_STATUSKeyword statusDimension
The serving status of the keyword, such as active, paused, or ended.
TOP_IMPRESSION_PERCENTAGESearch top impression rateMetric
The percentage of impressions that appear in the top position of search results.
TOP_OF_PAGE_BID_ESTIMATETop of page bid estimateMetric
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_URLTracking URLDimension
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.
WEEKWeek (Mon-Sun)Dimension
Represents the week (Monday to Sunday) when the ad campaign performance data was collected, facilitating weekly performance reviews and trend identification.
YEARYearMetric
Represents the calendar year in which the ad campaign performance data occurred, used for annual reporting and long-term trend analysis.