Pinterest | All Pins Standard Dataset

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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.