Apple Ads
06:30
Written to Campaign spend
Apple Ads to Google Sheets
Spend, taps and installs from your App Store campaigns, refreshed on a schedule. By campaign, ad group, keyword or search term.
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
Apple Ads
06:31
Written to Keyword installs
Apple Ads
06:32
Written to Search terms
What lands in your spreadsheet
Day, campaign, ad group, keyword and search term, with country and device if you want them. Impressions, taps, installs, new downloads and redownloads, spend, cost per tap and cost per install. Money arrives in your ad account's currency.
DayCampaignCampaign IDAd groupAd group IDKeywordMatch typeKeyword IDSearch termSearch term sourceCountry or regionDevice
ImpressionsTapsTap-through rateSpendAverage cost per tapAverage cost per thousand impressionsCost per tap installAverage cost per installTap installsView installsTotal installsNew downloadsRedownloadsTap install rateTotal install rate
What lands
- Each report owns a tab, and everything in it is replaced on every refresh. Nothing else in the spreadsheet is touched.
- It runs whether the spreadsheet is open or not. Refreshes happen on our servers, so the numbers are current when you open the file, not when you remember to.
Want it in BigQuery as well? See Apple Ads to BigQuery.
Setting it up
Connecting takes a minute
- 01In Sources, click Sign in with Apple and sign in as an Apple Ads Admin or Campaign Group Manager.
- 02Build a report, choose the ad account, pick your fields and set a schedule.
- 03Say which tab it writes to and how often it refreshes.
Access
What it can see, and what it cannot
Fresh Sheets only reads. Your Apple role may be able to change campaigns, but our code only ever requests reports and lists of ad accounts and campaigns.
Pricing
Start on Plus, and decide later
30 days of Plus, free, no card. Then one report keeps refreshing weekly.
How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
FAQ
Questions
How often can it refresh?
As often as your plan allows. How often depends on your plan: every day on Plus, every 6 hours on Pro and every hour on Max.
Does it read Apple Maps campaigns?
No. Fresh Sheets reads App Store campaigns only.
Get Apple Ads into your spreadsheet
Try it free for 30 days.