TikTok Ads06:00
Written to 
fs_spend_by_campaign
TikTok Ads to BigQuery
Spend, reach and conversions at any level, in your own dataset. Google has no TikTok connector of its own, so this is the short way round.
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
TikTok AdsTikTok Ads06:01
Written to fs_ad_group_reach
TikTok Ads06:02
Written to fs_daily_conversions
What lands in BigQuery
- Four levels: ad account, campaign, ad group and ad. Deleted ones are included, so past spend doesn't vanish when you tidy up.
- Spend, impressions, clicks, reach and conversions, with their costs.
- Include Day and history builds up.
- Up to 50,000 rows a report.
Click Connect TikTok on the Sources page of your Fresh Sheets account, sign in on TikTok's page, and choose the ad accounts to share.
Which plans send to BigQuery
Pro and Max, and the free 30 days. Sending to BigQuery uses no extra refreshes: one run counts once, wherever it lands.
FAQ
Questions
Does the connection expire?
No. It lasts until you remove it, and removing it asks TikTok to revoke it.
Can it change my campaigns?
No. Fresh Sheets asks only for reporting and ad account access, and our code only ever reads.
Other sources to BigQuery
Analytics
Send your TikTok Ads reports to BigQuery
BigQuery is included in the free 30 days, then on Pro and Max.