Google Ads performance by geography — derived from user IP and Google’s geolocation services.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 × location.
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
Reporting granularity is bounded by your campaign’s targeting. A campaign that targets only countries cannot be drilled down to city. Don’t expect city-level rows from a national campaign.
Slice by
Unique to this data model:| Dimension | Type | Values |
|---|---|---|
city | String | City name |
most_specific_location | String | Finest available identifier for the matched location |
location_type | String | City, Region/State, Country, DMA, Postal Code, Radius |
Use it to answer
- Which regions deliver the highest ROAS — where should I rebalance budget?
- Where should we test expansion — which untargeted markets resemble our best ones?
- What bid modifier is justified by the CPA gap by city?
- How does AOV vary by geography — different purchase basket mix per market?
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 |
| Conversion | |
| 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 · view_through_conversions · video_views