# ChatGPT Ads datasets and fields

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

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

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

## Connection and sync

You connect ChatGPT Ads with API credentials from the ChatGPT Ads account. Maven stores them encrypted.

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

## Datasets

### Ad account

Single-row account metadata snapshot.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| URL | Text |
| preview URL | Text |
| timezone | Text |
| currency code | Text |

### Campaigns

Campaign entity table — snapshot of all campaigns.

| Field | Type |
| --- | --- |
| campaign ID | Text |
| campaign name | Text |
| description | Text |
| status | Text |
| start time | Timestamp |
| end time | Timestamp |
| lifetime spend limit micros | Integer |
| lifetime spend limit | Number |
| targeting countries | Text |
| targeting excluded countries | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |

### Ad groups

Ad group entity table — snapshot of all ad groups.

| Field | Type |
| --- | --- |
| ad group ID | Text |
| ad group name | Text |
| description | Text |
| campaign ID | Text |
| status | Text |
| context hints | Text |
| billing event type | Text |
| max bid micros | Integer |
| max bid | Number |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |

### Ads

Ad entity + creative metadata — snapshot of all ads.

| Field | Type |
| --- | --- |
| ad ID | Text |
| ad name | Text |
| ad group ID | Text |
| campaign ID | Text |
| status | Text |
| review status | Text |
| creative type | Text |
| creative title | Text |
| creative body | Text |
| creative target URL | Text |
| creative file ID | Text |
| creative image URL | Text |
| created at | Timestamp |
| updated at | Timestamp |
| account ID | Text |

### Ad insights

Ad-grain daily insights.

| Field | Type |
| --- | --- |
| date | Date |
| ad ID | Text |
| ad name | Text |
| ad group ID | Text |
| ad group name | Text |
| campaign ID | Text |
| campaign name | Text |
| account ID | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| start time | Timestamp |
| end time | Timestamp |
| timezone | Text |

### Ad group insights

Ad-group-grain daily insights.

| Field | Type |
| --- | --- |
| date | Date |
| ad group ID | Text |
| ad group name | Text |
| campaign ID | Text |
| campaign name | Text |
| account ID | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| start time | Timestamp |
| end time | Timestamp |
| timezone | Text |

### Campaign insights

Campaign-grain daily insights.

| Field | Type |
| --- | --- |
| date | Date |
| campaign ID | Text |
| campaign name | Text |
| account ID | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| start time | Timestamp |
| end time | Timestamp |
| timezone | Text |

### Conversion pixels

Conversion pixel catalog for the ad account (id, name, client type).

| Field | Type |
| --- | --- |
| account ID | Text |
| pixel ID | Text |
| data source ID | Text |
| pixel name | Text |
| client type | Text |
| snapshot date | Date |

### Conversion event settings

Per-account conversion event/goal configuration (attribution windows, associated campaigns/sources, archived flag). Config only -- not volume or event-level data.

| Field | Type |
| --- | --- |
| account ID | Text |
| event setting ID | Text |
| ad account ID | Text |
| name | Text |
| event type | Text |
| custom event name | Text |
| archived | True/false |
| is shopify managed | True/false |
| attribution window days | Integer |
| view through attribution window days | Integer |
| version | Integer |
| source IDs json | Text |
| sources json | Text |
| campaigns json | Text |
| snapshot date | Date |

### Conversion event samples daily

| Field | Type |
| --- | --- |
| account ID | Text |
| pixel ID | Text |
| sample date | Date |
| action source | Text |
| API channel | Text |
| event type | Text |
| sample event count | Integer |
| last event timestamp | Timestamp |
| last received at | Timestamp |
| p50 latency seconds | Number |
| p95 latency seconds | Number |
| syncs sampled | Integer |

### Account insights

Account-grain daily insights.

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| start time | Timestamp |
| end time | Timestamp |
| timezone | Text |

### Ad product insights

| 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 |
| product feed ID | Text |
| product item ID | Text |
| product title | Text |
| product image URL | Text |
| product target URL | Text |
| product brand | Text |
| product price | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| spend reported | True/false |
| timezone | Text |
