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
The connector:
- 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.
- Show all time value values.
- 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.
- Replace blank metric values with zeros.
- No header row.
- Show all time values.
- Advanced settings.
Explore our guides to set up data transfers to various destinations.
Set up Data Warehouse and Cloud Storage products (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
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.