# InApp

## I. Filter

### 1. Where

Where to buy products in the game: shop, battlepass,...

### 2. Product

Products that players buy: treasure\_pack, starship,... purchased at different locations.

<figure><img src="https://content.gitbook.com/content/jXDVMhWRiIUCExjfRIcD/blobs/YdKvFeuT7EWHQHqG1nQh/image.png" alt=""><figcaption><p>Where + Product Filter</p></figcaption></figure>

## I. Diagrams

### 1. Total Inapp by Date

The graph shows the amount of Inapp players have purchased distributed by day, which can track which period players deposit strongly to develop the game (Unit: USD).

For example, Figure 1.1 shows that on August 2, 2024, players deposit the most Inapp during the month, and the strongest when buying buying gold\_1.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2Fui5wBxghmKo8adxYkjnb%2Fimage.png?alt=media&#x26;token=fc1c9124-1d2f-4828-b415-64261b058e88" alt=""><figcaption><p>Figure 1.1. Total Inapp Chart by Date</p></figcaption></figure>

### 2. ARPDAU By Date

* ARPDAU: Average Revenue Per Daily Active User.
* The chart shows average Inapp revenue per daily active player.
* Formula: ARPDAU = Total Daily Revenue / Total Daily Active Players
* For example, Figure 2.1 shows that on July 31, 2024, there is in-app revenue of $2,248, 184,043 active users, and an ARPDAU of 1.22¢.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FBImf0vBUePlujs7mN4v2%2Fimage.png?alt=media&#x26;token=71581f26-73f2-43b2-843c-9ad9dcb133b0" alt=""><figcaption><p>Figure 2.1. ARPDAU chart by day</p></figcaption></figure>

### 3. Total Inapp by Level

The graph shows the amount of Inapp players have purchased allocated by level, which can be tracked at which level players deposit strongly to develop the game(Unit: USD)

For example: Figure 3.1 shows that at level 44, the player who loads the most Inapp is between levels 0-56.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FMdBalVa9egFS6yHg4lrf%2Fimage.png?alt=media&#x26;token=cdd4a779-5aa3-45da-aaef-7c0c74335621" alt=""><figcaption><p>Figure 3.1. Total Inapp Chart by Level</p></figcaption></figure>

The drag bar shows how much the Inapp load rate on a set level accounts for compared to the total Inapp load on the entire level (Inapp load distribution by level).

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FlCjU1YfigCn7Xzpo2ueh%2Fimage.png?alt=media&#x26;token=77b556cb-f9c2-442d-bd06-03f586fe9fd5" alt=""><figcaption><p>Figure 3.2. The drag bar shows the ratio of Inapp volume distribution by level</p></figcaption></figure>

### 4. ARPDAU By Level

* The chart shows the average Inapp revenue per active player by level.
* Formula: ARPDAU by level = Total revenue per level / Total active players per level
* For example, Figure 4.1 shows that at level 63, there is inapp revenue of $98, 1,202 active users, and an ARPDAU of 8.22¢.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FvrpF17SjfGuoQuY8If7B%2Fimage.png?alt=media&#x26;token=20a0186a-5cba-4d45-ad88-acf522b2c6c9" alt=""><figcaption><p>Figure 4.1 ARPDAU chart by level</p></figcaption></figure>

### 5. InApp player count by level

The graph shows the number of players who have loaded Inapp distributed by level, which level can be tracked at which level players deposit strongly to develop the game.(Unit: User)&#x20;

For example: Figure 5.1 shows that at level 44, there are the most players who load Inapp between levels 28-51.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2F0FKEGoY56cdxSjR8YyzW%2Fimage.png?alt=media&#x26;token=258ce9cc-e782-4f71-a392-474b79137551" alt=""><figcaption><p>Figure 5.1. Graph of Total Inapp players by level</p></figcaption></figure>

### 6. Top in-app player

The graph shows the total number of Inapps that each user has loaded arranged in descending order. (Unit: USD)

For example, Figure 4.1 shows that the 3d8e3b6aa715df67 player has the largest Inapp intake

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FsHMzppwGa3bZYchndiQB%2Fimage.png?alt=media&#x26;token=d7f578c9-fe02-403d-8f3e-44540b8de075" alt=""><figcaption><p>Figure 6.1. Chart Top players who load Inapp the most</p></figcaption></figure>

### 7. Player in-app rate by install day

The graph shows the in-app loading rate of a set of players who install the game during the specified time period.

For example, Figure 7.1 shows that in the period from July 1, 2024 to July 31, 2024, the total Inapp deposits of players with retention days of 3-17 on July 12, 2024 is the largest.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2F7qbYObitnBde9dKs7aua%2Fimage.png?alt=media&#x26;token=5c39df4e-d78e-46df-bc0d-1c4fa23a301c" alt=""><figcaption><p>Figure 7.1. Player in-app rate by install day</p></figcaption></figure>

#### Filter Retention Day

This is a filter used to select a set of players to compare. For example, retention day is Day 0 - Day 90, which means selecting the number of players who installed the game in the last 90 days (compared to the current time).&#x20;

We can change the Retention Day range to compare between player sets.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FjIGiYqLkOgCF40P83XV6%2Fimage.png?alt=media&#x26;token=7903506e-a0d6-4efe-b275-fbb96083ea07" alt=""><figcaption><p>Figure 7.2. Retention day filter</p></figcaption></figure>

### 8. Total Inapp by Inapp LTV value

* The graph uses percentiles to segment players based on their Inapp LTV value and sums the Inapp in each of those player sets.
* Example in Figure 8.1: With the set of players with inapp LTV ranging from 41($) to 600($), the 95% to 100% percentile, the user with inapp LTV from 235.44($) to 541.76($) has the largest amount of Inapp Revenue.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FAt1NpVseXw4WwE1cHXLG%2Fimage.png?alt=media&#x26;token=06bee680-5fbf-4c88-a26d-d74daa64abb2" alt=""><figcaption><p>Figure 8.1. Total Inapp Chart by LTV Value</p></figcaption></figure>

* Filter Inapp LTV ($): select the inapp LTV amount to retrieve data on the corresponding user set.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FohX1eoUGZu2R95T9JLiR%2Fimage.png?alt=media&#x26;token=a2697278-1788-46fa-acc3-1cacdd63e0c7" alt=""><figcaption><p>Figure 8.2. LTV inapp interval filter</p></figcaption></figure>

* Select the percentile range to query.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FZi7MaQrAEQ6m8JYoALk4%2Fimage.png?alt=media&#x26;token=b3495bb4-e743-4ce3-a5d8-630887b301d7" alt=""><figcaption><p>Figure 8.3. Interquartile range filter</p></figcaption></figure>

### 9. ARPPU By Date

* ARPPU: Average revenue per paying user- is a metric used to calculate the amount of revenue generated by paying users, on average, over a given period of time.
* The chart shows the average revenue per in-app user.
* Calculation formula: ARPPU = Total revenue generated in period X / Total number of users  loading in-app in period X.
* For example: According to figure 8.1 at the time of August 2, 2024, the revenue is 2,657($), the number of users loading inapp is 464 -> ARPPU = 5.73(¢).

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FVYwCWBqmHOsRWrFMRAw4%2Fimage.png?alt=media&#x26;token=8d4ce935-e54c-43a6-a611-130765fb9fef" alt=""><figcaption><p>Figure 8.1. ARPPU chart by Date</p></figcaption></figure>

### 10. Paying Rate by Date

* The chart shows the ratio of in-app purchases to total daily active players. This provides insights into the game's monetization performance and engagement.
* Formula: Paying Rate = Total number of users who top up in-app in a period of time X \* 100 / Total number of active users in a period of time X.
* For example: Figure 10.1 on August 2, 2024, there are 464 users loading inapp, the number of active users is 191,572 -> Paying Rate will be 0.24%.

<figure><img src="https://1219926239-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FjXDVMhWRiIUCExjfRIcD%2Fuploads%2FzjfLisSNuthb7nSq7HFY%2Fimage.png?alt=media&#x26;token=2faacb20-61a1-404f-8f48-9a89e07f9dbe" alt=""><figcaption><p>Figure 10.1. Paying Rate Chart by Date</p></figcaption></figure>
