Google Ads performance by where the ad actually appeared — websites, mobile apps, YouTube channels, and YouTube videos.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 × placement.
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 |
|---|---|---|
placement_type | String | Website, Mobile App, YouTube Channel, YouTube Video, Other |
placement_url | String | URL or identifier of where the ad appeared |
placement_display_name | String | Human-readable name (site, app, channel, or video title) |
Use it to answer
- Which placements waste budget with no conversions — candidates for the exclusion list?
- Which placements consistently convert — promote to managed placements?
- Are any placement URLs misaligned with our brand?
- Which YouTube channels and apps perform best for video and in-app ads?
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 |
| Video | |
| Video Views | Sum |
Raw fields (for custom calculations)
Raw fields (for custom calculations)
ad_spend · conversion_value · conversions · clicks · impressions · engagements · interactions · view_through_conversions · video_views