Skip to main content
The ROAS view puts ad spend next to the revenue that Appeeky Analytics attributed to the same campaigns:
  • Apple Search Ads, by campaign or keyword. The SDK records the Apple Search Ads campaign id and keyword id of each install, so the join is exact: no name matching and no modeled attribution.
  • TikTok Ads and Meta Ads, by campaign, through smart links. A smart link with channel tiktok_ads or meta_ads and the campaign id as external id belongs to that campaign. See TikTok Ads and Meta Ads.
Apple Search Ads ROAS is only available on iOS apps. TikTok Ads and Meta Ads ROAS works on iOS and Android, for ads that use a smart link. Other networks are not attributed per install; see SKAdNetwork for their results.

Prerequisites

  1. Analytics turned on for an iOS app, with the SDK’s native module (Apple Search Ads attribution needs it).
  2. Apple Search Ads connected in Appeeky. See Apple Search Ads Credentials.
  3. RevenueCat connected and identify called, so purchases reach the installs. See Revenue.
Without Apple Search Ads connected, the view still lists the campaigns or keywords the SDK attributed, with their installs and revenue, but no spend.

How It Works

  1. Appeeky takes the installs first seen in the selected period that came from Apple Search Ads, grouped by campaign id or keyword id.
  2. 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.
  3. It reads Apple Search Ads spend and installs for the same dates and the same campaigns or keywords, limited to this app.
  4. It joins both sides on the Apple id.
Campaigns or keywords that spent money but brought no SDK installs still show, so wasted spend is visible. Groups with SDK installs but no spend in the report also show, with zero spend. At campaign level this can include campaigns from other sources, such as a smart link campaign. The SDK side covers the top 50 groups by installs.

Query parameters


Columns

totals adds up spend, revenue, ad installs and SDK installs over all rows, with an overall roas.

Ad groups

With level=adgroup, spend comes from Apple’s keyword reports summed per ad group, so Search Tab campaigns (which have no keyword reports) are not included. Revenue needs the analytics service to group installs by the Apple Search Ads ad group id. While it can’t, sdkJoin is false: rows show Apple’s spend and installs, and revenueUsd, cpi and roas are not computed.

Per day

series has one point per day of the period for Apple Search Ads: Revenue in series is counted on the day of the sale, so it is not the same as the cohort revenue in rows. The Overview draws it as daily spend bars with a revenue line. 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.

TikTok Ads and Meta Ads

The channels array has one section per network, always at campaign level, whatever level is.
  1. Appeeky reads campaign spend and installs for the same dates from the connected TikTok Ads advertiser or Meta ad account (the default one selected in Integrations). Spend reports are cached for 15 minutes.
  2. It adds up installs and revenue of this app’s smart links whose channel is the network and whose external id is the campaign id. Several links can point at one campaign.
  3. It joins both sides on the campaign id.
Only campaigns that a smart link of this app names count. An ad account can promote several apps, so the other campaigns are not this app’s spend: unlinked reports how many campaigns had spend without a link, and how much. linksWithoutCampaignId counts links for the network that have no external id yet; their installs can’t be joined. Each section has: Every row also has a channel field: apple_search_ads on the top-level rows, the network on channel rows.

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, currencyMismatch is true and every roas value is null. Spend, CPI and revenue still show, each in its own currency.
  • If campaigns report in more than one currency, currency is MIXED and ROAS is not computed.
Appeeky does not convert currencies.

Response

If Apple Search Ads is connected but the spend report fails, appleAds.error holds the message, the rows show SDK data only and totals is null.