Google Ads performance by device and ad-network type — the broadest metric set, including cross-device conversion value.Documentation Index
Fetch the complete documentation index at: https://docs.ocular.dev/llms.txt
Use this file to discover all available pages before exploring further.
What this data model represents
Grain: one row perdate × ad_account × campaign × adset × ad × device × ad_network_type.
Metrics, grouped by category — every number you can compute on this data model. Expand below for examples in each.
Show sample metrics in each category
Show sample metrics in each category
Show sample dimensions in each category
Show sample dimensions in each category
Slice by
Unique to this data model:| Dimension | Type | Values |
|---|---|---|
device | String | Mobile, Desktop, Tablet |
ad_network_type | String | Search, Mixed, YouTube, Other |
ad_id / ad_name / ad_status | String | Individual ad identity — also available on Conversion Action |
Use it to answer
- How does ROAS split across Mobile / Desktop / Tablet — where should budget shift?
- Which network (Search, Display, YouTube, partners) carries the actual conversions?
- How much revenue is being cross-device-attributed — am I under-crediting mobile?
- Which individual ad creative wins on each device?
Available metrics
Everything you can compute on this data model. Need a metric not listed? See the Google Ads metric availability matrix.| Metric | Formula |
|---|---|
| Spend & revenue | |
| Ad Spend | Sum of daily spend |
| Conversion Value | Sum of reported revenue |
| ROAS | Conversion Value ÷ Ad Spend |
| Conversions | Sum of attributed conversion events |
| AOV | Conversion Value ÷ Conversions |
| Clicks & impressions | |
| Clicks | Sum of clicks |
| Impressions | Sum of impressions |
| CTR | Clicks ÷ Impressions × 100 |
| Cost efficiency | |
| CPC | Ad Spend ÷ Clicks |
| CPM | Ad Spend ÷ Impressions × 1,000 |
| CPA | Ad Spend ÷ Conversions |
| RPC | Conversion Value ÷ Clicks |
| Engagement | |
| Engagements | Sum |
| Interactions | Sum |
| CPE | Ad Spend ÷ Engagements |
| CPI | Ad Spend ÷ Interactions |
| Conversion | |
| Conversion Rate | Conversions ÷ Clicks × 100 |
| View Through Conversions | Sum of conversions from impressions without clicks |
| Cross Device Conversions | Sum of conversions on a different device from the click |
| Cross Device Conversion Value | Sum of revenue from cross-device conversions |
| Video | |
| Video Views | Sum |
| Video 25% Watched | Sum |
| Video 50% Watched | Sum |
| Video 75% Watched | Sum |
| Video 100% Watched | Sum |
Raw fields (for custom calculations)
Raw fields (for custom calculations)
ad_spend · conversion_value · conversions · clicks · impressions · engagements · interactions · view_through_conversions · cross_device_conversions · cross_device_conversion_value · video_views · video_25_watched · video_50_watched · video_75_watched · video_100_watched