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 …

At the heart of every company is revenue, and Mineblocks is no exception. For our first KPI we’ll calculate daily revenue.

Great! That query doesn’t take refunds into account. We’ll update the query to exclude refunds. Fields like […] will only have data if the transaction was refunded, and otherwise left […] .

Mineblocks is a game, and one of the core metrics to any game is the number people who play each day. That KPI is called Daily Active Users, or DAU. DAU is defined as the number of unique pl…

Great! Since Mineblocks is on multiple platforms, we can calculate DAU per-platform.

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…

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 …

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…

Great! Now you’re familiar with using the […] clause to create temporary result sets. You just built the first part of ARPU, […] . From here we can build the second half of ARPU in our […..

Nice work, you just defined ARPU for Mineblocks! In our ARPU query, we used […] instead of […] in the […] clause. This is a special case join. […] When the columns to join have t…

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…

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 […] table is a list of when the user played, and it’s not …

Now that we have our […] 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 ori…

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…