Connect Pinterest Ads to Azure with Windsor.ai

pinterest Field Reference logo

+

azure logo 2

Stream all your marketing data from Pinterest Ads to Azure

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 Azure

Azure or Microsoft Azure is a cloud computing offering which allows management and hosting on Microsoft Managed data centers. It is used for business critical applications. In combination with Windsor.ai it allows joining marketing, analytics and CRM data to gain deeper insights.

First step:

You need to select Pinterest ads as a Data Source and Grant Access to Windsor.ai.

Second Step:

you will need to go to Select  Destination and select Azur Blog Storage As A Data Destination.

Instruction

Create an Azure Blob Storage (or an Azure Synapse Analytics) resource on your Azure Portal and provide a connection string for it. Also, you may choose different container and blob names.

Visit Wiki page for details: https://wiki.windsor.ai/azure_blob_storage

You should also read:

Stream Your Data to Azure

Looker Studio Pinterest Ads Overview Report

Most Popular Social Media Marketing Templates for Looker Studio, Excel, and Power BI

Pinterest Ads metrics and dimensions available for streaming into Azure

NameTypeDescription
Account IDTEXTYour Pinterest Advertiser ID
Ad GroupTEXTAlias for ad group name.
Ad Group Entity StatusTEXTYour ad group entity status.
Ad Group IDTEXTYour ad group ID.
Ad Group NameTEXTYour ad group name.
Ad Group StatusTEXTYour ad group status.
Ad IDTEXTYour ad 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
NUMERICThe 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)
CTRPERCENTClick-through rate of clicks on your Pin to content on or off of Pinterest (paid and earned)
CurrencyTEXTAccount currency
DateDATEDate
Earned engagementsNUMERICEarned actions from ads saved to boards
NUMERICPaid 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
FrequencyNUMERICThe average number of times each user saw your ad.
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
NUMERICThe 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
NUMERICThe total number of clicks to the destination URL associated with your ad
Pin Promotion IDTEXTYour ad ID.
Ad nameTEXTName of your ad
Ad StatusTEXTAd status ('ACTIVE', 'OTHER', 'PAUSED')
User ReachNUMERICTotal number of unique users who saw your ads
ROASPERCENTThe 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 conversion value (Checkout) in microsNUMERICTotal value of checkout events resulting from clicks on your ad, in micros of 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)
Total video views.NUMERICTotal video views.
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 conversion value (Checkout) in microsNUMERICTotal value of checkout events resulting from views of your ad, in micros of 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 CostNUMERICThe 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
NUMERICNumber 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
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
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
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
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
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 Azure

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.