LupyAi

TikTok Ads — data fields

Spend, reach, video and conversion metrics for TikTok ad campaigns. Every field id you can pass to fields= in the API, Looker Studio, exports and AI chats. Shared ids line up across sources so they blend.

All sources Meta Ads (Facebook & Instagram)Google AdsTikTok AdsLinkedIn AdsGoogle Analytics 4Google Search ConsoleFacebook Pages (organic)Instagram (organic)YouTube AnalyticsShopifyWooCommerceKlaviyo
Field idNameSectionKindTypeDescription
account_id Account ID dimension string
account_name Account name dimension string
ad_id Ad ID dimension string
ad_name Ad name dimension string
adgroup_id Ad group ID dimension string
adgroup_name Ad group name dimension string
campaign Campaign name dimension string
campaign_id Campaign ID dimension string
clicks Clicks metric integer
comments Comments metric integer
conversions Conversions metric float
country Country code dimension string
cpc CPC metric currency
cpm CPM metric currency
ctr CTR (%) metric percent
datasource Data source dimension string Connector the row came from
date Date dimension date
follows Follows metric integer
impressions Impressions metric integer
likes Likes metric integer
objective Objective dimension string
purchases Complete payments metric float
reach Reach metric integer
revenue Purchase value metric currency Derived from TikTok's complete_payment_roas × spend
shares Shares metric integer
spend Spend metric currency
video_completions Video completions metric integer
video_views Video views metric integer
video_views_2s 2-second views metric integer

Date parts

Available on any source with date. Metrics are re-aggregated to the period.

weekWeek (starting Monday)year_weekYear-week (2026-W42)monthMonth (2026-10)quarterQuarter (2026-Q4)yearYearday_of_weekDay of week (Mon..Sun)

Calculated metrics

Computed after aggregation wherever the inputs exist.

roasrevenue / nullif(spend, 0)cpaspend / nullif(conversions, 0)conversion_rateconversions / nullif(clicks, 0) * 100aovrevenue / nullif(orders, 0)

Filters

Pass JSON in filters=:

[["spend","gt",100],"and",
 ["campaign","contains","brand"]]

Operators: eq, neq, gt, gte, lt, lte, contains, ncontains, null, notnull, in.