Use the Apple Search Ads data source connector to create an overview dashboard to analyze the performance of all Apple Search Ads campaigns. You can combine the data from Apple Search Ads with data from other platforms, such as Facebook, Snapchat, and Pinterest.
For a full list of metrics and dimensions available in our Apple Search Ads data source connector, take a look at our Apple Search Ads documentation.
Once you've connected to Apple Search Ads, you're ready to create your first query in Google Sheets, Looker Studio (formerly Data Studio), or Excel.
Try these queries
See the following use cases for examples on how to use the metrics and dimensions.
See cost, impressions, installs, and taps on your ad
Take a look at your ad's performance this month. In this example, we take a look at the total cost of your ad campaigns, as well as impressions, installs, and taps for your ad.
The "Cost" metric shows the total spend of a campaign in the currency used in the campaign. The "Impressions" metric shows the number of times your ad appeared in App Store search results within the reporting time period. The "Installs" metric shows the total number of new downloads or redownloads resulting from an ad within the reporting period. Search Ads installs are attributed within a 30‑day tap-through window. The "Taps" metric shows the number of times your ad was tapped by users within the reporting time period.
For best results in Looker Studio, use the table chart type.
- Set the date range to This month to date.
- Select the Cost, Impressions, Installs, and Taps metrics.
See cost and installs last year and this year
Explore how much your ad campaigns have cost last year and this year to date and how many installs your app has gained.
The "Cost" metric shows the total spend of a campaign in the currency used in the campaign. The "Installs" metric shows the total number of new downloads or redownloads resulting from an ad within the reporting period. Search Ads installs are attributed within a 30‑day tap-through window.
For best results in Looker Studio, use the time series chart type.
- Set the date range to This year to date.
- Select the Cost and Installs metrics.
- Select the Year & month dimension to split the query results by year and month.
- Set the Comparison date range to Previous year.
See cost, impressions, installs, and taps per campaign, ad group, and date
In this example, we take a look at the cost, impressions, installs, and taps for your ad for the past 28 days. To get a better view of various campaigns, we view the data by campaign, ad group, and split the results by date.
The "Cost" metric shows the total spend of a campaign in the currency used in the campaign. The "Impressions" metric shows the number of times your ad appeared in App Store search results within the reporting time period. The "Installs" metric shows the total number of new downloads or redownloads resulting from an ad within the reporting period. Search Ads installs are attributed within a 30‑day tap-through window. The "Taps" metric shows the number of times your ad was tapped by users within the reporting time period.
For best results in Looker Studio, use the table chart type.
- Set the date range to Last 28 days.
- Select the Cost, Impressions, Installs, and Taps metrics.
- Select the Campaign name, Ad group, and Date dimensions to split the query results by campaign, ad group, and date.
Set up scheduled refreshes for your reports
You can set up scheduled refreshes for your reports created in Google Sheets and Excel. Follow the instructions on how to create and manage scheduled reports in Google Sheets and how to set up scheduled report triggers in Excel.
In Looker Studio, you can have a copy of your report emailed to you and important stakeholders at regular intervals.
More resources
You might also be interested in: