Home > Destinations > Power BI > Pinterest Ads

Connect Pinterest Ads to Power BI

Connect Pinterest Ads to Power BI and and make the most of your data with direct integration into Power BI. Discover how to transfer, analyze, and visualize your marketing data to support better, data-driven decisions.

Pinterest Ads query · Power BI format
Ready to refresh
Pinterest Ads One source
Saved query API URL
Power BI Web · Import
Pinterest Ads accounts One or several selected accounts
Reporting grain Date · campaign · ad set · ad
Fields Selected metrics + dimensions
Date range Last 28 days · example preset
Filters Optional · query-specific
Power BI mode Import through Web (Basic)
One saved URL represents one Catchr source. Multiple Pinterest Ads accounts can share the query.

Used by the world's leading companies

Get Pinterest Ads data into Power BI

A no-code connection that works in Power BI Desktop and in the Power BI service.

Connect your data

Launch Pinterest Ads reporting faster

Skip ODBC drivers and custom API scripts. The connection runs from your browser and Power BI, with nothing else to install on your machine.

Automate extraction

Always work with fresh numbers

Once the report is published, Power BI calls your Facebook Ads query again on the schedule you choose, so weekly reviews start from current figures.

More than just one source

One query per source, one model for all your ads

Create a separate Catchr query for Google Ads, TikTok Ads, or GA4, load each table, and relate them in the same Power BI model.

Start with a template

Ready-to-use Power BI dashboards

Move faster with templates built for Advertising reporting in Power BI.

Use your Pinterest Ads data with ready-to-use dashboards for tracking performance, trends, and key indicators.

Pinterest Ads metrics and dimensions available in Power BI

Access 538 metrics and 126 dimensions from Pinterest Ads connectors including ROAS (Checkout), Web ROAS (Checkout), CPC, CPM, Paid CTR, Click-through conversions (Checkout), Campaign name, Ad Group Name, Ad Name, Ad Creative Type, Keyword, Placement, Day of the month and more.

538

Available metrics

126

Available dimensions

How to connect Pinterest Ads to Power BI ?

Four steps, from Catchr to a refreshed Power BI report.

Step one

Authorize Pinterest Ads

Connect Pinterest Ads in Catchr with a Pinterest Ads user that has access to the Advertising accounts you need, and make those accounts available for reporting.

Client A · Connected sources
5 sources ready
Pinterest Ads 3 advertising accounts Connected
Google Ads 2 advertising accounts Connected
Google Analytics 4 1 web property Connected
HubSpot 1 CRM portal Connected
Step two

Build and preview the query

Choose Power BI format, select Pinterest Ads, accounts, fields, date range, filters, and supported options. Preview the response, save the query, and copy its URL.

Step three

Use Get data > Web

In Power BI Desktop, choose Get data > Web, keep Basic selected, paste the complete Catchr URL, confirm, then load or transform the response.

Step four

Shape, model, and refresh

Clean the table in Power Query, add relationships and DAX measures, then publish the report and set its refresh schedule in the Power BI service.

YOUR NEXT REPORT

What you can build with Facebook Ads data in Power BI

Marketing performanceIllustrative data
Purchase value$38,400
Spend$12,000
ROAS3.20×
Purchase value & spend4 weeks
Week 1
Week 2
Week 3
Week 4
● Purchase value● Spend

ROAS and CPA as DAX measures

Define ROAS as purchase value divided by spend, and CPA as spend divided by purchases, once in the model, so every visual and filter uses the same calculation.

Pinterest Ads to Power BI pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

More Power BI connectors

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Pinterest Ads to Power BI: FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How do I connect Pinterest Ads to Power BI?

Authorize Pinterest advertising in Catchr and select the ad account. In Catchr’s Power BI query builder, select spend, impressions, outbound clicks and relevant conversion events and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping account, reporting currency and attribution definitions clear in the model.

What is the difference between Pin clicks and outbound clicks?

Pin clicks include interactions that open content on or off Pinterest. Outbound clicks specifically refer to the destination URL. Use outbound clicks when evaluating traffic sent to your website, and keep Pin clicks as a separate measure of engagement with the creative.

Can I separate paid and earned Pinterest activity?

Yes. Catchr's catalog includes separate paid and earned fields for clicks, saves and engagements. Keep them in distinct chart series when explaining the effect of advertising. Combining them without clear labels can make organic follow-on activity look like directly purchased delivery.

Should I count saves as conversions?

A save shows interest in returning to content; it is not automatically a purchase or lead. Report saves alongside outbound clicks and your chosen conversion event. Use the distinction to explain whether a campaign is encouraging discovery, site visits or a business outcome.

Why do Pinterest clicks not match GA4 sessions?

First compare outbound clicks rather than all Pin clicks. A click and a recorded session still differ because of page loading, tracking, consent and repeat visits. Add GA4 and align campaign tags and dates to investigate the gap.

How should I compare Pinterest creatives?

Compare ads with similar objectives and enough delivery to make the comparison meaningful. Show spend and impressions next to outbound clicks, saves and conversions. A creative with many saves may support discovery without being the strongest driver of immediate purchases.

Can I compare Pinterest-attributed purchases with Shopify sales?

Yes. Add Shopify to view store transactions alongside Pinterest performance. Match currency and period, and label the attribution setting used for Pinterest. Store revenue and platform-attributed revenue describe different views of the same business and should not be added together.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.

Your next report should not start with five exports

Connect your marketing platforms and build a data workflow your entire agency can use.

14 days free-trial
No credit-card required
100+ sources