How to connect TikTok Ads to Google Data Studio (2022)

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

This is a step-by-step guide to help you set up your TikTok Ads reports on Google Data Studio. Discover how to automate your PPC, video, engagement, and e-commerce reports. 

It’s also an in-depth guide to understand all the metrics TikTok Ads offers to analyze and optimize your campaigns. 

In a nutshell, to connect TikTok Ads to Google Data Studio, you should use a connector, like Porter, that you can access on their site or the Google Data Studio gallery. Then you should sign in with the Google account you use for Data Studio and your TikTok Ads account. Finally, choose the ad accounts you want to report and will automatically generate your first report in about a minute. 

TikTok Ads connector for Google Data Studio

First, we’ll learn how to import TikTok Ads data to Google Data Studio automatically through a connector. 

For this tutorial, of course, we will use our Porter Metrics TikToK Ads connector. It is self-promotion, but will also mention why we made it the best solution available. 

You can access the TikTok Ads connector in three ways: 

If you access through our website or link, you will download our default report template to speed up your reporting; if you access through the connector gallery, you will start with a blank report. 

Signing up with Google and TikTok

Once on the connector, signup with your Gmail account to create your Porter account. We only take your email and not any other personal information. 

Tik Tok Ads Connector

Then, you should sign in with your personal TikTok account so Porter can retrieve all the Tik Tok Ads accounts associated with that profile. 

Account authorization Tik Tok Ads

Performance Tik Tok Ads report

About privacy: we only get your emails to create users. We don’t bring any other information or share it (on purpose) with third parties. 

Here’s our video tutorial on connecting your data to Google Data Studio

Choosing your Tik Tok Ads accounts

Once signed in, you will be allowed to bring one or more Tik Tok Ads accounts to your Google Data Studio report. 

Allow account access Tik Tok Ads

We made it possible to bring multiple (or all) Tik Tok Ads accounts in a single data source so you could combine metrics like ad spend and conversion to have a total of all your paid efforts on Tik Tok Ads. 

Combine metrics

Just click on Connect in the top right corner of the page. 

In the next view, you will see all the fields available on our Tik Tok Ads connector for Google Data Studio. 

Parameters to admin

The Tik Tok Ads connector for Google Data Studio, by Porter, is the most complete one, offering 656 fields available (so far) with all your campaigns, accounts, posts, video data and much more. We committed to bring all the fields that the API allowed us. 

Now click on Connect on the top right corner to generate our default report template. 

If you successfully bring Tik Tok Ads data to your Google Data Studio report, you’re officially starting a 14-days free trial. You may want to check out our friendly pricing here

Again: If you started using the connector from the link we provided, you’ll get our report template; if you did it from the Data Studio connector gallery, you will load a blank report. 

The report template is meant to save you time, but you’re free to start reporting from scratch. 

So far, we have already created our first Tik Tok Ads report on Google Data Studio, but we can play around a bit more with the connector to see what it offers. 

Here, you can choose three ways for reporting:

  • Create your Google Data Studio report from scratch (read or watch our tutorials)
  • Download our Tik Tok Ads reports templates for Data Studio
  • Browse our default report template 

Before playing around with the charts, we’ll explain the Tik Tok Ads metrics and dimensions. 

Understanding Tik Tok Ads metrics and dimensions 

We can set up our Tik Tok Ads report on Google Data Studio by navigating all its fields, metrics, and dimensions available. 

The way I see Google Data Studio is that it’s a canvas where you drop any type of charts, combining any sort of metrics and dimensions. 

The metrics are the numerical values, like clicks, spent, and conversions; dimensions are how you break down the metrics, like by campaign, by country, by creative, etc. 

The Tik Tok Ads connector is super flexible and lets you combine them however you want. 

If it’s your very first time with Data Studio, I would recommend you to check this resource to create your first Google Data Studio report

To help you navigate through the Tik Tok Ads metrics, I would recommend watching this tutorial on creating charts and graphs

Advertiser account dimensions

The account-related dimensions on the Tik Tok Ads connector have fixed values; they don’t change over time. They are:

  • Advertiser name
  • Advertiser currency
  • Advertiser address
  • Advertiser country
  • Advertiser language
  • Advertiser timezone

I just created a table within our Data Studio report to show all these advertiser related fields:

Advertiser related files

I find this table useful to understand which ad accounts I’m reporting. If I bring multiple ad accounts to this connection, I could have a summary view of all my accounts performance in a single table:

Summary view all accounts

If you manage multiple Tik Tok Ads accounts this kind of table would give you an overall performance. 

Tik Tok Ads performance reports

Tik Tok Ads performance metrics may be the most popular and relevant in the platform, as they bring fields such as: 

  • Results
  • Result (SKAN): SKAN refers to an attribution model introduced by Apple in response to the limitation of iOS14. As such, you can report your Tik Tok Ads conversion in a standard way and with SKAN, which will give different values. 
  • Secondary goal results
  • Result rate
  • Secondary goal result rate
  • Spend
  • Clicks
  • CPM

If you look at our Tik Tok Ads connector fields, you’ll often find all the conversion-related metrics with a version that contains (SKAN); Tik Tok Ads will provide you conversion data in both standard way and SKAN, the Apple’s attribution model in response to iOS 14. 

Interestingly, Tik Tok Ads, unlike Facebook Ads, provides the metric “Result” which represents the number of results a campaign has, regardless of the conversion type or objective. 

Tik Tok Ads standard conversion metrics

Standard conversions, similar to Facebook Ads, refers to a way for advertisers to name or categorize their conversions. Instead of creating a conversion and adding a custom name, you could choose one of the standard options, like purchases, so you can identify the type of conversion your ads are generating. 

Tik Tok Ads offers a wide variety of standard conversions, such as: 

  • Login
  • Subscribes
  • Purchases
  • Unlock achievement
  • Start trial
  • App installs
  • Checkout
  • Conversions
  • Add to cart
  • Add billing
  • Add to payment
  • Add to wishlist
  • Complete tutorial
  • Create group
  • Join group
  • Create role
  • Launch app
  • Loan apply
  • Loan approved
  • Loan disbursement
  • Start trial
  • View content

For all these standard conversions, Tik Tok Ads also provides aggregations such us:

Unique: for example, Unique Subscribes

Cost: cost per Subscribe and cost per unique subscribe

Rate: Subscribe rate (which divides the standard conversion by impressions)

Value: you may add a value to every conversion; whenever a purchase happens, you can attribute a certain amount of money. If you add values to your conversions, you may calculate your ROAS

Also, for all standard conversions and their aggregations, you’ll also have a SKAN version. e.g. Unique Subscribes (SKAN), Cost per subscribe (SKAN), etc. 

Tik Tok Ads campaigns dimensions

These fields let you break down your ads performance by campaigns, groups, and ads, so you can see which of them performs the best. 

The campaign-level fields include: 

  • Campaign name
  • Campaign ID
  • Campaign budget (metric)
  • Campaign creation time
  • Campaign modify time
  • Campaign objective type
  • Campaign operation status

Generally, I use them in tables along with performance metrics like clicks, impressions, CTR, and conversions, but other chart types like bar charts, pie charts, and time series would work well, too. 

Campaigns dimensions

Tik Tok ad group dimensions

Tik Tok Ads campaign structure is pretty similar to Google or Facebook: Campaigns, groups, and ads. 

For this example, we’ll explore  campaign ad group reports, which brings dimensions such as:

  • Ad group name
  • Ad group ID
  • Ad group status

Tik Tok Ads ad-level reports

When getting data from your ads, you can bring dimensions such as:

  • Ad name
  • Ad ID
  • Ad status
  • Ad text

Tik Tok Ads video metrics

Video is the main format of Tik Tok. On ads, you can display these fields: 

  • Video thumbnail (displays an image)
  • Video ID
  • Average video plays
  • Average video plays per user
  • Video play actions
  • Video views played at 100%
  • Video views played at 75%
  • Video views played at 50%
  • Video views played at 25%
  • 2-seconds video plays
  • 6-seconds video plays

With these fields you can display tables by breaking down your videos by ID and thumbnail. 

You can also report video funnels to know when people stop watching your videos. 

Tik Tok Ads Audience fields

Tik Tok Ads offers some demographics to break down your metrics, such as:

  • Age
  • Platform
  • Country
  • Gender
  • Industry

Setting up the Tik Tok Ads report on Data Studio

Creating charts 

Once you understand the Tik Tok Ads metrics, it’s fine to create your first charts if you haven’t. 

We prepared a video tutorial on how to create your first charts and graphs on Google Data Studio:

https://www.youtube.com/watch?v=BVQjmkWjeMY&t=1s

Follow these steps to create your first charts: 

  • Open the Google Data Studio report on the edit mode.
  • Go to the menu and select Insert or Add a Chart. 
  • Choose a chart type (scorecard, time series, tables, pie charts, and bar charts are the most common).
  • Make sure the chart is linked to the Tik Tok Ads connector.
  • Depending on the chart, you should choose a combination of metrics and dimensions. A good one could be visualizing spend as a scorecard and over time by choosing Date as the the time dimension.
  • Set to compare the data against last period.

Filters and controls

Filters and controls on Google Data Studio make your reports interactive and clean your data. 

A good use case for filters and controls withTik Tok Ads data may be filtering your campaign objectives or campaign names so you can analyze performance metrics just for some of them, like excluding the campaigns that were meant for engagement rather than lead generation. 

We prepared this tutorial on how to create filters and controls on Google Data Studio

Custom formulas

When it comes to formulas, think of Google Data Studio like Google Sheets: you can calculate any sort of metrics with countless math functions. 

However, the most common formula you may want could be conversion rates, which is just dividing a metric with another. 

Our connector brings a default conversion rate metric that divides conversions/clicks to landing pages. 

Watch this tutorial to learn to create custom formulas on Data Studio

Case statements

As you set formulas to create metrics, you can use case statements to create new dimensions. 

With Tik Tok Ads data, you may want to group your campaigns by brands or products you’re promoting if in their campaigns name there are characters to let you do so. 

Here are our tutorials on case statements and regular expressions

Blending Tik Tok Ads data with Google and Facebook Ads

A great use case of the Tik Tok Ads connector for Google Data Studio is combining it with other connectors, such as Facebook Ads and Google Ads. 

With them, you may create a cross-channel ads report to visualize your total ad spend and conversions across your paid channels. 

You may want to follow this video tutorial on blending data on Google Data Studio

Follow these steps to combine your data

  • Open the Google Data Studio report on the edit mode.
  • Click on Manage added data sources and make sure to connect your Facebook Ads, Google Ads data (or any other connector you might use). 
  • Create a table for each connector whose dimension is equivalent to the date and the metrics are conversions and ad spend (or any metric you may want to compare). 
  • Make sure the tables are beside each other on the same page. 
  • Select the three tables and do a right-click. 
  • Select Blend data.
  • Google Data Studio will automatically create a table combining the metrics of the three connectors. 
  • To verify the data was correctly blended, go to edit the blended data source and make sure that the dimensions equivalent to the date work as the join keys. For Facebook Ads and Tik Tok Ads they’re both called Date; for Google Ads it’s Day. 

Customizing your report

We prepared a video tutorial showing you ways to customize your Tik Tok Ads reports (and even making them whitelabel). 

https://www.youtube.com/watch?v=MHrdmSZfjRk

Sharing your Tik Tok Ads report

Google Data Studio, such as other Google products, have great collaboration and sharing features. 

You can: 

  • Choose the Gmail/G Suite users who can access your reports as editors or viewers 
  • Schedule email deliveries
  • Share a link to access the report
  • Download a PDF version
  • Embedding the report on other website

We covered all of these in our tutorial How to Share your Google Data Studio reports.

Tik Tok Ads report templates on Google Data Studio

It’s ok if you don’t want to set up your Data Studio reports. We prepared a set of Tik Tok Ads Google Data Studio report templates covering all the possible use cases so you don’t have to. 

We have a tutorial on how to use Data Studio report templates, too. 

A common question is how you can add these templates to your current reports. You just need to select all the elements of your Data Studio report, copy, and paste them into your other reports. 

 

More posts

Instagram Insights – FREE Report Template

Download this free report template and pull your Instagram page insights. Deliver page impressions, followers, likes, profile trends, demographic, and post insights