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

Primary Key: the concatenation of identifier, date, utc_hour, and ad_id can be used as a primary key


How did we do?