Four steps to teach you to write a product's operational data analysis report.

During the game operation, we can see a bunch of game-related data in the background, how do we deal with this data? A detailed analysis will be done around a report instance. The content mainly includes the analysis goal, the analysis summary, the week operation data analysis, the operation data overall analysis four pieces of content

First, determine the analytical objectives

The main objectives of the analysis include the following three areas:

analysis purposes;
Analysis scope;
Analysis time.

As shown, the analysis of the target in addition to the main three aspects, there is a column of remarks, here is the calculation of the period of the problem. It is important to emphasize that when we do operational data analysis, we usually compare pre-and post-update data, so our set-up analysis cycles are generally followed by the actual update of the game. Second, the analysis summary

The analysis summary mainly includes two aspects content

1. Last week/week recharge data comparison

The total amount of recharge;
Number of recharge;
Number of servers;
Server average recharge;
Average number of server recharge.

Compare the difference between the above content and increase or decrease ratio, if the game has special requirements, you can add other data content appropriately.

2. Last week/week updated content comparison

The main display is updated within two weeks of activity content or some major adjustments.

Three or one-week operational data analysis

1. This week's income profile

Daily recharge amount, on the chain of Sunday to recharge the amount;
User ARPU value, the ARPU value of the chain last week.
The comparison of top-up with last week or before, such as the rise or fall, the larger factors that affect the recharge.

2. New User profile

New users are new players, the main introduction of these new players dynamic data, generally two months for the total duration of the display comparison, the specific period data is still in weeks. The new user data mainly includes: installed download number, create the role number, install → role conversion rate, pay the number of people, create a role → paid conversion rate, ARPU value, the next day retention, 3rd retention, 7th retention, etc., can be added according to the actual game. 3. Active user Profile

The active user profile consists mainly of three parts:

Daily average number of people online, the number of real-time online last week, increase/decrease percentage;
Average daily paid users landing number, the number of paid landing last week, increase/decrease percentage;
Active players per day, the number of active players per day, increase/decrease percentage.

4. Item consumption overview

The consumption profile of props mainly includes:

Type of output activity;
Item classification;
Single-class props consumption of ingot, consumption accounted for, the chain last week;
Daily consumption of silver ingot, the total consumption of ingot, the chain last week to decline/rise;
The article briefly describes the item classification with good/poor activity effect.

5. Current Ingot Stock

The current stock of silver ingot refers to the amount of stock that the player has not spent on the ingot, as well as the extra gold ingot stock in the game. For example, I charge 1000 pieces, take the 1w ingot, spent 8K, I caused the stock is 2K, when the platform of the silver ingot stock is rising, on behalf of the consumption point is not enough, or to supplement the new consumer system, or the consumption of business activities.

6. Key business event paying player participation

The following points are taken into account in the participation of activities:

Category of paid groups, active paid players;
Participation ratio of paid players;
The number of gold ingots consumed by paid players in the event;
Paid players in the activity of the ingot consumption of the weekly consumption of the proportion of the total ingot;
The per capita consumption of the gold ingot number of paid players.

According to the relevant data of these paid players, the effectiveness of the activity and the level of acceptance of the player are judged. If the data is not good, then the activity does not, you need to delve into its existing problems, to see if the problem is in the difficulty of the activity, the activities of the reward is not attractive, or the activity itself is too poor to play. Depending on the reason of the analysis, it is necessary to adjust the play setting or replace the new activity in the next update activity. In addition, the same period may be launched a number of activities, in the conduct of a single activity data analysis, but also to compare the effect of the various activities, for the next operation of other products, have a experience to learn.

Note: Number of paid players: The number of players logged in during the event, consumption ratio = total consumption of active items ingot/When the total consumption of silver ingot.

Iv. General analysis of game operation data

After a simple analysis of the week's operations, a detailed analysis of the data for a certain operating cycle is followed.

1. Recent Recharge Overview

The recent top-up situation is basically a week-long unit for analysis, the main analysis includes: weekly income, income growth rate, when the income of the Sunday, when the total number of weeks paid, ARPU value, server number, service daily income, etc., according to the actual situation of the game can be appropriate increase or decrease the analysis category. For a simple example:

2. New Registered User Analysis

Because it is an analysis of new registered users, this piece of analysis is slightly coincident with the previous week's operational data. This piece of analysis focuses on the data comparison of the various channels, including the new registered user comparison, active user comparison, the cumulative payment amount comparison of three parts.

3. Active user Analysis

The active user analysis in front is mainly about the daily active user analysis of the week, and the active user analysis here can be two weeks, three weeks or longer analysis, mainly to see the actual game needs.

Active user profile description consists of three main components:

Daily average number of people online, the number of real-time online last week, increase/decrease percentage;
Average daily paid users landing number, the number of paid landing last week, increase/decrease percentage;
Active players per day, the number of active players per day, increase/decrease percentage.

Note: The content described here is not necessarily a comparison between this week and last week, depending on the purpose of the analysis. Note: The number of old paid login = excluded statistics Day New paid players

4. Prop Consumption analysis

The analysis of props consumption mainly includes three parts:

Ingot consumption structure, such as equipment, lottery, promotional categories;
Analysis of the consumption of specific ingot for each type of prop;
The consumption ratio of each type of prop in the analysis period.

In addition, the specific text description analysis Here is not an example, reference to the actual situation of the data analysis table simple to do a text description can be. For some well-sold props and poor sales props can focus on the analysis of the reasons for the differences, so that the next update can be adjusted to improve.

Weekly daily average ingot consumption
Ingot consumption ratio

5. Paid player Gold ingot situation

The main analysis of the gold ingot of paid players:

Obtain the amount of silver ingot, including recharge, gain in the game;
Consumption of ingot, including the consumption of top-up ingot and the consumption of silver ingot;
The stock of ingot, including the recharge stock and gift stock.

Note:

Top-up players total gold ingot Source = top-up to obtain Silver ingot + game related channels to receive a gift of gold ingot;
Top-up player ingot stock = Silver ingot stock + gift silver ingot stock;
Consumption of silver ingot = ingot consumption + gift of ingot consumption.

6. Key game system Monitoring

Because of the numerous systems in each game, it's easy to get a brief introduction to the purple card partner and the replica level.

Obtain the purple card number analysis

Analysis is conducted primarily for players at different pay levels. In the mainstream card game, purple card is usually more advanced cards, the number of purple cards for the game system analysis has more important significance. According to the analysis can be observed whether the number of purple card is reasonable, such as large R and small r whether there is a clear difference in ownership, purple card is easy to get or rare. After analysis, we can adjust the probability of the output card and get the channel.

Replica system Monitoring

Copies of similar tweets, or tasks, are the focus of the game that needs our attention. According to each level player's clearance participation number, you can easily see each level players participate in the situation, so as to determine whether the level set unreasonable or data anomalies.

In fact, in addition to system monitoring, the player's upgrade, mall pay, etc. can do a detailed analysis, mainly to see your game at which stage, the focus of the analysis.

7. Key business event paying player participation

The analysis here mainly includes the participation of the active players in the previous period, or the periodic analysis of the activities with longer periods. This analysis is similar to the previous activity analysis, which is not explained in detail here. Summarize

After completing the above analysis, it is necessary to summarize the whole analysis report, such as some suggestions for revising the content. Because the different categories of the game are relatively large, so this analysis is only to play a role. When we describe the analysis report in the actual work, we usually decide the object of analysis according to the game index, the focus of the stage and the module of analysis. Therefore, it is necessary to make a concrete analysis of the situation in the end.

Four steps to teach you to write a product's Operational data Analysis report (GO)