AppsFlyer
Installs, cost, revenue and in-app events for your AppsFlyer apps, by media source, campaign and country.
The AppsFlyer connector brings your apps' aggregated data into the sheet: installs, sessions, loyal users, cost, revenue and in-app events, broken down by date, agency, media source, campaign and (in the country report) country.
The connection does not use a Google login: you enter your AppsFlyer V2.0 API token, found under account menu (top right) > Security center > AppsFlyer API tokens > Manage your AppsFlyer API tokens. An account admin user is required; the V1.0 token does not work. You choose the connection name.
After connecting, pick the app from the list of apps in your account, then one of three data categories: partners (user acquisition by date, agency, media source and campaign), geo (the same data plus country) and retargeting (conversions from retargeting campaigns). Each report uses one category only.
Available metrics
Besides the metrics below, the connector adds your app's in-app events (for example af_purchase), each with up to three metrics: unique users, event count and sales. Events are read from the app's data for the last 30 days when you select it in the sidebar, so only events recorded in that period appear. The list is kept in memory for 6 hours.
Available dimensions
| Dimension | Note |
|---|---|
| Date | Install date, in UTC. |
| Agency / PMD | The agency or partner managing the campaign, as reported by AppsFlyer. |
| Media Source | The source that brought the user (pid in AppsFlyer). |
| Campaign | The campaign name (c parameter in AppsFlyer). |
| Country | Available in the geo category only. |
| App ID | The app identifier in AppsFlyer (the package name for Android, id followed by digits for iOS). |
| App Name |
Known limits
- Call limits set by AppsFlyerAppsFlyer allows 24 calls per day per app (120 per account) for periods of 3 or more days, and 1 call per minute per app for periods of 0-2 days. Each report run uses one call; picking the app in the sidebar uses another one to read the events (at most once every 6 hours). Past the limit AppsFlyer returns an error and the report has to be run again later.
- Max 200,000 rows per reportAppsFlyer returns at most 200,000 rows per call. If that limit is reached, the connector flags it in the sheet with a warning: shorten the period in that case.
- Aggregated data onlyThe connector uses the aggregated Pull API. Raw data (one row per install or event), SKAdNetwork, cohorts and Protect360 are not included in this version.
- An admin V2.0 API token is requiredThe V1.0 token does not work, and the V2.0 token must be generated by an admin user of the AppsFlyer account. If the admin changes, the token changes and the connection has to be reconnected with the new one.
- Cost for acquisition campaigns onlyAppsFlyer provides cost only for user acquisition campaigns. In the retargeting category Total Cost, ROI and Average eCPI stay at 0 without being a real value.
- Dates always in UTCThe connector does not use the timezone set in the AppsFlyer app: dates and days are in UTC. Near midnight a day's data can therefore appear on the adjacent day compared with the AppsFlyer dashboard.
- In-app events: last 30 days onlyThe events you can select as metrics are those with data in the last 30 days: an event that has not occurred for longer does not appear, even if the report covers a past period when it did. The list is kept in memory for 6 hours, so an event sent for the first time may appear with a few hours' delay.
Execution notes
Each report makes a single call to AppsFlyer for the whole selected period. The data comes from AppsFlyer's aggregated Pull API, available on every plan.
Data is organized by install date: revenue, sessions and events are those generated, up to today, by the users who installed the app on that day. For this reason past days can still grow when you run the report again.
Dates are in UTC, so near midnight they can differ by one day from the AppsFlyer dashboard, which uses the timezone set in the app. Revenue and cost are in the currency set in the app.
CTR, conversion rate, loyal users per install, ROI, ARPU and eCPI are not copied from AppsFlyer: the connector recalculates them as a ratio of sums, both in the rows and in the totals, so they stay correct whatever grouping you choose.