Connect TikTok Ads to Google BigQuery

tiktok to google bigquery

Analyze your TikTok Ads data with Google BigQuery

Connect TikTok Ads to Google BigQuery in 2023

It is very simple to connect TikTok Ads to Google BigQuery, it can be done in a fast and easy manner with Windsor.ai.

 

First Step:

You need to select TikTok Ads as a Data Source and Grant Access to Windsor.ai.

TikTok Integration

 

Second Step:

You will need to go to Google BigQuery as a Destination.

BigQuery Integration

 

Third Step:

Make sure you follow the instructions on the screen. Once you complete the setup your data will start streaming in the interval you specify. You can always come back and change the settings at a later stage.

BigQuery Integration

 (Don’t forget to grant access to bq-upload@windsor-ai-bigquery.iam.gserviceaccount.com)

 

Fourth Step:

As a connector URL, you can use any URL providing a JSON. Either from the connectors or for example a URL with cached and transformed data from Charts.Windsor.ai

Tiktok Ads metrics and dimensions available for streaming into Google BigQuery

Connect your data

 

FieldData TypeDescriptionExplanation
Basic Dimensions
accountid
stringAccount IDThe account id of the Snapchat Ads account
source
stringSourceThe source. Always returns snapchat.
campaign
stringCampaign nameThe campaign name.
Basic Metrics
spend
floatCostTotal cost of advertising during the campaign.
impressions
floatImpressionsThe number of times an ad was seen on screen.
clicks
floatClicksThe number of clicks on your ads.
ctr
floatCTRThe click through rate (CTR) is the percentage of impression that led to a click.
reach
floatReachThe number of unique users who have seen your ads. This metric is estimated.
Video Play Metrics
video_play_actions
floatVideo ViewsThe number of times your video starts to play. Replays will not be counted.
video_watched_2s
float2-Second Video ViewsThe number of times your video played for at least 2 seconds. Replays will not be counted.
video_watched_6s
float6-Second Video ViewsThe number of times your video played for at least 6 seconds, or completely played. Replays will not be counted.
video_views_p25
floatVideo Views at 25%The number of times your video was played at 25% of its length. Replays will not be counted.
video_views_p50
floatVideo Views at 50%The number of times your video was played at 50% of its length. Replays will not be counted.
video_views_p75
floatVideo Views at 75%The number of times your video was played at 75% of its length. Replays will not be counted.
video_views_p100
floatVideo Views at 100%The number of times your video was played at 100% of its length. Replays will not be counted.
average_video_play
floatVideo Average Watch Time Per Video ViewThe average time your video was played per single video view, including any time spent replaying the video.
average_video_play_per_user
floatVideo Average Watch Time Per PersonThe average time your video was played per person, including any time spent replaying the video. This metric is estimated.
Engagement Metrics
likes
floatLikesThe total amount of likes the ad received during the campaign.
comments
floatCommentsThe number of comments the ad received during the campaign.
shares
floatSharesThe number of shares the ad received during the campaign.
profile_visits
floatProfile visitsThe number of homepage visits the ad drove during the campaign. This metric is only for in-feed native ads.
follows
floatFollowThe total amount of follows the ad received during the campaign. This metric is only for in-feed native ads.
clicks_on_music_disc
floatClicks on music discThe total amount of clicks on your ad`s official music during the campaign. This metric is only for in-feed native ads.
clicks_on_hashtag_challenge
floatClicks on hashtag challengeThe total amount of clicks on your ad`s hashtag challenge during the campaign.
engagements
floatEngagementThe number of clicks on interactive elements on your ads during the campaign, such as likes, comments, shares, homepage visits, follows, music clicks, hashtag challenge clicks and total clicks.
engagement_Rate
floatEngagement RateThe engagement rate is the number of engagements that your ad receives divided by the number of times your ad is shown.
skip_ad
floatSkip AdThe number of clicks on the skip button of takeover ad.
Additional Format Metrics
interact_card_show_cnt
floatInteractive Card ImpressionInteractive Card Impression
interact_card_a_click_cnt
floatInteractive Card Button A ClickInteractive Card Button A Click
interact_card_b_click_cnt
floatInteractive Card Button B ClickInteractive Card Button B Click
vote_card_show_cnt
floatVoting Card ImpressionVoting Card Impression
vote_card_a_click_cnt
floatVoting Card Button A ClickVoting Card Button A Click
vote_card_b_click_cnt
floatVoting Card Button B ClickVoting Card Button B Click
vote_card_convert_click_cnt
floatVoting Card CTA Button ClickVoting Card CTA Button Click
redpacket_show_cnt
floatPremium Badge ImpressionPremium Badge Impression
redpacket_click_cnt
floatPremium Badge ClickPremium Badge Click
image_card_show_cnt
floatDisplay Card ImpressionDisplay Card Impression
image_card_click_cnt
floatDisplay Card ClickDisplay Card Click

Windsor.ai: Easily connect TikTok Ads to Google BigQuery

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 marketeers, whenever they want.

insights

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

Build your TikTok Ads and Google BigQuery Integrations