Two Minute Reports Logo
Connectors

Apple Search Ads

Connect Apple Search Ads to Google Sheets or Looker Studio

Two Minute Reports' Apple Search Ads connector lets you access and analyze your data directly in Google Sheets or Looker 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
  • API Account Manager or API Account Read Only user role — only these roles can generate the API credentials required to connect. Standard user roles cannot create API certificates.
  • API access enabled in your Apple Search Ads settings

How to get your API credentials from Apple Search Ads

Apple Search Ads uses a public/private key pair for authentication. TMR generates the public key — you paste it into your Apple Search Ads dashboard and retrieve the Client ID, Team ID, and Key ID.

Step 1: Set up an API user (if needed)

Only accounts with API Account Manager or API Account Read Only role can generate API credentials. Standard user roles and Account Admin roles cannot. If you don't already have an account with one of these roles, invite one from your Admin account:

  1. Log in to your Apple Search Ads dashboard with your Account Admin account
  2. Click your account name (top right) → Settings
  3. Go to User ManagementInvite User
  4. Enter the name and Apple ID of the user to invite
  5. Set the role to API Account Manager or API Account Read Only → click Send Invite
  6. The invitee accepts the email invite (they must complete Apple Search Ads signup if new)

Step 2: Generate the API credentials

  1. Go to ads.apple.com/advanced → click Sign In → choose Advanced

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

  1. Click your account name (top right) → Settings — you'll land on the API Credentials page

  1. In TMR's connection setup screen, copy the Public Key shown under Public Key to copy

Copy the entire public key including the -----BEGIN PUBLIC KEY----- and -----END PUBLIC KEY----- lines. The pasted key must have a line break at the end for authentication to succeed.
  1. Paste it into the Public Key field in the Apple Search Ads API Credentials page → click Save (or Generate API Client if the key fields are empty on a new account)

  1. After saving, the Client ID, Team ID, and Key ID are generated and displayed
  2. Copy the Client ID, Team ID, and Key ID — you'll enter these in TMR

How to create a connection

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

  1. Name the connection and enter the Client ID, Team ID, and Key ID you retrieved from the Apple Search Ads API Credentials page. How to get API credentials

After creating a connection:

  1. Enable the accounts you want to use from the available options

Important: Only enabled accounts can fetch data and count toward your plan usage. You can enable or disable accounts at any time in the hub to manage your plan usage efficiently.

How to get Apple Search Ads data into your reports

To pull Apple Search Ads data into Google Sheets:

  1. In the TMR sidebar, go to Data Queries and click Add
  2. Select the accounts you want to analyze (can select multiple)
  3. Choose your metrics and dimensions from available options
  4. Select the date range for your analysis
  5. Configure sorting and filtering options as needed
  6. Click Run Query to populate the data into Google Sheets

Copyright © 2026