Integrations

TikTok Ads datasets and fields

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

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.

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.

FieldType
account IDText
advertiser IDText
account nameText
account statusText
account currencyText
account timezoneText
timezone rawText
country codeText
languageText
industryText
account roleText
account typeText
owner business center IDText
source created atTimestamp
metadata provenanceText

Pixels#

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

FieldType
advertiser IDText
account IDText
account nameText
snapshot dateDate
pixel IDText
pixel nameText
pixel codeText
pixel categoryText
pixel setup modeText
create timeTimestamp
activity statusText
enable expanded data sharingTrue/false
enable first party cookiesTrue/false
advanced matching emailTrue/false
advanced matching phone numberTrue/false
automatic advanced matching fieldsText
asset ownershipText
eventsText
event countInteger

Pixel event stats daily#

Daily pixel event statistics.

FieldType
dateDate
advertiser IDText
account IDText
pixel IDText
event typeText
countNumber

Ad insights#

Daily ad-level performance.

FieldType
dateDate
advertiser IDText
account IDText
account nameText
account currencyText
account timezoneText
campaign IDText
campaign nameText
adgroup IDText
adgroup nameText
ad IDText
ad nameText
impressionsInteger
clicksInteger
spendNumber
reachInteger
CPCNumber
CPMNumber
CTRNumber
frequencyNumber
conversionsInteger
cost per conversionNumber
conversion rateNumber
real time conversionsInteger
real time cost per conversionNumber
real time conversion rateNumber
resultsNumber
cost per resultNumber
result rateNumber
real time resultsNumber
real time cost per resultNumber
real time result rateNumber
total purchase valueNumber
video play actionsInteger
video watched 2sInteger
video watched 6sInteger
video views p25Integer
video views p50Integer
video views p75Integer
video views p100Integer
average video playNumber
profile visitsInteger
followsInteger
likesInteger
commentsInteger
sharesInteger

Ad conversion events#

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

FieldType
dateDate
advertiser IDText
account IDText
account nameText
campaign IDText
campaign nameText
adgroup IDText
adgroup nameText
ad IDText
ad nameText
custom event typeText
custom page eventsNumber

Conversion report coverage daily#

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

FieldType
dateDate
account IDText
report nameText
requested grainText
reported grainText
report statusText
row countInteger
is partialTrue/false

Campaigns#

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

FieldType
account IDText
account nameText
advertiser IDText
campaign IDText
campaign nameText
objectiveText
operation statusText
secondary statusText
budgetNumber
budget modeText
schedule typeText
schedule start timeTimestamp
schedule end timeTimestamp
create timeTimestamp
modify timeTimestamp

Adgroups#

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

FieldType
account IDText
account nameText
advertiser IDText
adgroup IDText
adgroup nameText
campaign IDText
campaign nameText
operation statusText
secondary statusText
budgetNumber
budget modeText
scheduled budgetNumber
optimization goalText
optimization eventText
bid typeText
bid priceNumber
billing eventText
pacingText
placement typeText
placements jsonText
age groups jsonText
genderText
location IDs jsonText
interest category IDs jsonText
interest keyword IDs jsonText
schedule typeText
schedule start timeTimestamp
schedule end timeTimestamp
promotion typeText
brand safety typeText
creative material modeText
is smart performance campaignTrue/false
create timeTimestamp
modify timeTimestamp

Configured target coverage#

Current completeness status for TikTok ad-group optimization-target collection.

FieldType
coverage keyText
account IDText
scope levelText
collection statusText
source entity countInteger
configured target countInteger
capability reasonText
collected atTimestamp

Ads#

TikTok Ads ad-level structure: status and hierarchy.

FieldType
account IDText
account nameText
advertiser IDText
ad IDText
ad nameText
campaign IDText
adgroup IDText
operation statusText
secondary statusText
create timeTimestamp
modify timeTimestamp

Ad creatives#

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

FieldType
ad IDText
ad nameText
advertiser IDText
account IDText
account nameText
campaign IDText
campaign nameText
adgroup IDText
adgroup nameText
ad formatText
creative typeText
image modeText
video IDText
video URLText
cover URLText
preview URLText
video durationNumber
video widthInteger
video heightInteger
image IDs jsonText
image URLs jsonText
thumbnail URLText
call to actionText
landing page URLText
display nameText
ad textText
UTM params jsonText
click tracking URLText
impression tracking URLText
identity IDText
identity typeText
page IDText
tiktok item IDText
operation statusText
secondary statusText
create timeTimestamp
modify timeTimestamp
is acoTrue/false

Ad insights material#

FieldType
dateDate
account IDText
advertiser IDText
campaign IDText
adgroup IDText
ad IDText
material typeText
material IDText
metric setText
spendNumber
impressionsInteger
clicksInteger
conversionsInteger
real time conversionsInteger
total purchase valueNumber
video play actionsInteger
video watched 2sInteger
video watched 6sInteger
video views p25Integer
video views p50Integer
video views p75Integer
single image impressionsInteger

Material assets#

FieldType
account IDText
advertiser IDText
material typeText
material IDText
video IDText
image IDText
material nameText
widthInteger
heightInteger
duration secondsNumber
cover source URLText
file signatureText
created timeTimestamp
modified timeTimestamp
resolvedTrue/false
preview statusText
stored preview pathText
stored preview asset IDText
stored preview widthInteger
stored preview heightInteger
stored atTimestamp

Ad insights country#

TikTok ad-level performance by country.

FieldType
dateDate
advertiser IDText
account IDText
campaign IDText
adgroup IDText
ad IDText
country codeText
spendNumber
impressionsInteger
clicksInteger
reachInteger
CTRNumber
CPCNumber
CPMNumber
frequencyNumber
conversions reportedTrue/false
conversionsInteger
cost per conversionNumber
real time conversionsInteger

Ad demographic insights weekly#

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

FieldType
account IDText
advertiser IDText
account nameText
campaign IDText
campaign nameText
adgroup IDText
adgroup nameText
ad IDText
ad nameText
week start dateDate
week end dateDate
ageText
genderText
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber

Ad placement insights weekly#

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

FieldType
account IDText
advertiser IDText
account nameText
campaign IDText
campaign nameText
adgroup IDText
adgroup nameText
ad IDText
ad nameText
week start dateDate
week end dateDate
publisher platformText
platform positionText
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber

Ad device insights weekly#

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

FieldType
account IDText
advertiser IDText
account nameText
campaign IDText
campaign nameText
adgroup IDText
adgroup nameText
ad IDText
ad nameText
week start dateDate
week end dateDate
device platformText
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber

Ad demographic insights daily#

TikTok ad-day delivery by age and gender.

FieldType
dateDate
advertiser IDText
account IDText
campaign IDText
adgroup IDText
ad IDText
ageText
genderText
spendNumber
impressionsInteger
clicksInteger
reachInteger
CTRNumber
CPCNumber
CPMNumber
frequencyNumber
conversions reportedTrue/false
conversionsInteger
cost per conversionNumber
real time conversionsInteger

Ad placement insights daily#

TikTok ad-day delivery by placement.

FieldType
dateDate
advertiser IDText
account IDText
campaign IDText
adgroup IDText
ad IDText
publisher platformText
platform positionText
spendNumber
impressionsInteger
clicksInteger
reachInteger
CTRNumber
CPCNumber
CPMNumber
frequencyNumber
conversions reportedTrue/false
conversionsInteger
cost per conversionNumber
real time conversionsInteger

Ad device insights daily#

TikTok ad-day delivery by device platform.

FieldType
dateDate
advertiser IDText
account IDText
campaign IDText
adgroup IDText
ad IDText
device platformText
spendNumber
impressionsInteger
clicksInteger
reachInteger
CTRNumber
CPCNumber
CPMNumber
frequencyNumber
conversions reportedTrue/false
conversionsInteger
cost per conversionNumber
real time conversionsInteger

Ad insights dma#

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

FieldType
dateDate
advertiser IDText
account IDText
campaign IDText
adgroup IDText
ad IDText
dma IDText
spendNumber
impressionsInteger
clicksInteger
reachInteger
CTRNumber
CPCNumber
CPMNumber
frequencyNumber
conversions reportedTrue/false
conversionsInteger
cost per conversionNumber
real time conversionsInteger

Ad insights province#

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

FieldType
dateDate
advertiser IDText
account IDText
campaign IDText
adgroup IDText
ad IDText
province IDText
spendNumber
impressionsInteger
clicksInteger
reachInteger
CTRNumber
CPCNumber
CPMNumber
frequencyNumber
conversions reportedTrue/false
conversionsInteger
cost per conversionNumber
real time conversionsInteger

Account insights weekly#

Advertiser-grain weekly performance with API-deduped reach.

FieldType
account IDText
advertiser IDText
account nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber

Campaign insights weekly#

Campaign-grain weekly performance with API-deduped reach.

FieldType
account IDText
advertiser IDText
campaign IDText
campaign nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber

Ad insights weekly#

Ad-grain weekly performance with API-deduped reach.

FieldType
account IDText
advertiser IDText
campaign IDText
campaign nameText
adgroup IDText
adgroup nameText
ad IDText
ad nameText
week start dateDate
week end dateDate
impressionsInteger
spendNumber
clicksInteger
reachInteger
frequencyNumber

Ad insights age gender#

TikTok ad performance by age and gender.

FieldType
account IDText
ad IDText
ad nameText
adgroup IDText
adgroup nameText
advertiser IDText
ageText
campaign IDText
campaign nameText
clicksText
CPCText
CPMText
CTRText
dateDate
frequencyText
genderText
impressionsText
loaded atText
reachText
spendText
stat time dayText

Ad insights device#

TikTok ad performance by device platform.

FieldType
account IDText
ad IDText
ad nameText
adgroup IDText
adgroup nameText
advertiser IDText
campaign IDText
campaign nameText
clicksText
CPCText
CPMText
CTRText
dateDate
frequencyText
impressionsText
loaded atText
reachText
spendText
stat time dayText

Ad insights platform#

TikTok ad performance by platform.

FieldType
account IDText
ad IDText
ad nameText
adgroup IDText
adgroup nameText
advertiser IDText
campaign IDText
campaign nameText
clicksText
CPCText
CPMText
CTRText
dateDate
frequencyText
impressionsText
loaded atText
reachText
spendText
stat time dayText