Reconcile rising sign-ups with falling revenue per user
business judgment and data storytelling.
reconcile the metrics via total revenue and segment mix, frame the tradeoff, recommend an action.
declaring one team wrong instead of synthesizing both.
What's really being asked
The interviewer wants to see if you can hold two true-but-tension-filled findings together and turn them into a clear business recommendation, rather than getting stuck on which number is correct. It probes communication maturity and quantitative reasoning under ambiguity.
The full answer
Start by validating both analyses: a 15 percent lift in sign-ups and a 5 percent drop in average revenue per new user can coexist. Then compute the combined effect. If volume rose 15 percent while per-user revenue fell 5 percent, total revenue from the cohort still grew roughly 9 percent, so the pie got bigger even though each slice is thinner. Explain the likely mechanism: broad campaigns pull in more top-of-funnel, lower-intent users, which dilutes the average. Distinguish first-purchase revenue from lifetime value and propose tracking retention and LTV over the next quarters before judging the campaign. Close with a recommendation tied to the business goal.
The mistakes people make
Framing it as marketing versus finance and declaring one side wrong. Fixating on the ARPU drop as proof of failure while ignoring the net revenue gain. Presenting raw numbers without a recommendation or a single takeaway leadership can act on.
What usually comes next
How would you confirm the lower ARPU is from user mix and not pricing or seasonality? What if total revenue had fallen? How would you segment the cohort to find which channels brought the diluting users?
A concrete example
Suppose the baseline was one thousand new users at one hundred dollars each, totaling one hundred thousand dollars. After the campaign you get one thousand one hundred fifty users at ninety-five dollars each, totaling one hundred nine thousand two hundred fifty dollars, a clear net gain. You present one slide: a waterfall showing volume contributing positively and ARPU contributing negatively, with net revenue up, plus a note that you will watch ninety-day retention to confirm the new users stick.
Interview question
Sign-ups rose 15% but average revenue per new user fell 5% for the same cohort. What single number best settles whether the campaign helped the business?
- a.The sign-up count in isolation
- b.The per-user revenue change in isolation
- c.Total cohort revenue (volume times per-user revenue)Correct
- d.Whichever team's report leadership trusts more
Why? this is the answer
Total revenue captures both effects: 1.15 volume times 0.95 ARPU is about a 9 percent net gain. Looking at ARPU alone ignores that the larger user base more than offsets the thinner margin per user.
Just read this? Test yourself on what you have been reading.
Read the original → en.wikipedia.org
- #data-storytelling
- #metrics
- #business-analytics
- #communication
- #arpu
Put your scrolling time to good use
Learn one idea, try a quiz and save useful cards for revision. Tezvyn makes it easy to learn and stay current in your tech field, a few minutes at a time.
The iPhone app is on the way
We are building it. Until it lands, nothing here is held back from you: every interview card, your saved cards, streaks and the job board all work in Safari, plus hundreds of free practice quizzes of thirty questions each. Sign in and it all carries over to the app the day it arrives.
Want it as an icon? Tap Share at the bottom of Safari, then Add to Home Screen. It opens full screen and the cards you have read stay available offline.
We are hiring for this. Every open role lists the topics its interview covers, so you can prepare for the real thing rather than guessing.
See open roles