Schema: Data Warehouse - Platform Performance - Pinterest
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 | tier_1 | Marketing channel categorization level 1 | str |
8 | tier_2 | Marketing channel categorization level 2 | str |
9 | tier_3 | Marketing channel categorization level 3 | str |
10 | tier_4 | Marketing channel categorization level 4 | str |
11 | tier_5 | Marketing channel categorization level 5 | str |
12 | 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 |
13 | campaign_name | The name of the advertising campaign | str |
14 | campaign_id | The unique identifier associated with a given advertising campaign | str |
15 | campaign_status | The status of a given campaign – active, paused, or archived | str |
16 | ad_group_name | The name of the ad group | str |
17 | ad_group_id | The unique identifier associated with a given ad group | str |
18 | ad_group_status | The status of given ad group – running, paused, not started, completed, advertiser disabled, or archived | str |
19 | pin_promotion_ad_group_type | str | |
20 | pin_promotion_ad_group_type_2 | str | |
21 | pin_promotion_name | The name of the promoted pin | str |
22 | pin_promotion_id | The unique identifier of the promoted pin (i.e., ad) | str |
23 | pin_promotion_status | The status of a pin promotion – active, other, or paused. | str |
24 | pin_id | The unique identifier of the pin | str |
25 | ad_id | The unique identifier associated with a given ad | str |
26 | 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 |
27 | currency_code | The local currency of your account in the ad platform (e.g., EUR, USD) | str |
28 | spend_usd | The estimated total amount of money you’ve spent on your campaign, ad set or ad during its schedule in USD. | float |
29 | clicks | The total number of clicks on your Pin or ad to content on Pinterest or off of Pinterest (e.g., the advertisers website) | int |
30 | clickthrough_1_gross | Pin clicks for first order ad events (e.g., clicks on a promoted pin) | int |
31 | clickthrough_2 | Pin clicks for downstream or earned events (e.g., clicks on a saved instance of a promoted pin). Advertisers are not billed for earned activity. | int |
32 | impressions | The number of times your Pins or ads were on screen. | int |
33 | impression_1_gross | Impressions for first order ad events (e.g., promoted pins) | int |
34 | impression_2 | Impressions for downstream or earned events (e.g., impressions of a saved instance of a promoted pin). | int |
35 | repin_1 | The number of times the pin was saved to another user’s board. This metric captures repins of first order ad events (e.g., repins of promoted pins). | int |
36 | repin_2 | The number of times the pin was saved to another user’s board. This metric captures repins of downstream or earned events (e.g., repins of saved instances of promoted pins). | int |
37 | outbound_click_1 | An outbound click is a click on a pin that lead the user to a destination off of Pinterest (i.e., the advertiser’s websiter). This metric aggregates all outbound clicks for first order ad events (e.g., outbound clicks of promoted pins). | int |
38 | outbound_click_2 | An outbound click is a click on a pin that lead the user to a destination off of Pinterest (i.e., the advertiser’s websiter). This metric aggregates all outbound clicks for downstream or earned events (e.g., outbound clicks of saved instances of promoted pins). | int |
39 | engagement_1 | Engagements track any interactions with your Pins – this includes saves, Pin clicks, outbound clicks, carousel card swipes, secondary creative (collections) clicks and Idea Pin forward/backward swipes. This metric captures all engagement for first order ad events (e.g., promoted pins). | int |
40 | engagement_2 | Engagements track any interactions with your Pins – this includes saves, Pin clicks, outbound clicks, carousel card swipes, secondary creative (collections) clicks and Idea Pin forward/backward swipes. This metric captures all engagement for secondary or earned events (i.e., saved instances of promoted pins). | int |
41 | video_mrc_views_2 | The number of times your video ad played continuously for 2 seconds while at least 50% in view after being saved to another person’s board. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | int |
42 | video_avg_watchtime_in_second_2 | The average time people watched your video. This includes people who rewatch your video in the same day. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | float |
43 | video_p0_combined_2 | The number of times the non-ad Pin version of your video played while at least 50% in view, but did not reach 25% played. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | int |
44 | video_p25_combined_2 | The number of times the non-ad version of your Pin played at least a quarter of the content while at least 50% in view. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | int |
45 | video_p50_combined_2 | The number of times the non-ad version of your Pin played at least half the content while at least 50% in view. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | int |
46 | video_p75_combined_2 | The number of times the non-ad version of your Pin played at least three quarters of the content while at least 50% in view. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | int |
47 | video_p95_combined_2 | The number of times the non-ad version of your Pin played at least 95% of the content while at least 50% in view. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | int |
48 | video_p100_complete_2 | The number of times the non-ad Pin version of your video played completely while at least 50% in view. Note that metrics ending in _2 refer to actions taking on an organic (non-ad) Pin. | int |
49 | total_conversions | The total number of conversions across all conversion objectives | int |
50 | total_conversions_quantity | The total order quantity across all conversion objectives | int |
51 | 1d_view | The count of conversions within the specified lookback window | dict |
52 | 1d_click | The count of conversions within the specified lookback window | dict |
53 | 1d_engagement | The count of conversions within the specified lookback window | dict |
54 | 7d_view | The count of conversions within the specified lookback window | dict |
55 | 7d_click | The count of conversions within the specified lookback window | dict |
56 | 7d_engagement | The count of conversions within the specified lookback window | dict |
57 | 14d_view | The count of conversions within the specified lookback window | dict |
58 | 14d_click | The count of conversions within the specified lookback window | dict |
59 | 14d_engagement | The count of conversions within the specified lookback window | dict |
60 | 30d_view | The count of conversions within the specified lookback window | dict |
61 | 30d_click | The count of conversions within the specified lookback window | dict |
62 | 30d_engagement | The count of conversions within the specified lookback window | dict |
63 | 60d_view | The count of conversions within the specified lookback window | dict |
64 | 60d_click | The count of conversions within the specified lookback window | dict |
65 | 60d_engagement | The count of conversions within the specified lookback window | dict |
66 | rb_sync_id | Identifier used by Rockerbox to sync dataset to your warehouse | str |
67 | updated_at | timestamp |