# TikTok Ads datasets and fields

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

Source: https://mavendata.ai/docs/integrations/tiktok

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

## Connection and sync

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

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

## Datasets

### Accounts

Non-sensitive TikTok advertiser identity and immutable reporting settings.

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| account name | Text |
| account status | Text |
| account currency | Text |
| account timezone | Text |
| timezone raw | Text |
| country code | Text |
| language | Text |
| industry | Text |
| account role | Text |
| account type | Text |
| owner business center ID | Text |
| source created at | Timestamp |
| metadata provenance | Text |

### Pixels

Daily snapshot of the advertiser's TikTok pixel catalog -- setup mode, activity status, advanced-matching flags, and event catalog.

| Field | Type |
| --- | --- |
| advertiser ID | Text |
| account ID | Text |
| account name | Text |
| snapshot date | Date |
| pixel ID | Text |
| pixel name | Text |
| pixel code | Text |
| pixel category | Text |
| pixel setup mode | Text |
| create time | Timestamp |
| activity status | Text |
| enable expanded data sharing | True/false |
| enable first party cookies | True/false |
| advanced matching email | True/false |
| advanced matching phone number | True/false |
| automatic advanced matching fields | Text |
| asset ownership | Text |
| events | Text |
| event count | Integer |

### Pixel event stats daily

Daily pixel event statistics.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| pixel ID | Text |
| event type | Text |
| count | Number |

### Ad insights

Daily ad-level performance.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| account name | Text |
| account currency | Text |
| account timezone | Text |
| campaign ID | Text |
| campaign name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| ad ID | Text |
| ad name | Text |
| impressions | Integer |
| clicks | Integer |
| spend | Number |
| reach | Integer |
| CPC | Number |
| CPM | Number |
| CTR | Number |
| frequency | Number |
| conversions | Integer |
| cost per conversion | Number |
| conversion rate | Number |
| real time conversions | Integer |
| real time cost per conversion | Number |
| real time conversion rate | Number |
| results | Number |
| cost per result | Number |
| result rate | Number |
| real time results | Number |
| real time cost per result | Number |
| real time result rate | Number |
| total purchase value | Number |
| video play actions | Integer |
| video watched 2s | Integer |
| video watched 6s | Integer |
| video views p25 | Integer |
| video views p50 | Integer |
| video views p75 | Integer |
| video views p100 | Integer |
| average video play | Number |
| profile visits | Integer |
| follows | Integer |
| likes | Integer |
| comments | Integer |
| shares | Integer |

### Ad conversion events

Native TikTok provider-attributed conversions at ad x custom event x day grain.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| ad ID | Text |
| ad name | Text |
| custom event type | Text |
| custom page events | Number |

### Conversion report coverage daily

Successful-empty coverage for TikTok native conversion-action reports.

| 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 |

### Campaigns

TikTok Ads campaign-level structure: status, objective, budget, schedule.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| advertiser ID | Text |
| campaign ID | Text |
| campaign name | Text |
| objective | Text |
| operation status | Text |
| secondary status | Text |
| budget | Number |
| budget mode | Text |
| schedule type | Text |
| schedule start time | Timestamp |
| schedule end time | Timestamp |
| create time | Timestamp |
| modify time | Timestamp |

### Adgroups

TikTok Ads adgroup-level structure: targeting, optimization, billing, budget.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| advertiser ID | Text |
| adgroup ID | Text |
| adgroup name | Text |
| campaign ID | Text |
| campaign name | Text |
| operation status | Text |
| secondary status | Text |
| budget | Number |
| budget mode | Text |
| scheduled budget | Number |
| optimization goal | Text |
| optimization event | Text |
| bid type | Text |
| bid price | Number |
| billing event | Text |
| pacing | Text |
| placement type | Text |
| placements json | Text |
| age groups json | Text |
| gender | Text |
| location IDs json | Text |
| interest category IDs json | Text |
| interest keyword IDs json | Text |
| schedule type | Text |
| schedule start time | Timestamp |
| schedule end time | Timestamp |
| promotion type | Text |
| brand safety type | Text |
| creative material mode | Text |
| is smart performance campaign | True/false |
| create time | Timestamp |
| modify time | Timestamp |

### Configured target coverage

Current completeness status for TikTok ad-group optimization-target 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 |

### Ads

TikTok Ads ad-level structure: status and hierarchy.

| Field | Type |
| --- | --- |
| account ID | Text |
| account name | Text |
| advertiser ID | Text |
| ad ID | Text |
| ad name | Text |
| campaign ID | Text |
| adgroup ID | Text |
| operation status | Text |
| secondary status | Text |
| create time | Timestamp |
| modify time | Timestamp |

### Ad creatives

TikTok Ads ad-level creative metadata: video/image assets, CTA, landing page, tracking, and identity (incl. Spark Ads organic post link).

| Field | Type |
| --- | --- |
| ad ID | Text |
| ad name | Text |
| advertiser ID | Text |
| account ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| ad format | Text |
| creative type | Text |
| image mode | Text |
| video ID | Text |
| video URL | Text |
| cover URL | Text |
| preview URL | Text |
| video duration | Number |
| video width | Integer |
| video height | Integer |
| image IDs json | Text |
| image URLs json | Text |
| thumbnail URL | Text |
| call to action | Text |
| landing page URL | Text |
| display name | Text |
| ad text | Text |
| UTM params json | Text |
| click tracking URL | Text |
| impression tracking URL | Text |
| identity ID | Text |
| identity type | Text |
| page ID | Text |
| tiktok item ID | Text |
| operation status | Text |
| secondary status | Text |
| create time | Timestamp |
| modify time | Timestamp |
| is aco | True/false |

### Ad insights material

| Field | Type |
| --- | --- |
| date | Date |
| account ID | Text |
| advertiser ID | Text |
| campaign ID | Text |
| adgroup ID | Text |
| ad ID | Text |
| material type | Text |
| material ID | Text |
| metric set | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| conversions | Integer |
| real time conversions | Integer |
| total purchase value | Number |
| video play actions | Integer |
| video watched 2s | Integer |
| video watched 6s | Integer |
| video views p25 | Integer |
| video views p50 | Integer |
| video views p75 | Integer |
| single image impressions | Integer |

### Material assets

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| material type | Text |
| material ID | Text |
| video ID | Text |
| image ID | Text |
| material name | Text |
| width | Integer |
| height | Integer |
| duration seconds | Number |
| cover source URL | Text |
| file signature | Text |
| created time | Timestamp |
| modified time | Timestamp |
| resolved | True/false |
| preview status | Text |
| stored preview path | Text |
| stored preview asset ID | Text |
| stored preview width | Integer |
| stored preview height | Integer |
| stored at | Timestamp |

### Ad insights country

TikTok ad-level performance by country.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| campaign ID | Text |
| adgroup ID | Text |
| ad ID | Text |
| country code | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| reach | Integer |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| frequency | Number |
| conversions reported | True/false |
| conversions | Integer |
| cost per conversion | Number |
| real time conversions | Integer |

### Ad demographic insights weekly

API-deduped TikTok ad-week delivery by age and gender.

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| ad ID | Text |
| ad name | Text |
| week start date | Date |
| week end date | Date |
| age | Text |
| gender | Text |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |

### Ad placement insights weekly

API-deduped TikTok ad-week delivery by publisher placement.

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| ad ID | Text |
| ad name | Text |
| week start date | Date |
| week end date | Date |
| publisher platform | Text |
| platform position | Text |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |

### Ad device insights weekly

API-deduped TikTok ad-week delivery by device platform.

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| account name | Text |
| campaign ID | Text |
| campaign name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| ad ID | Text |
| ad name | Text |
| week start date | Date |
| week end date | Date |
| device platform | Text |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |

### Ad demographic insights daily

TikTok ad-day delivery by age and gender.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| campaign ID | Text |
| adgroup ID | Text |
| ad ID | Text |
| age | Text |
| gender | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| reach | Integer |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| frequency | Number |
| conversions reported | True/false |
| conversions | Integer |
| cost per conversion | Number |
| real time conversions | Integer |

### Ad placement insights daily

TikTok ad-day delivery by placement.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| campaign ID | Text |
| adgroup ID | Text |
| ad ID | Text |
| publisher platform | Text |
| platform position | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| reach | Integer |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| frequency | Number |
| conversions reported | True/false |
| conversions | Integer |
| cost per conversion | Number |
| real time conversions | Integer |

### Ad device insights daily

TikTok ad-day delivery by device platform.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| campaign ID | Text |
| adgroup ID | Text |
| ad ID | Text |
| device platform | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| reach | Integer |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| frequency | Number |
| conversions reported | True/false |
| conversions | Integer |
| cost per conversion | Number |
| real time conversions | Integer |

### Ad insights dma

TikTok ad-level performance by DMA (US only).

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| campaign ID | Text |
| adgroup ID | Text |
| ad ID | Text |
| dma ID | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| reach | Integer |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| frequency | Number |
| conversions reported | True/false |
| conversions | Integer |
| cost per conversion | Number |
| real time conversions | Integer |

### Ad insights province

TikTok ad-level performance by province/state/region.

| Field | Type |
| --- | --- |
| date | Date |
| advertiser ID | Text |
| account ID | Text |
| campaign ID | Text |
| adgroup ID | Text |
| ad ID | Text |
| province ID | Text |
| spend | Number |
| impressions | Integer |
| clicks | Integer |
| reach | Integer |
| CTR | Number |
| CPC | Number |
| CPM | Number |
| frequency | Number |
| conversions reported | True/false |
| conversions | Integer |
| cost per conversion | Number |
| real time conversions | Integer |

### Account insights weekly

Advertiser-grain weekly performance with API-deduped reach.

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| account name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |

### Campaign insights weekly

Campaign-grain weekly performance with API-deduped reach.

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| campaign ID | Text |
| campaign name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |

### Ad insights weekly

Ad-grain weekly performance with API-deduped reach.

| Field | Type |
| --- | --- |
| account ID | Text |
| advertiser ID | Text |
| campaign ID | Text |
| campaign name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| ad ID | Text |
| ad name | Text |
| week start date | Date |
| week end date | Date |
| impressions | Integer |
| spend | Number |
| clicks | Integer |
| reach | Integer |
| frequency | Number |

### Ad insights age gender

TikTok ad performance by age and gender.

| Field | Type |
| --- | --- |
| account ID | Text |
| ad ID | Text |
| ad name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| advertiser ID | Text |
| age | Text |
| campaign ID | Text |
| campaign name | Text |
| clicks | Text |
| CPC | Text |
| CPM | Text |
| CTR | Text |
| date | Date |
| frequency | Text |
| gender | Text |
| impressions | Text |
| loaded at | Text |
| reach | Text |
| spend | Text |
| stat time day | Text |

### Ad insights device

TikTok ad performance by device platform.

| Field | Type |
| --- | --- |
| account ID | Text |
| ad ID | Text |
| ad name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| advertiser ID | Text |
| campaign ID | Text |
| campaign name | Text |
| clicks | Text |
| CPC | Text |
| CPM | Text |
| CTR | Text |
| date | Date |
| frequency | Text |
| impressions | Text |
| loaded at | Text |
| reach | Text |
| spend | Text |
| stat time day | Text |

### Ad insights platform

TikTok ad performance by platform.

| Field | Type |
| --- | --- |
| account ID | Text |
| ad ID | Text |
| ad name | Text |
| adgroup ID | Text |
| adgroup name | Text |
| advertiser ID | Text |
| campaign ID | Text |
| campaign name | Text |
| clicks | Text |
| CPC | Text |
| CPM | Text |
| CTR | Text |
| date | Date |
| frequency | Text |
| impressions | Text |
| loaded at | Text |
| reach | Text |
| spend | Text |
| stat time day | Text |
