Get Pinterest Ads data to Google Sheets

Easily automate and extract Pinterest Ads data to Google Sheets, simplifying data processing, visualization, integration with other sources, and collaboration with your team.

Why connect Pinterest Ads to Google Sheets

Access real-time performance metrics of your ads

Access real-time performance metrics of your ads

Automatically import data such as impressions, clicks, and conversions to get a real-time snapshot of your Pinterest ad performance. Monitor these metrics to understand the effectiveness of your ads and optimize your advertising strategy accordingly.

Create auto-updating reports for ad performance

Create auto-updating reports for ad performance

Generate an automatically updating list of Pinterest ad metrics in Google Sheets and create performance reports based on this data. Use these reports to analyze trends, identify successful ad campaigns, and plan future advertising strategies.

Combine Pinterest ad data with website analytics

Combine Pinterest ad data with website analytics

Pull Pinterest ad data into Google Sheets, add website analytics data, and analyze the combined data for a comprehensive understanding of your ad performance. This will help you understand the customer journey from ad click to website visit to conversion, enabling you to optimize your advertising strategy for better results.

Pinterest Ads to Google Sheets : what to export

Export all important Pinterest Ads Metrics and Dimensions for analysis in Google Sheets

Performance

Performance

Analyze how much you spent with amount spent, calculate the ROI with conversions, and track user engagement with total impressions. Monitor your campaigns' efficiency with CPC and clicks, and gauge ad frequency and reach. Know your promoted Pins' impact with paid clicks, conversions value, and CTR. Use these insights to optimize your ad strategy and increase your Pinterest ad campaign's success rate.

Conversion checkout

Conversion checkout

Analyze your Pinterest ad success with valuable checkout insights. Understand order values and quantities, click and view-through conversions, and ROAS to optimize your strategy. Learn which ads are driving sales and the value of each checkout event to achieve success. Use these insights to create data-driven reports and improve your operations.

Time

Time

Organize your data by the date and time they occurred using Pinterest Ads. Compare metrics daily, weekly, and monthly to gather valuable insights. Use these insights to create reports that can improve your marketing and advertising strategy. Remember to pay attention to weekly start dates, week numbers, and year-month numbers.

Conversions add to cart

Conversions add to cart

Analyze the add to cart conversions data to evaluate the impact of your ads. Track click and view-through conversions, conversion quantity, value and engagement, and web click or view-through conversions. Use these insights to optimize campaigns, allocate budgets, refine targeting and ad content, and to drive more clicks and conversions.

Campaign

Campaign

Identify campaign success by naming your campaigns for easy tracking, using unique IDs to avoid confusion, and keeping track of campaign statuses to ensure they're running smoothly. Knowing how your campaigns are performing is beneficial for improving operations and making informed decisions.

Ad

Ad

Track and update the name, status, ID, pin ID, creative type, and destination URL of promoted pins/ads to gain valuable insights into your Pinterest Ads performance. Use this data to generate reports and enhance your operations to increase engagement and drive conversions.

Video engagements

Video engagements

Maximize your Pinterest Ads strategy by analyzing video engagements, views, and completion rates. Gauge success in each category with metrics such as video starts, 100% and 50% completion rates, time spent watching and engagement. Use these insights to optimize campaigns, improve targeting, and increase ROI.

Account

Account

Identify your account name and unique identifier for tracking and monitoring purposes. Understand and gauge your audience's location with the country dimension. Benefit from using these metrics to optimize ads for a specific region or tailor ad content for audiences in a certain country.

Ad group

Ad group

Analyze your ad group's name and status to determine which groups are generating the most engagement. Use the unique ID to track performance over time and identify areas for improvement. With these insights, you can optimize ads and improve overall campaign success.

Conversions page visit

Conversions page visit

Track click-through conversions (page visits) to gain insights into the effectiveness of your promoted Pins in driving traffic to your website from Pinterest. These insights can help you identify what content works best and optimize your campaigns to reach your marketing goals. Use this data to create reports that guide your decision-making and improve your overall marketing strategy.

How to export Pinterest Ads to Google Sheets & automate it

Google Sheets
Step 1

Install Two Minute Reports (TMR) for Google Sheets

Open Google Sheets and install Two Minute Reports from the add-ons menu. No credit card required.

Step 2

Connect your Pinterest Ads with Two Minute Reports

Open TMR add-on and select Data Source from the menu button. Click Add and add your new Pinterest Ads data source

Step 3

Select the Pinterest Ads data you need

Open the Queries menu and create a new query. Select the Pinterest Ads data source you added along with the Pinterest Ads metrics and dimensions you want.

Step 4

Automate Schedules to Pinterest Ads export to Google Sheets

Create a new schedule to automatically fetch live data from Pinterest Ads at periodic intervals. You can even send emails, PDFs or Excel sheets on schedule.

Step 5

Skip steps and jump start Pinterest Ads with Templates

Instead of creating a report from scratch use our premade Pinterest Ads templates below and get started in no time

Start using these quick templates Now

Pinterest Ads - Campaign and Ad Analysis Report
Looker Studio

Automate Pinterest Ads to Google Sheets export & do more with Two Minute Reports

Two Minute Reports for Google Sheets has these features for you

Ease of Use

Ease of Use

Two Minute Reports is designed to be user-friendly and easy to navigate. With its intuitive interface, you can quickly generate reports and track your marketing campaigns without the need for extensive training or technical knowledge.

Battle tested by Millions of Users

Battle tested by Millions of Users

By working with BI platforms developed with Billions of Investment by Google - like Google Sheets and Looker Studio, Two Minute Reports provides robust capabilities and a secure infrastructure for your Reporting

Data Integration and more

Data Integration and more

Two Minute Reports integrates with Pinterest Ads and over 30+ Marketing platforms so that you can analyse and visualize your data in the BI platform of your choice.

Why use Two Minute Reports to import Pinterest Ads data to Google Sheets

Marketers know how critical it is for a business to correctly measure the performance of ad campaigns. Using standard Pinterest Ads tools, the in-line performance analytics are pretty straightforward. But things can change if you need to analyse custom metrics over an extended period. Generic Pinterest Ads dashboard tools are simply not intended for more detailed analysis that includes customizing filters and analysing the performance of multiple campaigns from multiple accounts. That is where Two Minute Reports steps in. Its Pinterest Ads to Google Sheets integration allows you to automate the process of extracting data from Ads on a custom schedule. You can merge data on multiple campaigns and ads in a single sheet, applying all the powerful tools Google provides. These include pivot tables, graph visualization, formulas, and team sharing capabilities.

Pinterest Ads

Pinterest Ads

88arrow
Google Sheets

Google Sheets

88arrow
fads

Manage, Share, Analyze

Do more with Google Sheets + Pinterest Ads

With Two Minute Reports, you can get Pinterest Ads data in Google Sheets and also merge it with other Advertising data from platforms like Facebook Ads, Google Ads, Linkedin Ads, Snapchat Ads, Tiktok Ads, Microsoft/Bing Ads, Pinterest Ads, Apple Search Ads, Amazon Ads. Not just that, you can also get data from different types of Mobile, Database, Advertising (PPC), Web Analytics, SEO, E-Commerce, Other sources, Social Media, Email, Customer relationship management Data Sources.

fads

Facebook Ads

gadw

Google Ads

lads

Linkedin Ads

snapads

Snapchat Ads

ttads

Tiktok Ads

Get Pinterest Ads data in other tools too

We also help get your Google Sheets to the following Tools

Looker Studio

Looker Studio

Two Minute Reports for Google Sheets helps you to get your Pinterest Ads data to Google Sheets. You can not just analyse data you do much more there. By running on top of Google Sheets, we support a range of customization options, including the ability to create custom formulas and functions, unlimited formatting and sharing capabilities, Google Sheets has a friendly interface that many of us are familiar with. Spreadsheets are easier to handle when you are looking at a lot of Data and you dont have to learn a new tool.

Connect other Ad Platform Data Sources with Google Sheets

You can combine data from other Ad data sources with your Pinterest Ads Reports

Image
Facebook Ads

Facebook Ads

Social media ad platform for targeted audience reach.

Google Ads

Google Ads

Advertising platform for displaying ads on Google's search results pages.

Linkedin Ads

Linkedin Ads

Professional social media platform's advertising data source.

Snapchat Ads

Snapchat Ads

Social media advertising platform for Snapchat users.

Connect other Marketing Channels with Google Sheets

You can combine Pinterest Ads data with not just Ad Platforms but also with other Platforms too

Mobile

Mobile

The category includes Data Sources like the Apple App Store and Google Playstore. That have information on apps that are provided to the data sources.

Database

Database

The category includes SQL based data sources connectors such as Cloud Firestore, MariaDB, MySQL, Postgre SQL.

Advertising (PPC)

Advertising (PPC)

This falls in the advertising category, more evidently Pay Per Click Connectors, for Facebook Ads, Google Ads, Snapchat Ads, LinkedIn Ads, TikTok Ads and Miicrosoft Ads

Web Analytics

Web Analytics

Data Sources like Google analytics, that analyzes the behaviour of visitors to a web site, falls in this category.