> ## 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 Search Ads data source in Adriel.
Renamed from Yahoo! JAPAN Search 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 Search Ads (formerly Yahoo! JAPAN Search Ads) is the paid search product of LY Ads, the advertising platform operated by LY Corporation for the Japanese market. Advertisers run keyword-targeted search campaigns, and the connector imports the resulting architecture and daily performance data via the Yahoo! JAPAN Ads API. It shares its authentication, connection, cache, and reporting pipeline with LY Ads Display Ads through a common base, but uses the search-specific API endpoint, metric set, and keyword-level reporting.
As a marketing connector, metrics, breakdowns, and currencies are standardized so widgets can aggregate across sources without additional configuration.
To connect this data source, see [How to connect LY Ads Search Ads to Adriel](/data-sources/g-n/ly-ads-search-ads/how-to-connect).
## Data refresh strategy
### Architecture data
Architecture covers ad accounts, campaigns, ad sets (ad groups), ads, and keywords. It refreshes twice daily, at **4:00 PM UTC** and **5:00 AM UTC**.
### Reports data
Reports include daily performance for ad accounts, campaigns, ad sets, ads, and keywords.
**Cache-only.** Report data is served from cached daily performance snapshots and is never fetched on demand when a dashboard loads. Each dashboard view aggregates data from the most recent snapshot. Because snapshots are aggregated daily, metrics based on uniqueness (such as Reach) may be overvalued when viewed over a date range longer than one day.
When a data source is first created, the cache is filled for the previous **93 days** across all levels (ad account, campaign, ad set, ad, keyword).
**Refresh schedule.** Cached reports refresh 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 sync covers ad account, campaign, ad set, ad, and keyword, plus the device, country, and location breakdowns at the ad-account level. Data is considered reliable within the cache sync period; data outside this range may be incomplete or missing.
## Architecture levels
Ad account → Campaign → Ad set (ad group) → Ad → Keyword
The same five levels are used for both architecture (entity metadata) and reports (performance) queries.
## 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 or column name returned by the Yahoo! JAPAN Ads API; *italic* marks a value Adriel computes or derives when it doesn't map cleanly to a single API field. Some raw fields back several rows — notably `ad.finalUrl` (the ad's landing URL, from which UTM values are parsed) and `Conv. value` — so the same key can appear on multiple rows; that's the shared source field, not a duplicated entry. Currency values are reported in each ad account's configured LY Ads currency.
**Currency conversion.** Each ad account's currency comes from its LY Ads settings. When an ad account's currency differs from the workspace currency, costs are automatically converted using the current day's exchange rate.
### Basic
| Metric | Description | Data type | API Key |
| ---------------- | -------------------------------------------------------------------------------- | --------- | ---------------------------------- |
| Channel Type | The Yahoo Japan Ads subchannel for the record. | Text | *Adriel-side* |
| 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 | The metric used to represent the result for the campaign's configured objective. | Text | *Resolved from campaign objective* |
| Results | The number of results for the campaign's configured objective. | Number | *Adriel-derived* |
### Campaign Attributes
| Metric | Description | Data type | API Key |
| --------------- | ---------------------------------------------------------------------------------- | --------- | ------------------------------------------------------------------------ |
| Ad Account Name | The Yahoo Japan ad account name. | Text | `accountName` |
| Ad Name | The ad name. | Text | `adName` |
| Ad Set Name | The ad group name. | Text | `adGroupName` |
| Ad Spend | The advertising cost. | Currency | `Cost` |
| Bid Cap | Maximum bid amount configured for the campaign or ad group when bid caps are used. | Currency | *Adriel-side* |
| Bid Strategy | The bidding strategy configured for the campaign or ad group when available. | Array | `biddingStrategyConfiguration.biddingScheme.campaignBiddingStrategyType` |
| Budget | The budget amount configured for the campaign or ad group when available. | Currency | `budget.amount` |
| Campaign Name | The campaign name. | Text | `campaignName` |
| Creative URL | The media URLs attached to the ad creative when available. | Text | `medias[].mediaUrl` |
| Daily Budget | Daily budget amount configured for the campaign or ad group. | Currency | *Adriel-side* |
| Ends | The scheduled end date of the campaign. | Date | `endDate` |
| Is Active | Whether the campaign, ad group, or ad is currently active. | Text | *Adriel-side* |
| Landing URL | The 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 | The campaign objectives associated with the record when available. | Array | *Adriel-derived* |
| Starts | The scheduled start date of the campaign. | Date | `startDate` |
| Status | The serving status of the campaign, ad group, or ad when available. | Text | `servingStatus` |
| Status Text | Text label describing the delivery status of the campaign, ad group, or ad. | Text | *Adriel-side* |
| UTM Campaign | The `utm_campaign` value extracted from the ad landing URL when available. | Array | `ad.finalUrl` |
| UTM Content | The `utm_content` value extracted from the ad landing URL when available. | Array | `ad.finalUrl` |
| UTM Medium | The `utm_medium` value extracted from the ad landing URL when available. | Array | `ad.finalUrl` |
| UTM Source | The `utm_source` value extracted from the ad landing URL when available. | Array | `ad.finalUrl` |
| UTM Term | The `utm_term` value extracted from the ad landing URL when available. | Array | `ad.finalUrl` |
**UTM values are parsed by Adriel, not returned by LY Ads.** Adriel reads the UTM query parameters from each ad's landing URL and exposes them as metrics for rollup.
### Campaign Structure
| Metric | Description | Data type | API Key |
| ------------- | --------------------------------------------- | --------- | ------------- |
| Ad Account ID | The Yahoo Japan ad account ID. | Text | `accountId` |
| Ad ID | The Yahoo Japan ad ID. | Text | `adId` |
| Ad Set ID | The Yahoo Japan ad group ID. | Text | `adGroupId` |
| Campaign ID | The Yahoo Japan campaign ID. | Text | `campaignId` |
| Channel | The marketing channel assigned to the record. | Array | *Adriel-side* |
| Keyword ID | The Yahoo Japan keyword ID. | Text | `keywordID` |
| Keyword Name | The keyword text. | Text | `keyword` |
### Computed Metric
These are calculated by Adriel from other metrics; they have no single underlying LY Ads field.
| Metric | Description | Data type | API Key |
| ------ | ------------------------------------------------------- | ---------- | ----------------- |
| ROAS | Return on ad spend — conversion value divided by spend. | Percentage | *Adriel-computed* |
### Conversion Performance
| Metric | Description | Data type | API Key |
| ---------------- | --------------------------- | --------- | ------------- |
| Conversion Value | The total conversion value. | Currency | `Conv. value` |
| Conversions | The number of conversions. | Number | `Conversions` |
| Revenue | The total conversion value. | Currency | `Conv. value` |
**Conversion events come from your LY Ads account.** Each conversion action tracked in the account is imported automatically and only appears in dashboards when the underlying event is active. Conversions may be shown as a single total or grouped by conversion category (for example, `category__Purchase / Sales`, `category__Application`).
### Impression Click Performance
| Metric | Description | Data type | API Key |
| ------------ | --------------------------------------------------- | ---------- | ----------------- |
| Clicks (All) | The number of clicks. | 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 | The number of impressions. | Number | `Impressions` |
| Link Clicks | The number of clicks. | Number | `Clicks` |
### LY Ads Search Ads-specific
These metrics exist only for LY Ads Search Ads and aren't part of any cross-connector category. Every group above is a standard category shared with other connectors.
Impression share metrics use percentage values with **unique** aggregation — they are not summable across rows, so a total over multiple entities will not equal the sum of the individual values. They are available at the ad-account, campaign, and (partially) ad-set levels, but not at the ad level.
| Metric | Description | Data type | API Key |
| ------------------------------------------------ | ------------------------------------------------------------------------------------------------ | ---------- | -------------------------------------------------- |
| Absolute Top Impression Share | The share of eligible impressions shown in the absolute top position of the search results page. | Percentage | `Search absolute top impression share` |
| Ad Group ID | The Yahoo Japan ad group ID. | Text | `Ad group ID` |
| Ad Group Tracking ID | The ad group tracking ID. | Text | `Ad group tracking ID` |
| Ad Relevance | Yahoo Japan Ads qualitative rating for ad relevance. | Text | `Ad relevance` |
| Ad Strength | Yahoo Japan Ads ad strength rating for the ad. | Text | `Ad strength` |
| Ad Tracking ID | The ad tracking ID. | Text | `Ad tracking ID` |
| Ad Type | The Yahoo Japan ad format. | Text | `Ad Type` |
| Budget Lost Absolute Top Impression Share | The share of eligible absolute top impressions lost because of budget limits. | Percentage | `Search absolute top impression share (budget)` |
| Budget Lost Impression Share | The share of eligible impressions lost because of budget limits. | Percentage | `Lost impression share (budget)` |
| Campaign ID | The Yahoo Japan campaign ID. | Text | `CampaignID` |
| Campaign Tracking ID | The campaign tracking ID. | Text | `Campaign tracking ID` |
| City | The city where the impression or click was reported. | Text | `City` |
| Clicks | The number of clicks. | Number | `Clicks` |
| Conv Value | The total conversion value. | Currency | `Conv. value` |
| Conversions | The number of conversions. | Number | `Conversions` |
| Conversions (All) | The number of all conversions reported by Yahoo Japan Ads. | Number | `Conversions (all)` |
| Cost | The advertising cost. | Currency | `Cost` |
| Country | The country where the impression or click was reported. | Text | `Country` |
| Cross Device Conv | The number of conversions attributed across devices. | Number | `Cross-device conv.` |
| Device | The device type used for the impression or click. | Text | `Device` |
| Directory1 | The first path field shown in the ad URL. | Text | `Directory1` |
| Directory2 | The second path field shown in the ad URL. | Text | `Directory2` |
| Display URL | The display URL shown in the ad. | Text | `Display URL` |
| Exact Match Impression Share | The share of eligible impressions the keyword received for exact-match searches. | Percentage | `Exact match impression share` |
| Expected CTR | Yahoo Japan Ads qualitative rating for expected click-through rate. | Text | `Expected CTR` |
| Final URL | The final landing page URL used after the click. | Text | `Final URL` |
| Impression Share | The share of eligible impressions your ads received. | Percentage | `Impression share` |
| Impressions | The number of impressions. | Number | `Impressions` |
| Invalid Clicks | The number of invalid clicks. | Number | `Invalid clicks` |
| Keyword | The keyword text associated with the result. | Text | `Keyword` |
| Keyword ID | The Yahoo Japan keyword ID. | Text | `Keyword ID` |
| Keyword Tracking ID | The keyword tracking ID. | Text | `Keyword tracking ID` |
| Label | The label attached to the entity. | Text | `Label` |
| Landing Page Experience | Yahoo Japan Ads qualitative rating for landing page experience. | Text | `Landing page experience` |
| Lost Impression Share (Budget) | The share of eligible impressions lost because of budget limits. | Percentage | `Lost impression share (budget)` |
| Lost Impression Share (Rank) | The share of eligible impressions lost because of ad rank. | Percentage | `Lost impression share (rank)` |
| Match Type | The keyword match type. | Text | `Match Type` |
| Rank Lost Absolute Top Impression Share | The share of eligible absolute top impressions lost because of ad rank. | Percentage | `Search absolute top lost impression share (rank)` |
| Rank Lost Impression Share | The share of eligible impressions lost because of ad rank. | Percentage | `Lost impression share (rank)` |
| Rank Lost Top Impression Share | The share of eligible top-of-page impressions lost because of ad rank. | Percentage | `Search top lost impression share (rank)` |
| Search Absolute Top Impression Share | The share of eligible impressions shown in the absolute top position of the search results page. | Percentage | `Search absolute top impression share` |
| Search Absolute Top Impression Share (Budget) | The share of eligible absolute top impressions lost because of budget limits. | Percentage | `Search absolute top impression share (budget)` |
| Search Absolute Top Lost Impression Share (Rank) | The share of eligible absolute top impressions lost because of ad rank. | Percentage | `Search absolute top lost impression share (rank)` |
| Search Top Impression Share | The share of eligible impressions shown at the top of the search results page. | Percentage | `Search top impression share` |
| Search Top Impression Share (Budget) | The share of eligible top-of-page impressions lost because of budget limits. | Percentage | `Search top impression share (budget)` |
| Search Top Lost Impression Share (Rank) | The share of eligible top-of-page impressions lost because of ad rank. | Percentage | `Search top lost impression share (rank)` |
| Show Ads On | The search network where the ad was shown. | Text | `Show ads on` |
| Smartphone Final URL | The smartphone-specific final URL used after the click. | Text | `Smartphone final URL` |
| Title1 | The first ad headline or title. | Text | `Title1` |
| Top Impression Share | The share of eligible impressions shown at the top of the search results page. | Percentage | `Search top impression share` |
| Tracking URL | The tracking URL associated with the ad or keyword. | Text | `Tracking URL` |
## Breakdowns
### Basic
| Breakdown | Description | API Key |
| --------- | ------------------------------------ | ----------------- |
| Channel | Groups results by marketing channel. | *Adriel-assigned* |
### Campaign Structure
| Breakdown | Description | API Key |
| ------------- | ------------------------------------------------------------------- | --------------- |
| Ad Name | Groups results by ad name. | *Adriel-side* |
| Ad Set Name | Groups results by ad set (ad group) name. | *Adriel-side* |
| Campaign Name | Groups results by campaign name. | *Adriel-side* |
| Platform | Groups results by publishing platform. | *Adriel-side* |
| Status | The serving status of the campaign, ad group, or ad when available. | `servingStatus` |
### Creatives
Adriel post-processes ad creatives to generate these breakdowns.
| Breakdown | Description | API Key |
| ---------------- | ------------------------------------------------------- | ------------- |
| Ad Copy | Groups results by words extracted from the ad creative. | *Adriel-side* |
| Color Clustering | Groups results by the dominant creative color cluster. | *Adriel-side* |
| Creative Image | Groups results by the creative image hash. | *Adriel-side* |
| Emoji Analysis | Groups results by emojis detected in the creative. | *Adriel-side* |
### Date
The platform returns daily records; all time-grouping breakdowns are Adriel-side aggregations of the same underlying daily data.
| Breakdown | Description | API Key |
| ----------------------------- | ------------------------------------------------------- | ---------------- |
| Auto Time Breakdown | Groups results by an automatically selected time grain. | *Adriel-side* |
| Daily Breakdown | Groups results by calendar day. | `Day` |
| Monthly Breakdown | Groups results by calendar month. | `Month` |
| Quarterly Breakdown | Groups results by calendar quarter. | *Adriel-side* |
| Week Date Breakdown | Groups results by the starting date of the week bucket. | *Adriel-side* |
| Week Number Breakdown (W#) | Groups results by week number in the year. | *Adriel-side* |
| Weekly Breakdown (Start: Mon) | Groups results by Monday-Sunday week. | `Week (Mon-Sun)` |
| Weekly Breakdown (Start: Sun) | Groups results by Sunday-Saturday week. | *Adriel-side* |
| Yearly Breakdown | Groups results by calendar year. | *Adriel-side* |
### Others
| Breakdown | Description | API Key |
| ----------- | --------------------------------------- | ------------- |
| No Grouping | Returns all results in a single bucket. | *Adriel-side* |
### LY Ads Search Ads-specific
These breakdowns exist only for LY Ads Search 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 | Groups results by ad. | `adName` |
| Ad Account | Groups results by Yahoo Japan ad account. | `accountName` |
| Ad Label | Groups results by ad label. | `labels` |
| Ad Set | Groups results by ad group. | `adGroupName` |
| Ad Set Label | Groups results by ad group label. | `labels` |
| Ad Track ID | Groups results by ad tracking ID. | `Ad tracking ID` |
| Campaign | Groups results by campaign. | `campaignName` |
| Campaign Label | Groups results by campaign label. | `labels` |
| Campaign Track ID | Groups results by campaign tracking ID. | `Campaign tracking ID` |
| Country | Groups results by country. | `Country` |
| Creative Description | Groups results by the first ad description line. | `Description 1` |
| Creative Headline | Groups results by the first ad title or headline. | `Title1` |
| Device Target | Groups results by device type. | `Device` |
| Keyword Name | Groups results by keyword. | `keyword` |
| Keyword Label | Groups results by keyword label. | `labels` |
| Keyword Match Type | Groups results by keyword match type. | `Match Type` |
| Keyword Track ID | Groups results by keyword tracking ID. | `Keyword tracking ID` |
| Location | Groups results by city. | `City` |
| Search Term View | Groups results by the search query that triggered the ad. | `Search Query` |
## Limitations
Based on the current connector, LY Ads Search Ads has the following limits:
* **Cache-only reports** — report data is served from cached daily snapshots and is never fetched on demand. Data is reliable only within the cache sync window; older data may be incomplete or missing.
* **Uniqueness metrics over long ranges** — metrics based on uniqueness (such as Reach) may be overvalued when a date range longer than one day is viewed, because snapshots are aggregated daily.
* **Impression share not summable** — impression share metrics use unique aggregation and are not available at the ad level; budget-lost impression share is also excluded at the ad-set level.
* **Search-only breakdowns** — Keyword, Keyword text, and Search term breakdowns return data only for Search campaigns.
* **Age, gender, region, and site breakdowns are unavailable** — these are Display-Ads-only. A site breakdown request on Search Ads returns an `INVALID_DIMENSIONS_METRICS_COMBINATION` error.
* **No video or viewability metrics** — video-performance and viewability metrics are Display-Ads-only and do not populate for Search Ads.
* **Date range caps** — daily breakdowns are limited to 93 days, weekly to 1 year, and monthly to 2 years; data outside these windows may be truncated.
## API references
* [Yahoo! JAPAN Ads API documentation](https://ads-developers.yahoo.co.jp/)
* [Yahoo! JAPAN Ads Search Ads API reference](https://ads-developers.yahoo.co.jp/reference/searchads/)
* [Yahoo! JAPAN Ads OAuth (biz-oauth)](https://biz-oauth.yahoo.co.jp/)
## See also
* [How to connect LY Ads Search Ads to Adriel](/data-sources/g-n/ly-ads-search-ads/how-to-connect) — step-by-step setup guide
* [LY Ads Display Ads data reference](/data-sources/g-n/ly-ads-display-ads/data-reference)