Apple Search Ads

The Apple Search Ads connector gets your Apple Search Ads data into Google Sheets and Google Data Studio. Use it to track your key metrics in a spreadsheet or a Google Data Studio report.
What you can report on
- Campaign impressions, taps, and installs
- Cost per tap (CPT) and cost per acquisition (CPA)
- Keyword performance and bid data
- Ad group and campaign-level spend breakdowns
- Conversion rates and install attribution
Prerequisites
- An Apple Search Ads account
- The API Account Manager or API Account Read Only role in Apple Search Ads. Only these two roles can generate API credentials. Standard and Account Admin roles cannot
- API access enabled in your Apple Search Ads settings
How to get your credentials
Apple Search Ads authenticates with a public/private key pair. Two Minute Reports generates the public key; you paste it into Apple Search Ads, and Apple gives you back the Client ID, Team ID and Key ID the connection needs.
Keep this page and the Two Minute Reports connection form open side by side. You copy a key out of one and paste three values back into the other.
Step 1: Set up an API user
Skip this step if you already sign in with an API Account Manager or API Account Read Only account.
- Sign in to your Apple Search Ads dashboard with your Account Admin account
- Select your account name (top right) › Settings
- Go to User Management › Invite User
- Enter the name and Apple ID of the person to invite
- Set the role to API Account Manager or API Account Read Only, then select Send Invite
- Ask them to accept the email invite. If they're new to Apple Search Ads, they complete signup first
Step 2: Generate the API credentials
- Go to ads.apple.com/advanced, select Sign In, then choose Advanced

- Sign in with your API Account Manager or API Account Read Only account

- Select your account name (top right) › Settings. You land on the API Credentials page

- In the Two Minute Reports connection form, select Copy under Public key

-----BEGIN PUBLIC KEY----- and -----END PUBLIC KEY----- lines. The pasted key needs a line break at the end, or authentication fails.- Paste it into the Public Key field on the Apple Search Ads API Credentials page, then select Save. On a new account where the key fields are empty, the button reads Generate API Client

- Apple generates and displays the Client ID, Team ID and Key ID
- Copy all three. You enter them in Two Minute Reports in the next section
How to create a connection
- In the Hub, open Connections & accounts.
- Select Create connection.
- Select Apple Search Ads in the connector list.
- Select Next.

- In Name the connection, enter a name.
- Enter the Client ID, Team ID and Key ID from Apple Search Ads. If you don't have them yet, see How to get your credentials.
- Select Test connection.

- Enable the accounts you want to report on.
- Select Done.

How to get Apple Search Ads data into Google Sheets or Google Data Studio
To get Apple Search Ads data into Google Sheets:
- In the Two Minute Reports sidebar, open Data Queries.
- Select Add.
- Select the accounts you want to report on. You can select more than one.
- Select your metrics and dimensions.
- Select the date range.
- Set sorting and filters if you need them.
- Select Run query. Two Minute Reports adds the data to your sheet.


To get Apple Search Ads data into Google Data Studio:
- In the Hub, open Google Data Studio › Apple Search Ads.
- Select Create report.

- Select or create a query config:
- To use a query config you have: select it in Choose your query config. Then select Save.
- To create a query config: if you already have one, first select Create new query config in the list. Enter a name in Name your query config, and select the accounts in Select your accounts. Select Save.


- Select Create from scratch. If templates show under Quick start from a template, you can select one instead.

- Looker Studio (formerly Google Data Studio) opens in a new tab, with the Two Minute Reports connector. If you are in more than one team, select your team in Select your Team.
- In Select Query Config, select your query config.
- Select Connect in the top-right corner.

- In your new report, add Apple Search Ads metrics and dimensions to the canvas.
