App Growth Metrics Calculator

Published on 8 Jun 2016 . 2 min read



https://img.sheroes.in/img/default_img.jpg https://img.sheroes.in/img/default_img.jpg

App Growth Metrics: eCPI, CAC, True LTV, Retention, Cost of MAU/DAU Calculator for Beginners [Download Excel]

I keep stressing upon the fact about using the “Right Metrics” in all my growth discussions, including this article I wrote a few months back — https://growthbug.com/cohorts-to-ltv-cac-to-mau-tips-to-make-it-meaningful-avoid-vanity-dd8e91289900#.an2e4eyph

Calculating “Right Metrics” is paramount to your growth initiatives. We often make some common & unintentional mistakes while calculating some basic metrics like MAUs, LTV, CPI. Here is my small attempt to suggest a better way to calculate your daily-use key metrics to help you stay laser focussed on the real growth.

SOME OF THE FORMULAS INCLUDED IN THE DOWNLOADABLE EXCEL:

1. True Active Users = Active Users for that Period — New User Acquired during that Period

Common Mistake: Not deducting new user acquired during that period

2. Real Cost per Install = Marketing Cost / (Paid Installs * (1-Uninstall%))

Common Mistake: Not accounting for Uninstalls upfront

3. Cost per Active User = (Overall Marketing Cost — App Install Budget) / (MAU at month End — New App Installs incl. Organic)

Common Mistake: Ignoring the marketing dollars on Non-App install campaigns

4. True LTV = Average Revenue Per Month X Net Margin X Lifespan (in Months)

Common Mistake: Ignoring Net Margin

5. Retention Rate = True Active Users in Current Period / True Active Users in the Previous Period

Common Mistake: Taking just Active users instead of True Active Users (1st formula on top)

& few other daily use formulas are included in the sheet included various CAC models, User Lifespan, Uninstall % etc.

DOWNLOAD HERE:http://bit.ly/growthmetrics

Note: It is a generic sheet suited to most Apps & growth models. Feel free to customize the sheet as per your need and share it back with the community. Mail me at dabbot@gmail.com to get your modified excel’s link embedded in this article. Tag me on twitter.com/deepakabbot

First published here 


email-statistics-laptop-metrics-highres
SHEROES
SHEROES - lives and stories of women we are and we want to be. Connecting the dots. Moving the needle. Also world's largest community of women, based out of India. Meet us at www.sheroes.in @SHEROESIndia facebook.com/SHEROESIndia


Share the Article :

Similar Articles You love
Download App

Get The App

Experience the best of SHEROES - Download the Free Mobile APP Now!