Global Research Syndicate
No Result
View All Result
  • Latest News
  • Consumer Research
  • Survey Research
  • Marketing Research
  • Industry Research
  • Data Collection
  • More
    • Data Analysis
    • Market Insights
  • Latest News
  • Consumer Research
  • Survey Research
  • Marketing Research
  • Industry Research
  • Data Collection
  • More
    • Data Analysis
    • Market Insights
No Result
View All Result
globalresearchsyndicate
No Result
View All Result
Home Data Analysis

Monitoring game economy inflation for product people – Data-Driven Product Management – Daantje on Data

globalresearchsyndicate by globalresearchsyndicate
November 11, 2019
in Data Analysis
0
Monitoring game economy inflation for product people – Data-Driven Product Management – Daantje on Data
0
SHARES
1
VIEWS
Share on FacebookShare on Twitter

READ ALSO

Prefilled Syringes Market Size, Share & Sales Analysis by Manufacturers, Regions, Type and Application 2026 | Becton Dickinson & Co., Gerresheimer, Baxter International – KSU

XTZ Aims To Break $3 Despite Heavy Resistance

We all know that inflation in a game economy can cause a lot of problems. Among which:

  • Decreased need to spend money on in-app purchases to obtain game items/currency
  • Increased difficulty for new players to be able to compete with older players
  • Lack of feeling of meaningful progression
  • Overall spender demotivation

This video from Extra Credits is a great resource on inflation and Power Creep

This article is aimed at giving product people the tools needed to monitor inflation, deflation, and equilibria in their games.

High-level tutorial on monitoring game economy inflation

It all starts with good analytics tracking of game metrics. https://andersdrachen.files.wordpress.com/2013/07/02drachenetal02.pdf

In order to monitor inflation, we start by listing the game currencies and items that players can accumulate, for example:

  • Gems (hard currency)
  • Fairy Dust (soft currency)

We gather these metrics on a database maybe with a structure similar to the one below.

playerID current_gems current_fairydust gametimestamp
lala123 1045 2000 11/10/2019 21:53:36
vivi456 24 34 11/10/2019 21:54:36
lala123 500 2000 11/10/2019 21:55:36

The next step is to gather the data in order to analyze inflation. For this step, we query the database where the player data is stored and aggregate the minimum number of gems (or other currency), that the player held during the day. This number gives us a baseline for the lowest amount that the account saw that day. After we aggregate that minimum amount per player per day, it’s time to see what is the average minimum number of gems for that day. The SQL code snippet below can give us an idea of how to accomplish that task.

with pre_select as (
    SELECT DATE_TRUNC('day', gametimestamp) as day, 
        playerID, 
        MIN(current_gems) as gems, 
        MIN(current_fairydust) as fairydust
    FROM game_table
    GROUP BY 1, 2 )
SELECT day,
    AVG(gems) min_gem_inventory,
    AVG(fairydust) min_fairydust
FROM pre_select
GROUP BY 1
ORDER BY 1

After we query our data, the simplest method for product people is to get a CSV and import it to a spreadsheet, like on the sample below.

day min_gem_inventory min_gem_inventory_serie1 min_gem_inventory_serie2
01/01/2020 23 23  
02/01/2020 10 10  
03/01/2020 34 34  
04/01/2020 36 36  
05/01/2020 57 57  
06/01/2020 100 100  
07/01/2020 250 250  
08/01/2020 245   245
09/01/2020 100   100
10/01/2020 400   400
11/01/2020 500   500
12/01/2020 1000   1000

After getting the data on a table like the one above the next step is to plot a chart of the currency vs. the day. So, on the x-axis, we plot the day or the time series and on the y-axis our variable that we want to monitor.

We start by plotting the min_gem_inventory with a blue line. We can see that there seem to be two different periods with the naked eye. At first, we see slow growth until the 7th. Then, a rapid growth period ensues. If this would be real data, probably around the 8th we introduced an update that affected the number of resources that players could get.

min_gem_inventory-vs.-day.png

Given these two different periods, we plot 2 new series with the days where we see the different behaviors (red and yellow data). From here, we add a trendline with the linear option.

This trendline will create a linear regression of the type y = a x + b . The a coefficient indicates the slope, the greater the number the higher the inflation. The a coefitient also gives us the inflation rate. In our example, during the red period, the players’ gem inventory expands at an average rate of 1.04 gems per day, after the game update that value changed to 6.25 gems per day.

Analysis

If we’re able to track the evolution of the players’ wallets over time, then with simple linear regressions, we’re able to draw a lot of conclusions about the game economy.

If the slope of the linear trend line is greater than 0, then, we have some inflation. If the line moves mostly sideways, there’s an equilibrium. Game economies are dynamic. Often, there’s a need to correlate progression with access to resources. Therefore, equilibria are rare in games.

When the slope goes down, there’s a deflationary period. Good games can find ways of mitigating inflation by adopting strategies that introduce sinks for currencies (places where players spend currencies and make them disappear from the game economy).


PS – This is a high-level article. If you like the way that I approach these subjects, feel free to comment and get in touch. If you have any ideas of topics that you would like to see covered, let me know. I could spend a whole day just talking about empowering game dev teams with data-driven insights non-stop. All the best, Daniela.

The post Monitoring game economy inflation for product people – Data-Driven Product Management appeared first on Daantje on Data.

 

View the full article

 

Related Posts

Tissue Engineering Market Entry Strategies, Countermeasures of Economic Impact Channels to 2026
Data Analysis

Prefilled Syringes Market Size, Share & Sales Analysis by Manufacturers, Regions, Type and Application 2026 | Becton Dickinson & Co., Gerresheimer, Baxter International – KSU

January 18, 2021
XTZ Aims To Break $3 Despite Heavy Resistance
Data Analysis

XTZ Aims To Break $3 Despite Heavy Resistance

January 18, 2021
Bitcoin Cash, IOTA, Compound Price Analysis: 18 January
Data Analysis

Bitcoin Cash, IOTA, Compound Price Analysis: 18 January

January 18, 2021
Global Air Bubble Bags Market Scope and Price Analysis of Top Manufacturers Profiles 2019-2025 – Instant Tech Market News
Data Analysis

Global Portable Electronic Refrigerant Leak Detector Market Scope and Price Analysis of Top Manufacturers Profiles 2020-2027 – NeighborWebSJ

January 18, 2021
The relationship between cancer fatalism and education
Data Analysis

Correlation of phase angle with sarcopenia and its diagnostic value in elderly men with cancer

January 18, 2021
Gold Sheared, Silver Smeared – Report Door
Data Analysis

Gold Sheared, Silver Smeared – Report Door

January 18, 2021
Next Post
F.B.I. and Prosecutors Try Speaking Plainly About Domestic Terrorism

F.B.I. and Prosecutors Try Speaking Plainly About Domestic Terrorism

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

POPULAR NEWS

‘Vatican Blackout’ Trends on Twitter as Trigger-Happy Users Try to Link It with US Election Fraud

‘Vatican Blackout’ Trends on Twitter as Trigger-Happy Users Try to Link It with US Election Fraud

January 10, 2021
Global Food Authenticity Industry

Fifth Third Bank Partners with Cardtronics to Enhance Brand Visibility in Carolinas through ATM Branding Program

February 4, 2020
Horowitz: Asian-American researcher fired from Michigan State administration for advancing facts about police shootings

Horowitz: Asian-American researcher fired from Michigan State administration for advancing facts about police shootings

July 8, 2020
Digital Learning Market 2020 industry report explores segmented by growth opportunities, emerging-trends, and industry verticals till 2025

Online Brand Protection Software Market report reviews size, share, analysis, trends, growth and forecast 2025

March 6, 2020
Survey finds 40% of fashion brands have not paid suppliers | Apparel Industry News

Survey finds 40% of fashion brands have not paid suppliers | Apparel Industry News

May 29, 2020

EDITOR'S PICK

Eye Health Supplements Market Primary Research, Secondary Research, Product Research, Trends and Forecast by 2025 | Vitabiotics, Valeant Pharmaceuticals, Pfizer

Eye Health Supplements Market Primary Research, Secondary Research, Product Research, Trends and Forecast by 2025 | Vitabiotics, Valeant Pharmaceuticals, Pfizer

December 17, 2019
Birth Defects Tied to Rise in Lifelong Cancer Risk – Consumer Health News

Birth Defects Tied to Rise in Lifelong Cancer Risk – Consumer Health News

December 3, 2020
Magnet Wire Market Research, Recent Trends and Growth Forecast 2025

Magnet Wire Market Research, Recent Trends and Growth Forecast 2025

September 13, 2020
Product Lifecycle Management Consumer Packaged Goods and Retail (PLM CPandR) Market Report 2019 – Market Size, Share, Price, Trend and Forecast

Global Online Survey Software Market 2020 Sales Outlook, Up-to-date Development Data and Industry Trends Forecast from 2026 – Pro News Time

January 10, 2020

Categories

  • Consumer Research
  • Data Analysis
  • Data Collection
  • Industry Research
  • Latest News
  • Market Insights
  • Marketing Research
  • Survey Research
  • Uncategorized

Recent Posts

  • Treating post-infectious smell loss in COVID-19 patients
  • Prefilled Syringes Market Size, Share & Sales Analysis by Manufacturers, Regions, Type and Application 2026 | Becton Dickinson & Co., Gerresheimer, Baxter International – KSU
  • Trimethyl orthoformate Market Report 2020, Size, Share, SWOT Analysis and Key Players – Linshu Huasheng Chemical Co., Ltd., Sinobioway Biomedicine – KSU
  • Privacy Policy
  • Terms of Use
  • Antispam
  • DMCA
  • Contact Us

Copyright © 2020 Globalresearchsyndicate.com.

No Result
View All Result
  • Latest News
  • Consumer Research
  • Survey Research
  • Marketing Research
  • Industry Research
  • Data Collection
  • More
    • Data Analysis
    • Market Insights

Copyright © 2020 Globalresearchsyndicate.com.

Login to your account below

Forgotten Password?

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In