Analytics use cases

Last actions before churn

The goal of each game developer is to keep users in the app as long as possible and try to understand the reasons why they churn to prevent it.

That is why we try to find out which actions users do before they leave the app. For an analytical platform, it can’t be calculated because when the user stops using the app, the connection with SDK is lost and it can’t send any events to the platform.

But still, you can use several ways to learn about the actions of these users. Here they are:

User flow

Please do the following to see which events prevented churn:

  1. Choose Churn in the Event dropdown menu.

  2. Choose Flow direction - to the event.

  3. Select basic and custom events for the report.

After you build the report, you will see the most recent event that leads to the Churn. If you want to see more previous events, just tap the event to expand it.

Raw data export or SQL Wizard

Another way is to process data manually (e.g via Excel). To do that, at first you need to export data in the Raw Data -> Raw Export section.

Export Custom events and Sessions there.

After that, please do the following:

  1. Using the Sessions data, find the time of the last session of the user and select only users who churned (e.g. whose last session was 3 days ago).

  2. Merge information about all custom and basic events and find the last event of the user.

  3. Link both tables by the devtodev ID field to find out what was the last event.

You can do the same in the SQL Wizard section. Here’s how:

  1. Select in one query the Last_Seen parameter in the Users table and Date parameter in each event table.

  2. Find the most recent event for each user and filter the list by the Last_Seen date to choose only users who churned.

Users

The last option would be to view the actions of specific users one by one. It can be done in the Users section.

1. Filter users by the Last seen parameter which is calculated automatically. You can also add more filters to specify those users you want to explore.

2. After you apply the filter, you will see the list of users. Open their card to see the Last user activity tab. There will be the latest events that were performed by the user.

Actually, 50-100 users will be enough to find patterns in their behavior.

Using these ways you can explore the last user's activity in the game. All of them have advantages and disadvantages, but please note that sometimes only the last event is not enough to understand the reasons for churn. Especially if you use a lot of custom events in research. As a result, you can get meaningless events, such as Open the Settings tab, View the chat, etc. That is why it is better to check more events to see the whole picture.

A/B Tests

It is necessary to take A/B tests during the development stage. So how is it possible to make A/B tests on the devtodev platform?

Here you can find some simple steps on how to run A/B tests:

  1. Creating the audience for the experiment is on the developer's side. Our advice is to perform an A/B test on the new users divided into equal groups and show the proper variant of the experiment to each group.

  2. There are two ways to assign a group to a user - use custom user property (here you can find how to create it) and specify the group (a, b, etc) in the property; or with the help of custom event, specifying the group in the parameter (here you can find how to create such event)

  3. Create segments of the users for each group of the test right after starting the experiment. If the group was specified in the custom user property - create the segment using this property and specify for each segment a specific value of the property (Custom Segmentation -> User data -> Select properties). If the group was specified in the custom event - create the segment using this event and identify the specific value of the parameter with the group value. You should have the same number of segments and groups in the experiment.

  4. These segments can be applied to different reports in devtodev as filters. For example, in the Report Master you can compare metrics for several segments in one chart. Use these segments to check the metrics for all groups and choose a winner.