Connect Pinterest Ads to Snowflake with Windsor.ai

pinterest

+

snowflake

Stream all your advertising data from Pinterest Ads to Snowflake

About Pinterest Ads

Pinterest Ads is an advertising service on the Pinterest platform which offers markteres to run awareness and consideration campaigns. It also allows marketers to promote their pins. The platform is designed to promote product and gift ideas via its social marketplace.

About Snowflake

Snowflake is a cloud data warehouse. Contrary to on premise data bases it eliminates the need to maintain hardware infrastructure. I’s architecture allow it to scale dynamically depending on the resource consumption needed by the users. The outcome of working with a cloud data warehouse like Snowflake is a greatly increased productivity of end users working with Snowflake data.

Pinterest Ads metrics and dimensions available for streaming into Snowflake

NameTypeDescription
Account ID (alias for Advertiser ID)TEXTYour Pinterest Advertiser ID
Ad Network Conversions (alias for Conversions)NUMERICTotal number of conversions for all event types using the Pinterest Tag integration after an ad interaction
Ad Network Revenue (alias for Total conversion value)NUMERICThe value from web conversions from your promoted Pins, including both first-order and downstream, in account currency
Advertiser IDTEXTYour Pinterest Advertiser ID
CampaignTEXTAlias for Campaign Name
Campaign IDTEXTCampaign ID
Campaign NameTEXTCampaign Name
Campaign StatusTEXTCampaign status ('ADVERTISER_DISABLED', 'ARCHIVED', 'COMPLETED', 'NOT_STARTED', 'PAUSED', 'RUNNING')
Total number of Pin clicks (alias for Pin clicks)NUMERICThe total number of clicks on your Pin to content on or off of Pinterest (paid and earned)
Pin clicksNUMERICThe total number of clicks on your Pin to content on or off of Pinterest (paid and earned)
Earned Pin clicksNUMERICTotal number of Pin clicks from ads saved to another person's board
Paid Pin clicksNUMERICThe total number of clicks on your Pin to content on or off of Pinterest
CPANUMERICThe average CPA for all event types using the Pinterest Tag integration after an ad interaction
Cost Per ClickNUMERICCost-per-click (CPC) bidding means that you pay for each click on your ads
CPMNUMERICCost per 1000 impressions (paid and earned)
CTRNUMERICClick-through rate of clicks on your Pin to content on or off of Pinterest (paid and earned)
DateDATEDate
Earned engagementsNUMERICEarned actions from ads saved to boards
Paid engagementsNUMERICPaid actions taken as a result of your ads
Engagements (alias for Total Engagements)NUMERICThe total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves
ImpressionsNUMERICNumber of times someone saw your ad (paid and earned)
Earned impressionsNUMERICTotal number of times your ad was viewed after being saved to another person's board
Paid impressionsNUMERICThe number of times your ad was seen
Outbound clicksNUMERICThe total number of clicks to the destination URL associated with your ad (paid and earned)
Earned outbound clicksNUMERICThe total number of clicks to the destination URL associated with your ad saved to another person's board
Paid outbound clicksNUMERICThe total number of clicks to the destination URL associated with your ad
Ad IDTEXTYour ad ID.
Ad nameTEXTName of your ad
Ad StatusTEXTAd status ('ACTIVE', 'OTHER', 'PAUSED')
ROASNUMERICThe average ROAS from web conversions from your promoted Pins, including both first-order and downstream, in account currency
SpendNUMERICThe money you spend for promoted Pins, in account currency
Conversions (Add to cart)NUMERICTotal number of add to cart events resulting from interactions with your ad
Conversion value (Add to cart)NUMERICTotal value of add to cart events resulting from interactions with your ad, in account currency
Conversions (Checkout)NUMERICTotal number of checkout events resulting from interactions with your ad
Conversion value (Checkout)NUMERICTotal value of checkout events resulting from interactions with your ad, in account currency
Click-through conversions (Add to cart)NUMERICThe number of add to cart events resulting from clicks on your ad
Click-through conversion value (Add to cart)NUMERICTotal value of add to cart events resulting from clicks on your ad, in account currency
Click-through conversions (Checkout)NUMERICThe number of checkout events resulting from clicks on your ad
Click-through conversion value (Checkout)NUMERICTotal value of checkout events resulting from clicks on your ad, in account currency
Click-through conversions (Custom)NUMERICThe number of custom events resulting from clicks on your ad
Click-through conversion value (Custom)NUMERICTotal value of custom events resulting from clicks on your ad, in account currency
Click-through conversions (Lead)NUMERICThe number of lead events resulting from clicks on your ad
Click-through conversion value (Lead)NUMERICTotal value of lead events resulting from clicks on your ad, in account currency
Click-through conversions (Page visit)NUMERICThe number of page visit events resulting from clicks on your ad
Click-through conversion value (Page visit)NUMERICTotal value of page visit events resulting from clicks on your ad, in account currency
Click-through conversions (Website search)NUMERICThe number of website search events resulting from clicks on your ad
Click-through conversion value (Website search)NUMERICTotal value of website search events resulting from clicks on your ad, in account currency
Click-through conversions (Signup)NUMERICThe number of signup events resulting from clicks on your ad
Click-through conversion value (Signup)NUMERICTotal value of signup events resulting from clicks on your ad, in account currency
Click-through conversions (Category view)NUMERICThe number of category view events resulting from clicks on your ad
Click-through conversion value (Category view)NUMERICTotal value of category view events resulting from clicks on your ad, in account currency
Click-through conversions (Watch video)NUMERICThe number of watch video events resulting from clicks on your ad
Click-through conversion value (Watch video)NUMERICTotal value of watch video events resulting from clicks on your ad, in account currency
ConversionsNUMERICTotal number of conversions for all event types using the Pinterest Tag integration after an ad interaction
Total conversion valueNUMERICThe value from web conversions from your promoted Pins, including both first-order and downstream, in account currency
Conversions (Custom)NUMERICTotal number of custom events resulting from interactions with your ad
Conversion value (Custom)NUMERICTotal value of custom events resulting from interactions with your ad, in account currency
Total engagementsNUMERICThe total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves
Engagement conversions (Add to cart)NUMERICTotal number of add to cart events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Add to cart)NUMERICTotal value of add to cart events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Checkout)NUMERICTotal number of checkout events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Checkout)NUMERICTotal value of checkout events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Custom)NUMERICTotal number of custom events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Custom)NUMERICTotal value of custom events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Lead)NUMERICTotal number of lead events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Lead)NUMERICTotal value of lead events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Page visit)NUMERICTotal number of page visit events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Page visit)NUMERICTotal value of page visit events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Website search)NUMERICTotal number of website search events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Website search)NUMERICTotal value of website search events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Signup)NUMERICTotal number of signup events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Signup)NUMERICTotal value of signup events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Category view)NUMERICTotal number of category view events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Category view)NUMERICTotal value of category view events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement conversions (Watch video)NUMERICTotal number of watch video events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Engagement value (Watch video)NUMERICTotal value of watch video events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves.
Conversions (Lead)NUMERICTotal number of lead events resulting from interactions with your ad
Conversion value (Lead)NUMERICTotal value of lead events resulting from interactions with your ad, in account currency
Conversions (Page visit)NUMERICTotal number of page visit events resulting from interactions with your ad
Conversion value (Page visit)NUMERICTotal value of page visit events resulting from interactions with your ad, in account currency
Conversions (Website search)NUMERICTotal number of website search events resulting from interactions with your ad
Conversion value (Website search)NUMERICTotal value of website search events resulting from interactions with your ad, in account currency
Conversions (Signup)NUMERICTotal number of signup events resulting from interactions with your ad
Conversion value (Signup)NUMERICTotal value of signup events resulting from interactions with your ad, in account currency
Total video played at 75%NUMERICTotal number of times your video ad played 75% of its length, including views that skipped ahead to this point (paid and earned)
Total video startsNUMERICTotal number of times your video ad started playing (paid and earned)
Total video played at 100%NUMERICTotal number of times your video ad played 100% of its length, including views that skipped ahead to this point (paid and earned)
Total video played at 25%NUMERICTotal number of times your video ad played 25% of its length, including views that skipped ahead to this point (paid and earned)
Total video played at 50%NUMERICTotal number of times your video ad played 50% of its length, including views that skipped ahead to this point (paid and earned)
Total video played at 95%NUMERICTotal number of times your video ad played 95% of its length, including views that skipped ahead to this point (paid and earned)
View-through conversions (Add to cart)NUMERICTotal number of add to cart events resulting from views of your ad
View-through conversion value (Add to cart)NUMERICTotal value of add to cart events resulting from views of your ad, in account currency
Conversions (Category view)NUMERICTotal number of category view events resulting from interactions with your ad
Conversion value (Category view)NUMERICTotal value of category view events resulting from interactions with your ad, in account currency
View-through conversions (Checkout)NUMERICTotal number of checkout events resulting from views of your ad
View-through conversion value (Checkout)NUMERICTotal value of checkout events resulting from views of your ad, in account currency
View-through conversions (Custom)NUMERICTotal number of custom events resulting from views of your ad
View-through conversion value (Custom)NUMERICTotal value of custom events resulting from views of your ad, in account currency
View-through conversions (Lead)NUMERICTotal number of lead events resulting from views of your ad
View-through conversion value (Lead)NUMERICTotal value of lead events resulting from views of your ad, in account currency
View-through conversions (Page visit)NUMERICTotal number of page visit events resulting from views of your ad
View-through conversion value (Page visit)NUMERICTotal value of page visit events resulting from views of your ad, in account currency
View-through conversions (Website search)NUMERICTotal number of website search events resulting from views of your ad
View-through conversion value (Website search)NUMERICTotal value of website search events resulting from views of your ad, in account currency
View-through conversions (Signup)NUMERICTotal number of signup events resulting from views of your ad
View-through conversion value (Signup)NUMERICTotal value of signup events resulting from views of your ad, in account currency
View-through conversions (Category view)NUMERICTotal number of category view events resulting from views of your ad
View-through conversion value (Category view)NUMERICTotal value of category view events resulting from views of your ad, in account currency
View-through conversions (Watch video)NUMERICTotal number of watch video events resulting from views of your ad
View-through conversion value (Watch video)NUMERICTotal value of watch video events resulting from views of your ad, in account currency
Conversions (Watch video)NUMERICTotal number of watch video events resulting from interactions with your ad
Conversion value (Watch video)NUMERICTotal value of watch video events resulting from interactions with your ad, in account currency
Total Cost (alias for Spend)NUMERICThe money you spend for promoted Pins, in account currency
Transaction Revenue (alias for Total conversion value)NUMERICThe value from web conversions from your promoted Pins, including both first-order and downstream, in account currency
Transactions (alias for Conversions)NUMERICTotal number of conversions for all event types using the Pinterest Tag integration after an ad interaction
Earned video startsNUMERICTotal number of times your video ad started playing after it was saved to another person's board
Paid video startsNUMERICNumber of times your video ad started playing
Earned video played at 100%NUMERICTotal number of times your video ad reached 100% of its length after it was saved to another person's board, including views that skipped ahead to this point
Paid video played at 100%NUMERICNumber of times your video ad reached 100% of its length, including views that skipped ahead to this point
Earned video played at 25%NUMERICTotal number of times your video ad reached 25% of its length after it was saved to another person's board, including views that skipped ahead to this point
Paid video played at 25%NUMERICNumber of times your video ad reached 25% of its length, including views that skipped ahead to this point
Earned video played at 50%NUMERICTotal number of times your video ad reached 50% of its length after it was saved to another person's board, including views that skipped ahead to this point
Paid video played at 50%NUMERICNumber of times your video ad reached 50% of its length, including views that skipped ahead to this point
Earned video played at 75%NUMERICTotal number of times your video ad reached 75% of its length after it was saved to another person's board, including views that skipped ahead to this point
Paid video played at 75%NUMERICNumber of times your video ad reached 75% of its length, including views that skipped ahead to this point
Earned video played at 95%NUMERICTotal number of times your video ad reached 95% of its length after it was saved to another person's board, including views that skipped ahead to this point
Paid video played at 95%NUMERICNumber of times your video ad reached 95% of its length, including views that skipped ahead to this point

Windsor.ai: Easily connect Pinterest Ads to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.