Connect TikTok Ads to Google Data Studio

Directly connect TikTok Ads to Google Data Studio, in minutes, and in an easy-to-use format.

tiktok google data studio integration

Analyze Your Marketing Metrics from TikTok Ads in GDS

Why integrate TikTok Ads with Google Data Studio?

  • Integrating TikTok Ads data with Google Data Studio can help you understand how your target audience is engaging with your ads, and make more informed decisions about future campaigns. 

 

  • By understanding how users engage with your content, you’ll be able to gauge the level of interest in particular content or topics which help you create more effective ads that are more likely to be clicked, shared, and remembered.

 

  • Google Data Studio can help you collect data from multiple data sources. Connecting TikTok Ads with other data sources such as Google Analytics will allow you to better visualize your whole customer journey.

 

  • Google Data Studio helps you visualize your TikTok Ads data and monitor performance in real time. You can able to identify potential problems early on with your campaigns and optimize accordingly.

About the TikTok Ads Google Data Studio Connector

The TikTok Ads Google Data Studio Connector pulls Metrics and Dimensions for TikTok Ads. The Insights are retrieved at the Campaign or Ad Level.

Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

Prerequisites

To set up the connector, the user should have:

How to connect TikTok Ads to Google Data Studio?

Do you plan to connect and visualize your TikTok Ads in Google Data Studio? Follow the Tutorial Below:

You need to select TikTok as a Data Source and grant access to Windsor.ai. You will be asked to authenticate with a TikTok ID during the installation of the connector.

tiktok snowflake integration

Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend.select fields on the right

Go to “Select Destination” and choose Looker Studio.

select looker studio

Once done, select “connect” and authorize access to your data source.

Windsor.ai TikTok Ads Google Data Studio Connector

Google Data Studio Templates for TikTok Ads

These free and customizable Google Data Studio TikTok Ads templates will assist you in visualizing your data for easy reporting and analysis.

TikTok Ads metrics & dimensions available for streaming into Google Data Studio

NameTypeDescription
acTEXTGroup by network
Account IDTEXTThe TikTok Ads account ID
Account NameTEXTThe TikTok Ads account name
Ad Group IDTEXTAd group ID
Ad Group NameTEXTAd group name
Ad IDTEXTAd ID
Ad NameTEXTAd Name
Ad titleTEXTSupported at Ad level.
App Event Optimization TypeTEXTSupported at Ad Group and Ad level.
Age RangeTEXTThe Age Range of the Audience
App InstallNUMERICThe number of times your mobile app was installed that were recorded as app events and attributed to your ads. (The total count is calculated based on the time each ad impression occurred.)
Video Average Watch Time Per Video ViewNUMERICThe average time your video was played per single video view, including any time spent replaying the video.
Video Average Watch Time Per PersonNUMERICThe average time your video was played per person, including any time spent replaying the video. This metric is estimated.
BidTEXTSupported at Ad Group and Ad level.
Bid strategyTEXTSupported at Ad Group and Ad level.
Billing EventTEXTSupported at Ad Group and Ad level.Example: `Clicks`, `Impression`.
Ad group budgetTEXTSupported at Ad Group and Ad level.
Budget Optimize SwitchTEXTWhether Campaign Budget Optimization (CBO) is enabled
Call To ActionTEXTCall-to-action (CTA)
Call To Action ID (deprecated)TEXTCall-to-action (CTA) ID
CampaignTEXTThe Campaign Name
Campaign Bid TypeTEXTBidding strategy on the campaign level.
Campaign BudgetNUMERICCampaign budget
Campaign Budget Type (deprecated)TEXTCampaign budget type
Campaign Creation TimeTEXTTime at which campaign was created
Campaign Deep Bid TypeTEXTBidding strategy for in-app events.
Campaign IDTEXTThe Campaign ID
Campaign Modify Time (deprecated)TEXTTime at which campaign was modified
CampaignTEXTThe Campaign Name
Campaign Optimize GoalTEXTOptimization goal. Returned only if Campaign Busget Optimization is enabled.
ROAS bidTEXTROAS goal for Value Optimization bid strategies (VO_*)
Campaign TypeTEXTCampaign objective
ClicksNUMERICThe Number of Clicks
CommentsNUMERICThe number of comments your video creative received within 1 day of a user seeing a paid ad.
Total Complete PaymentNUMERICPage Event Metric. The number of complete payment events.
ConversionNUMERICThe number of times your ad achieved an outcome, based on the secondary goal you selected. (Duplicate)
Conversion RatePERCENTThe number of conversions and divided by the number of total ad interactions that can be tracked to a conversion.
ConversionsNUMERICThe number of times your ad achieved an outcome, based on the secondary goal you selected.
Cost per App InstallNUMERICThe average cost for each app install event. (The total count is calculated based on the time each ad impression occurred.)
Cost per conversionNUMERICThe cost (Spend) divided by the conversions your ad generates(Conversions)
Cost per Unique Create Group NUMERICThe average cost for each unique create group event that is attributed toyour ads. (The total count is calculated based on the time each ad impression occurred.)
Cost per Unique RegistrationNUMERICThe average cost for each unique registration that is attributed to your ad. (The total count is calculated based on the time each ad impression occurred.)
Cost per Create Group NUMERICCost per Create Group (The total count is based on when you were billed.)
Cost per RegistrationNUMERICCost per Registration (The total count is based on when you were billed.)
CountryCOUNTRYThe code of Country of the Audience
CPCNUMERICThe cost (Spend) divided by the clicks your ad receives(Clicks)
Cost per Unique Create GroupNUMERICThe average cost for each unique create group event that is attributed toyour ads. (The total count is calculated based on the time each adimpression occurred.)
Create Group Rate (%) NUMERICThe percentage of unique create group events out of all app install events. (The total count is calculated based on the time each ad impression occurred.)
CTRPERCENTThe number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions).
CurrencyTEXTThe currency code, e.g. USD.
DateDATEThe Date
Target audience type for DPATEXTThe Audience that DPA products target
FollowsNUMERICThe number of new followers that were gained within 1 day of a user seeing a paid ad. This metric is only for Boosted TikToks.
FrequencyNUMERICThe average number of times each person saw your ad.(Conversions)
GenderTEXTThe Gender of the Audience
FormatTEXTSupported at Campaign, Ad Group and Ad level.
ImpressionsNUMERICThe Number of Impressions
Total Initiate CheckoutNUMERICPage Event Metric. The number of initiate checkout events.
TEXTWhether the ad is automated.
LanguageTEXTThe Language of the Audience
LikesNUMERICThe number of likes your video creative received within 1 day of a user seeing a paid ad.
Mobile App IDTEXTSupported at Ad Group and Ad level. Returned if the promotion type of one Ad Group is App.
ObjectiveTEXTCampaign type. Possible values: APP, LANDING_PAGE
Objective TypeTEXTAdvertising objective
Automated creative optimizationTEXTAutomated creative optimization
PlacementTEXTThe Placement Name
Placement typeTEXTThe Placement type
PlatformTEXTThe Operating System of the Audience
2-Second Video ViewsNUMERICThe number of times your video played for at least 2 seconds. Replays will not be counted.
6-Second Video ViewsNUMERICThe number of times your video played for at least 6 seconds, or completely played. Replays will not be counted.
Video Views at 25%NUMERICThe number of times your video was played at 25% of its length. Replays will not be counted.
Video Views at 50%NUMERICThe number of times your video was played at 50% of its length. Replays will not be counted.
Video Views at 100%NUMERICThe number of times your video was played at 100% of its length. Replays will not be counted.
Video Views at 75%NUMERICThe number of times your video was played at 75% of its length. Replays will not be counted.
Promotion typeTEXTThe promotion type
Unique PurchaseNUMERICIn-app event metric. The number of unique purchases event occurred in your app that were recorded by your measurement partner. (The total count is calculated based on the time each ad impression occurred.)
Purchase Rate (%)NUMERICIn-app event metric. The percentage of unique purchase event out of all the app install event. (The total count is calculated based on the time each ad impression occurred.)
ReachNUMERICThe number of unique users who saw your ads at least once
Real-time App InstallNUMERICThe number of times your mobile app was installed that were recorded as app events and attributed to your ads. (The total count is based on when the conversion actually happened.)
Cost per Real-time App InstallNUMERICThe average cost for each app install event. (The total count is based on when the conversion actually happened.)
Unique RegistrationNUMERICThe number of unique registrations in your mobile app that were recorded as app events and attributed to your ads. (The total count is calculated based on the time each ad impression occurred.)
Registration Rate (%)NUMERICThe percentage of unique registration events out of all app install events. (The total count is calculated based on the time each ad impression occurred.)
SharesNUMERICThe number of shares your video creative received within 1 day of a user seeing a paid ad.
Optimization goalTEXTSupported at Ad Group and Ad level.
spendNUMERICThe Media Spend
Total CheckoutNUMERICIn-app event metric. Checkout (Total No.) (The total count is based on when you were billed.)
Total Checkout ValueNUMERICIn-app event metric. Total Checkout Value (The total count is based on when you were billed.)
Total Complete Payment ValueNUMERICPage Event Metric. The total value returned from all Complete Payment events.
Total Complete TutorialNUMERICThe number of complete tutorial events that are attributed to your ads.
Total Complete Tutorial ValueNUMERICThe total value returned from all complete tutorial events.
Total Create GroupNUMERICThe number of create group events that are attributed to your ads.
Total Create Group ValueNUMERICThe total value returned from all create group events.
Total Initiate Checkout ValueNUMERICPage Event Metric. The total value returned from initiate checkout events.
Video Views (tiktok)NUMERICThe number of times your video starts to play. Replays will not be counted.
Total RegistrationNUMERICTotal Registration. The total count is based on when you were billed.
Total CostNUMERICThe Media Spend (Duplicate)
TikTok App ID TEXTTikTok App ID, the App ID you used when creating an Ad Group. Supported at Ad Group and Ad level. Returned if the promotion type of one Ad Group is App.
TikTok App NameTEXTThe name of your TikTok App. Supported at Ad Group and Ad level. Returned if thepromotion type of one Ad Group is App.
Value per Create Group NUMERICValue per Create Group (The total count is based on when you were billed.)
TodayDATEToday's date

Easily connect TikTok Ads to Google Data Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your TikTok Ads and Google Data Studio Integrations