This guide covers the basic functionality of the Supermetrics TikTok Ads connector, and gives examples of how to set up a query for Google Sheets, Data Studio, and Excel.
Before you begin
To connect Supermetrics to TikTok, you need:
- Ad account Analyst user role access. Learn how to manage permissions in TikTok Business Center.
Available fields
Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the data source.
- Field label is the name that appears in the sidebar.
- Metrics can be found under type - “met”.
- Dimensions can be found under type - “dim” .
Main features
- Fetches all the main advertising metrics: impressions, clicks, CTR, cost, CPC, CPM, reach, conversions, conversion rates, CPA, and more.
- Splits the data by campaign, ad group, ad, or by time. It also supports hourly granularity.
- Inspects results by targeting demographics: location, language, age, gender, device, interest, and more.
- Fetches detailed conversion data for all the different in-app events or page events.
Instructions
- Authenticate the data source in Google Sheets.
- Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
- Select Metrics.
- Select Split by Dimensions. You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
- Click Get Data to Table to create your query and pull your data.
Advanced options for Google Sheets
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query.
- Replace blank metric values with zeros.
- Combine new results with old.
- Format results for Data Studio (to import data from Google Sheets to Data Studio).
- No header row.
- Highlight values with colours (green, red, etc.).
- Advanced settings.
- Authenticate the data source in Data Studio.
- Under Dimension, select Dimensions.
- Under Metric, select Metrics.
- Select how to sort the data.
- Select the Date range from the auto or custom options. If you choose a custom date range, click the arrow on the top-right hand side. Under a specific period, select a Start Date and End Date.
Advanced options for Data Studio
You can filter your data by selecting the field, condition, and value to filter by. Learn more about using filters.
- Authenticate the data source in Excel.
- Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
- Select Metrics.
- Select Split by Dimensions. You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
- Click Get data to create your query and pull your data.
Advanced options for Excel
- You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
- Under Options, you can add additional features to your query. Learn more about Supermetrics advanced settings in Excel.
Explore our guides to set up data transfers to various destinations.
- Set up BigQuery
- Set up data warehouse and cloud storage products (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- Set up the Supermetrics API
Troubleshooting
- We support only campaigns that use auction as buying type. Reservation ads are not supported at the moment.
- If you see an error about metrics and dimensions not fetching together, or fields being incompatible, follow these steps to fix the issue.
- If you see errors relating to quotas, or “daily query quotas”, read this guide.