TikTok Ads reports in Google Sheets, refreshed on a schedule
Your TikTok Ads spend and results, current before you open the file.
30 days of Plus, free from sign-up. No card needed.
What you can pull from TikTok Ads
TikTok Ads to Google Sheets works one level at a time: Ad account, Campaign, Ad group or Ad. Each row is one of them, with the fields you choose, by day or as a total over your date range.
Names and IDs are available down to the level you choose. Money is in your ad account's currency, and days are in its time zone.
Columns TikTok Ads writes to Google Sheets
Row one holds the column names. Money shows its currency symbol when a report has only one currency.
| Column | Format | Available at |
|---|---|---|
| Day | Date | Every level |
| Ad account | Text | Every level |
| Ad account ID | Text | Every level |
| Campaign | Text | Campaign, Ad group, Ad |
| Campaign ID | Text | Campaign, Ad group, Ad |
| Ad group | Text | Ad group, Ad |
| Ad group ID | Text | Ad group, Ad |
| Ad | Text | Ad |
| Ad ID | Text | Ad |
| Currency | Text | Every level |
| Impressions | Whole number | Every level |
| Clicks (destination) | Whole number | Every level |
| Reach | Whole number | Every level |
| Conversions | Number | Every level |
| Spend | Money | Every level |
| CPC (destination) | Money | Every level |
| Cost per thousand impressions | Money | Every level |
| Cost per conversion | Money | Every level |
Yesterday's spend, already in the tab
TikTok Ads, written to Campaign spend
- Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.
Three things to choose, once
- On the Sources page, choose Connect TikTok, sign in on TikTok's own page and pick the ad accounts Fresh Sheets can read.
- Pick a level, the fields you want and a date range.
- Choose the tab, worksheet or table it writes to, and how often it refreshes.
Try it with your own TikTok Ads data.
Other ways to do it
TikTok Ads Manager can export a report as a file, and send one by email on a schedule.
Source: TikTok Ads Help: Create and manage reports; TikTok Ads Help: Scheduled reports
Fresh Sheets writes the figures straight into your tab instead.
What this doesn't cover
TikTok organic posts, TikTok Shop and lead generation forms aren't included.
Guides that use TikTok Ads
What it can see, and what it cannot
You connect TikTok by signing in on TikTok's own page and choosing which ad accounts Fresh Sheets can read. The app Fresh Sheets signs in with asks TikTok for ad account information and reporting only.
Our code only ever reads from TikTok. Besides read requests, it sends TikTok only the request that completes your sign-in and, when you remove the connection or delete your account, the request that ends Fresh Sheets' access. It refuses anything else before the request is sent, and never creates, edits or pauses a campaign, an ad group or an ad.
The access TikTok grants is stored encrypted and is never shown to anyone. You can remove it at any time on the Sources page. Removing it asks TikTok to end Fresh Sheets' access, stops the reports that read through it, and leaves what they already wrote in your spreadsheets. You can also end it in your TikTok for Business settings.
Fresh Sheets never changes anything you did not ask it to.
Your data is never sold and never used to train anything.
How we handle your dataStart on Plus, and decide later
Then one report keeps refreshing weekly.
How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
Questions
Can you export TikTok Ads data to Google Sheets automatically?
Yes. Fresh Sheets writes your TikTok Ads results into a spreadsheet you already have, in a tab you choose, on a schedule, without the file being open.
Which campaigns are included?
Every campaign, ad group or ad TikTok reports for the date range. Fresh Sheets asks TikTok to include ones you have since deleted, so tidying up your account does not remove last month's spend from the report.
What currency are the figures in?
Your ad account's own currency. Add the Currency field to show which one in the tab. Days are in your ad account's time zone.
How often can it refresh?
Daily on Plus, every 6 hours on Pro and every hour on Max. On Free, one report refreshes weekly.
How many rows can a report have?
Up to 50,000 rows a run. A report that would return more doesn't run, and tells you how to bring it under.
Does the connection expire?
No. It lasts until you remove it here or revoke it in TikTok. Removing it here asks TikTok to revoke it too.
Source: Obtain a long-term access token, TikTok API for Business
How long a date range can a report cover?
A daily report can cover long ranges, because it's fetched in 30-day pieces. A report of totals can cover up to 365 days.
Does it change anything in TikTok Ads?
No. Fresh Sheets only reads from TikTok. It never creates, edits or pauses a campaign, an ad group or an ad.
Set up your first TikTok Ads report
Connect TikTok, pick a level, your fields and a tab, and leave it running.
30 days of Plus, free from sign-up. No card needed.