Connect Tiktok Ads to Google BigQuery with Windsor.ai
Stream all your media and ads data from from Tiktok Ads to Google BigQuery
About Tiktok Ads
TikTok Ads allows marketers to advertise to TikToks rapidly growing user base. Supported media activities on TikTok Ads include the traditional display and video advertising as well as sponsored challenges.
You need to select TikTok ads as a Data Source and Grant Access to Windsor.ai.
you will need to go to Select Destination to choose where do you want to send your data.
In this case Select Google BigQuery As A Data Destination
(Don’t forget to grant access to firstname.lastname@example.org)
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.
- 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
You should also read:
|string||Account ID||The account id of the Snapchat Ads account|
|string||Source||The source. Always returns snapchat.|
|string||Campaign name||The campaign name.|
|float||Cost||Total cost of advertising during the campaign.|
|float||Impressions||The number of times an ad was seen on screen.|
|float||Clicks||The number of clicks on your ads.|
|float||CTR||The click through rate (CTR) is the percentage of impression that led to a click.|
|float||Reach||The number of unique users who have seen your ads. This metric is estimated.|
Video Play Metrics
|float||Video Views||The number of times your video starts to play. Replays will not be counted.|
|float||2-Second Video Views||The number of times your video played for at least 2 seconds. Replays will not be counted.|
|float||6-Second Video Views||The number of times your video played for at least 6 seconds, or completely played. Replays will not be counted.|
|float||Video Views at 25%||The number of times your video was played at 25% of its length. Replays will not be counted.|
|float||Video Views at 50%||The number of times your video was played at 50% of its length. Replays will not be counted.|
|float||Video Views at 75%||The number of times your video was played at 75% of its length. Replays will not be counted.|
|float||Video Views at 100%||The number of times your video was played at 100% of its length. Replays will not be counted.|
|float||Video Average Watch Time Per Video View||The average time your video was played per single video view, including any time spent replaying the video.|
|float||Video Average Watch Time Per Person||The average time your video was played per person, including any time spent replaying the video. This metric is estimated.|
|float||Likes||The total amount of likes the ad received during the campaign.|
|float||Comments||The number of comments the ad received during the campaign.|
|float||Shares||The number of shares the ad received during the campaign.|
|float||Profile visits||The number of homepage visits the ad drove during the campaign. This metric is only for in-feed native ads.|
|float||Follow||The total amount of follows the ad received during the campaign. This metric is only for in-feed native ads.|
|float||Clicks on music disc||The total amount of clicks on your ad`s official music during the campaign. This metric is only for in-feed native ads.|
|float||Clicks on hashtag challenge||The total amount of clicks on your ad`s hashtag challenge during the campaign.|
|float||Engagement||The 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.|
|float||Engagement Rate||The engagement rate is the number of engagements that your ad receives divided by the number of times your ad is shown.|
|float||Skip Ad||The number of clicks on the skip button of takeover ad.|
Additional Format Metrics
|float||Interactive Card Impression||Interactive Card Impression|
|float||Interactive Card Button A Click||Interactive Card Button A Click|
|float||Interactive Card Button B Click||Interactive Card Button B Click|
|float||Voting Card Impression||Voting Card Impression|
|float||Voting Card Button A Click||Voting Card Button A Click|
|float||Voting Card Button B Click||Voting Card Button B Click|
|float||Voting Card CTA Button Click||Voting Card CTA Button Click|
|float||Premium Badge Impression||Premium Badge Impression|
|float||Premium Badge Click||Premium Badge Click|
|float||Display Card Impression||Display Card Impression|
|float||Display Card Click||Display Card Click|
Windsor.ai: Easily connect Tiktok Ads to Google BigQuery
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.
Start a free trial today.
Integrate all your data and measure what matters.