Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Post from Trion-Using Data to Help Make Better Games

syriinxsyriinx Member UncommonPosts: 1,383



Categories: From the Dev TeamUpdates.


Over the past decade, data has been increasingly important in making game design decisions. Social games are among the catalysts for this change in thinking, primarily to hone in on the best ways to monetize their titles. Among core gamers, that’s created a perception that using game data = evil.

At Trion, we use the raw power of data for a very different purpose: we want to build a better game experience.

By understanding our populations and play-trends, by coupling the immersion of our development teams in-depth knowledge of our games with the analytical power of our in-game data, we have more information to use in making better, more fun online games.

By making a better experience, everyone wins.

I’m the head of a group of talented gurus of the data at Trion Worlds and today I’m writing about how we extract and use it to help our development team make our games bigger, better, and more fun with each update.

Let’s get into how the sausage is made in this data factory. To do that, I want to lay out the basics of the tools we use to crunch the numbers.


At Trion, we have 3 different main sources of data for any of our games. We have the game databases that store everything that the game cares about, like your characters, our platform database that contains all details about your account and a log event system capable of capturing live in-game events as they occur.


For the purposes of our analytics, the persistent character record is often as deep as we need to go into the game databases. The character record is shredded out of the game database and placed in a replica that is at most up to 5 minutes delayed. Some of the things within that record are: character id, user id, server, character name, current level, total coin on character, profession, last active date, total seconds played to date, and so on.

This is the source that we’ll generally go to in order to answer questions like “how many Rogues have played in the last 2 weeks” or “of the players playing in the last 2 weeks, what’s the plot of their level ranges?” Other interesting things can be done with this, like getting the longest played duration of all characters across an account to help us understand class preferences across the world.


This is the repository where all of the account level data is stored. This is the master record of all things that relate to the status of the account (such as knowing if people have opted in to receive update emails and whether or not an account is banned).

This is also how we know which language to talk to people in, which games the account has access to, and so on.. We can blend this data with the others to compile e-mail campaigns, or when we want to determine what products and services players have purchased, and so on.


The event system is a truly massive beast.  It’s where we record the majority of in-game activities. Logins, logouts, experience gained, player killed, monster killed, etc. There’re a lot of very detailed things that can be gleaned from the event logs. More than just for analysis, this is also where GMs look when they need to answer petitions from the game.


Using elements of all of these, one of the most useful things we’ve created is something that’s simply called the “Daily Activity Report.”  It’s a monster that belies the simplicity of that name.

This blends data from all of those sources above, to not only tell us how a game is doing day-to-day, week-to-week, but it also breaks down the every in-game activity by user.

That’s really powerful.  This report rapidly became an important guide for designers in letting them know how much their parts of the game were being played.

The designers are the experts on why, and we don’t pretend that data has the answer to that – But we can answer key questions for them, like how many, and how often, to help them in their decision making. We see something like x number of users played Rift yesterday and of this base, y% participated in a normal dungeon, whereas z% participated in PvP. Depending on the timeframe, this might tell us which is the prevailing activity in-game.


In late 2011, we did a deep dive to find out why players were leaving RIFT. We found a very interesting fact: there was a higher rate of players leaving between levels 7 and 14: players were getting through the tutorial and into the main world but not progressing much further. We took this information to the development team who went into the game and look a hard look at what was going on in areas we had highlighted. The team found that by spreading out our large groups of creatures, we could make running paths less congested and more manageable to a new players. We also modified the quest flow to minimize backtracking and improved the flow and difficultly of the early experience. While the design team did the heavy lifting to research and implement the gameplay decisions that improved the Freemarch and Silverwood experience, that work would have been far more difficult without being identified by the power of our data.


Shortly after Defiance released, the data team went to work crunching the numbers on what was and wasn’t working in the game. After some digging, we found that “We’re on the air”, a mission in Defiance where you protect the local radio station, was the most abandoned mission in the game. We sent this and other data points to our development team and set them to work. This resulted in making a far less frustrating and more fun mission: we changed the structure and flow and changed the encounter from a solo mission to a group engagement that you could take on with your friends. Instantly, the mission became more fun – and the data reflected the hard work the dev team put in to make it happen!



From the Daily Activity report, it was easy to determine that the most frequently embarked upon activity was the act of harvesting artifacts. Between 40% and 60% of our daily active users chase artifacts (and by chasing, I mean harvesting). When so many people are avidly hunting for something, there’s only one logical conclusion: give them more of what they want. Using this data, the development team decided to add more artifacts to the world in a variety of interesting ways. We added the Autumn Harvest event and added a lot more artifact drops from world events. As you can see from the graph below, players really dug the added Artifact hunting we gave them:

<img size-large="" wp-image-3140"="" alt="graph" data-cke-saved-src="" src="" width="560" height="245">

* Artifact Event includes both World and Zone events


The Extra Life event occurs annually, where players get sponsored to play a number of hours in-game which results in donations to various hospitals. Trion Worlds has been a participant in Extra Life for the last 3 years running and I’ve been required to pull the participation figures for in-game perks that players earn. The primary goal of players participating in Extra Life is to play a total of 25 hours during the event’s window. For this particular event the window was Friday at 6pm thru 12am Monday morning. To service things like this, I use the Logout event, which unfortunately requires that the participants had processed a logout event after having played the required time (this may create problems for users who don’t log out for days after the event). We aggregate seconds played for the players generating a logout event, where the session’s time would’ve fallen into the event window. A list of users who’ve exceeded the 25 hour threshold has a batch entitlement applied to their account (an entitlement is a bundle of products that we might grant to someone that might include in-game achievements, titles, items, etc.). So for all of you out there who played in Extra Life, this is the work that goes on behind the curtain to get you your titles and other goodies. I’m crunching the numbers right now!

This blog only scratches the surface of how we use data everyday at Trion Worlds but hopefully has given you a good overview into what kinds of questions we ask every day as we work to expand and improve our games. From special events like Extra Life to marketing efforts to changes in core gameplay, we use data to help our experts make the best choices for your game experience.

-Barish Orhon



  • syriinxsyriinx Member UncommonPosts: 1,383

    Some of this makes me think Trion just doesnt get it.


    The part about the 7-14 bit for instance.  The reason people leave between 7-14 has nothing to do with the zone design.  Its the time when people decide they dont like the game.  They play through the tutorial zone waiting to see if the game changes once they leave it.  they find out it doesn't so they leave.  The mob density at launch did suck, but it didnt really become an issue until you find your mount is worthless against it.


    Using data is a good thing.  But its easy to draw the wrong conclusions from it.  The wave of people leaving between 7-14 you can't do much about without redoing your game, those are the people that just dont like it.  Its the people that leave after investing some time into your game that you need to worry about.

Sign In or Register to comment.