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 your ad impressions that were shown as the very first ad above the organic search results. |
metric |
ACCOUNT_ID |
Account ID |
The unique identifier for the advertiser account. |
metric |
ACCOUNT_NAME |
Account Name |
The name of the advertiser account. |
dimension |
ADGROUP_BID |
Ad group bid |
The default bid amount set at the ad group level. |
metric |
ADGROUP_ID |
Ad group ID |
The unique identifier for the ad group. |
metric |
ADGROUP_NAME |
Ad group name |
The name of the ad group. |
dimension |
ADGROUP_TRACKING_ID |
Ad group tracking ID |
A unique identifier for a specific ad group within a campaign in Yahoo! JAPAN Ads. This ID is used to track and report on ad group performance. |
metric |
AD_EDITORIAL_STATUS |
Editorial Status |
The editorial status of the ad, indicating if it’s approved, disapproved, or pending review. |
dimension |
AD_ID |
Ad ID |
The unique identifier for the ad. |
metric |
AD_KEYWORD_ID |
Keyword ID |
The unique identifier for the keyword associated with an ad. |
metric |
AD_NAME |
Ad Name |
The name of the ad. |
dimension |
AD_TRACKING_ID |
Ad tracking ID |
A unique identifier for a specific ad within an ad group in Yahoo! JAPAN Ads. This ID is used to track and report on individual ad performance. |
metric |
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 conversion rate for all conversions, calculated as All Conversions / Clicks. |
metric |
ALL_CONV_VALUE |
Conv. value (all) |
The total value of all conversions, including cross-device conversions. |
metric |
ALL_CONV_VALUE_PER_COST |
Conv. value (all)/cost |
The total value of all conversions divided by the total cost. |
metric |
ASSET_DESCRIPTION1 |
Asset (description1) |
The first description asset used in a responsive search ad or other ad format. |
dimension |
ASSET_DESCRIPTION2 |
Asset (description2) |
The second description asset used in a responsive search ad or other ad format. |
dimension |
ASSET_DESCRIPTION3 |
Asset (description3) |
The third description asset used in a responsive search ad or other ad format. |
dimension |
ASSET_DESCRIPTION4 |
Asset (description4) |
The fourth description asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE1 |
Asset (title1) |
The first title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE10 |
Asset (title10) |
The tenth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE11 |
Asset (title11) |
The eleventh title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE12 |
Asset (title12) |
The twelfth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE13 |
Asset (title13) |
The thirteenth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE14 |
Asset (title14) |
The fourteenth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE15 |
Asset (title15) |
The fifteenth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE2 |
Asset (title2) |
The second title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE3 |
Asset (title3) |
The third title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE4 |
Asset (title4) |
The fourth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE5 |
Asset (title5) |
The fifth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE6 |
Asset (title6) |
The sixth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE7 |
Asset (title7) |
The seventh title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE8 |
Asset (title8) |
The eighth title asset used in a responsive search ad or other ad format. |
dimension |
ASSET_TITLE9 |
Asset (title9) |
The ninth title asset used in a responsive search ad or other ad format. |
dimension |
AVG_CPC |
Avg. CPC |
The average cost-per-click (CPC) for your ads. |
metric |
Ad Group Bid |
Ad Group Bid |
The default bid amount set at the ad group level. |
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 |
Ad Group Tracking ID |
Ad Group Tracking ID |
A unique identifier for a specific ad group within a campaign in Yahoo! JAPAN Ads. This ID is used to track and report on ad group performance. |
metric |
All Conv. |
All Conv. |
The total number of all conversions, including cross-device conversions. |
metric |
All Conv. Rate |
All Conv. Rate |
The conversion rate for all conversions, calculated as All Conversions / Clicks. |
metric |
All Conv. Value |
All Conv. Value |
The total value of all conversions, including cross-device conversions. |
metric |
All Conv. Value Per Cost |
All Conv. Value Per Cost |
The total value of all conversions divided by the total cost. |
metric |
BID |
Bid (JPY) |
The maximum cost-per-click (CPC) bid amount for a keyword or other target in Japanese Yen. |
metric |
BID_STRATEGY_ID |
Portfolio bidding ID |
The unique identifier for the portfolio bidding strategy applied. |
dimension |
BID_STRATEGY_NAME |
Portfolio bidding name |
The name of the portfolio bidding strategy. |
dimension |
BID_STRATEGY_TYPE |
Bid strategy |
The type of bidding strategy used (e.g., Manual CPC, Target CPA, Maximize Conversions). |
dimension |
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. |
metric |
CAMPAIGN_NAME |
Campaign name |
The name of the campaign. |
dimension |
CAMPAIGN_START_DATE |
Start Date |
The start date of the campaign in YYYYMMDD format. |
metric |
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 |
CLICK_TYPE |
ClickType |
The type of click on the ad (e.g., Headline, Sitelink). |
dimension |
CONVERSIONS |
Conversions |
The number of conversions recorded for your ads. |
metric |
CONVERSION_NAME |
Conversion name |
The name of the conversion action that was recorded. |
dimension |
CONV_RATE |
Conv. rate |
The conversion rate, calculated as Conversions / Clicks. |
metric |
CONV_VALUE |
Conv. value |
The total value of conversions. |
metric |
CONV_VALUE_PER_COST |
Conv. value/cost |
The total value of conversions divided by the total cost. |
metric |
COST |
Cost |
The total cost of your ad clicks. |
metric |
COST_PER_ALL_CONV |
Cost/conv. (all) |
The average cost for all conversions, calculated as Total Cost / All Conversions. |
metric |
COST_PER_CONV |
Cost/conv. |
The average cost per conversion, calculated as Total Cost / Conversions. |
metric |
CREATIVE_QUALITY_SCORE |
Ad relevance |
The Ad Relevance component of Quality Score, indicating how closely your ad’s message matches the user’s intent. |
dimension |
CROSS_DEVICE_CONVERSIONS |
Cross-device conv. |
Conversions that started on one device and finished on another. |
metric |
Campaign Name |
Campaign Name |
The name of the campaign. |
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 |
Conv. Rate |
Conv. Rate |
The conversion rate, calculated as Conversions / Clicks. |
metric |
Conv. Value |
Conv. Value |
The total value of conversions. |
metric |
Conv. Value Per Cost |
Conv. Value Per Cost |
The total value of conversions divided by the total cost. |
metric |
Conversions across devices |
Conversions across devices |
Conversions that started on one device and finished on another. |
metric |
Cost Per All Conv. |
Cost Per All Conv. |
The average cost incurred for all conversions attributed to an ad, ad group, or campaign. This metric includes all types of conversions tracked. |
metric |
Cost Per Conv. |
Cost Per Conv. |
The average cost incurred for each conversion. This metric is calculated by dividing the total advertising cost by the number of conversions achieved. |
metric |
DAILY_SPENDING_LIMIT |
Daily Spending Limit |
The daily budget limit set for a campaign or account. |
metric |
DAY |
Day |
The date for the reported data in YYYYMMDD format. |
dimension |
DAY_OF_WEEK |
Day of the week |
The day of the week for the reported data (e.g., Monday, Tuesday). |
dimension |
DESCRIPTION1 |
Description 1 |
The first line of ad description text. |
dimension |
DESCRIPTION2 |
Description 2 |
The second line of ad description text. |
dimension |
DESTINATION_URL |
Destination URL |
The URL that users are directed to after clicking an ad. This is often an older term for Final URL. |
dimension |
DEVICE |
Device |
The type of device on which the ad was shown (e.g., PC, smartphone, tablet). |
dimension |
DIRECTORY1 |
Directory1 |
The first optional path for display URL. |
dimension |
DIRECTORY2 |
Directory2 |
The second optional path for display URL. |
dimension |
DISPLAY_URL |
Display URL |
The URL that is shown in the ad to users. This is typically a simplified or cleaner version of the actual landing page URL. |
dimension |
Day of week |
Day of week |
The day of the week for the reported data (e.g., Monday, Tuesday). |
dimension |
ENHANCED_CPC_ENABLED |
Enhanced CPC |
Indicates whether Enhanced CPC bidding strategy is enabled for the entity (e.g., ad group or campaign). |
dimension |
EXACT_MATCH_IMPRESSION_SHARE |
Exact match impression share |
The percentage of impressions that your ads received for searches that precisely matched your exact match keywords, compared to the total number of impressions your ads were eligible to receive for those searches. |
metric |
Enhanced CPC |
Enhanced CPC |
Enhanced CPC (Enhanced Cost Per Click) was an autobidding strategy designed to optimize bids by automatically adjusting them up or down for clicks more or less likely to result in a conversion. This bidding strategy is no longer supported in Yahoo! JAPAN Ads Search Ads API v18 for reporting or modification. |
dimension |
Exact Match Impression Share |
Exact Match Impression Share |
The percentage of impressions that your ads received for searches that precisely matched your exact match keywords, compared to the total number of impressions your ads were eligible to receive for those searches. |
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 landing page URL specific for smartphone users after clicking an ad. |
dimension |
FIRST_PAGE_BID_ESTIMATE |
First page bid estimate |
An estimate of the bid you need to set for your ad to appear on the first page of search results. |
dimension |
First Page Bid Estimate |
First Page Bid Estimate |
An estimate of the bid you need to set for your ad to appear on the first page of search results. |
dimension |
HISTORICAL_CREATIVE_QUALITY_SCORE |
Ad relevance (hist.) |
The historical Ad Relevance component of Quality Score, providing a measure of past performance regarding ad message match to user intent. |
dimension |
HISTORICAL_LANDING_PAGE_QUALITY_SCORE |
Landing page experience (hist.) |
The historical Landing Page Experience component of Quality Score, indicating past performance of how relevant and useful your landing page is to people who click your ad. |
dimension |
HISTORICAL_QUALITY_SCORE |
Quality index (hist.) |
The historical Quality Index of your keyword, providing a measure of past performance regarding relevance and quality. |
metric |
HISTORICAL_SEARCH_PREDICTED_CTR |
Expected CTR (hist.) |
The historical predicted Click-Through Rate (CTR) for search ads, indicating the estimated likelihood of users clicking on an ad based on past performance data. |
dimension |
HOUR_OF_DAY |
Hour of day |
The hour of the day (0-23) for the reported data. |
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 clicks identified as invalid (e.g., fraudulent or accidental clicks). |
metric |
INVALID_CLICK_RATE |
Invalid Click Rate |
The percentage of invalid clicks received by your ads. |
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 |
Invalid Clicks |
Invalid Clicks |
The number of clicks identified as invalid (e.g., fraudulent or accidental clicks). |
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 |
A unique identifier for a specific keyword within an ad group in Yahoo! JAPAN Ads. This ID is used to track and report on keyword performance. |
metric |
Keyword Tracking ID |
Keyword Tracking ID |
A unique identifier for a specific keyword within an ad group in Yahoo! JAPAN Ads. This ID is used to track and report on keyword performance. |
metric |
LABELS |
Label |
Labels are user-defined tags that can be applied to campaigns, ad groups, ads, and keywords to help organize and categorize advertising entities. They provide a flexible way to group related items for reporting and management purposes. |
dimension |
MONTH |
Month |
The month for the reported data. |
dimension |
NEGATIVE_KEYWORD |
Negative Keywords |
The negative keywords that prevent your ads from showing for irrelevant searches. |
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 |
POST_CLICK_QUALITY_SCORE |
Landing page experience |
The Landing Page Experience component of Quality Score, indicating how relevant and useful your landing page is to people who click your ad. |
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 |
QUARTER |
Quarter |
The quarter for the reported data. |
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 |
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 percentage of your ad impressions that were shown as the very first ad above the organic search results. |
metric |
SEARCH_BUDGET_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE |
Search absolute top impression share (budget) |
The estimated percentage of absolute top impressions that your ads didn’t receive due to insufficient budget. |
metric |
SEARCH_BUDGET_LOST_TOP_IMPRESSION_SHARE |
Search top impression share (budget) |
The estimated percentage of top impressions that your ads didn’t receive due to insufficient budget. |
metric |
SEARCH_PREDICTED_CTR |
Expected CTR |
The predicted Click-Through Rate (CTR) for search ads, indicating the estimated likelihood of users clicking on an ad. |
dimension |
SEARCH_RANK_LOST_ABSOLUTE_TOP_IMPRESSION_SHARE |
Search absolute top lost impression share (rank) |
The estimated percentage of absolute top impressions that your ads didn’t receive due to low Ad Rank (quality score and bid). |
metric |
SEARCH_RANK_LOST_TOP_IMPRESSION_SHARE |
Search top lost impression share (rank) |
The estimated percentage of top impressions that your ads didn’t receive due to low Ad Rank (quality score and bid). |
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 (e.g., eligible, paused, removed). |
dimension |
Search lost absolute top impression share (budget) |
Search lost absolute top impression share (budget) |
The estimated percentage of absolute top impressions that your ads didn’t receive due to insufficient budget. |
metric |
Search lost absolute top impression share (rank) |
Search lost absolute top impression share (rank) |
The estimated percentage of absolute top impressions that your ads didn’t receive due to low Ad Rank (quality score and bid). |
metric |
Search lost top impression share (budget) |
Search lost top impression share (budget) |
The estimated percentage of top impressions that your ads didn’t receive due to insufficient budget. |
metric |
Search lost top impression share (rank) |
Search lost top impression share (rank) |
The estimated percentage of top impressions that your ads didn’t receive due to low Ad Rank (quality score and bid). |
metric |
TITLE1 |
Title1 |
The first title of the ad. |
dimension |
TITLE2 |
Title2 |
The second title of the ad. |
dimension |
TITLE3 |
Title3 |
The third title of the ad. |
dimension |
TOP_IMPRESSION_PERCENTAGE |
Search top impression rate |
The percentage of your ad impressions that were shown anywhere above the organic search results. |
metric |
TOP_OF_PAGE_BID_ESTIMATE |
Top of page bid estimate |
An estimate of the bid you need to set for your ad to appear anywhere on the first page of search results. |
dimension |
TRACKING_URL |
Tracking URL |
The tracking URL template that allows you to specify additional tracking parameters. |
dimension |
Top Of Page Bid Estimate |
Top Of Page Bid Estimate |
An estimate of the bid you need to set for your ad to appear anywhere on the first page of search results. |
dimension |
VALUE_PER_ALL_CONV |
Conv. value (all)/conv. (all) |
The average value of all conversions, calculated as All Conversion Value / All Conversions. |
metric |
VALUE_PER_CONV |
Conv. value/conv. |
The average value per conversion, calculated as Conversion Value / Conversions. |
metric |
Value Per All Conv. |
Value Per All Conv. |
The average value of all conversions, calculated as All Conversion Value / All Conversions. |
metric |
Value Per Conv. |
Value Per Conv. |
The average value per conversion, calculated as Conversion Value / Conversions. |
metric |
WEEK |
Week (Mon-Sun) |
The calendar week (Monday to Sunday) during which the ad performance data was recorded, used for weekly aggregation of metrics. |
dimension |
Week |
Week |
The week for the reported data. |
dimension |
YEAR |
Year |
The year for the reported data. |
metric |