Data Coding

March game check

EasySupercelldaily activesrevenue per daily userpayer sharegroup by· 20 XP (10 per step)

Mock interview. You're interviewing for a data analyst job at a mobile game studio. The interviewer shares daily_player_stats: one row per player per day they played, with that day's revenue. "Let's check March's numbers."

  • DAU: players with a row on a given day. Average it over the month.
  • ARPDAU (average revenue per daily active user): total revenue / total player-days.
  • Payer share: monthly players who paid anything, as a share of all monthly players.

Step 1: The headline numbers

"Give me March 2026 in one row: monthly players, average DAU, revenue, ARPDAU and payer share."

Expected output

  • One row; avg_dau rounded to 1 decimal, arpdau to 3 decimals, payer_share as a percentage to 1 decimal

Example of the shape (made-up values):

players avg_dau revenue arpdau payer_share
500 90.0 700.00 0.250 12.0

Hints, the later steps and the answer come with Pro.

Step 1 of 2

Write your query here. Ctrl + Enter submits.