This post provides the queries to measure engagement in your game
Category: SQL aficionado
Mostly hacks or cools tricks I’ve come across to have easily manipulable and usable data outputs. By default, I use a redshift syntax.
Looking at the average and median time to convert through time – in SQL
A quick way to go back in time and see how your times to convert changed as your title ages. This illustrates why you should stay away from average times when considering behaviors in your game.
How to measure your userbase’s net worth and LTV – in SQL
I’m following up here on my previous posts about having game-centric metrics. With this query you should be able to have in one same data
How to optimize your LTV curves – in SQL
Creating an LTV curve can be a heavy operation. Use this little trick to optimize your queries and compare LTV curves across different user segments
Alexandre Macmillan 