# Google Ads datasets and fields

> The 25 datasets Maven lands from Google Ads, every field in them, and how the connection syncs.

Source: https://mavendata.ai/docs/integrations/google-ads

Maven lands 25 datasets from Google Ads in each client workspace. This page lists every one with all of its fields. For the metrics, reports and setup steps, see the [Google Ads integration page](https://mavendata.ai/integrations/google-ads).

## Connection and sync

You connect Google Ads by signing in to it and approving access, so nobody shares a password.

The first Google Ads sync pulls the most recent 30 days so the workspace fills quickly. A follow-up backfill then adds older history, up to 1125 days in total. After that, each scheduled sync re-reads the last 7 days, so late changes are picked up.

## Datasets

### Customer settings

Authoritative Google Ads customer currency, reporting timezone and auto-tagging snapshot.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| metadata provenance | Text |
| auto tagging enabled | True/false |

### Campaigns

Current Google Ads campaign entities with provider schedule, bidding, and budget metadata.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign status | Text |
| campaign start date time | Text |
| campaign end date time | Text |
| channel type | Text |
| channel sub type | Text |
| bidding strategy | Text |
| bidding strategy resource | Text |
| target cpa micros | Integer |
| target ROAS | Number |
| campaign budget resource | Text |
| campaign budget ID | Text |
| campaign budget name | Text |
| campaign budget status | Text |
| campaign budget period | Text |
| daily budget micros | Integer |
| lifetime budget micros | Integer |
| campaign budget explicitly shared | True/false |
| campaign budget delivery method | Text |
| budget period | Text |
| campaign objective | Text |
| campaign type | Text |
| daily budget | Number |
| lifetime budget | Number |
| start date | Text |
| end date | Text |

### Campaign performance

Campaign-level daily performance — impressions, clicks, cost, conversions.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign status | Text |
| channel type | Text |
| bidding strategy | Text |
| bidding strategy resource | Text |
| target cpa micros | Integer |
| target ROAS | Number |
| impressions | Integer |
| clicks | Integer |
| engagements | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| all conversions | Number |
| CTR | Number |
| avg CPC | Number |
| avg CPM | Number |
| final URL suffix | Text |
| tracking URL template | Text |
| URL custom parameters | Text |
| campaign final URL suffix | Text |
| campaign tracking URL template | Text |
| campaign URL custom parameters | Text |
| customer final URL suffix | Text |
| customer tracking URL template | Text |
| customer URL custom parameters | Text |
| video views | Integer |
| all conversion value | Number |

### Ad performance

Ad-level daily performance with ad, ad group, campaign, and customer URL option fields.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| campaign name | Text |
| ad group ID | Text |
| ad group name | Text |
| ad group status | Text |
| ad group type | Text |
| ad ID | Text |
| ad name | Text |
| ad status | Text |
| ad type | Text |
| impressions | Integer |
| clicks | Integer |
| engagements | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| final URL | Text |
| final URLs | Text |
| final URL suffix | Text |
| tracking URL template | Text |
| URL custom parameters | Text |
| ad final URL | Text |
| ad final URLs | Text |
| ad final URL suffix | Text |
| ad tracking URL template | Text |
| ad URL custom parameters | Text |
| ad group final URL suffix | Text |
| ad group tracking URL template | Text |
| ad group URL custom parameters | Text |
| campaign final URL suffix | Text |
| campaign tracking URL template | Text |
| campaign URL custom parameters | Text |
| customer final URL suffix | Text |
| customer tracking URL template | Text |
| customer URL custom parameters | Text |
| video views | Integer |
| all conversion value | Number |

### Ad group performance

Ad group-level daily performance with ad group, campaign, and customer URL option fields.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| campaign name | Text |
| ad group ID | Text |
| ad group name | Text |
| ad group status | Text |
| ad group type | Text |
| impressions | Integer |
| clicks | Integer |
| engagements | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| final URL suffix | Text |
| tracking URL template | Text |
| URL custom parameters | Text |
| ad group final URL suffix | Text |
| ad group tracking URL template | Text |
| ad group URL custom parameters | Text |
| campaign final URL suffix | Text |
| campaign tracking URL template | Text |
| campaign URL custom parameters | Text |
| customer final URL suffix | Text |
| customer tracking URL template | Text |
| customer URL custom parameters | Text |
| video views | Integer |
| all conversion value | Number |

### Device performance

Campaign performance by device type.

| Field | Type |
| --- | --- |
| date | Date |
| device | Text |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| impressions | Integer |
| clicks | Integer |
| engagements | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| final URL suffix | Text |
| tracking URL template | Text |
| URL custom parameters | Text |
| campaign final URL suffix | Text |
| campaign tracking URL template | Text |
| campaign URL custom parameters | Text |
| customer final URL suffix | Text |
| customer tracking URL template | Text |
| customer URL custom parameters | Text |

### Geo performance

Campaign performance by geo region (state/province).

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| country criterion ID | Text |
| location type | Text |
| region resource name | Text |
| region criterion ID | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |

### Geo performance metro

Daily campaign performance by DMA.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| country criterion ID | Text |
| location type | Text |
| metro resource name | Text |
| metro criterion ID | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |

### Geo performance county

Daily campaign performance by county.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| country criterion ID | Text |
| location type | Text |
| county resource name | Text |
| county criterion ID | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |

### Geo performance postal

Daily campaign performance by postal code.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| country criterion ID | Text |
| location type | Text |
| postal code resource name | Text |
| postal code criterion ID | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |

### Geo target constants

Geo target constants for country, region, DMA region, county and postal code.

| Field | Type |
| --- | --- |
| criterion ID | Text |
| name | Text |
| canonical name | Text |
| country code | Text |
| target type | Text |
| status | Text |
| account ID | Text |
| account name | Text |

### Conversion action performance

Lowest provider-returned conversion metrics segmented by Google Ads conversion action and conversion date.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign channel type | Text |
| ad group ID | Text |
| ad group name | Text |
| ad ID | Text |
| ad name | Text |
| asset group ID | Text |
| asset group name | Text |
| conversion action resource name | Text |
| conversion action ID | Text |
| conversion action name | Text |
| conversions | Number |
| conversion value | Number |
| reported grain | Text |

### Conversion report coverage daily

Successful native Google Ads conversion-action report coverage, including zero-row account-days.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| report name | Text |
| requested grain | Text |
| reported grain | Text |
| report status | Text |
| row count | Integer |
| is partial | True/false |

### Conversion actions

Conversion-action dimension with gtag tag-snippet labels.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| conversion action ID | Text |
| conversion action resource name | Text |
| conversion action name | Text |
| conversion action type | Text |
| conversion action status | Text |
| conversion action category | Text |
| counting type | Text |
| origin | Text |
| primary for goal | True/false |
| include in conversions metric | True/false |
| click through lookback window days | Integer |
| view through lookback window days | Integer |
| default value | Number |
| default currency code | Text |
| always use default value | True/false |
| owner customer | Text |
| conversion ID | Text |
| conversion label | Text |
| conversion last received request date time | Text |
| conversion last conversion date | Text |

### Customer conversion settings

Account-level Google Ads conversion tracking settings.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| conversion tracking ID | Text |
| cross account conversion tracking ID | Text |
| accepted customer data terms | True/false |
| conversion tracking status | Text |
| enhanced conversions for leads enabled | True/false |
| google ads conversion customer | Text |

### Campaign conversion goals

Per-campaign biddable conversion categories — the campaign's optimization target.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| conversion category | Text |
| conversion origin | Text |
| biddable | True/false |

### Configured target coverage

Current completeness status for Google Ads campaign conversion-goal collection.

| Field | Type |
| --- | --- |
| coverage key | Text |
| account ID | Text |
| scope level | Text |
| collection status | Text |
| source entity count | Integer |
| configured target count | Integer |
| capability reason | Text |
| collected at | Timestamp |

### Asset group performance

Performance Max asset-group daily performance and raw status diagnostics.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign status | Text |
| asset group ID | Text |
| asset group name | Text |
| asset group status | Text |
| asset group primary status | Text |
| asset group primary status reasons | Text |
| asset group ad strength | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| account name | Text |

### Asset group asset performance

Performance Max asset-link daily performance, serving status, and policy diagnostics.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| campaign ID | Text |
| campaign name | Text |
| asset group ID | Text |
| asset group name | Text |
| asset resource name | Text |
| asset ID | Text |
| asset name | Text |
| asset type | Text |
| asset text | Text |
| image URL | Text |
| image width | Integer |
| image height | Integer |
| mime type | Text |
| youtube video ID | Text |
| field type | Text |
| asset group asset status | Text |
| asset group asset primary status | Text |
| asset group asset primary status details | Text |
| asset group asset primary status reasons | Text |
| policy approval status | Text |
| policy review status | Text |
| policy topic entries | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| video views | Integer |
| preview asset ID | Text |
| preview storage path | Text |
| preview source URL | Text |
| preview status | Text |
| preview failure code | Text |
| preview verified at | Timestamp |
| preview content type | Text |
| preview width | Integer |
| preview height | Integer |
| account name | Text |
| creative ID | Text |

### Ad asset performance

Native daily creative performance at ad and asset grain.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| campaign ID | Text |
| campaign name | Text |
| ad group ID | Text |
| ad group name | Text |
| ad ID | Text |
| ad name | Text |
| creative ID | Text |
| creative name | Text |
| asset type | Text |
| field type | Text |
| enabled | True/false |
| performance label | Text |
| pinned field | Text |
| asset source | Text |
| asset text | Text |
| image URL | Text |
| image width | Integer |
| image height | Integer |
| mime type | Text |
| youtube video ID | Text |
| video thumbnail URL | Text |
| landing page URL | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| video views | Integer |
| ad type | Text |
| campaign advertising channel type | Text |
| preview asset ID | Text |
| preview storage path | Text |
| preview source URL | Text |
| preview status | Text |
| preview failure code | Text |
| preview verified at | Timestamp |
| preview content type | Text |
| preview width | Integer |
| preview height | Integer |
| account name | Text |

### Video asset performance

Daily per-video delivery from the Google Ads video report at date x ad x YouTube video grain. Written by account-scoped date-window replace.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| campaign ID | Text |
| campaign name | Text |
| campaign advertising channel type | Text |
| ad group ID | Text |
| ad group name | Text |
| ad ID | Text |
| ad name | Text |
| ad type | Text |
| youtube video ID | Text |
| video title | Text |
| video channel ID | Text |
| video duration millis | Integer |
| video thumbnail URL | Text |
| impressions | Integer |
| clicks | Integer |
| cost micros | Integer |
| conversions | Number |
| conversion value | Number |
| video views | Integer |
| account name | Text |

### Creative assets

Text, image, and video assets attached to ads with durable Maven preview metadata.

| Field | Type |
| --- | --- |
| asset link resource name | Text |
| account ID | Text |
| campaign ID | Text |
| ad group ID | Text |
| ad ID | Text |
| ad name | Text |
| creative ID | Text |
| creative name | Text |
| asset type | Text |
| field type | Text |
| enabled | True/false |
| performance label | Text |
| pinned field | Text |
| asset source | Text |
| asset text | Text |
| image URL | Text |
| image width | Integer |
| image height | Integer |
| mime type | Text |
| youtube video ID | Text |
| video thumbnail URL | Text |
| landing page URL | Text |
| preview asset ID | Text |
| preview storage path | Text |
| preview source URL | Text |
| preview status | Text |
| preview failure code | Text |
| preview verified at | Timestamp |
| preview content type | Text |
| preview width | Integer |
| preview height | Integer |
| account name | Text |

### Offline upload client summaries

Offline-conversion-upload health per uploading client (rolling \~7-day snapshot).

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| client | Text |
| snapshot date | Date |
| status | Text |
| success rate | Number |
| total event count | Integer |
| successful event count | Integer |
| pending event count | Integer |
| last upload date time | Text |
| alerts json | Text |
| daily summaries json | Text |
| job summaries json | Text |

### Offline upload action summaries

Offline-conversion-upload health per conversion action (rolling \~7-day snapshot).

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| conversion action ID | Text |
| conversion action name | Text |
| client | Text |
| snapshot date | Date |
| status | Text |
| success rate | Number |
| total event count | Integer |
| successful event count | Integer |
| pending event count | Integer |
| last upload date time | Text |
| alerts json | Text |
| daily summaries json | Text |
| job summaries json | Text |

### Offline upload daily summaries

Per-day offline-conversion-upload counts per account, summed across uploading clients.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| upload date | Date |
| successful count | Integer |
| failed count | Integer |
| pending count | Integer |
