Home > Destinations > Power BI > Twitter Ads

Connect Twitter Ads to Power BI

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

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

Used by the world's leading companies

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

Twitter Ads metrics and dimensions available in Power BI

Access 277 metrics and 141 dimensions from Twitter Ads connectors including Conversion Purchases Total, Conversion Purchases Sale Amount, Mobile Conversion Purchases Total, Mobile Conversion Add To Carts Total, Mobile Conversion Checkouts Initiated Total, Date, Campaign Name, Ad Group Name, Ad Name, Campaign Effective Status, Account Name and more.

277

Available metrics

141

Available dimensions

How to connect Twitter Ads to Power BI ?

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

Step one

Authorize Twitter Ads

Connect Twitter Ads in Catchr with a Twitter 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
Twitter 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 Twitter 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.

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

Twitter 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 X Ads to Power BI?

Connect the X account that can access the advertising account through Catchr's Twitter Ads source. In Catchr’s Power BI query builder, select a daily campaign table 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 on-X placement scope and the exact conversion metric clear in the model.

Which X Ads metrics can I include in my report?

The connector requests engagement, billing, video, media, web conversion and mobile conversion data. You can report by account, campaign, ad group or promoted post using the fields available at that level. Choose metrics that match the campaign objective: an engagement campaign and an app campaign should not be judged by the same result column.

Are X Ads clicks the same as website link clicks?

No. X's Clicks metric includes interactions beyond visits to your website. URL clicks specifically measure clicks on an ad's link or Website Card, including earned clicks. For a traffic dashboard, use the link-click metric consistently in both CTR and cost-per-click calculations. Label engagement rate separately so a high interaction rate is not mistaken for a high website visit rate.

Does the Twitter Ads connector include all my organic posts?

This source is built around advertising accounts, campaigns and promoted posts. It is not a complete organic profile analytics feed. Use the separate Twitter public data source for its supported public account and post statistics, and keep those figures separate from paid reporting. A post appearing in an ads report does not make its metrics interchangeable with public lifetime counters.

How should I compare X Ads conversions with Google Analytics?

Compare a specific conversion event, not an unlabelled total of different actions. Check dates, attribution rules and whether you are reading web or mobile conversions, then reconcile the chosen event against an X Ads export. Google Analytics uses its own measurement and attribution, so totals can differ. Validate purchase counts and revenue units before using them in a client-facing CPA or ROAS calculation.

Why does my Power BI report differ from X Ads Manager?

Check the advertising account, campaign level, placement scope, date boundaries and exact metric name. Catchr's reporting requests use the on-X placement scope, so a differently scoped native report may not match. Compare daily rows over a completed period rather than just the grand total. If the first or last day appears shifted, or a conversion value is implausible, send Catchr the date range, field names and matching export for investigation before relying on the chart.

Does X Ads reporting update in real time?

Catchr retrieves reports through X's asynchronous analytics jobs: a report must finish before its results can be read. That is not a live event stream, and X can later revise historical figures, including billing adjustments. Allow the query to finish, refresh the dashboard when needed, and use completed periods for regular client comparisons rather than treating the current day's values as final.

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