This article details the dataset structure that Alight Analytics considers standard for the Promoted Pins dataset from Pinterest. We pull this with a 1-day lag and a 30-day span daily. We can only pull data for the previous 365 days.
| Field | Type | Description |
| Report Date | Date | The date for the reported metrics |
| Campaign Id | Number | The Campaign Id for the promoted pin |
| Campaign Name | Percent | The Campaign Name for the promoted pin |
| Campaign Status | Number | The Campaign Status for the promoted pin |
| Ad Group Id | Percent | The Ad Group Id for the promoted pin |
| Ad Group Name | Number | The Ad Group Name for the promoted pin |
| Ad Group Status | Percent | The Ad Group Status for the promoted pin |
| Pin Id | Number | The Id for the pin |
| Pin Promotion Id | Number | The Id for the promoted pin |
| Pin Promotion Name | Percent | The Name of the pin promotion |
| Pin Promotion Status | Number | The Status of the pin promotion |
| Paid Clicks | Number | The total number of times people have clicked on your Pin to a destination on or off of Pinterest (Paid) |
| Earned Clicks | Datetime | The total number of times people have clicked on your Pin to a destination on or off of Pinterest (Earned) |
| Paid Closeups | Dimension | The total number of times people viewed a close-up version of your Pin (Paid) |
| Earned Closeups | Dimension | The total number of times people viewed a close-up version of your Pin (Earned) |
| Paid Engagements | Dimension | The total number of engagements on your Pins. This includes saves, closeups, link clicks, and carousel card swipes. |
| Downstream Engagements | Dimension | The total number of engagements on your Pins. This includes saves, closeups, link clicks, and carousel card swipes (Downstream) |
| Paid Impressions | Boolean | The total number of times your Pins were shown. |
| Earned Impressions | Boolean | The total number of times your Pins were shown. |
| Paid Saves | Boolean | The total number of times people saved your Pins to a board. |
| Earned Saves | Boolean | The total number of times people saved your Pins to a board. |
| Spend | Boolean | Total Spend for the promoted pin |
| Total Conversions | Dimension | |
| Paid Average Video Watch Time | Dimension | The average time someone spent watching your video (Paid) |
| Earned Average Video Watch Time | Dimension | The average time someone spent watching your video (Earned) |
| Paid Video Views | Dimension | The number of views for at least 2 seconds with 50% of video in view (Paid) |
| Earned Video Views | Dimension | The number of views for at least 2 seconds with 50% of video in view (Earned) |
| Video Starts | Dimension | The number of times your video was started |
| Earned Video Starts | Dimension | The number of times your video was started (Earned) |
| Video Watched At 100 Percent | Dimension | The number of times your video was viewed to 100% of its length |
| Earned Video Watched At 100 Percent | Dimension | The number of times your video was viewed to 100% of its length (Earned) |
| Video Watched At 25 Percent | Dimension | The number of times your video was viewed to 25% of its length |
| Earned Video Watched At 25 Percent | Dimension | The number of times your video was viewed to 25% of its length (Earned) |
| Video Watched At 50 Percent | Dimension | The number of times your video was viewed to 50% of its length |
| Earned Video Watched At 50 Percent | Dimension | The number of times your video was viewed to 50% of its length (Earned) |
| Video Watched At 75 Percent | Dimension | The number of times your video was viewed to 75% of its length |
| Earned Video Watches At 75 Percent | Dimension | The number of times your video was viewed to 75% of its length (Earned) |
| Video Watched At 95 Percent | Dimension | The number of times your video was viewed to 95% of its length |
| Earned Video Watched At 95 Percent | Dimension | The number of times your video was viewed to 95% of its length (Earned) |
| Insert Date | Timestamp | ChannelMix Field: when the row was inserted into the dataset |
| ChannelMix Profile | Dimension | ChannelMix Field: the ChannelMix Profile associated with the data |
Comments
Please sign in to leave a comment.