Connect TikTok Ads to Snowflake

Tik Tok Field Reference logo
+
snowflake

Stream your marketing data from TikTok Ads to Snowflake

Connect TikTok Ads to Snowflake in 2023

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

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. Snowflake Integration 1
  2. Create the WINDSOR_UPLOAD role (name has no importance) Snowflake Integration 2
  3. Create a user and add the previously created role to that user Snowflake Integration 3
  4. Grant rights to the DATABASE to the created user Snowflake Integration 4
  5. Grand the rights to the destination table Snowflake Integration 5
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form

 

  • Get the username Import Snowflake 1

 

  • Get the password Import Snowflake 2

 

  • Get the account Import Snowflake 3

 

  • Get the warehouse Import Snowflake 4

 

  • Get the database Import Snowflake 5

 

  • Get the schema Import Snowflake 6

 

  • Get the table name Import Snowflake 7

 

Second step

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

tiktok snowflake integration

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3.Enter all the credentials required and click Save
Snowflake connector

 

4.Your data will now be streamed to Snowflake. In case there is an error you will be notified.

TikTok Ads metrics and dimensions available for streaming into Snowflake

Connect your data

 

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
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.
Budget Optimize SwitchTEXTWhether Campaign Budget Optimization (CBO) is enabled
Call To ActionTEXTCall-to-action (CTA)
Call To Action IDTEXTCall-to-action (CTA) ID
CampaignTEXTThe Campaign Name
Campaign Bid TypeTEXTBidding strategy on the campaign level.
Campaign BudgetNUMERICCampaign budget
Campaign Budget TypeTEXTCampaign 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 TimeTEXTTime at which campaign was modified
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 PaymentNUMERICThe number of complete payment events.
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 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 RegistrationNUMERICCost per Registration (The total count is based on when you were billed.)
CountryCOUNTRYThe Country of the Audience
CPCNUMERICThe cost (Spend) divided by the clicks your ad receives(Clicks)
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
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.
GenderTEXTThe Gender of the Audience
ImpressionsNUMERICThe Number of Impressions
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.
ObjectiveTEXTCampaign type. Possible values: APP, LANDING_PAGE
Objective TypeTEXTAdvertising objective
PlacementTEXTThe Placement Name
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.
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.
spendNUMERICThe Media Spend
Total CheckoutNUMERICThe number of checkout events that are attributed to your ads.
Total Checkout ValueNUMERICThe total value returned from all checkout events.
Total Complete Payment ValueNUMERICThe 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 ValueNUMERICTThe 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.
Video ViewsNUMERICThe 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)

Easily connect TikTok Ads to Snowflake

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 Snowflake Integrations