Pinterest | Top Pins Standard Dataset
Matt Rodenberg
This article details the dataset structure that Alight Analytics considers standard for the Top Pins by Impressions dataset from Pinterest. This report pulls the top 100 pins for a specific day (or it could be a range of days if specified) sorted by the highest volume of impressions for that day. Currently, we are only able to pull the top 100 pins and this data is only available for the previous 6 months.
| Field | Type | Description |
| Report Date | Date | The date in which the top 100 pins data is being reported. |
| Closeup | 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). |
| Closeup Rate | Percent | This is the rate of closeups. |
| Engagement | Number | This is how many times the pin is interacted with including Saves, Closeups, and link Clicks |
| Engagement Rate | Percent | The rate at which the interactions occurred. |
| Clickthrough | Number | This is link clicks from the pin. |
| Clickthrough Rate | Percent | This is the rate of link clicks from the pin. |
| Impression | Number | This is how many times the pin is seen, including in-feed views, follower views, etc. |
| Save | Number | This is how many times the pin has been saved by other pinners. |
| Save Rate | Percent | This is the rate of saves. |
| Pin Repin Count | Number | The count of the pin repins |
| Pin Comment Count | Number | The count of the pin comments |
| Pin Created At | Datetime | The Date and Time that the Pin was created |
| Pin Title | Dimension | The Title of the Pin |
| Pin Description | Dimension | The Description of the Pin |
| Pin Type | Dimension | The type of Pin |
| Pin Id | Dimension | The Id of the Pin |
| Pin Is Repin | Boolean | Returns True or False if the pin was a repin |
| Pin Is Video | Boolean | Returns True or False if the pin was a video |
| Pin Is Playable | Boolean | Returns True or False if the pin was playable |
| Pin Is Promotable | Boolean | Returns True or False if the pin was is promotable |
| Pin Not Promotable Reason | Boolean | If the Pin is not Promotable then returns a |
| Pin Ad Creative Type | Dimension | The creative type for the pin |
| Pin Is Downstream Promotion | Boolean | Returns True or False if the pin was a downstream promotion |
| Pin Link | Dimension | The landing page included in the pin |
| Pin Domain | Dimension | The domain for the pin |
| Pin Cacheable Id | Dimension | The Cacheable id for the pin |
| Pin Price Currency | Dimension | The currency code for the price included in the pin |
| Pin Tracking Params | Dimension | Tracking parameters for the pin |
| Pin Tracked Link | Dimension | The tracked link for the pin |
| Pin Price Value | Dimension | The actual dollar amount for the price in the pin |
| Pin Is Uploaded | Dimension | Returns True or False if the pin was uploaded. |
| 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 |