Home > Destinations > Power BI > Apple Search Ads

Connect Apple Search Ads to Power BI

Connect Apple Search 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.

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

Used by the world's leading companies

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

Apple Search Ads metrics and dimensions available in Power BI

Access 30 metrics and 106 dimensions from Apple Search Ads connectors including Local Spend Amount, Impressions, Taps, Installs, Conversion Rate, Tap-Through Rate (TTR), Average Cost Per Install Amount, Campaign Name, Ad Group Name, Keyword Text, Keyword Match Type, Search Term Source, Country Or Region, Day of the month and more.

30

Available metrics

106

Available dimensions

How to connect Apple Search Ads to Power BI ?

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

Step one

Authorize Apple Search Ads

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

Apple Search 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.

Apple Search 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 Apple Search Ads to Power BI?

Register the public key supplied by Catchr in Apple Ads, then enter the Client ID, Team ID and Key ID in Catchr. In Catchr’s Power BI query builder, select campaign delivery and installation metrics 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 app, reporting currency and the selected install attribution measure clear in the model.

Which Apple Search Ads metrics can I report on?

Catchr exposes impressions, taps, spend, tap-through rate, cost per tap, cost per acquisition, and download metrics. Campaign, ad-group, ad, and keyword information helps explain performance. Use compatible fields for the reporting level you choose and keep the spend currency visible when comparing accounts.

What is the difference between installs and new downloads?

Installs can include both new downloads and redownloads. New-download metrics isolate downloads classified as new, while redownload metrics describe users downloading an app they previously installed. Use the metric appropriate to acquisition or re-engagement, and keep the attribution basis consistent across the comparison.

Why do total installs differ from tap-through installs?

Total installs include tap-through and view-through downloads, while the tap-through measure covers installs attributed to ad taps. Catchr also exposes view-install fields. Do not add total installs to its component metrics, and match the same install definition when comparing cost per install with the Apple Ads interface.

Can I analyze keyword performance and Search Match?

Catchr exposes keyword reporting fields and the ad-group setting that indicates whether Search Match is enabled. Use these to organize keyword and ad-group analysis, but do not assume that a setting proves which search query produced every install. Keep campaign and ad-group IDs in your analysis when names are reused.

How should I calculate average cost per tap across campaigns?

Divide total spend by total taps, using a consistent currency. An unweighted average of campaign-level cost-per-tap values gives small campaigns the same influence as large ones. Apply the same principle to install costs: choose the intended install metric and divide the corresponding spend by that total.

Can I compare Apple Search Ads with app-store performance?

Yes. Add App Store Connect to compare advertising delivery with broader app performance. Align apps, countries, dates, and download definitions. App-store totals include activity beyond paid acquisition, so they should not be expected to equal ad-attributed installs.

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