Pinterest | Organic Pin Analytics Dataset
Brendon Reimer
This article details the dataset structure that ChannelMix considers standard for the Organic Pin Analytics dataset from Pinterest. This dataset is used to define organic Pin analytics in ChannelMix OneViews. Data is pulled daily for the last 30 days with a 1 day lag.
| Field | Type | Description |
| Report Date | Date | The date in which the pin analytics were collected. |
| Pin Created At | Datetime | The date and time that the Pin was created. |
| Pin Board Owner Username | Text | The username for the owner of the Board where the Pin is found. |
| Pin Board Section ID | Text | The ID of the board section to which this Pin belongs. |
| Pin Board ID | Text | The ID of the board to which this Pin belongs. |
| Pin Parent Pin ID | Text | The source Pin id if this Pin was saved from another Pin. |
| Pin ID | Text | The ID of the Pin. |
| Pin Title | Text | The title of the Pin. |
| Pin Description | Text | The description of the Pin. |
| Pin Alt Text | Text | Optional text added to the Pin to explain what people can see in it. |
| Pin Has Been Promoted | Boolean | True/False; whether the Pin has been promoted. |
| Pin Link | Text | The URL of the Pin. |
| Pin External Link | Text | The URL of the external link included in the Pin. |
| Pin Note | Text | Private note for the Pin. |
| Pin Creative Type | Text | The creative type for the pin. |
| Pin Media Type | Text | The media type for the pin. |
| Pin Media Cover Image URL | Text | The URL for the cover image of the Pin. |
| Pin Media Images Originals URL | Text | The original URL of the media image in the Pin. |
| First of Mult Images URL | Text | The first image URL for a Pin that has multiple images (this situation is commonly seen with "Idea Pins"). |
| Impressions | Whole Number | This is how many times the pin is seen, including in-feed views, follower views, etc. |
| Pin Clicks | Whole Number | The total number of clicks on your Pin or ad so it opens in closeup. |
| Outbound Clicks | Whole Number | The number of times people perform actions that lead them to a destination off Pinterest.
Note: Outbound clicks are measured starting from the date the link is added. |
| Clickthroughs | Whole Number | This is link clicks from the pin. |
| Clickthrough Rate | Decimal | This is the rate of link clicks from the pin. |
| Closeups | Whole Number | This is how many times the pin has been clicked to close up and take over the screen(full page view of the pin). |
| Saves | Whole Number | This is how many times the pin has been saved by other pinners. |
| Save Rate | Decimal | This is the rate of saves. |
| User Follows | Whole Number | The number of times people followed you after viewing your Pin. |
| Profile Visits | Whole Number | The number of times people visited your profile after viewing your Pin. |
| Video MRC Views | Whole Number | Accredited video views following the standard of the Media Rating Council (MRC). The amount of views for at least 2 seconds with 50% of video in view. |
| Video Starts | Whole Number | The total number of video starts. |
| Video 10s Views | Whole Number | The number of times your video was viewed for at least 10 seconds or more. |
| Quartile 95 Percent Views | Decimal | The number of times your video was viewed to 95% of its length. |
| Full Screen Plays | Whole Number | The number of times your video was viewed after being expanded to full screen. |
| Full Screen Playtime | Decimal | The total amount of time a video Pin was played in full screen mode. |
| Video v50 Watch Time | Decimal | The total play time for your video in minutes. |
| Video Avg. Watch Time | Decimal | The average time someone spent playing the video and static image cards included in your Pin. |
| Pin Product Tags | Dimension | A list of dictionaries containing the details of the products that were tagged in the Pin. |
| Pin Is Standard | Boolean | True/False; whether the Pin is considered "standard" by Pinterest. Standard Pin size on Pinterest: 2:3 aspect ratio; 1000 pixels wide x 1500 pixels tall. |
| Pin Media Items | Text | A list of dictionaries containing the details of the media items included in the Pin (this situation is commonly seen with "Idea Pins"). |
| Pin Media Images 150x150 URL | Text | The URL of the media image in the Pin formatted as 150x150. |
| Pin Media Images 400x300 URL | Text | The URL of the media image in the Pin formatted as 400x300. |
| Pin Media Images 600x URL | Text | The URL of the media image in the Pin formatted as 600x. |
| Pin Media Images 1200x URL | Text | The URL of the media image in the Pin formatted as 1200x. |
| Insert Date | Timestamp | ChannelMix Field: when the row was inserted into the dataset. |
| ChannelMix Profile | Text | ChannelMix Field: the ChannelMix Profile associated with the data. |