Pinterest Ads & Power BI: How to integrate your data and template

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.

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.

• Change the export format by selecting "PowerBI".

• Under the 'Source' tab, choose 'Pinterest Ads' as your data source.

• Pick the specific Pinterest Ads account(s) you wish to analyze.

• Add the metrics and dimensions relevant to your analysis.

• Select your desired time range for data, either a set period or custom dates.

• If necessary, apply filters to refine your data request.

• You can also add platform-specific options to customize your request further.

• Your data request URL will be generated and displayed at the top. Preview your results before proceeding.

• Once satisfied, copy the URL to use in the next step.

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'.

• Paste the URL you copied from Catchr into the basic mode input box.

• 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.

‍