Integrations
ChatGPT Ads datasets and fields
The 12 datasets Maven lands from ChatGPT Ads, every field in them, and how the connection syncs.
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.
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 |