
Quick Guide to automate your TikTok Ads report with Google Sheets (with template!)
By Kanrawee Sae HongAnalyticsNo CommentsThere are many tools out there that allow you to pull data easily from your TikTok Ads accounts into a Google Spreadsheet for further processing. However, they usually come at a monthly cost. Therefore, we would like to share a solution to automate this data pulling for free by using our template!
In this article, we will also share what you need in order to use our template, things to look out for, and what the report will look like.
PREREQUISITES BEFORE STARTING
In order to use Tiktok API to pull data, you will first need to register as a developer here and create an app.
For the expected outcome, please refer here to see support dimensions and metrics.
(Keep in mind that there can only be one ID dimension and one time dimension in each request. For example, you can only have campaign_id with stat_time_day but not with the adgroup_id or ad_id ID dimensions)
Wait until your app is approved
After the app is approved, you will see your app id and secret.
The next thing you should get from the app is an authorization code (auth code).
Here is how you can get the auth code:
- First, go to https://ads.tiktok.com/marketing_api/apps/
- Choose your app
- Now you will see app information including app id and secret
- Then you will need to copy the URL from Advertiser authorization URL
- You will need to open the copied URL in a new browser’s tab. It will redirect you to permissions page and you will need to go through verification process
- Once you’ve verified, you will again be redirected to whatever you had entered as the app’s Advertiser Redirect URL
Here you will be able to see your auth code in the URL. See our Marketyze example below!
Please keep in mind that the auth code is for a one time use only. If you need to generate a new auth code, you will need to generate a new token as well.
Now you’re ready to get your TikTok Ads data!
STAGE 1: Generate your access token!
- Make a copy of this Google Sheet
- In the tab name “(1) Generate Token”, fill in your app id, auth code, and app secret.
- Then click on the “Generate Token” button
- Once it’s done, you will see the access token with run status and time
STAGE 2: Get your report!
- In the tab name “(2) Configure”, fill in your report name, ad account id, data level, dimensions, metrics, and date range.
- Click on the “Run Report” button. This might take a long while, perhaps around 3-5 minutes
- Once done, you will see the run status and the new tab created with a Tiktok_ prefix along with your defined report name
Your report is ready! Below an example
If you want to run the report again, go back to the sheet and click the “Run report” button in the sheet “(2) Configure.” There is no need to recreate the token. Please keep in mind however, that re-running the report will override — and not merge — the previous data.
We’d love to hear from you if, and how you are using this template. If you need any help, please feel free to contact us via email: analytics@marketyze.io
