Connect Pinterest Ads to Google Data Studio with Windsor.ai
Directly connect your Pinterest Ads data, in minutes, and in an easy-to-use format.
All your marketing data in one place, just in a few clicks.
In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.
Automate and save time.
No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Use all your data where and when you need it.
We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).
About Pinterest Ads
Pinterest Ads is an advertising platform developed by Pinterest, a visual discovery engine for discovering ideas, that allows businesses to reach out to the platform’s 400 million active users. Advertisers can utilize different targeting options based on demographics, interests, or search keywords with Pinterest Ads. The ads can be shown to users who are actively searching for products, as well as users who are passively browsing through their feeds.
Learn more about Pinterest Ads.
About Google Data Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Looker Studio.
Why integrate Pinterest Ads data with Google Data Studio?
- Integrating Pinterest Ads data with Looker Studio can help you gain a better understanding of how users interact with your pins and make more informed decisions about where to spend your advertising budget. Understanding which pins are most effective for your business allows you to further optimize those pins and increase your visibility on the platform.
- Looker Studio dashboards can assist you in automating the tracking of your campaign performance and key metrics. You can be able to measure the effectiveness of your Pinterest Ads campaigns in real-time.
- Using Looker Studio to visualize your Pinterest Ads data will help you discover insights that will enhance the success of your paid media campaigns on Pinterest and your entire paid media marketing strategy.
- Looker Studio has robust reporting features that make it simple to discover which advertisements are generating the most traffic and conversions.
About the Pinterest Ads - Google Data Studio Connector
The Pinterest Ads Looker Studio Connector pulls Metrics and Dimensions for Pinterest Ads. The Insights are retrieved at the campaign level. Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- A valid Pinterest Business account. (Visit our privacy policy and terms of use)
- Google account for Pinterest Ads to Looker Studio integration.
- A Windsor account. Start your free trial now.
How to connect Pinterest Ads data to Google Data Studio?
You need to select Pinterest Ads as a Data Source and grant access to Windsor.ai.
Select the fields on the right to later use in your data source. For example, you can include metrics such as Pin Clicks, ROAS, or Spend.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Windsor.ai: All your marketing data in one place
Power up your marketing performance with result-driven marketing solutions
- Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
- The setup is done in minutes. No coding is required.
- Currently, we support more than 3000 dimensions and metrics.
- See the value and return on every marketing touchpoint.
- Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.
Google Data Studio Templates for Pinterest Ads
Do you plan to connect and visualize your Pinterest Ads data in Looker Studio?
These free and customizable Looker Studio Pinterest Ads templates will assist you in visualizing your data for easy reporting and analysis.
Google Data Studio Tutorials for Pinterest Ads
Would you like to take your Looker Studio Pinterest Ads dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available Pinterest Ads Metrics and Dimensions
| Name | Type | Description |
|---|---|---|
| Account ID | TEXT | Your Pinterest Advertiser ID |
| Ad Group | TEXT | Alias for ad group name. |
| Ad Group Entity Status | TEXT | Your ad group entity status. |
| Ad Group ID | TEXT | Your ad group ID. |
| Ad Group Name | TEXT | Your ad group name. |
| Ad Group Status | TEXT | Your ad group status. |
| Ad ID | TEXT | Your ad ID. |
| Ad Network Conversions (alias for Conversions) | NUMERIC | Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction |
| Ad Network Revenue (alias for Total conversion value) | NUMERIC | The value from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| Advertiser ID | TEXT | Your Pinterest Advertiser ID |
| Campaign | TEXT | Alias for Campaign Name |
| Campaign ID | TEXT | Campaign ID |
| Campaign Name | TEXT | Campaign Name |
| Campaign Status | TEXT | Campaign status ('ADVERTISER_DISABLED', 'ARCHIVED', 'COMPLETED', 'NOT_STARTED', 'PAUSED', 'RUNNING') |
| Total number of Pin clicks (alias for Pin clicks) | NUMERIC | The total number of clicks on your Pin to content on or off of Pinterest (paid and earned) |
| Pin clicks | NUMERIC | The total number of clicks on your Pin to content on or off of Pinterest (paid and earned) |
| Earned Pin clicks | NUMERIC | Total number of Pin clicks from ads saved to another person's board |
| Paid Pin clicks | NUMERIC | The total number of clicks on your Pin to content on or off of Pinterest |
| CPA | NUMERIC | The average CPA for all event types using the Pinterest Tag integration after an ad interaction |
| Cost Per Click | NUMERIC | Cost-per-click (CPC) bidding means that you pay for each click on your ads |
| CPM | NUMERIC | Cost per 1000 impressions (paid and earned) |
| CTR | PERCENT | Click-through rate of clicks on your Pin to content on or off of Pinterest (paid and earned) |
| Currency | TEXT | Account currency |
| Date | DATE | Date |
| Earned engagements | NUMERIC | Earned actions from ads saved to boards |
| Paid engagements | NUMERIC | Paid actions taken as a result of your ads |
| Engagements (alias for Total Engagements) | NUMERIC | The total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves |
| Frequency | NUMERIC | The average number of times each user saw your ad. |
| Impressions | NUMERIC | Number of times someone saw your ad (paid and earned) |
| Earned impressions | NUMERIC | Total number of times your ad was viewed after being saved to another person's board |
| Paid impressions | NUMERIC | The number of times your ad was seen |
| Outbound clicks | NUMERIC | The total number of clicks to the destination URL associated with your ad (paid and earned) |
| Earned outbound clicks | NUMERIC | The total number of clicks to the destination URL associated with your ad saved to another person's board |
| Paid outbound clicks | NUMERIC | The total number of clicks to the destination URL associated with your ad |
| Pin Promotion ID | TEXT | Your ad ID. |
| Ad name | TEXT | Name of your ad |
| Ad Status | TEXT | Ad status ('ACTIVE', 'OTHER', 'PAUSED') |
| User Reach | NUMERIC | Total number of unique users who saw your ads |
| ROAS | PERCENT | The average ROAS from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| Spend | NUMERIC | The money you spend for promoted Pins, in account currency |
| Conversions (Add to cart) | NUMERIC | Total number of add to cart events resulting from interactions with your ad |
| Conversion value (Add to cart) | NUMERIC | Total value of add to cart events resulting from interactions with your ad, in account currency |
| Conversions (Checkout) | NUMERIC | Total number of checkout events resulting from interactions with your ad |
| Conversion value (Checkout) | NUMERIC | Total value of checkout events resulting from interactions with your ad, in account currency |
| Click-through conversions (Add to cart) | NUMERIC | The number of add to cart events resulting from clicks on your ad |
| Click-through conversion value (Add to cart) | NUMERIC | Total value of add to cart events resulting from clicks on your ad, in account currency |
| Click-through conversions (Checkout) | NUMERIC | The number of checkout events resulting from clicks on your ad |
| Click-through conversion value (Checkout) | NUMERIC | Total value of checkout events resulting from clicks on your ad, in account currency |
| Click-through conversion value (Checkout) in micros | NUMERIC | Total value of checkout events resulting from clicks on your ad, in micros of account currency |
| Click-through conversions (Custom) | NUMERIC | The number of custom events resulting from clicks on your ad |
| Click-through conversion value (Custom) | NUMERIC | Total value of custom events resulting from clicks on your ad, in account currency |
| Click-through conversions (Lead) | NUMERIC | The number of lead events resulting from clicks on your ad |
| Click-through conversion value (Lead) | NUMERIC | Total value of lead events resulting from clicks on your ad, in account currency |
| Click-through conversions (Page visit) | NUMERIC | The number of page visit events resulting from clicks on your ad |
| Click-through conversion value (Page visit) | NUMERIC | Total value of page visit events resulting from clicks on your ad, in account currency |
| Click-through conversions (Website search) | NUMERIC | The number of website search events resulting from clicks on your ad |
| Click-through conversion value (Website search) | NUMERIC | Total value of website search events resulting from clicks on your ad, in account currency |
| Click-through conversions (Signup) | NUMERIC | The number of signup events resulting from clicks on your ad |
| Click-through conversion value (Signup) | NUMERIC | Total value of signup events resulting from clicks on your ad, in account currency |
| Click-through conversions (Category view) | NUMERIC | The number of category view events resulting from clicks on your ad |
| Click-through conversion value (Category view) | NUMERIC | Total value of category view events resulting from clicks on your ad, in account currency |
| Click-through conversions (Watch video) | NUMERIC | The number of watch video events resulting from clicks on your ad |
| Click-through conversion value (Watch video) | NUMERIC | Total value of watch video events resulting from clicks on your ad, in account currency |
| Conversions | NUMERIC | Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction |
| Total conversion value | NUMERIC | The value from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| Conversions (Custom) | NUMERIC | Total number of custom events resulting from interactions with your ad |
| Conversion value (Custom) | NUMERIC | Total value of custom events resulting from interactions with your ad, in account currency |
| Total engagements | NUMERIC | The total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves |
| Engagement conversions (Add to cart) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total 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) | NUMERIC | Total number of lead events resulting from interactions with your ad |
| Conversion value (Lead) | NUMERIC | Total value of lead events resulting from interactions with your ad, in account currency |
| Conversions (Page visit) | NUMERIC | Total number of page visit events resulting from interactions with your ad |
| Conversion value (Page visit) | NUMERIC | Total value of page visit events resulting from interactions with your ad, in account currency |
| Conversions (Website search) | NUMERIC | Total number of website search events resulting from interactions with your ad |
| Conversion value (Website search) | NUMERIC | Total value of website search events resulting from interactions with your ad, in account currency |
| Conversions (Signup) | NUMERIC | Total number of signup events resulting from interactions with your ad |
| Conversion value (Signup) | NUMERIC | Total value of signup events resulting from interactions with your ad, in account currency |
| Total video played at 75% | NUMERIC | Total number of times your video ad played 75% of its length, including views that skipped ahead to this point (paid and earned) |
| Total video starts | NUMERIC | Total number of times your video ad started playing (paid and earned) |
| Total video played at 100% | NUMERIC | Total 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% | NUMERIC | Total 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% | NUMERIC | Total 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% | NUMERIC | Total 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. | NUMERIC | Total video views. |
| View-through conversions (Add to cart) | NUMERIC | Total number of add to cart events resulting from views of your ad |
| View-through conversion value (Add to cart) | NUMERIC | Total value of add to cart events resulting from views of your ad, in account currency |
| Conversions (Category view) | NUMERIC | Total number of category view events resulting from interactions with your ad |
| Conversion value (Category view) | NUMERIC | Total value of category view events resulting from interactions with your ad, in account currency |
| View-through conversions (Checkout) | NUMERIC | Total number of checkout events resulting from views of your ad |
| View-through conversion value (Checkout) | NUMERIC | Total value of checkout events resulting from views of your ad, in account currency |
| View-through conversion value (Checkout) in micros | NUMERIC | Total value of checkout events resulting from views of your ad, in micros of account currency |
| View-through conversions (Custom) | NUMERIC | Total number of custom events resulting from views of your ad |
| View-through conversion value (Custom) | NUMERIC | Total value of custom events resulting from views of your ad, in account currency |
| View-through conversions (Lead) | NUMERIC | Total number of lead events resulting from views of your ad |
| View-through conversion value (Lead) | NUMERIC | Total value of lead events resulting from views of your ad, in account currency |
| View-through conversions (Page visit) | NUMERIC | Total number of page visit events resulting from views of your ad |
| View-through conversion value (Page visit) | NUMERIC | Total value of page visit events resulting from views of your ad, in account currency |
| View-through conversions (Website search) | NUMERIC | Total number of website search events resulting from views of your ad |
| View-through conversion value (Website search) | NUMERIC | Total value of website search events resulting from views of your ad, in account currency |
| View-through conversions (Signup) | NUMERIC | Total number of signup events resulting from views of your ad |
| View-through conversion value (Signup) | NUMERIC | Total value of signup events resulting from views of your ad, in account currency |
| View-through conversions (Category view) | NUMERIC | Total number of category view events resulting from views of your ad |
| View-through conversion value (Category view) | NUMERIC | Total value of category view events resulting from views of your ad, in account currency |
| View-through conversions (Watch video) | NUMERIC | Total number of watch video events resulting from views of your ad |
| View-through conversion value (Watch video) | NUMERIC | Total value of watch video events resulting from views of your ad, in account currency |
| Conversions (Watch video) | NUMERIC | Total number of watch video events resulting from interactions with your ad |
| Conversion value (Watch video) | NUMERIC | Total value of watch video events resulting from interactions with your ad, in account currency |
| Total Cost | NUMERIC | The money you spend for promoted Pins, in account currency |
| Transaction Revenue (alias for Total conversion value) | NUMERIC | The value from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| Transactions (alias for Conversions) | NUMERIC | Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction |
| Earned video starts | NUMERIC | Total number of times your video ad started playing after it was saved to another person's board |
| Paid video starts | NUMERIC | Number of times your video ad started playing |
| Earned video played at 100% | NUMERIC | Total 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% | NUMERIC | Number of times your video ad reached 100% of its length, including views that skipped ahead to this point |
| Earned video played at 25% | NUMERIC | Total 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% | NUMERIC | Number of times your video ad reached 25% of its length, including views that skipped ahead to this point |
| Earned video played at 50% | NUMERIC | Total 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% | NUMERIC | Number of times your video ad reached 50% of its length, including views that skipped ahead to this point |
| Earned video played at 75% | NUMERIC | Total 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% | NUMERIC | Number of times your video ad reached 75% of its length, including views that skipped ahead to this point |
| Earned video played at 95% | NUMERIC | Total 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% | NUMERIC | Number of times your video ad reached 95% of its length, including views that skipped ahead to this point |