Home > Destinations > Power BI > AdsWizz

Connect AdsWizz to Power BI

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

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

Used by the world's leading companies

Get AdsWizz data into Power BI

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

Connect your data

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

AdsWizz metrics and dimensions available in Power BI

Access 59 metrics and 102 dimensions from AdsWizz connectors including Total Impressions, Audio Impressions, Clicks, CTR, Total Conversions, Conversion Rate, Return on Ad Spend, Total Reach - Unique Users, Campaign, Advertiser, Ad, Date, Geo - Country, Device Type, Publisher, Ad format and more.

59

Available metrics

102

Available dimensions

How to connect AdsWizz to Power BI ?

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

Step one

Authorize AdsWizz

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

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

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

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

Connect AdsWizz in Catchr using an API key with reporting access and select the advertiser. In Catchr’s Power BI query builder, select Audio Impressions and campaign delivery for a completed period 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 audio delivery versus companion-display activity clear in the model.

Which audio advertising metrics can I use in my AdsWizz dashboard?

The Catchr catalog includes Audio Impressions, Total Impressions, Total Reach - Unique Users, LTR/VTR, audio quartiles and clicks. It also includes companion-banner, Second Screen, ShakeMe and conversion fields where those features and measurements apply. Keep audio delivery separate from companion display activity so a combined impression total does not look like a count of audio listens.

What is the difference between listen-through rate and listen-through conversions?

Listen-through rate describes how much ad playback reached completion. Listen-through conversions describe downstream actions attributed to an audio exposure. A completed listen is not automatically a purchase or lead. Show LTR/VTR alongside the relevant conversion field, and use the Audio Pixel Action dimension when you need to identify the type of tracked outcome.

Can I measure AdsWizz conversions and return on ad spend?

Catchr's AdsWizz fields include Total Conversions, Click-Through Conversions, Listen-Through Conversions, View-Through Conversions, Conversion Value, CPA and Return on Ad Spend. Results depend on the attribution and measurement configured in AdsWizz, such as AudioPixel tracking. Connecting the reporting source does not create conversion tracking or recover untracked purchases. Confirm the action and monetary units before comparing these results with store revenue.

Why does an AdsWizz report fail when I add more dimensions?

AdsWizz reports limit the number of breakdowns in one request. Catchr already includes Advertiser, and adds a daily time breakdown when the query includes Date. Start with Date, a metric and one useful breakdown such as Campaign or Publisher. Split country, device and other analyses into separate charts if adding them together exceeds the reporting limit.

Why do AdsWizz totals or dates differ from my export?

Match the advertiser, metrics, filters and reporting period first. Catchr requests daily date windows in UTC, so an export using local dates can differ at the edges of the period. Compare the returned rows as well as the total. If rows are still missing with matching settings, send Catchr support the advertiser, dates and field selection so the report can be checked before you use it for billing or client reconciliation.

Can I add daily AdsWizz reach to get monthly unique listeners?

No. The same person may appear in several days, campaigns or publisher groups, so adding unique-user counts can double-count listeners. Request reach for the full period without a daily breakdown and verify it against the matching AdsWizz report. For cross-channel dashboards with Spotify Ads, keep each platform's reach separate unless you have a measurement method that deduplicates listeners across platforms.

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