> ## 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 Google Display & Video 360 data source in Adriel.

## Introduction

Display & Video 360 (DV360) is Google's enterprise demand-side platform for programmatic display, video, audio, and connected-TV buying. The connector ingests advertiser, insertion order, line item, and creative performance through the Display & Video API and offline reporting, so campaigns bought in DV360 report alongside other channels.

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 Google Display & Video 360 to Adriel](/data-sources/g-n/google-display-video-360-dv360/how-to-connect).

## Data refresh strategy

### Architecture data

Architecture covers ad accounts (advertisers), campaigns (insertion orders), ad sets (line items), and ads (creatives). It refreshes twice daily, at **4:00 PM UTC** and **5:00 AM UTC**.

### Reports data

**Cache-only.** Report data is served from cached daily performance snapshots. Dashboard views aggregate from the most recent snapshot rather than fetching fresh on every load. Metrics based on uniqueness, such as reach, can appear overvalued when viewed across a period longer than one day.

**Initial backfill.** On data source creation, the cache fills with **365 days** of history for ad account, campaign, ad set, and ad.

**Refresh schedule.** Reports refresh once per day at **7:00 PM UTC**, syncing the **last 10 days** for ad account, campaign, ad set, ad, and the country-by-ad-account breakdown. Data is considered reliable within this sync window. Data outside the window may be incomplete, missing, or not fully accurate due to legacy caching behavior.

## Architecture levels

Advertiser → Insertion order → Line item → Creative

In the standardized model, advertiser maps to **ad account**, insertion order to **campaign**, line item to **ad set**, and creative to **ad**, so DV360 reports alongside other ad platforms. In DV360's native hierarchy, advertisers belong to a parent **partner**.

## Date range limits

DV360 offers daily and monthly date breakdowns. Each has a maximum look-back window; ranges longer than the limit are automatically shortened.

| Breakdown | Max range |
| --------- | --------- |
| Daily     | 93 days   |
| Monthly   | 2 years   |

## Metrics

<Note>
  **How to read the API Key column**

  Code style like `METRIC_IMPRESSIONS` is the literal Display & Video 360 API metric name. *Italic text* describes how a value is produced when it is computed by Adriel rather than fetched from a single API field.
</Note>

### Cost and revenue

| Metric                                 | Description                                                             | Data type | API Key                              |
| -------------------------------------- | ----------------------------------------------------------------------- | --------- | ------------------------------------ |
| Spend                                  | Media cost in the advertiser's billing currency.                        | Currency  | `METRIC_MEDIA_COST_ADVERTISER`       |
| Total media cost (advertiser currency) | Total media cost, including fees, in the advertiser's currency.         | Currency  | `METRIC_TOTAL_MEDIA_COST_ADVERTISER` |
| Revenue                                | Reported revenue in the advertiser's currency.                          | Currency  | `METRIC_REVENUE_ADVERTISER`          |
| CM360 post-click revenue               | Revenue attributed to post-click conversions from Campaign Manager 360. | Currency  | `METRIC_CM360_POST_CLICK_REVENUE`    |
| CM360 post-view revenue                | Revenue attributed to post-view conversions from Campaign Manager 360.  | Currency  | `METRIC_CM360_POST_VIEW_REVENUE`     |
| Media cost eCPA (advertiser currency)  | Effective media cost per acquisition.                                   | Currency  | *spend / impressions*                |
| Media cost eCPM (advertiser currency)  | Effective media cost per thousand impressions.                          | Currency  | *(spend / impressions) × 1000*       |
| Revenue eCPC (advertiser currency)     | Effective revenue per click.                                            | Currency  | *revenue / impressions*              |
| Revenue eCPM (advertiser currency)     | Effective revenue per thousand impressions.                             | Currency  | *(revenue / impressions) × 1000*     |

### Delivery and clicks

| Metric               | Description                             | Data type  | API Key                       |
| -------------------- | --------------------------------------- | ---------- | ----------------------------- |
| Impressions          | Times the ads were displayed.           | Number     | `METRIC_IMPRESSIONS`          |
| Billable impressions | Impressions counted as billable.        | Number     | `METRIC_BILLABLE_IMPRESSIONS` |
| Invalid impressions  | Impressions flagged as invalid traffic. | Number     | `METRIC_INVALID_IMPRESSIONS`  |
| Clicks               | Ad clicks.                              | Number     | `METRIC_CLICKS`               |
| Invalid clicks       | Clicks flagged as invalid traffic.      | Number     | `METRIC_INVALID_CLICKS`       |
| Engagements          | User engagements with the ad.           | Number     | `METRIC_ENGAGEMENTS`          |
| Expansions           | Expansions of expandable creatives.     | Number     | `METRIC_EXPANSIONS`           |
| Engagement rate      | Engagements as a share of impressions.  | Percentage | *Engagements / impressions*   |

### Viewability

| Metric                            | Description                                       | Data type | API Key                                   |
| --------------------------------- | ------------------------------------------------- | --------- | ----------------------------------------- |
| Active View: eligible impressions | Impressions eligible for Active View measurement. | Number    | `METRIC_ACTIVE_VIEW_ELIGIBLE_IMPRESSIONS` |

### Reach

<Note>
  Reach is a uniqueness-based metric. DV360 counts unique users within each daily snapshot, so reach can appear inflated when aggregated across a period longer than one day. Reach also requires a country breakdown and monthly granularity to return meaningful values.
</Note>

| Metric | Description                 | Data type | API Key                           |
| ------ | --------------------------- | --------- | --------------------------------- |
| Reach  | Total unique users reached. | Number    | `METRIC_UNIQUE_REACH_TOTAL_REACH` |

Additional Unique Reach and Coviewed Reach group metrics (for example click reach, impression reach, viewable-impression reach, and average impression frequency) and Unique Reach Audience metrics (for example percentage composition impressions and target rating points) are also available and route to DV360's reach report types.

### Video and audio

| Metric                       | Description                                       | Data type  | API Key                                            |
| ---------------------------- | ------------------------------------------------- | ---------- | -------------------------------------------------- |
| Starts (video)               | Video plays initiated.                            | Number     | `METRIC_RICH_MEDIA_VIDEO_PLAYS`                    |
| First-quartile views (video) | Plays reaching 25% of video length.               | Number     | `METRIC_RICH_MEDIA_VIDEO_FIRST_QUARTILE_COMPLETES` |
| Midpoint views (video)       | Plays reaching 50% of video length.               | Number     | `METRIC_RICH_MEDIA_VIDEO_MIDPOINTS`                |
| Third-quartile views (video) | Plays reaching 75% of video length.               | Number     | `METRIC_RICH_MEDIA_VIDEO_THIRD_QUARTILE_COMPLETES` |
| Complete views (video)       | Plays reaching 100% of video length.              | Number     | `METRIC_RICH_MEDIA_VIDEO_COMPLETIONS`              |
| Completion rate (video)      | Complete video views as a share of impressions.   | Percentage | *Complete Views (Video) / impressions*             |
| TrueView: views              | TrueView video views.                             | Number     | `METRIC_TRUEVIEW_VIEWS`                            |
| TrueView: view rate          | TrueView views as a share of impressions.         | Percentage | *TrueView: Views / impressions*                    |
| Complete listens (audio)     | Audio plays reaching 100% of length.              | Number     | `METRIC_COMPLETE_LISTENS_AUDIO`                    |
| Completion rate (audio)      | Complete audio listens as a share of impressions. | Percentage | *Complete Listens (Audio) / impressions*           |

### Conversions

<Note>
  Floodlight conversion metrics, keyed as `floodlight:{activity name}`, only appear when the DV360 advertiser is linked with Campaign Manager 360. Without that link, Floodlight fields are not returned.
</Note>

| Metric                          | Description                                                      | Data type  | API Key                                      |
| ------------------------------- | ---------------------------------------------------------------- | ---------- | -------------------------------------------- |
| Total conversions               | Attributed conversions across configured conversion definitions. | Number     | `METRIC_TOTAL_CONVERSIONS`                   |
| Post-click conversions          | Conversions attributed to a click (last click).                  | Number     | `METRIC_LAST_CLICKS`                         |
| Post-view conversions           | Conversions attributed to an impression (last impression).       | Number     | `METRIC_LAST_IMPRESSIONS`                    |
| % clicks leading to conversions | Share of clicks that led to a post-click conversion.             | Percentage | `METRIC_CLICK_TO_POST_CLICK_CONVERSION_RATE` |

## Breakdowns

### Ad hierarchy

| Breakdown  | Description               | API Key     |
| ---------- | ------------------------- | ----------- |
| Ad account | Group by advertiser.      | `adAccount` |
| Campaign   | Group by insertion order. | `campaign`  |
| Ad set     | Group by line item.       | `adSet`     |
| Ad         | Group by creative.        | `ad`        |

### Geographic

| Breakdown                | Description                                   | API Key             |
| ------------------------ | --------------------------------------------- | ------------------- |
| Country (per ad account) | Geographic breakdown at the advertiser level. | `country/adAccount` |

### Time

<Note>
  Time breakdowns are Adriel-side aggregations of the same underlying daily snapshots, not separate data pulls.
</Note>

| Breakdown         | Description                      |
| ----------------- | -------------------------------- |
| Daily breakdown   | Split reports by day.            |
| Monthly breakdown | Split reports by calendar month. |

## Limitations

Based on the current connector, Google Display & Video 360 has the following limits:

* **Cache-only reporting** — report data comes from a daily cache rather than a live fetch. Numbers outside the 10-day rolling sync window stay anchored to the last snapshot, and uniqueness-based metrics such as reach and frequency can appear inflated over long date ranges.
* **Reach requires a country breakdown and monthly granularity** — requesting reach (or any Unique Reach group metric) without a country breakdown produces an API error, and reach cannot be combined with advertiser-currency segmentation. Monthly granularity is required for meaningful numbers.
* **Gender and age breakdowns are not offered by this connector** — their availability varies by campaign type, which would make segmented totals inconsistent with non-segmented queries.
* **Invalid Clicks and Invalid Impressions drop with country segmentation** — adding a country breakdown silently removes these two metrics from the query because they are incompatible with country segmentation.
* **Floodlight conversions require a CM360 link** — Floodlight activity metrics appear only when the advertiser is linked with Campaign Manager 360.
* **Weekly date breakdown is not offered** — only daily and monthly date breakdowns are available.
* **Fetch window** — the maximum fetchable date range per request is 700 days, and the cache soft limit is 365 days.
* **Report generation latency** — DV360 builds reports asynchronously, so time between a refresh and data availability depends on report size and Google's job queue.
* **Custom saved queries use a separate connector** — user-authored DV360 saved queries are supported through the separate DV360 Report connector, which caches a free-format report file on its own schedule.

## API references

* [Display & Video 360 API reference](https://developers.google.com/display-video/api/reference/rest)
* [Bid Manager API reference](https://developers.google.com/bid-manager/reference/rest)
* [OAuth 2.0 for Google APIs](https://developers.google.com/identity/protocols/oauth2)

## See also

* [Google Display & Video 360 how-to (paired)](/data-sources/g-n/google-display-video-360-dv360/how-to-connect) — step-by-step setup guide
* [Google Ads data reference](/data-sources/g-n/google-ads/data-reference)
* [Google Campaign Manager 360 data reference](/data-sources/g-n/google-campaign-manager-360/data-reference)