+
Stream your marketing data from TikTok Ads to Snowflake
About TikTok Ads
About 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:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select TikTok Ads as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3.Enter all the credentials required and click Save
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
| name | type | description |
|---|---|---|
| AC | TEXT | Group by network |
| Account ID | TEXT | The TikTok Ads account ID |
| Account Name | TEXT | The TikTok Ads account name |
| Ad Group ID | TEXT | Ad group ID |
| Ad Group Name | TEXT | Ad group name |
| Ad ID | TEXT | Ad ID |
| Ad Name | TEXT | Ad Name |
| Age Range | TEXT | The Age Range of the Audience |
| App Install | NUMERIC | The 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 View | NUMERIC | The average time your video was played per single video view, including any time spent replaying the video. |
| Video Average Watch Time Per Person | NUMERIC | The average time your video was played per person, including any time spent replaying the video. This metric is estimated. |
| Budget Optimize Switch | TEXT | Whether Campaign Budget Optimization (CBO) is enabled |
| Call To Action | TEXT | Call-to-action (CTA) |
| Call To Action ID | TEXT | Call-to-action (CTA) ID |
| Campaign | TEXT | The Campaign Name |
| Campaign Bid Type | TEXT | Bidding strategy on the campaign level. |
| Campaign Budget | NUMERIC | Campaign budget |
| Campaign Budget Type | TEXT | Campaign budget type |
| Campaign Creation Time | TEXT | Time at which campaign was created |
| Campaign Deep Bid Type | TEXT | Bidding strategy for in-app events. |
| Campaign ID | TEXT | The Campaign ID |
| Campaign Modify Time | TEXT | Time at which campaign was modified |
| Campaign Optimize Goal | TEXT | Optimization goal. Returned only if Campaign Busget Optimization is enabled. |
| ROAS bid | TEXT | ROAS goal for Value Optimization bid strategies (VO_*) |
| Campaign Type | TEXT | Campaign objective |
| Clicks | NUMERIC | The Number of Clicks |
| Comments | NUMERIC | The number of comments your video creative received within 1 day of a user seeing a paid ad. |
| Total Complete Payment | NUMERIC | The number of complete payment events. |
| Conversion Rate | PERCENT | The number of conversions and divided by the number of total ad interactions that can be tracked to a conversion. |
| Conversions | NUMERIC | The number of times your ad achieved an outcome, based on the secondary goal you selected. |
| Cost per App Install | NUMERIC | The average cost for each app install event. (The total count is calculated based on the time each ad impression occurred.) |
| Cost per conversion | NUMERIC | The cost (Spend) divided by the conversions your ad generates(Conversions) |
| Cost per Unique Registration | NUMERIC | The 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 Registration | NUMERIC | Cost per Registration (The total count is based on when you were billed.) |
| Country | COUNTRY | The Country of the Audience |
| CPC | NUMERIC | The cost (Spend) divided by the clicks your ad receives(Clicks) |
| CTR | PERCENT | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). |
| Currency | TEXT | The currency code, e.g. USD. |
| Date | DATE | The Date |
| Follows | NUMERIC | The number of new followers that were gained within 1 day of a user seeing a paid ad. This metric is only for Boosted TikToks. |
| Gender | TEXT | The Gender of the Audience |
| Impressions | NUMERIC | The Number of Impressions |
| Is Automated AD | TEXT | Whether the ad is automated. |
| Language | TEXT | The Language of the Audience |
| Likes | NUMERIC | The number of likes your video creative received within 1 day of a user seeing a paid ad. |
| Objective | TEXT | Campaign type. Possible values: APP, LANDING_PAGE |
| Objective Type | TEXT | Advertising objective |
| Placement | TEXT | The Placement Name |
| Platform | TEXT | The Operating System of the Audience |
| 2-Second Video Views | NUMERIC | The number of times your video played for at least 2 seconds. Replays will not be counted. |
| 6-Second Video Views | NUMERIC | The number of times your video played for at least 6 seconds, or completely played. Replays will not be counted. |
| Video Views at 25% | NUMERIC | The number of times your video was played at 25% of its length. Replays will not be counted. |
| Video Views at 50% | NUMERIC | The number of times your video was played at 50% of its length. Replays will not be counted. |
| Video Views at 100% | NUMERIC | The number of times your video was played at 100% of its length. Replays will not be counted. |
| Video Views at 75% | NUMERIC | The number of times your video was played at 75% of its length. Replays will not be counted. |
| Reach | NUMERIC | The number of unique users who saw your ads at least once |
| Real-time App Install | NUMERIC | The 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 Install | NUMERIC | The average cost for each app install event. (The total count is based on when the conversion actually happened.) |
| Unique Registration | NUMERIC | The 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 (%) | NUMERIC | The percentage of unique registration events out of all app install events. (The total count is calculated based on the time each ad impression occurred.) |
| Shares | NUMERIC | The number of shares your video creative received within 1 day of a user seeing a paid ad. |
| spend | NUMERIC | The Media Spend |
| Total Checkout | NUMERIC | The number of checkout events that are attributed to your ads. |
| Total Checkout Value | NUMERIC | The total value returned from all checkout events. |
| Total Complete Payment Value | NUMERIC | The total value returned from all Complete Payment events. |
| Total Complete Tutorial | NUMERIC | The number of complete tutorial events that are attributed to your ads. |
| Total Complete Tutorial Value | NUMERIC | TThe total value returned from all complete tutorial events. |
| Total Create Group | NUMERIC | The number of create group events that are attributed to your ads. |
| Total Create Group Value | NUMERIC | The total value returned from all create group events. |
| Video Views | NUMERIC | The number of times your video starts to play. Replays will not be counted. |
| Total Registration | NUMERIC | Total Registration. The total count is based on when you were billed. |
| Total Cost | NUMERIC | The Media Spend (Duplicate) |
Easily connect TikTok Ads to Snowflake
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 marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.