> ## Documentation Index
> Fetch the complete documentation index at: https://docs.adriel.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Data reference
> Metrics, breakdowns, refresh cadence, and limits for the LY Ads Display Ads data source in Adriel.
Renamed from Yahoo! JAPAN Display Ads in September 2026, following LY Corporation's rebrand of Yahoo! JAPAN Ads to LY Ads. Only the display name and icon changed — existing connections, data sources, and widgets are unaffected.
## Introduction
LY Ads Display Ads (formerly Yahoo! JAPAN Display Ads, also known as YDA or YDN) is the display advertising product of LY Ads, the advertising platform operated by LY Corporation, 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 LY Ads 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 LY Ads Display Ads to Adriel](/data-sources/g-n/ly-ads-display-ads/how-to-connect).
## 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 columns**
**Data 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 LY Ads.** 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 LY Ads 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` |
### LY Ads Display Ads-specific
These metrics exist only for LY Ads 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* |
### LY Ads Display Ads-specific
These breakdowns exist only for LY Ads 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](https://ads-developers.yahoo.co.jp/en/ads-api/)
## See also
* [How to connect LY Ads Display Ads to Adriel](/data-sources/g-n/ly-ads-display-ads/how-to-connect) (paired how-to)
* [LY Ads Search Ads data reference](/data-sources/g-n/ly-ads-search-ads/data-reference) — for the search-ads sibling connector