Two Minute Reports Logo
Connectors

Apple Search Ads

Connect Apple Search Ads to Google Sheets or Google Data Studio

Two Minute Reports' Apple Search Ads connector lets you access and analyze your data directly in Google Sheets or Google Data Studio. Build custom reports, monitor key metrics, and make data-driven decisions — all without writing any code.

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

  1. Sign in to your Apple Search Ads dashboard with your Account Admin account
  2. Select your account name (top right) › Settings
  3. Go to User Management › Invite User
  4. Enter the name and Apple ID of the person to invite
  5. Set the role to API Account Manager or API Account Read Only, then select Send Invite
  6. 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

  1. Go to ads.apple.com/advanced, select Sign In, then choose Advanced

  1. Sign in with your API Account Manager or API Account Read Only account

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

  1. In the Two Minute Reports connection screen, copy the key shown under Public Key to copy

Copy the whole key, including the -----BEGIN PUBLIC KEY----- and -----END PUBLIC KEY----- lines. The pasted key needs a line break at the end, or authentication fails.
  1. 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

  1. Apple generates and displays the Client ID, Team ID and Key ID
  2. Copy all three. You enter them in Two Minute Reports in the next section

How to create a connection

  1. Go to https://hub.twominutereports.com/connections
  2. Select New Connection
  3. Select Apple Search Ads from the list of connectors

  1. Name the connection, then 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

  1. Enable the accounts you want to report on

Only enabled accounts fetch data, and only enabled accounts count toward your plan. You can enable or disable accounts at any time on the Connections page.

How to get Apple Search Ads data into your reports

To pull Apple Search Ads data into Google Sheets:

  1. In the Two Minute Reports sidebar, go to Data Queries and select Add
  2. Select the accounts you want to analyze. You can select more than one
  3. Choose your metrics and dimensions
  4. Select the date range
  5. Set sorting and filtering if you need them
  6. Select Run Query to pull the data into Google Sheets

Copyright © 2026