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

So you want to have game analytics, huh?


I’ve asked game development communities on Facebook and Reddit what was it that they were interested in the context of this blog. I expected a large number of interests, but the truth is that most requests were in the lines of “how do I start?” The Setting Up Game Analytics category of posts that I start today is about that. How to setup game analytics in your studio. From planning and choosing the technology to defining events and integration with external services. I expect many posts in this category. Continue reading