Home > Destinations > Data Studio (ex Looker Studio) > Xandr

Connect Xandr to Data Studio (ex Looker Studio)

Connect Xandr to Data Studio (ex Looker Studio) and and build automated dashboards without CSV exports, spreadsheets, or manual API setup.

Looker Studio
Power BI
Google Sheets
BigQuery
Snowflake

Used by the world's leading companies

Why do agencies use Catchr for Xandr reporting in Data Studio (Looker Studio)?

Catchr lets media buyers and agencies stop rebuilding Xandr reports by hand: the data lands in Data Studio ready to chart, for every ad account you manage.

No manual csv export
‍

Stop downloading files from Xandr every time a client report, spreadsheet, or dashboard needs fresh numbers.

Connected in minutes

Your first Xandr report can be live in a few minutes. Authorize your Xandr account, pick your ad accounts, and your data source is ready.

Built for agencies with many Advertising accounts

Pull several Advertising accounts into one data source, then filter by account to build a report per client or brand in the same Data Studio file.

Xandr to Looker Studio 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

How to connect Xandr to Data Studio with Catchr?

To connect Xandr to Looker Studio (Data Studio), open the Catchr connector, authorize your Xandr account, select the ad accounts you want to report on, then create your report.

1. Open the Catchr Xandr connector in Looker Studio

Click the connector link to open it inside Looker Studio. You will be asked to authorize the connector before creating your data source.

2. Authorize Looker Studio (Data Studio) and Catchr

Choose the Google account you use for Looker Studio and authorize Catchr to create a secure Xandr data source.

3. Connect your Xandr account

Sign in with your Xandr account that has access to the accounts you want to report on. Make sure your user has the right Xandr permissions.

4. Select your Xandr accounts

Choose one or several Advertising accounts, depending on the report you want to build.

5. Create your Data Studio report

Click Create report, then add charts, scorecards, tables, filters, and date controls using your Xandr metrics and dimensions.

6. Customize your dashboard

Use Spend, Imps, Clicks, Ctr, Cpc, Cpm, Total Convs, Conv Rate, Total Revenue, Video Completion Rate, Date, Campaign Name, Line Item Name, Creative Name, Insertion Order Name, Geo Country Name, Media Type, Supply Type, Deal Name, Advertiser Currency and many more.

Xandr metrics and dimensions available in Data Studio

Access 57 metrics and 72 dimensions from Xandr connectors including Spend, Imps, Clicks, Ctr, Cpc, Cpm, Total Convs, Conv Rate, Total Revenue, Video Completion Rate, Date, Campaign Name, Line Item Name, Creative Name, Insertion Order Name, Geo Country Name, Media Type, Supply Type, Deal Name, Advertiser Currency and more.

57

Available metrics

72

Available dimensions

Build better Xandr dashboards in Data Studio (ex Looker Studio)

Use Catchr to create dashboards that show what is working, what is wasting budget, and where performance is changing.

Client reporting for agencies

Create clean Looker Studio dashboards for each client with with Spend, Imps, Clicks, Ctr, Cpc, Cpm, Total Convs, Conv Rate, Total Revenue, Video Completion Rate always up to date.

Budget pacing

Compare daily spend with the monthly budget of each campaign, so overspend shows up mid-month instead of on the invoice.

Review what drives results across

Compare to see where budget, traffic, or revenue is improving and where performance is dropping.

Compare with your other channels

Combine with your others marketing to understand performance across your full acquisition journey.

Keep an eye on Xandr performance

Track Xandr Spend, Imps, Clicks, Ctr, Cpc, Cpm, Total Convs, Conv Rate, Total Revenue, Video Completion Rate in refreshable Data Studio dashboards so you can spot changes before they become reporting problems.

Customer testimonials

What our customers say about us.

85 %
Faster
Reporting time

After three years of use, Catchr has become essential for both our teams and our clients. So far, it has been our best solution for compiling and analyzing data from different advertising platforms. It’s easy to set up, and the customer service is responsive and excellent.

Valentin Keravel
CEO, Laio – Agency

With Catchr’s automated API, we can finally collect and centralize all advertising data, connect it with booking information, and calculate the real ROAS for our restaurant clients. It gives them full visibility, more autonomy, and the ability to optimize campaigns to maximize ROI.

Corentin Largeron
Freelance
30
hours saved

The solution is a real game changer, providing optimal time savings for our data reporting. The major strength of the solution is their highly responsive and professional support.

Corentin Largeron
CEO at The Browz – Agency

Xandr to Data Studio (ex Looker Studio): FAQ

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

Can I still report on Xandr data after the Microsoft Invest transition?

Microsoft announced that media buying through Microsoft Invest would no longer be supported from February 28, 2026. Catchr's Xandr integration reads advertiser reports; it does not restore campaign buying. Reporting on an existing account depends on the API access and data Microsoft still makes available to that account. Confirm those permissions before relying on a new dashboard. Campaigns moved to Amazon DSP need that platform's separate connection.

How do I connect an existing Xandr account to Looker Studio?

If your Xandr reporting access is active, add Xandr in Catchr using the username and password of an account with API access. Then open the Catchr Xandr connector in Looker Studio and select an accessible advertiser. Create a simple daily report first and compare it with an available Xandr export. Microsoft Advertising search credentials are for a different platform and cannot substitute for Xandr credentials.

Which Xandr reports and dimensions does Catchr support?

The connector requests the Advertiser Analytics report for the selected advertiser. Its field catalog includes impressions, clicks, spend, conversions and video metrics, with campaign, insertion order, line item, creative, placement and deal dimensions. Use the ID alongside the name when comparing entities with similar names. This connection is not a general export of every Microsoft Monetize publisher report or every Xandr API dataset.

Why are older Xandr creative or placement details missing?

Microsoft's Advertiser Analytics documentation says creative, placement and brand detail is aggregated after 14 months. Older totals can therefore remain available without individual creative or placement rows. For historical comparisons, use a reporting level available throughout both periods. A connector cannot reconstruct detail that the reporting API no longer returns.

What is the difference between Xandr Spend and Spend Adv Curr?

Spend Adv Curr reports advertiser spend in the advertiser's preferred currency; include Advertiser Currency beside it. Media Cost measures impression purchase cost and should not be treated as an interchangeable spend total. Use the same cost field and currency for both your dashboard and reference export, especially when combining advertisers.

Why do Xandr conversions differ from Google Analytics?

Xandr exposes post-click and post-view conversions, while GA4 applies its own measurement and attribution rules. Separate those Xandr components before comparing them with GA4. Match dates and conversion events, and avoid adding the components to Total Convs again. Reporting several platforms together does not deduplicate the purchases they each claim.

How do I calculate Xandr viewability correctly?

Divide Imps Viewed by View Measured Imps to calculate viewability. Dividing by all impressions answers a different question because some impressions were not measured. Calculate the ratio from totals for the selected period, rather than adding daily percentages. Keep Video Completions separate: a completed video and a viewable impression measure different aspects of delivery.

Still have a question?

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