Apple Ads Basic Sync

Overview

99.8% match with bank payout

Implementation

• Core sync logic: src/lib/server/apple-ads-basic-sync.ts
• CSV upload endpoint: src/routes/api/sync/apple-ads-basic/stream/

---

More details

Primary source: downloaded CSV files from Apple

• No API exists for this. So you need to download and upload the files manually.
• Accurate: 99.8% match with bank payment
  • but daily accuracy lost, because we evenly spread the monthly cost through days
• Available immediately
• Dates input for fetch: dates interval

How sync works TODO

How the accuracy was measured + ground truth data for testing

• Apple Ads Advanced cost - 3. feb 2025 - 30. Nov 2025 (UTC)
  • payment from bank account - 2594 € (apple invoiced us advanced + basic together for 21996 €, so I just proportionally scaled to get cost of Basic ads)
  • Apple oficial dashboard - 2588 €
  • reported by this finboard - 2588 €