Connect Pinterest Ads to Google BigQuery with Windsor.ai

pinterest

+

bigquery

Stream all your marketing data from Pinterest Ads to Google BigQuery

About Pinterest Ads

Pinterest Ads is a social media advertising platform which allows businesses and individuals to advertise to their target audiences on Facebooks social media platform.

About Google BigQuery

Google BigQuery is a cloud based data warehouse. It allows flexible scaling and is a commonly used Platform as a Service solution.

Pinterest Ads metrics and dimensions available for streaming into Google BigQuery

NameTypeDescription
ClicksNUMERICThe Number of Clicks
ImpressionsNUMERICThe Number of Impressions Served
SpendNUMERICThe Media Spend
Total CostNUMERICThe Media Spend (Duplicate)
Account IDTEXTThe Account ID
CampaignTEXTThe Campaign Name
Campaign IDTEXTThe Campaign ID
DateDATEThe Date
ConversionsNUMERICThe Number of Attributed Conversions
Total RevenueNUMERICThe Attributed Revenue
Video Plays at 25 percentNUMERICThe number of times your video was played at 25% of its length.
Video Plays at 50 percentNUMERICThe number of times your video was played at 50% of its length.
Video Plays at 75 percentNUMERICThe number of times your video was played at 75% of its length.
Video Plays at 95 percentNUMERICThe number of times your video was played at 95% of its length.
Video Plays at 100 percentNUMERICThe number of times your video was played at 100% of its length.
Video PlaysNUMERICThe number of times your video starts to play.
Outbound ClicksNUMERICThe number of clicks on links that take people off Pinterest-owned properties.
EngagementsNUMERICThe total number of actions that people took on your Pinterest Page and its posts, attributed to your ads.
Promoted Pin NameTEXTThe name of the promoted pin / ad
Ad Network ConversionsNUMERICThe Ad Network Reported Conversions
Ad Network RevenueNUMERICThe Ad Network Reported Revenue
Add To Cart (Conversion Event)NUMERICItems added to shopping carts.
Checkout (Conversion Event)NUMERICCompleted transactions.
Custom Event (Conversion Event)NUMERICTracking for a special event that you want to include in your conversion reporting.
Lead (Conversion Event)NUMERICInterest in product or service.
Page Visit (Conversion Event)NUMERICInterest in product or service.
Search (Conversion Event)NUMERICWebsite searches.
Signup (Conversion Event)NUMERICSign ups for your products or services.
View Category (Conversion Event)NUMERICCategory page views.
Video Views (Conversion Event)NUMERICVideo views.

Windsor.ai: Easily connect Pinterest Ads to Google BigQuery

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.