Schema: Data Warehouse - Platform Performance - TikTok

Suggest Edits

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		int
33	video_play_actions		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

Updated about 2 years ago