Building Performance Metrics Dashboards for Mobile Freemium Games

Let’s take a moment to appreciate the largest title of a post of this blog to date. Building Performance Metrics Dashboards for Mobile Freemium Games is a mouthful and is exactly what we’ll discuss today.

Let’s dive right in. Continue reading

Databases and tables for game analytics


It has been some time so let’s recap how we got here. First I gave an overview of what a game analytics stack can be. Then I moved to the planning stage pointing the steps from zero to data science. In the last couple of posts in this category I wrote about basic events. First how to think and define them, later on the structure of the data created from those events. The last couple of posts were about user state, what it is and how we can use it.

I think it is abundantly clear that there is method in the madness! Today I’ll write about the databases and tables needed for basic reporting. Not only the definition of the fields but also different structures and technical considerations.  Continue reading

Why do I want a user state

ognd 019

A couple of weeks ago I wrote about the user state. Went through what it is and what it has, meaning, what variables are included. This week the focus is on what you can do with it.

Assuming you are sold to the idea of a user state, you now have (or will have!) a large table with all or users. That table has a many variables that touch all areas of The Player Lifecycle.

So… now what? What’s the point.

This is the objective of this post, to tell you what you can do with it. Continue reading

The User State

ognd 017

The user state is the unsung hero of game analytics. People spend countless hours looking at dashboards from reporting tables, analysing datasets built from purchases and session events but the user state is only remembered when some vital piece of information about the user wasn’t added to it.

Still the users state is central to a well built analytics system, especially if we are building your own in house.

So what is it? And why does it matter? Continue reading

More on game analytics basic events

The previous post had two big themes. The thought process of asking questions to define the events in a clear and detailed form was one. Introducing the basic metrics and the events that would allowed them was the other.

This post expands those two themes. The objective is to introduce concepts that will be used later to define reporting tables and dashboards and add more information to our two events. Continue reading

The basic events of game analytics

Open up your favourite note taking application. It can be a google spreadsheet, a Sublime Text 2 file or, if you are like me, a new Evernote note. We are going through the process of starting to define your game’s event taxonomy. My challenge is that we define the most basic set of events any game needs. Together! Continue reading

Game Analytics: Build or Buy?


Deciding to build or buy the components of our game analytics platform is one of the biggest decisions we have to make. I’ve seen many questions on Quora on this issue. Often people ask which is the best analytics platform. From my experience, the only person that can answer that is the person that asked it. Every other opinion is biased either by positive or negative experiences or commercial interest.

The problem is the question. Instead of asking which is the best solution, the question should be which solution best fits my needs. This post is about that. Defining needs that may exist and which should be addressed. Continue reading