How to export Apple Ads data to Sheets, Looker Studio or Tableau

Steps

1. Download a report by hand. On the Apple Ads site, open your campaigns, ad groups, keywords or search terms, pick the dates and download the table as a CSV. Custom reports under Reports give you more columns and a day-by-day split.
2. Load the CSV. Google Sheets: File › Import › Upload. Looker Studio: add data with the File Upload connector. Tableau: connect to a Text file. Each new week means a new download.
3. For a daily refresh, make an API user. In Apple Ads, go to Account Settings › API, invite an API user with the API Account Read Only role, and paste a public key you made (an EC P-256 key pair). Apple then shows a clientId, teamId and keyId.
4. Sign in from a script. Your script signs a short-lived client secret (a JWT, ES256) with the private key, swaps it for an access token at appleid.apple.com, and asks the Apple Ads API for a report per day. Build on the new Apple Ads Platform API: the older Campaign Management API v5 is switched off on 26 January 2027.
5. Write the rows where your report reads them. Append each day to a Google Sheet through the Sheets API, or to BigQuery or Postgres for Looker Studio and Tableau. Run it once a day, on a server, a cron job or a GitHub Action.

Why not Google Apps Script?

Apps Script can only sign with RSA keys, and Apple Ads wants an ES256 signature. That's why most Apple Ads exports run as a small Python or Node script somewhere else, or through a connector, rather than inside the spreadsheet.

Connectors

Data connector services such as Supermetrics and Windsor.ai sell ready-made Apple Ads connectors for Google Sheets, Looker Studio and Tableau. You sign in with Apple Ads and pick the columns; they refresh on a schedule. Worth it if you also pull other ad networks into the same report.

What the export won't tell you

• What people did after the install. Apple counts the install; whether they opened the app, came back or paid is in your app and in RevenueCat, not in Apple Ads.
• How the ads compare with every other download. App Store Connect has the total, Apple Ads has its part, and joining them by day, app and country is up to you.
• Days line up only roughly. Apple Ads uses your ad account's time zone and counts an install up to 30 days after the tap, so a day in Apple Ads and a day in App Store Connect rarely match exactly.

If what you want is "did the ads pay back?"

That's what Apparent does without a spreadsheet. Connect Apple Ads once and each campaign's spend sits on your app's own chart, next to every other download, and with RevenueCat it says who paid and whether the ads earned back what they cost.