Schema: Data Warehouse - Platform Performance - Snapchat
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 |