blog post

Connect Pinterest Ads to Looker Studio : How-to, templates and metrics

Johan Chemin
November 21, 2023
Connect Pinterest Ads to Looker Studio : How-to, templates and metrics

Quick steps to create a Pinterest Ads report with Google Sheets:

You can easiliy create a Pinterest Ads report following this step :

  1. Get informations from the data integration from our Pinterest Ads connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

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 Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  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.

The tutorial

Quick steps to create a Pinterest Ads report with Looker Studio:

You can easiliy create a Pinterest Ads report following this step :

  1. Get informations from the data integration from our Pinterest Ads connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Pinterest Ads at the end of the page.

The tutorial

Quick steps to create a Pinterest Ads report with PowerBI:

You can easiliy create a Pinterest Ads report following this step :

  1. Get informations from the data integration from our Pinterest Ads connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Pinterest Ads at the end of the page.

The tutorial

Pinterest is a powerful social media platform. If you run an e-commerce website, you must post photos of your product and video of your business life. It's a great way to keep people hooked. You can also use Pinterest Ads to reach even more people easily. As you can even sell your product on the Pinterest app, this is an excellent way to raise your sales.

An excellent way to keep track of all your performance is to use a dashboarding tool, and that's where Looker Studio (formerly Google Data Studio) comes into place!

You can check for your ads performance, product sales, post-interaction... Create a beautiful personalized dashboard for you and your team, and find out what's best for your business and what to avoid!

We'll see in this tutorial how to connect your Pinterest Ads data to Looker Studio and how to start creating a report with your data. You'll also find a template for Pinterest Ads at the end of the article.

How to create your Pinterest Ads Looker Studio data sources?

The first thing to create in Looker Studio is a data source. You can then use this data source in a report to bring your data into charts.

To do so:

Click here to go to our Pinterest Ads connector for Looker Studio.

Click Authorize 3 times.

Login to Catchr
First Authorize: Login to Catchr

Authorize Catchr to connect to a Google account
Second authorize: Allow Catchr to connect to a Google account
Authorize Looker Studio and Catchr to connect to Facebook Ads.
Third Authorize: Authorize Looker Studio and Catchr to connect to Facebook Ads.

Select your account, configure your data source, and click Connect

Configure your Pinterest Ads data source
Select the options for your Pinterest Ads data source.

There are four options for this connector:

  • View Window Day: 1, 7, 30, or 60 days.
  • Engagement Window Day: 1, 7, 30, or 60 days.
  • Click Window Day: 1, 7, 30, or 60 days.
  • Conversion report time: On Add Action or On Conversion

The left column lets you choose the configuration for all the reports. The right column lets you set these options for every chart in your report.

Uncheck the Use report template for new report to start with a new blank report. You'll find a link and a tutorial to use a template at the end of this article.

Click Connect and Allow.

You just created your Pinterest Ads data sources using Catchr's connector!

You land on your data source configuration page. This is where all your available fields are. You can check for their default type and change it. For example, you can choose the currency sign for your currency metrics (be careful, Looker Studio only manages the sign, it won't transform one currency to another).

You can also rename existing or create new fields using fields and Google functions.

You can learn more information about this page in this detailed article.

How to use this data source in a report?

You can see a Create Report button on your data source page at the top right. Click on it to create a new report with your data source.

Create your Facebook Ads report from your Facebook Ads data source
Create your Facebook Ads report from your Facebook Ads data source

You'll land on a new page. This is the report creation interface. There is a complete explanation of this page in this article. You will learn the great section and how to use it quickly.

Ok, now we are ready to create a report, we need to choose which metrics (KPIs) and dimensions (Breakdown) I will use.

I want to learn how all my ads perform and check a breakdown by campaign and ads group.

So here are the metrics I will use:

  • Spend: what is my investment in Pinterest Ads
  • Impressions: How many times one of my ads was shown on screen.
  • Pin Clicks: How many clicks an ad receives after being shown.
  • CTR: Percent of people clicking an ad after seeing it.
  • CPC: Cost per click on ads.
  • Conversions: How many purchases do my ads generate.
  • Total Conversion Value: How much money did my Ads generate.
  • CPA: Cost per acquisition, how much money did one purchase cost.
  • ROAS: Return on ads spend, how many times my ads generate my investments.

And my the dimensions to breakdown the metrics:

  • Campaign name: the list of all my campaigns
  • Ads name: the list of all my ads.
  • Date: breakdown by date to have a vision month over month or week over week.

Our academy has a complete list of dimensions and metrics available in the Pinterest Ads connector.

We selected all the fields needed; now, let's create our report!

How to add charts to your report?

How to add a date range selector:

The first thing to add to a report is a date range selector. It will let you choose the period for the data of the entire data set.

To add a control field on period, proceed like this:

  • Click Add a Control in the shortcut bar.
  • Select Date Range Control.
  • Place the component in the report.
Add a date selector to your Looker Studio report.
Add a date selector to your Looker Studio report.

You can set a default date range, so your report always loads with the selected period. Check the only options in the configuration panel once the date range selector is clicked.

Change the default configuration of your data time selector.
Change the default configuration of your data time selector.

How to add scorecards:

We can start adding scorecards to display our general results.

  • Click on Add a chart.
  • Select Scorecard
  • Place it in the report.
  • In the right panel: Select Spend under Metrics.
Add a scorecard to display a global metric.
Add a scorecard to display a global metric.

Add the comparison features :

Add the comparison to the previous period to a Looker Studio chart.
Add the comparison to the previous period to a Looker Studio chart.

This display the total spend for your Pinterest Ads during the selected period.

You can add a style to this scorecard. Select the scorecard then:

  • Click on Style in the header of the right panel.
  • Change the font size to a bigger size.
  • Center the title and value.
  • Add border and radius.
Style your scorecard.
Style your scorecard.

Now that we have one scorecard styled, copy and paste it for every metric wanted. Then only change the metric used.

Copy your scorecard and change the metric.
Copy your scorecard and change the metric.

How to add tables?

Now let's break down our metrics by campaign and ad groups.

  • Click on Add a Chart, then Table.
  • Place it in the report.
  • In the configuration panel, under Dimensions, choose Campaign name.
  • Under Metrics, add all the metrics you want to break down by Campaign.
Add and configure a table
Add and configure a table

We just configured the table, now check the Style menu to add some styles you like, then copy and paste the table and change the dimensions to the Ads name.

Tips: Right-click on the table and look for Resize column, then select the best options!

How to add a time series?

Time series are great for visualizing data over time; we will use the Date dimensions.

  • Click Add a Chart, then Time series.
  • Place it in the report.
Add a time series to your report.
Add a time series to your report.

  • In the right panel, under Dimensions, choose Date. In the Metrics, choose Spend.
configure metrics and dimension for your time series.
configure metrics and dimension for your time series.

You now have the amount spent by day. You can add more metrics in this table, like the Total conversion value, to quickly check what you spend and earn.

How to add a dynamic filter?

You can add a dynamic filter to let viewers play with the data. You almost already know how to date if you set the date filter, as advised at the start of this tutorial.

To do so:

  • Click Add a control. Select the Dropdown list. Place it in the report.
  • Use the Campaign name in the dimension.
Add a dropdown selector to your Looker Studio report.
Add a dropdown selector to your Looker Studio report.

You can now dynamically filter your data in view mode! Try it by clicking the View button at the top right.

Bonus : Your free Pinterest Ads Overview v2 Template

In this Pinterest Ads template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

Bonus : Your free Pinterest Ads OverviewTemplate for PowerBI

In this Pinterest Ads template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Pinterest Ads

Explore your Pinterest Marketing Ads data with PowerBI : How-to, templates and metrics

Master the integration of Pinterest Ads data with PowerBI using Catchr in our easy-to-follow guide, and elevate your marketing analytics for strategic insights and decision-making.

Florian Cabirol

How to Use Pinterest Ads KPIs to Optimize Your Campaigns

If you are a business owner looking to 3x your brand's revenue, explore Pinterest Ads. And don't forget to learn how to measure Pinterest Ads KPIs in this blog.

Florian Cabirol

Connect Pinterest Ads to Looker Studio : How-to, templates and metrics

Discover the power of data-driven Pinterest Ads with Looker Studio. Learn how to create comprehensive reports, unlock insights, and optimize your advertising strategy for success.

Johan Chemin

How to export your Pinterest Data to Google Sheets

Elevate your Pinterest Ads data management & analysis with Catchr! Export data to Google Sheets for easy organization, collaboration, and visualization. Discover more benefits now!

Florian Cabirol