Common Metrics
Lesson 1 of 1
  1. 1
    Introduction
    As a data scientist, when you’re not investigating spikes or dips in your data, you might be building dashboards of KPIs, or key performance indicators for a company. KPIs are often displayed …
    Start
  2. 2
    Daily Revenue
    At the heart of every company is revenue, and Mineblocks is no exception. For our first KPI we’ll calculate daily revenue.
    Start
  3. 3
    Daily Revenue 2
    Great! That query doesn’t take refunds into account. We’ll update the query to exclude refunds. Fields like refunded_at will only have data if the transaction was refunded, and otherwise left null.
    Start
  4. 4
    Daily Active Users
    Mineblocks is a game, and one of the core metrics to any game is the number of people who play each day. That KPI is called Daily Active Users, or DAU. DAU is defined as the number of unique…
    Start
  5. 5
    Daily Active Users 2
    Great! Since Mineblocks is on multiple platforms, we can calculate DAU per-platform.
    Start
  6. 6
    Daily Average Revenue Per Purchasing User
    We’ve looked at DAU and Daily Revenue in Mineblocks. Now we must understand the purchasing habits of our users. Mineblocks, like every freemium game, has two types of users: * purchasers: users w…
    Start
  7. 7
    Daily Average Revenue Per User
    The more popular (and difficult) cousin to Daily ARPPU is Daily ARPU, Average Revenue Per User. ARPU measures the average amount of money we’re getting across all players, whether or not they’ve …
    Start
  8. 8
    ARPU 2
    Daily ARPU is defined as revenue divided by the number of players, per-day. To get that, we’ll need to calculate the daily revenue and daily active users separately, and then join them on their dat…
    Start
  9. 9
    ARPU 2
    Great! Now you’re familiar with using the with clause to create temporary result sets. You just built the first part of ARPU, daily_revenue. From here we can build the second half of ARPU in our w…
    Start
  10. 10
    ARPU 3
    Nice work, you just defined ARPU for Mineblocks! In our ARPU query, we used using instead of on in the join clause. This is a special case join. from daily_revenue join daily_players using (dt)…
    Start
  11. 11
    1 Day Retention
    Now let’s find out what percent of Mineblock players are returning to play the next day. This KPI is called 1 Day Retention. Retention can be defined many different ways, but we’ll stick to th…
    Start
  12. 12
    1 Day Retention 2
    Before we can calculate retention we need to get our data formatted in a way where we can determine if a user returned. Currently the gameplays table is a list of when the user played, and it’s no…
    Start
  13. 13
    1 Day Retention 3
    Now that we have our gameplays table joined to itself, we can start to calculate retention. 1 Day Retention is defined as the number of players who returned the next day divided by the number of o…
    Start
  14. 14
    Common Metrics Conclusion
    While every business has different metrics to track their success, most are based on revenue and usage. The metrics in this lesson are merely a starting point, and from here you’ll be able to crea…
    Start