Loading...

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 AppsFlyer
    AppsFlyer 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 report
    AppsFlyer 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 only
    The 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 required
    The 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 only
    AppsFlyer 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 UTC
    The 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 only
    The 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.