How to link TikTok Ads to Google Data Studio
By pulling your TikTok Ads data into Google Looker Studio, you can create dashboards which show how well your ads are performing and how this impacts your website and your business. But how do you do it? Let’s find out…
Google Looker Studio (formerly known as Google Data Studio) is a powerful tool which enables you to pull in data from various sources and display them in any format you want – be it in tables or various types of graph – and really drill down into your data.
By pulling TikTok Ads data into Google Looker Studio, you can see all of your insights in a user-friendly format, and create dashboards which show exactly the data that you need.You can also combine your TikTok Ads data with other sources such as Facebook Ads, Google Analytics, MailChimp or eCommerce data such as Shopify, and start to see how your TikTok Ads are helping to grow your business.
Choosing a 3rd party connector
Adding TikTok Ads as a data source in Google Looker Studio requires a 3rd party connector.
Supermetrics and Power My Analytics are two of the biggest companies making Google Looker Studio connectors, and between them enable you to pull in data from 100+ data sources.
We have a review comparing the two here. While both have their own advantages and disadvantages, Supermetrics is by far the easiest if you want to get instant access to your TikTok Ads data within Google Looker Studio without using a “data warehouse”.
Supermetrics connects directly to the TikTok Ads API and can be set up in a matter of minutes.
Supermetrics has a 14 day free trial, so you can see if it’s the right solution for your business. After that it’s just $39 USD a month for the Individual plan, which includes 1 data source (TikTok Ads being a data source), 1 user and 5 accounts per data source. If you need more data sources, you’ll need a more expensive plan.
How to Connect TikTok Ads to Google Looker Studio with a Connector
1) Sign up to Supermetrics
First, sign up to Supermetrics here. They’ve got a 14-day trial which gets you access to all of their connectors, so you can try it out and see if it’s worth the investment.
Use code ‘rusticated’ at checkout for 20% off.
2) Log into Google Looker Studio and connect your data
Once you’re all signed up, sign into your Google Looker Studio account and start a blank report.
On the ‘Add data to report’ screen, ensure you’re on the ‘Connect to data’ tab.
Then, search for ‘TikTok Ads,’ and from the ‘Partner Connectors’ list choose the ‘TikTok Ads by Supermetrics’ option with the red logo.
3) Connect Looker Studio to Supermetrics
Click ‘TikTok Ads by Supermetrics’ and you’ll get to an Authorisation screen, and a title reading “Looker Studio requires authorisation to use this community connector.”
Click the blue ‘AUTHORISE’ button and follow the instructions, which grant Supermetrics permission to fetch the data.
You will get a popup asking you to grant Supermetrics permission to use your Google account.
Once done, a second Authorisation box should appear to the right of the first one, this time reading “TikTok Ads requires authorization to connect to data.”
Click ‘AUTHORISE’ again. This time you’ll be prompted to sign into your Supermetrics account.
At this stage, you’re granting Supermetrics permission to access your TikTok account.
If it doesn’t seem like anything’s happened, and you still see the second blue ‘AUTHORISE’ button, you may need to click it a second time. The majority of times I’ve tried adding a Supermetrics connector, I need to repeat this step a second time for it to all link up.
Once everything’s connected, your TikTok Ads account should now be a data feed within your new Looker Studio report, and you’re free to pull in all the dimensions and metrics needed to visualise your data.
For 20% off Supermetrics, use code rusticated upon signup.
We have more guides on using Supermetrics to pull data into Google Looker Studio here.