blog post

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

Florian Cabirol
November 28, 2023
Explore your Pinterest Marketing Ads data with PowerBI : 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

The purpose of this tutorial is to guide you through the process of connecting your Pinterest Ads account to PowerBI through Catchr. By the end of this guide, you'll have a comprehensive understanding of how to visualize and analyze your marketing data from Pinterest Ads directly in PowerBI, enabling you to make informed, data-driven decisions.

How to Connect Your Pinterest Ads Account to PowerBI

Add a Source on Catchr

Start by navigating to the Catchr homepage and find the 'Source' option on the left menu pane. Click this and select 'Add a Source' in the upper right corner.

From there, choose Pinterest Ads from the list of available platforms and proceed with the authorization process to link Catchr with your Pinterest Ads account.

Add a Source on Catchr

Create the Request to Transfer Pinterest Ads Data to PowerBI

Follow this detailed process to set up the data transfer:

  • Access Catchr's API section from the left menu.
API Section on Catchr
  • Change the export format by selecting "PowerBI".
Selecting PowerBI Export Format
  • Under the 'Source' tab, choose 'Pinterest Ads' as your data source.
Selecting Pinterest Ads as Source
  • Pick the specific Pinterest Ads account(s) you wish to analyze.
Selecting a Pinterest Ads Account
  • Add the metrics and dimensions relevant to your analysis.
Selecting Metrics and Dimensions
Selecting Additional Metrics and Dimensions
  • Select your desired time range for data, either a set period or custom dates.
Choosing a Time Period
  • If necessary, apply filters to refine your data request.
Applying Filters to the Data Request
  • You can also add platform-specific options to customize your request further.
Adding Options to the Request
  • Your data request URL will be generated and displayed at the top. Preview your results before proceeding.
Previewing Data Request Results
Data Preview
  • Once satisfied, copy the URL to use in the next step.
Copying the Request URL

Note: Using a Catchr template? Make sure to include all required dimensions and metrics indicated on the template's information page. This will allow the template to populate correctly with your data.

Import the Pinterest Ads Data and KPIs to PowerBI

PowerBI Desktop: You're now going to import this data into PowerBI Desktop:

  • Launch the 'Get Data' feature and select 'Web'.
Getting Data from Web in PowerBI
  • Paste the URL you copied from Catchr into the basic mode input box.
Pasting Data Request URL
  • Confirm by clicking 'OK'.

PowerBI might take a moment to complete the data import. During this time, you have the opportunity to modify the data query, should it be necessary. Once you've imported your data, you can unleash the full potential of PowerBI to create insightful dashboards and reports to share with your team.

PowerBI Web App: To access data sets in the PowerBI Web App, first publish from the PowerBI Desktop. Then, in the web app, you can locate your data set and utilize it to build new reports.

This brief tutorial should have you well on your way to leveraging Pinterest Ads data within PowerBI for improved marketing insights.

Example of Metrics You Can Use with the PowerBI Integration for Pinterest Ads

The PowerBI integration for Pinterest Ads unleashes a vast array of metrics that can be visualized and subjected to analysis within PowerBI's robust environment. As a marketer, you can harness these metrics to gain insights into campaign performance, ad spend efficiency, and consumer engagement dynamics.

For instance, you might track the ROAS (Return on Ad Spend) and CPC (Cost per Click) across various campaigns to understand which creatives yield the best returns. Exploring metrics like Impressions, CTR (Click-Through Rate), and Saves could unveil opportunities for optimization, highlighting the content that resonates most with your audience.

Furthermore, PowerBI's ability to create custom dashboards means you can combine multiple metrics in meaningful ways to tell a more compelling data story. For a complete listing of available fields and metrics, you can visit Catchr's dedicated page for Pinterest Ads Metrics.

By immersing yourself in data-driven decision-making with PowerBI and Catchr, you're equipping your marketing team with the knowledge to steer strategies towards maximum impact and success.

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