Apple Ads to BigQuery

App Store campaign performance in your own dataset, refreshed on a schedule.

30 days of Plus, free, no card. Then one report keeps refreshing weekly.

Apple Ads
06:00

Written to fs_spend_by_campaign

Apple Ads
06:01

Written to fs_keyword_installs

Apple Ads
06:02

Written to fs_search_terms

What lands in BigQuery

  • Include Day and history builds up. Each run replaces only its own dates.
  • Up to 10,000 rows a report.

In Sources, click Sign in with Apple and sign in as an Apple Ads Admin or Campaign Group Manager.

Which plans send to BigQuery

Every paid plan, and the free 30 days. Sending to BigQuery uses no extra refreshes: one run counts once, wherever it lands.

FAQ

Questions

Can it change my campaigns?

No. Fresh Sheets only requests reports and lists of ad accounts and campaigns, whatever your Apple role allows.

Send your Apple Ads reports to BigQuery

BigQuery is included in the free 30 days, then on every paid plan.