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:
- By using this link.
- By using our Make a free report call to action on our website
- Or by searching for it on the Google Data Studio connectors gallery by typing “Porter”.
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.
Then, you should sign in with your personal TikTok account so Porter can retrieve all the Tik Tok Ads accounts associated with that profile.
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.
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.
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.
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:
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:
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:
- 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
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:
- Unlock achievement
- Start trial
- App installs
- 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.
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:
Setting up the Tik Tok Ads report on Data Studio
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:
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.
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.
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.
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).
Sharing your Tik Tok Ads report
Google Data Studio, such as other Google products, have great collaboration and sharing features.
- 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.