ROAS is only available for Apple Search Ads on iOS apps. Other ad networks are not attributed per install; see SKAdNetwork for their results.
Prerequisites
- Analytics turned on for an iOS app, with the SDK’s native module (Apple Search Ads attribution needs it).
- Apple Search Ads connected in Appeeky. See Apple Search Ads Credentials.
- RevenueCat connected and
identifycalled, so purchases reach the installs. See Revenue.
How It Works
- Appeeky takes the installs first seen in the selected period that came from Apple Search Ads, grouped by campaign id or keyword id.
- For each group, it adds up the revenue those installs have made so far, and the revenue they made within 1, 7 and 30 days of install.
- It reads Apple Search Ads spend and installs for the same dates and the same campaigns or keywords, limited to this app.
- It joins both sides on the Apple id.
Query parameters
Columns
totals adds up spend, revenue, ad installs and SDK installs over all rows, with an overall roas.
adInstalls and sdkInstalls come from different systems and can differ. The SDK only counts an install once the app has been opened with the SDK and Apple has confirmed the attribution.
Revenue Windows
Each row has three windows: D1, D7 and D30.
A window only counts installs that are at least that many days old. For a 30-day range, D30 only includes installs from 30 or more days ago, so it can be empty for recent periods. Compare windows across rows, not with the
revenueUsd total.
Currency Rule
Revenue is always in USD. ROAS is only computed when the Apple Search Ads spend is in USD too.- If the Apple Search Ads account reports spend in another currency,
currencyMismatchistrueand everyroasvalue isnull. Spend, CPI and revenue still show, each in its own currency. - If campaigns report in more than one currency,
currencyisMIXEDand ROAS is not computed.
Response
appleAds.error holds the message, the rows show SDK data only and totals is null.

