Data reference - Adriel Knowledge Base

Introduction

Yahoo Japan Display Ads (YDA, also known as YDN) is the display advertising product of Yahoo! JAPAN Ads, covering banner, native, and video placements across the Yahoo! JAPAN network and its partner sites in Japan. The connector imports account structure and daily performance through the Yahoo Ads Display API, and standardizes them into Adriel’s internal model. As a marketing connector, metrics, breakdowns, and currencies are standardized so widgets can aggregate across sources without additional configuration. Compared with Yahoo Japan Search Ads, Display Ads adds video and viewability metrics plus audience (age, gender), prefecture, and site breakdowns, and does not support keyword-level reporting. To connect this data source, see How to connect Yahoo Japan Display Ads to Adriel.

Data refresh strategy

Architecture data

Architecture covers ad accounts, campaigns, ad sets (ad groups), and ads. It refreshes at 4:00 PM UTC and 5:00 AM UTC.

Reports data

Reports include daily performance for ad accounts, campaigns, ad sets, and ads. Cache only. Report data comes from cached daily performance snapshots. When a dashboard loads, values are aggregated from the last snapshot rather than fetched live. Because of this, metrics based on uniqueness (such as reach) can be overvalued when viewed over a range longer than one day. Initial backfill. When the data source is created, the cache is filled for the last 93 days at the ad account, campaign, ad set, and ad levels. Refresh schedule. Report data refreshes on three overlapping schedules:

7:00 AM UTC, every 5 days — syncs the last 90 days
8:00 PM UTC and 3:00 AM UTC daily — syncs the last 5 days
4:00 PM UTC daily — syncs the last 30 days

Each schedule covers the ad account, campaign, ad set, ad, and audience/geo breakdowns (device, country, location, age, gender, region). Data is considered reliable within the cache sync period; data outside this range may be incomplete, missing, or not fully accurate due to legacy caching behavior.

Architecture levels

Ad account → Campaign → Ad set (ad group) → Ad Keyword-level reporting is not supported for Display Ads and always returns empty.

Date range limits

To keep query sizes manageable, the connector enforces these maximum look-back windows per time breakdown:

Breakdown	Max range
Daily	93 days
Weekly	1 year
Monthly	2 years

Metrics

How to read the columnsData type uses Adriel’s vocabulary — Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean. API Key in code style like Impressions is the literal field returned by the Yahoo Ads Display API; italic marks a value Adriel computes or derives rather than one mapping to a single API field. Currency values are reported in each ad account’s configured currency; when it differs from the workspace currency, costs are converted at the current day’s exchange rate.

Basic

Metric	Description	Data type	API Key
Channel Type	Adriel subchannel used for this Yahoo Japan advertising source.	Text	Adriel-assigned
Creative Image	Hash of the creative image used to group visually identical creatives.	Text	Adriel-derived
Creative Type	Type of ad creative, such as banner, responsive, or video.	Text	Adriel-derived
Result Indicator	Result payload returned for this record when Adriel exposes aggregated results.	Text	Resolved from objective
Results	Aggregated result object stored for the record when available.	Text	Adriel-derived

Campaign Attributes

Metric	Description	Data type	API Key
Ad Account Name	Name of the Yahoo Japan ad account.	Text	`accountName`
Ad Name	Name of the ad.	Text	`adName`
Ad Set Name	Name of the ad group.	Text	`adGroupName`
Ad Spend	Total advertising cost in JPY.	Currency	`Cost`
Bid Cap	Maximum bid amount configured for the campaign or ad group when bid caps are used.	Currency	Adriel-side
Bid Strategy	Bid strategy types configured for the campaign or ad group.	Array	`biddingStrategyConfiguration.biddingScheme.campaignBiddingStrategyType`
Budget	Budget details configured for the campaign or ad group.	Text	`budget.amount`
Campaign Name	Name of the campaign.	Text	`campaignName`
Creative URL	Creative asset URLs fetched for the ad.	Text	`medias[].mediaUrl`
Daily Budget	Daily budget amount configured for the campaign or ad group.	Currency	Adriel-side
Ends	End date configured for the campaign or ad group.	Date	`endDate`
Is Active	Whether the campaign, ad group, or ad is currently active.	Text	Adriel-side
Landing URL	Landing page URLs used by the ad.	Array	`ad.finalUrl`
Lifetime Budget	Total lifetime budget configured for the campaign or ad group.	Currency	Adriel-side
Objective	Advertising objective configured for the campaign.	Text	Adriel-side
Starts	Start date configured for the campaign or ad group.	Date	`startDate`
Status	Delivery status for the selected campaign, ad group, or ad.	Text	`servingStatus`
Status Text	Text label describing the delivery status of the campaign, ad group, or ad.	Text	Adriel-side
UTM Campaign	UTM campaign values found in the landing URLs.	Text	Adriel-parsed
UTM Content	UTM content values found in the landing URLs.	Text	Adriel-parsed
UTM Medium	UTM medium values found in the landing URLs.	Text	Adriel-parsed
UTM Source	UTM source values found in the landing URLs.	Text	Adriel-parsed
UTM Term	UTM term values found in the landing URLs.	Text	Adriel-parsed

UTM values are parsed by Adriel, not returned by Yahoo. Adriel reads the UTM query parameters from each ad’s configuration and landing URL and exposes them as metrics for rollup.

Campaign Structure

Metric	Description	Data type	API Key
Ad Account ID	Yahoo Japan ad account ID.	Text	`accountId`
Ad ID	Yahoo Japan ad ID.	Text	`adId`
Ad Set ID	Yahoo Japan ad group ID.	Text	`adGroupId`
Campaign ID	Yahoo Japan campaign ID.	Text	`campaignId`
Channel	Yahoo Japan subchannels attached to the selected entity.	Array	Adriel-assigned

Computed Metric

These are calculated by Adriel from other metrics; they have no single underlying Yahoo field.

Metric	Description	Data type	API Key
Frequency	Average number of times each reached person saw the ad — impressions divided by reach.	Ratio	Adriel-computed
ROAS	Return on ad spend — conversion value divided by spend.	Ratio	Adriel-computed
Video Played To 100% (%)	Plays reaching 100% completion as a share of total plays.	Percentage	Adriel-computed
Video Played To 25% (%)	Plays reaching 25% completion as a share of total plays.	Percentage	Adriel-computed
Video Played To 50% (%)	Plays reaching 50% completion as a share of total plays.	Percentage	Adriel-computed
Video Played To 75% (%)	Plays reaching 75% completion as a share of total plays.	Percentage	Adriel-computed
View Rate	Video views as a share of video impressions.	Percentage	Adriel-computed

Conversion Performance

Metric	Description	Data type	API Key
All Conversions	Total number of all conversions.	Number	`Conversions (all)`
Conversion Goal	Conversion objective reported for the conversion row.	Text	`Objective of Conversion Tracking`
Conversion Value	Total conversion value attributed to the ads.	Currency	`Conv. value`
Conversions	Number of conversions.	Number	`Conversions`
Revenue	Total conversion value attributed to the ads.	Currency	`Conv. value`

Conversion events are imported from the ad account. Any conversion event tracked in the ad account is imported automatically, but only appears on the dashboard when the underlying event is active in the account. For each imported conversion, Adriel also generates derived KPIs — CVR, CPA, and ROAS.

Engagement

Metric	Description	Data type	API Key
Video Impressions	Number of video ad impressions recorded for the selected data.	Number	Adriel-derived

Impression Click Performance

Metric	Description	Data type	API Key
Clicks (All)	Total clicks recorded for the ads.	Number	`Clicks`
CPC	Cost per click — spend divided by clicks.	Currency	Adriel-computed
CPM	Cost per thousand impressions.	Currency	Adriel-computed
CTR	Click-through rate — clicks divided by impressions.	Percentage	Adriel-computed
Impressions	Number of impressions.	Number	`Impressions`
Link Clicks	Number of clicks.	Number	`Clicks`
Reach	Reach value exposed by this data source when available.	Number	Uniqueness metric; may be overvalued over multi-day ranges

Video Performance

Metric	Description	Data type	API Key
15s Video Plays	Number of video views that lasted at least 15 seconds when available.	Number	Adriel-derived
2s Video Plays	Number of video views that lasted at least 2 seconds when available.	Number	Adriel-derived
30s Video Plays	Number of video views that lasted at least 30 seconds when available.	Number	Adriel-derived
3s Video Plays	Number of video views that lasted at least 3 seconds.	Number	Adriel-derived
6s Video Plays	Number of video views that lasted at least 6 seconds when available.	Number	Adriel-derived
ThruPlays	Completed video plays recorded for the selected data when available.	Number	Adriel-derived
Video Play	Number of video play starts recorded for the selected data when available.	Number	Adriel-derived
Video Played To 100% (Views)	Number of video views that reached 100% playback.	Number	`100% video views`
Video Played To 25% (Views)	Number of video views that reached 25% playback.	Number	`25% video views`
Video Played To 50% (Views)	Number of video views that reached 50% playback.	Number	`50% video views`
Video Played To 75% (Views)	Number of video views that reached 75% playback.	Number	`75% video views`
Views	Number of video views.	Number	`Video views`

Yahoo Japan Display Ads-specific

These metrics exist only for Yahoo Japan Display Ads and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Metric	Description	Data type	API Key
10 Sec Video Views	Number of video views that lasted at least 10 seconds.	Number	`10 sec video views`
100% Video Views	Number of video views that reached 100% playback.	Number	`100% video views`
25% Video Views	Number of video views that reached 25% playback.	Number	`25% video views`
3 Sec Video Views	Number of video views that lasted at least 3 seconds.	Number	`3 sec video views`
50% Video Views	Number of video views that reached 50% playback.	Number	`50% video views`
75% Video Views	Number of video views that reached 75% playback.	Number	`75% video views`
95% Video Views	Number of video views that reached 95% playback.	Number	`95% video views`
Ad Delivery URL	URL or site where the ad was delivered.	Text	`Ad Delivery URL`
Ad Type	Type of ad, such as banner, responsive, or video.	Text	`Ad type`
Age	Age bucket of the audience reached by the ad.	Text	`Age`
Budget Lost Impression Share	Share of impressions lost because the campaign budget was limiting delivery.	Percentage	`Lost impression share (budget)`
City	City where the ad was served.	Text	`City`
Clicks	Number of clicks.	Number	`Clicks`
Conv Value	Total conversion value attributed to the ads.	Currency	`Conv. value`
Conv Value (All)	Total value of all conversions.	Currency	`Conv. value (all)`
Conv Value (Via Click)	Conversion value attributed to ad clicks.	Currency	`Conv. value (via click)`
Conversions	Number of conversions.	Number	`Conversions`
Conversions (All)	Total number of all conversions.	Number	`Conversions (all)`
Conversions (Via Click)	Number of conversions attributed to ad clicks.	Number	`Conversions (via click)`
Cost	Total advertising cost in JPY.	Currency	`Cost`
Cross Device Conv	Number of conversions completed on another device after ad engagement.	Number	`Cross-device conv.`
Daily	Reporting date for the row.	Date	`Day`
Description 1	Primary description text used in the ad.	Text	`Description 1`
Description 2	Secondary description text used in the ad.	Text	`Description 2`
Device	Device category where the ad was served.	Text	`Device`
Display URL	Display URL shown with the ad.	Text	`Display URL`
Final URL	Final landing page URL used by the ad.	Text	`Final URL`
Gender	Gender bucket of the audience reached by the ad.	Text	`Gender`
Impressions	Number of impressions.	Number	`Impressions`
Lost Impression Share (Budget)	Share of impressions lost because the campaign budget was limiting delivery.	Percentage	`Lost impression share (budget)`
Lost Impression Share (Rank)	Share of impressions lost because ad rank was not high enough.	Percentage	`Lost impression share (rank)`
Measured Impressions	Number of measured impressions eligible for viewability measurement.	Number	`Measured impressions`
Objective Of Conversion Tracking	Conversion objective assigned to the conversion action.	Text	`Objective of Conversion Tracking`
Paid Video Views (CPV)	Number of paid video views billed on a cost-per-view basis.	Number	`Paid video views (CPV)`
Prefectures	Prefecture where the ad was served.	Text	`Prefectures`
Rank Lost Impression Share	Share of impressions lost because ad rank was not high enough.	Percentage	`Lost impression share (rank)`
Video Views	Number of video views.	Number	`Video views`
View Through Conversions	Number of conversions attributed after an impression without a click.	Number	`View-through conversions`
Viewable Clicks	Number of clicks on viewable impressions.	Number	`Viewable clicks`
Viewable Impressions	Number of viewable impressions.	Number	`Viewable impressions`
Viewable Impressions Per Panel	Number of viewable impressions reported for each panel.	Number	`Viewable impressions per panel`

Breakdowns

Basic

Breakdown	Description	API Key
Channel	Adriel channel used for this data source.	Adriel-assigned

Campaign Structure

Breakdown	Description	API Key
Ad Name	Groups results by ad name.	`adName`
Ad Set Name	Groups results by ad set (ad group) name.	`adGroupName`
Campaign Name	Groups results by campaign name.	`campaignName`
Platform	Adriel subchannel used to group this Yahoo Japan data.	Adriel-assigned
Status	Delivery status used to group the selected entities.	`servingStatus`

Creatives

Adriel post-processes ad creatives to generate these breakdowns.

Breakdown	Description	API Key
Ad Copy	Words extracted from the creative for text-based grouping.	Adriel-side
Color Clustering	Grouped color palette extracted from the creative.	Adriel-side
Creative Image	Image hash used to group visually identical creatives.	Adriel-side
Emoji Analysis	Emoji pattern extracted from the creative text.	Adriel-side

Date

The connector’s report data is daily; all time-grouping breakdowns are Adriel-side aggregations of the same underlying daily data.

Breakdown	Description	API Key
Auto Time Breakdown	Automatic time bucket chosen by Adriel for the selected date range.	Adriel-side
Daily Breakdown	Day used to group reporting data.	Adriel-side
Monthly Breakdown	Month bucket used to group reporting data.	Adriel-side
Quarterly Breakdown	Quarter bucket used to group reporting data.	Adriel-side
Week Date Breakdown	Week start date bucket used to group reporting data.	Adriel-side
Week Number Breakdown (W#)	Groups results by week number in the year.	Adriel-side
Weekly Breakdown (Start: Mon)	Week bucket used to group reporting data.	Adriel-side
Weekly Breakdown (Start: Sun)	Sunday-to-Saturday week bucket used to group reporting data.	Adriel-side
Yearly Breakdown	Year bucket used to group reporting data.	Adriel-side

Others

Breakdown	Description	API Key
No Grouping	Single bucket that keeps all results together without further grouping.	Adriel-side

Yahoo Japan Display Ads-specific

These breakdowns exist only for Yahoo Japan Display Ads and aren’t part of any cross-connector category. Every group above is a standard category shared with other connectors.

Breakdown	Description	API Key
Ad	Ad name used to group data by ad.	`adName`
Ad Account	Ad account name used to group data by account.	`accountName`
Ad Label	Ad labels assigned in Yahoo Japan Ads.	`AD_LABELS`
Ad Set	Ad group name used to group data by ad group.	`adGroupName`
Ad Set Label	Ad group labels assigned in Yahoo Japan Ads.	`ADGROUP_LABELS`
Age	Age bucket used to group audience performance.	`Age`
Campaign	Campaign name used to group data by campaign.	`campaignName`
Campaign Label	Campaign labels assigned in Yahoo Japan Ads.	`CAMPAIGN_LABELS`
Creative Description	Creative description text used to group ad performance.	`DESCRIPTION1`, `DESCRIPTION2`
Creative Headline	Creative title used to group ad performance.	`AD_TITLE`
Device Target	Device category used to group performance.	`Device`
Gender	Gender bucket used to group audience performance.	`Gender`
Location	City used to group geographic performance.	`City`
Region	Prefecture used to group geographic performance.	`Prefectures`
Site	Site or delivery URL used to group placement performance.	`Ad Delivery URL`

Limitations

Cache only — report data comes from cached daily snapshots, not live queries. Uniqueness-based metrics (such as reach) can be overvalued over ranges longer than one day, and data outside the cache sync period may be incomplete or inaccurate.
No keyword reporting — keyword-level reports and the keyword breakdown are not supported for Display Ads and return empty.
Site breakdown constraints — the Site (ad delivery URL) breakdown cannot be combined with the ad level, and it drops the VIEWABLE_CLICK and MATERIAL_VIEWABLE_IMPS metrics.
Limited impression share — only budget-loss and rank-loss impression share fields are available; exact-match, search-top, and absolute-top variants are not.
Date range caps — daily 93 days, weekly 1 year, monthly 2 years.

API references

Yahoo! JAPAN Ads Developers — Display Ads API

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​Basic

​Campaign Attributes

​Campaign Structure

​Computed Metric

​Conversion Performance

​Engagement

​Impression Click Performance

​Video Performance

​Yahoo Japan Display Ads-specific

​Breakdowns

​Basic

​Campaign Structure

​Creatives

​Date

​Others

​Yahoo Japan Display Ads-specific

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Basic

Campaign Attributes

Campaign Structure

Computed Metric

Conversion Performance

Engagement

Impression Click Performance

Video Performance

Yahoo Japan Display Ads-specific

Breakdowns

Basic

Campaign Structure

Creatives

Date

Others

Yahoo Japan Display Ads-specific

Limitations

API references

See also