Schema: Data Warehouse - Platform Performance - Snapchat

Updated by Omar Elmaghrabi

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., Snapchat)

str

4

report

The name of the dataset (e.g., platform_performance_snapchat)

str

5

identifier

The unique identifier of the account in the advertising platform

str

6

date

The date that the action occurred

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 ad campaign. Your campaign contains ad squads and ads

str

15

campaign_id

The unique ID of the ad campaign

str

16

ad_squad_name

The name of the ad squad. Your ad squad contains one or more ads

str

17

ad_squad_id

The unique ID of the ad squad

str

18

ad_name

The name of the ad

str

19

ad_id

The unique ID of the ad

str

20

ad_type

The type of Snap ad (e.g., SNAP_AD, LONGFORM_VIDEO)

str

21

spend

The estimated total amount of money you've spent on your ad in the ad platform account's local currency

float

22

currency_code

The local currency of your account in the ad platform (e.g., EUR, USD)

str

23

spend_usd

The estimated total amount of money you've spent on your ad in USD

float

24

swipes

Swipe-up count

int

25

impressions

Impression count

int

26

earned_impressions

The number of times your ad was viewed after being shared by a Snapchatter via Chat or Stories

int

27

paid_impressions

The total number of times your ad was served to a user

int

28

total_impressions

The total number of impressions (Paid and Earned)

int

29

screen_time_millis

Total Time Spent on top Snap Ad (milliseconds)

int

30

avg_screen_time_millis

Average Top Snap view time across all impressions

float

31

quartile_1

Video views to 25%

int

32

quartile_2

Video views to 50%

int

33

quartile_3

Video views to 75%

int

34

view_completion

Video views to completion

int

35

video_views

The total number of impressions that meet the qualifying video view criteria of at least 2 seconds of consecutive watch time or a swipe up action on the Top Snap

int

36

video_views_15s

The total number of impressions that meet the qualifying video view criteria of at least 15 seconds, or 97% completion if it’s shorter than 15 seconds, or a swipe up action on the ad

int

37

video_views_time_based

The total number of impressions that meet the qualifying video view criteria of at least 2 seconds, not including swipe ups

int

38

saves

# of times lens/filter was saved to Memories

int

39

shares

# of times lens/filter was shared in a Chat or Story

int

40

attachment_impressions

Impression count from attachments

int

41

attachment_quartile_1

Long Form Video Views to 25%

int

42

attachment_quartile_2

Long Form Video Views to 50%

int

43

attachment_quartile_3

Long Form Video Views to 75%

int

44

attachment_view_completion

Long Form Video Views to completion

int

45

attachment_avg_view_time_millis

Average Attachment View Time (milli-seconds)

float

46

attachment_total_view_time_millis

Total Attachment View Time (milli-seconds)

int

47

view_1_day

View through conversions within a 1 day lookback

dict

48

view_7_day

View through conversions within a 7 day lookback

dict

49

swipe_1_day

Click through conversions within a 1 day lookback

dict

50

swipe_7_day

Click through conversions within a 7 day lookback

dict

51

swipe_28_day

Click through conversions within a 28 day lookback

dict

52

view_1_day_value

The total value of view through conversions in the ad platform account local currency within a 1 day lookback

dict

53

view_7_day_value

The total value of view through conversions in the ad platform account local currency within a 7 day lookback

dict

54

swipe_1_day_value

The total value of click through conversions in the ad platform account local currency within a 1 day lookback

dict

55

swipe_7_day_value

The total value of click through conversions in the ad platform account local currency within a 7 day lookback

dict

56

swipe_28_day_value

The total value of click through conversions in the ad platform account local currency within a 28 day lookback

dict

57

view_1_day_value_usd

The total USD value of view through conversions within a 1 day lookback window

dict

48

view_7_day_value_usd

The total USD value of view through conversions within a 7 day lookback window

dict

49

swipe_1_day_value_usd

The total USD value of click through conversions within a 1 day lookback window

dict

60

swipe_7_day_value_usd

The total USD value of click through conversions within a 7 day lookback window

dict

61

swipe_28_day_value_usd

The total USD value of click through conversions within a 28 day lookback window

dict

62

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

str

63

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?