TikTok – Redshift
Last published
2022-02-03
Categories
Marketing Advertising
Type
Data Model
Integrates with
The TikTok Kit combines data from multiple entities in the TikTok Marketing API and provides a full data model for tracking paid TikTok performance and insight analysis.
This Kit includes…
- Data ingestion from the following TikTok entities:
- Advertisers
- Campaigns
- Ad Groups
- Ads
- Creatives Report
- Auction Ads Report
- SKAN Report (Auction Ads at Ad Group level)
- Logic that orchestrates and transforms raw TikTok data to create a data model with related paid entities
Minimum RPU Consumption: 8
Configuring this Kit for use
Variables
In this Kit, there are two variables that are used to make for dynamic use of target configuration.
- {Schema_Tiktok} is used in all Target configurations and queries as the target schema name.
- {Tiktok_Alert_Group} is used as the alert email address(es) for when a river fails (optional).
Go to the Variables menu on the left side navigation bar and create variables for Schema_Tiktok and Tiktok_Alert_Group. Then fill in the values as the Redshift schema where you would like the data to land and the email address(es) to which you would like the failure emails sent.
Connections
Kits are imported with ‘blank’ source and target connections. In order to use the kit, you have two options:
- Swap out blank connections with existing connections
- Add credentials to the blank connections that come with the imported Kit
