Home > Destinations > Power BI > StackAdapt

Connect StackAdapt to Power BI

Connect StackAdapt 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.

StackAdapt query · Power BI format
Ready to refresh
StackAdapt One source
Saved query API URL
Power BI Web · Import
StackAdapt 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 StackAdapt accounts can share the query.

Used by the world's leading companies

Get StackAdapt data into Power BI

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

Connect your data

Launch StackAdapt 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 StackAdapt data with ready-to-use dashboards for tracking performance, trends, and key indicators.

StackAdapt metrics and dimensions available in Power BI

Access 56 metrics and 34 dimensions from StackAdapt connectors including Cost, Impressions, Clicks, CTR, Conversions, Revenue, ROAS, Date, Campaign Name, Campaign ID, Campaign Group Name, Advertiser Name, Channel Name, Campaign Status and more.

56

Available metrics

34

Available dimensions

How to connect StackAdapt to Power BI ?

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

Step one

Authorize StackAdapt

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

Client A · Connected sources
5 sources ready
StackAdapt 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 StackAdapt, 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.

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

StackAdapt 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 StackAdapt to Power BI?

Use your StackAdapt API key to connect Catchr and select an accessible advertiser. In Catchr’s Power BI query builder, select Campaign Name, Impressions, Clicks and Cost 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 advertiser, reporting currency and conversion definitions clear in the model.

Which StackAdapt metrics can I use in my dashboard?

Catchr includes Cost, Impressions, Clicks, CTR, Conversions, Conversion Revenue, ROAS and efficiency measures such as eCPM and eCPA. It also exposes campaign groups, campaigns, channel names and campaign status, plus video and audio playback metrics. Choose fields that fit the channel and campaign goal; video or audio measures are not meaningful for every campaign.

Can I separate click-through and impression-based conversions?

Yes. The catalog includes Click Conversions and Impression Conversions, plus separate secondary-conversion fields. Match the conversion family to the outcome you are measuring and the StackAdapt column you are comparing. Do not add a total to its components or combine primary and secondary outcomes as if they were all purchases. Use clear labels when showing more than one conversion measure.

Why is Conversion Revenue different from Revenue?

Catchr exposes these as distinct StackAdapt fields. Use Conversion Revenue for the value associated with tracked conversion events, and confirm that values are configured for those events. Do not substitute the separate Revenue field simply because its name sounds similar. When validating ROAS, check the conversion value, cost basis and attribution settings used by the corresponding platform report.

Can I report on video and audio completion?

Yes. Video and audio each have starts, quartile playback counts, completions and completion-rate fields. Use the matching family for each channel and keep video and audio charts separately labelled. For a combined rate across campaigns, use matching total completions and starts rather than a simple average of campaign percentages; a low-volume campaign should not carry the same weight as a high-volume one.

Why do StackAdapt conversions differ from GA4?

StackAdapt and GA4 can credit different touchpoints, use different attribution windows and record different conversion events. Compare the same outcome and dates, then check whether StackAdapt includes impression-based conversions. Confirm tracking and event values before interpreting a gap as missing sales. A reporting connector retrieves platform results; it does not reconcile different attribution models automatically.

Can I combine StackAdapt with Google Ads in one dashboard?

Yes. Add the Google Ads connector alongside StackAdapt and align dates, currencies and cost definitions. Compare channel delivery and efficiency, while keeping attributed conversions identified by platform. For overall unique sales, use a consistent business-level source rather than summing conversion claims from platforms that may both credit the same purchase.

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