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 |
Updated about 2 years ago