Pinterest | All Pins Standard Dataset
ChannelMix
This article details the dataset structure that Alight Analytics considers standard for the All Pins dataset from Pinterest. This report pulls all pins that have been interacted with in the past 90 days and metrics are broken about into different attribution windows. If a pin is not interacted with in the past 90 days, it will fall out of the dataset.
| Field | Type | Description |
| Report Date | Date | The date the data was pulled |
| Created At | Timestamp | The timestamp the pin was created |
| Pin Id | Dimension | The id of the pin |
| Pin Link | Dimension | The link to the pin |
| Description | Dimension | The description of the pin |
| Domain | Dimension | The domain the account is linked to |
| Is Downstream Promotion | Boolean | |
| Is Playable | Boolean | |
| Is Promotable | Boolean | |
| Is Repin | Boolean | |
| Is Uploaded | Boolean | |
| Is Video | Boolean | |
| Not Promotable Reason | Boolean | |
| Promoter Id | Dimension | |
| Comment Count | Number | The number of comments a pin has received |
| Repin Count | Number | The number of repins a pin has received |
| Title | Dimension | The title of the pin |
| Tracked Link | Dimension | |
| Tracking Params | Dimension | |
| Type | Dimension | |
| Video signature | Dimension | |
| attribution url | Dimension | |
| attribution author url | Dimension | |
| attribution provider name | Dimension | |
| attribution provider favicon url | Dimension | |
| attribution author name | Dimension | |
| attribution title | Dimension | |
| attribution provider icon url | Dimension | |
| pin stats type | Dimension | |
| last_updated_24h | Timestamp | The timestamp the metrics were last updated for the attribution window. |
| save_24h | Number | The number of saves over the last 24 hours |
| closeup_24h | Number | The number of closeups over the last 24 hours |
| impression_24h | Number | The number of impressions over the last 24 hours |
| clickthrough_24h | Number | The number of clickthroughs over the last 24 hours |
| last_updated_7d | Timestamp | The timestamp the metrics were last updated for the attribution window. |
| save_7d | Number | The number of saves over the last 7 days |
| closeup_7d | Number | The number of closeups over the last 7 days |
| impression_7d | Number | The number of impressions over the last 7 days |
| clickthrough_7d | Number | The number of clickthroughs over the last 7 days |
| last_updated_30d | Timestamp | The timestamp the metrics were last updated for the attribution window. |
| save_30d | Number | The number of saves over the last 30 days |
| closeup_30d | Number | The number of closeups over the last 30 days |
| impression_30d | Number | The number of impressions over the last 30 days |
| clickthrough_30d | Number | The number of clickthroughs over the last 30 days |
| last_updated_90d | Timestamp | The timestamp the metrics were last updated for the attribution window. |
| save_90d | Number | The number of saves over the last 90 days |
| closeup_90d | Number | The number of closeups over the last 90 days |
| impression_90d | Number | The number of impressions over the last 90 days |
| clickthrough_90d | Number | The number of clickthroughs over the last 90 days |
| Insert Date | Timestamp | ChannelMix Field: when the row was inserted into the dataset |
| ChannelMix Profile | Dimension | ChannelMix Field: the ChannelMix Profile associated to the data |