Ultimate Guide to automate your TikTok Ads report

By November 23, 2022January 4th, 20242 Comments3 min read

There 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 the data pulling from TikTok Ads for free by using our template!

In this article, we will also share what you need to use our template, things to look out for, and what the report will look like.

Prerequisites before starting pulling TikTok Ads data

To use TikTok API to pull data for your TikTok Ads, 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 TikTok app is approved

After the app is approved, you will see your app id and secret.

TikTok App ID and secret key page The next thing you should get from the app is an authorization code (auth code).
Here is how you can get the auth code:

  1. First, go to
  2. Choose your TikTok app.

    TikTok for business developers API page
  3. Now you will see app information including app id and secret.
  4. Then you will need to copy the URL from Advertiser authorization URL.

    TikTok for Business Development Marketyze Business Manager

  5. You will need to open the copied URL in a new browser’s tab. It will redirect you to the permissions page and you will need to go through a verification process.
  6. 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!

    Marketyze Auth code from URL bar

Please keep in mind that the auth code is for 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 TikTok Ads access token!

  1. Make a copy of this Google Sheet

    Make a copy of the Google Sheets to extract the TikTok Ads data template created by Marketyze.
  2. In the tab name “(1) Generate Token”, fill in your TikTok app id, auth code, and app secret.

    Insert the necessary information into the Google Sheets to extract TikTok Ads data created by Marketyze.
  3. Then click on the “Generate Token” button

    Click on generate token on the Google Sheets to extract TikTok Ads data created by Marketyze.

  4. Once it’s done, you will see the TikTok access token with run status and time

Access token and run time updated on the Google Sheets to extract TikTok Ads data created by Marketyze.

STAGE 2: Get your TikTok Ads report!

  1. In the tab name “(2) Configure”, fill in your TikTok Ads report name, ad account id, data level, dimensions, metrics, and date range.

    Configure the Google Sheets to extract TikTok Ads data created by Marketyze.
  2. Click on the “Run Report” button. This might take a long while, perhaps around 3-5 minutes

    Click on Run Report on the Google Sheets to extract TikTok Ads data created by Marketyze.

  3. Once done, you will see the run status and the new tab created with a Tiktok_ ‘Your report Name’.

    Your report is ready! Below is an example of a TikTok Ads report generated.

Sample report generated by the Google Sheets to extract TikTok Ads data created by Marketyze.

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 pulled from your TikTok Ads.

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:


Leave a Reply

we upgraded! 🚀

This will close in 0 seconds


Our website uses cookies and other tracking technologies to improve your browsing experience as set in our Privacy policy.

Privacy Preferences

You can turn your cookie settings on and off. Cookies of each type are available on request, except for necessary cookies.

Allow All
Manage Consent Preferences
  • Necessary cookies
    Always Active

    These cookies are strictly necessary for the operation of our website. You cannot disable these cookies.