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

databases_and_tables.jpg

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?

build_or_buy_suga_660w

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

Planning Game Analytics from 0 to data science

from_0_to_data_science_suga_660w

Game analytics can be very simple or go wide, far and deep. The trick is to define what it is that you will want on a given timeframe. The length of the timeframe depends on how sophisticated and complex are your objectives.

This post will go through the role that sophistication and complexity take in defining both your objectives and the analytics stack to support them. Continue reading

So you want to have game analytics, huh?

so_you_want_to_have_suga_660w

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