Pinterest | Promoted Pins Standard Dataset

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
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.