Calculate subscription app ROAS from App Store Connect data

Two 2022 spreadsheet walkthroughs show how the videos calculate blended and downstream subscription app ROAS using App Store Connect data.

How to calculate the ROAS of a subscription app's UA from iTunes data(with spreadsheet walkthrough)

Published 2022.

How to calculate downstream ROAS of a subscription app's UA from iTunes data(w/ spreadsheet)

Published 2022.

These two videos, both published in December 2022, demonstrate spreadsheet walkthroughs for calculating return on ad spend (ROAS) for subscription app user acquisition using App Store Connect data. The recordings work through blended metrics and the distinction between new and returning users. Each walkthrough has its own spreadsheet below.

The videos present an approach for cases where analytics tools or mobile measurement partners may not record the data an analyst wants to use, or where those tools are unavailable. They do not establish that App Store Connect data is universally complete or a substitute for every measurement setup; assess the data and definitions available for your own app.

Walkthrough spreadsheets

• Spreadsheet for the blended ROAS walkthrough
• Spreadsheet for the downstream ROAS walkthrough

Both are historical walkthroughs: App Store Connect and measurement practices may have changed since recording.

Explore more growth marketing videos and articles from RocketShip HQ.