Schema: Data Warehouse - Platform Performance - TikTok
Order | Name | Description | Type |
1 | advertiser | Rockerbox Account ID | str |
2 | type | The dataset type (e.g., platform_data) | str |
3 | platform | The name of the ad platform (e.g., Adwords) | str |
4 | report | The name of the dataset (e.g., platform_performance_adwords) | str |
5 | identifier | The unique identifier of the account in the advertising platform | str |
6 | date | The date that the action occured | date |
7 | utc_hour | The UTC hour that the action occured | int |
8 | tier_1 | Marketing channel categorization level 1 | str |
9 | tier_2 | Marketing channel categorization level 2 | str |
10 | tier_3 | Marketing channel categorization level 3 | str |
11 | tier_4 | Marketing channel categorization level 4 | str |
12 | tier_5 | Marketing channel categorization level 5 | str |
13 | mta_tiers_join_key | The unique identifier used to pull spend from an advertisting platform. This is typically the ad_id, but may differ based on your account setup | str |
14 | campaign_name | The name of the campaign. A campaign is made up of a series of ad groups, each with its own unique targeting settings, optimization goals, budgets, and ads | str |
15 | campaign_id | The unique identifier of the campaign | str |
16 | adgroup_name | The name of the ad group. An ad group relates to one campaign and contains a set of similar ads | str |
17 | adgroup_id | The unique identifier of the ad group | str |
18 | ad_name | The name of the ad | str |
19 | ad_id | The unique identifier of the ad | str |
20 | spend | The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in the ad platform account’s local currency | float |
21 | currency_code | The local currency of your account in the ad platform (e.g., EUR, USD) | str |
22 | spend_usd | The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in USD. | float |
23 | clicks | Clicks recorded to CTA button, ad caption, nickname, profile picture, and swipe-left | int |
24 | impressions | The number of times your ads were on screen | int |
25 | follows | The number of new followers that were gained within 1 day of a user seeing a paid ad | int |
26 | likes | The number of likes the video creative received within 1 day of a user seeing a paid ad | int |
27 | comments | The number of comments your video creative received within 1 day of a user seeing a paid ad | int |
28 | reach | The number of unique users who saw your ads at least once. This metric is estimated | int |
29 | frequency | The average number of times each person saw your ad | float |
30 | shares | The number of times your video creative was shared within 1 day of a user seeing a paid ad | int |
31 | profile_visits | The number of profile visits the paid ad drove during the campaign | int |
32 | secondary_goal_result | The number of times your ad achieved an outcome, based on the secondary goal you selected. | str |
33 | video_play_actions | The number of times your video starts to play. Replays will not be counted | int |
34 | average_video_play | The average time your video was played per single video view, including any time spent replaying the video | float |
35 | average_video_play_per_user | The average amount of time your video ads played per person. Including anytime spent replaying the video | float |
36 | video_watched_2s | Number of times your video was played for at least 2 seconds. Replays will not be counted | int |
37 | video_watched_6s | Number of times your video was played for at least 6 seconds. Replays will not be counted | int |
38 | video_views_p25 | The number of times your video was played at 25% of its length. Replays will not be counted | int |
39 | video_views_p50 | The number of times your video was played at 50% of its length. Replays will not be counted | int |
40 | video_views_p75 | The number of times your video was played at 75% of its length. Replays will not be counted | int |
41 | video_views_p100 | The number of times your video was played at 100% of its length. Replays will not be counted | int |
42 | clicks_on_music_disc | The number of clicks recorded to Music Disc icon and Music title | int |
43 | conversions | The number of times your ad achieved an outcome based on the objective and settings you selected | dict |
44 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | str |
45 | updated_at | timestamp |