blog post

How to export your Pinterest Data to Google Sheets

Florian Cabirol
April 12, 2023
How to export your Pinterest Data to Google Sheets

In the digital marketing world of today, Pinterest ads are a must-have for businesses that want to increase their visibility, engagement, and sales. As a result, the need for efficient data management and analysis is more important than ever. In this blog post, we will explore how Catchr, a powerful add-on for Google Sheets, can help you export your Pinterest Ads data to Google Sheets for better organization, accessibility, and analysis.

About Pinterest

Businesses can advertise their products and services to people who are very interested in them by using Pinterest ads. Pinterest is a great way for businesses to reach more people and make more sales. It has more than 450 million active users. To get the most out of your advertising, you need to keep an eye on and analyze how it's doing. That's where Catchr comes in, enabling you to export Pinterest Ads data to Google Sheets for seamless data management and analysis.

Benefits of Exporting Pinterest Ads Data to Google Sheets

There are several advantages to exporting your Pinterest Ads data to Google Sheets. Some of these benefits include:

Improved data organization and accessibility : By exporting your Pinterest Ads data to Google Sheets, you can easily organize and access your data from a single platform. This means no more juggling between different tools and interfaces to analyze your ad performance.

Reports that can be changed and shared: Google Sheets lets you make reports that meet the needs of your business. You can also easily share these reports with your team, making collaboration a breeze.

Easier data analysis and visualization: With Google Sheets, you can use powerful data analysis features like pivot tables, charts, and conditional formatting. This lets you learn more about how your ads are performing and make better decisions about how to improve your Pinterest Ads campaigns. 

Seamless Integration with Other Data Sources: Thanks to Catchr, you can connect your Pinterest Ads data to other marketing platforms and data sources. This means you can analyze and optimize your overall marketing strategy from a single location.

Connecting Pinterest ads to Google Sheets with Catchr

Installing the Catchr Add-on for Google Sheets

To start exporting your Pinterest Ads data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheet to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheet:

  1. Open a new Google Sheet.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

Authenticating Pinterest ads 

Once the add-on is installed, open a new Google Sheet and launch the Add-on.

Open the Catchr add-on in Google Sheet.
Open the Catchr add-on in Google Sheet.

Once done, click on "Add new" and select Pinterest Ads. If you do not have account yep, just click on the "+". 

Select account f

Configuring your query to get data

Now that you've connected Pinterest ads to Google Sheets, it's time to customize your data export to suit your needs.

Select Account(s)

Go to the "Select account(s)" tab and choose the Pinterest Ads account(s) you want to use. You can select multiple accounts if needed.

Choosing the Right Pinterest Ad Metrics and Dimensions

In the "Metrics" and "Dimensions" tabs of the Catchr sidebar, select the Pinterest Ads data you want to export. You can choose from a wide range of metrics and dimensions, for example:

Metrics:

  • Spend: The total amount spent on your Pinterest Ads campaigns. 
  • Impressions: The number of times your ads were shown. 
  • Clicks: The number of clicks your ads received.

Dimensions:

  • Campaign Name: The name of the campaign in Pinterest Ads.
  • Ad Group Name: The name of the ad group within a campaign.
  • Pin ID: The unique identifier of the promoted Pin.

Setting the Date Range and Frequency of Data Updates

In the "Date Range" tab, select the time frame you want to export data for. You can choose from pre-set options like "Last month" and "This year" or set a custom date range. You can also set the frequency of data updates in the "Options" tab.

Date range for Pinterest Ads
Date range for Pinterest Ads

Applying Filters to Your Data

You can use filters to narrow down your data export to specific metrics or dimensions. To use a filter, in the Catchr sidebar, choose the right dimension or metric, the operator, and the value. 

For example, you can filter your data by:

  • Ad Group Name contains “Product A”
  • Spend more than 100
  • Impressions less than 1000

Scheduling Automated Data Exports

Set up automated data exports in the "Options" tab to save time and make sure your data is always up-to-date. You can choose from various scheduling options and activate features like "append rows" or "combine rows" for added flexibility.

Options for Pinterest Ads
Options for Pinterest Ads

Tips for Organizing and Analyzing Your Exported Data in Google Sheets

Once you have your Pinterest Ads data in Google Sheets, follow these tips to make the most of your data:

Using templates for better data visualization: Use the pre-built templates in Google Sheets to make reports that are both visually appealing and good at showing how your ads are doing. 

Utilizing formulas and conditional formatting: Use the powerful formulas and conditional formatting options in Google Sheets to automate calculations and bring attention to important data. 

Creating and using pivot tables for in-depth analysis: Pivot tables are an essential tool for analyzing large datasets. Create pivot tables to summarize and analyze your Pinterest Ads data for deeper insights.

Collaborating and Sharing Your Data with Your Team: Google Sheets makes it easy to share your data with your team. Collaborate in real-time and ensure everyone stays informed about your ad performance.

When you export your Pinterest Ads data to Google Sheets, you can better organize your data, make reports that fit your needs, and integrate it with other marketing platforms. With Catchr, you can easily export and analyze your data, which will help you make better decisions and improve the performance of your ads. So, don't wait - start exploring the possibilities of data integration and analysis with Catchr today!

Start your free-trial now

Get all your marketing data in your favorite data activation, database or reporting tools.

Move your

Data

 with Catchr