TikTok Ads Data Connector User Guide

TikTok Ads Data Connector User Guide

The following article is a guide to automating reports with your TikTok Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your TikTok Ads reports. To begin creating reports with your TikTok Ads connector, you will need at least one TikTok Ads account as well as access to Looker Studio or Google Sheets.

Available Data 

  1. Key Performance Indicators - Account balance, active campaigns, active ad groups, active ads, cost, CPC, CPA, impressions, CTR, clicks, conversions, and CPM.
  2. Campaigns - Name, status, budget, total cost, CPC, CPM, impressions, clicks, CTR, conversions, CPA, result, cost per result, and result rate.
  3. Ad Groups - Name, status, budget, bid, start date, end date, total cost, CPC, CPM, impressions, clicks, CTR, conversions, CPA, result, cost per result, and result rate.
  4. Ads - Image, ad name, cost, CPC, CPM, impressions, clicks, CTR, conversions, CPA, result, cost per result, and result rate.
  5. Demographics - Clicks by age group and gender.
  6. Placement - Where the ad was shown.
  7. Complete List of Fields.

API Limitations

  1. Paid Metrics - Paid metrics such as Paid Likes, Paid Comments, and Paid Shares are not currently available in the API.
  2. Organic Data - TikTok does not currently offer an API with organic data. Only ads data is available at this time.
  3. Custom Fields - Custom fields are not available.
  4. Deleted Campaigns - Data from deleted campaigns is not available. You may be able to see your deleted campaign data in TikTok's native reports, but this data will not be available via the API.
  5. Images and Image IDs - An image will only be returned for ads that are images. Other non-image types of ads, such as videos, will not return an image or image ids.

Adjust Time Zone

TikTok Ads' API defaults to UTC. Use the time zone selector in your Hub to adjust the time zone for your main account to your local time.  Sub-accounts cannot be adjusted individually.
Data gathered before the time zone adjustment will remain fixed in the previous time zone setting.




Connection Requirements

At least Admin level access is required for a successful connection. To grant Admin access to a user, go to TikTok Business Center and click on the Users tab. Open the Members section and click Invite member. Under Access Settings, select Admin.



Cost Per Follow

Cost Per Follow is not an included field in TikTok's API, but it is easy to create a calculated field to see this information.

Looker Studio

Open the Resource menu and go to Manage added data sources.



Click on the icon to open the TikTok Ads data source.


Click Add a field and choose Add calculated field.





Give the new field a name like Cost Per Follow. Use the formula SUM(Total Cost)/SUM(Follows). Click Save.



Go back to your dashboard and add a Scorecard. Choose Cost Per Follow as a field and set it to use your country's currency.



Google Sheets or Excel

Select Total Cost and Follows for your metrics.



Select the cell in which you wish to display Cost Per Follow and create a formula with the cell designation for Total Cost divided by the cell designation for Follows.



Backfilling

Power My Analytics will initially backfill 13 months of data when you first create a report. Run a manual backfill from your Hub to get up to 2 years of data.

Troubleshooting

Follow the instructions in our Basic Troubleshooting guide to get your reports working again.



    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Microsoft Ads Data Connector User Guide

        The following article is a guide to automating reports with your Microsoft Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Microsoft Ads reports. To begin ...

      • Instagram Ads Data Connector User Guide

        The following article is a guide for automating reports with your Instagram Ads connector. It includes metrics available and instructions for how to connect, use, and backfill your Instagram Ads data. To create an Instagram Ads report, you will need ...

      • Twitter Ads Data Connector User Guide

        The following article is a guide to automating reports with your Twitter Ads connector. It includes information on available data as well as tips on how to get the most out of your Twitter Ads reports. To begin creating reports with your Twitter Ads ...

      • Pinterest Ads Data Connector User Guide

        The following article is a guide to automating reports with your Pinterest Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Pinterest Ads reports. To begin ...

      • Quora Ads Data Connector User Guide

        The following article is a guide to automating reports with your Quora Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Quora Ads reports. To begin creating ...