LogoLogo
My AppsLive demoNewsArticles
  • Introduction
  • 📌Product updates: 2025
    • 2024
    • 2023
  • Getting Started
    • Registration
    • Adding a space
    • Adding an app to the space
  • Basic Events & Custom Events
  • Integration
    • Expert Tips
      • What to track
      • Payments & Anti-cheat
      • Check your integration
    • Integration of SDK 2.0+
      • SDK Integration
        • Android
        • iOS
        • macOS
        • Windows
        • Web
          • Web SDK Integration
          • Web SDK Releases
        • Unity
        • Unreal Engine
        • Godot Engine
      • Automatic payment tracking
        • App Store
        • Google Play
      • Setting up Events
        • Basic methods
        • Secondary methods
        • User profile
        • Anticheat methods
        • Track sessions
      • Push notifications
        • Android
        • iOS
        • Windows (UWP)
        • Unity
          • Android
          • iOS
          • Windows (UWP/WSA)
        • Unreal Engine
      • A/B testing
        • Description of A/B testing on the SDK side
        • Working with A/B tests in the devtodev interface
        • A/B testing examples
    • Integration of SDK 1.0+ (deprecated)
      • SDK Integration
        • iOS
        • Android
        • Windows 8.1 and 10
        • Web
        • Unity
        • Mac OS
        • Adobe Air
        • UE4
      • Setting up Events
        • Basic methods
        • Secondary methods
        • User profile
        • Anti-cheat Methods
      • Push Notifications
        • IOS
        • Android
        • Windows 8.1 and Windows 10
        • Unity
        • Abode Air
        • UE4
    • Test Devices
    • Server API
      • Data API 2.0
      • Subscription API
      • Push API
        • IOS
        • Android
        • Windows UWP
        • Windows
      • Raw Export
      • Labels API
      • Data API
    • Import historical data via API
    • Data Export
      • Data Export to Cloud Storage (BigQuery / Amazon S3)
  • 3rd Party Sources
    • Attribution Trackers
      • AppsFlyer
      • Adjust
      • Branch.io
      • Kochava
      • Tenjin
      • Tune (MAT)
      • Singular
      • Custom postback API
      • Facebook Ads referral decryption
    • App Marketplace Data
      • App Store Connect Stats
      • App Store Subscriptions
      • Google Play Console Stats
      • Google Play Subscriptions
      • AppGallery Connect Stats
    • Ad revenue
      • AdColony
      • AdMob
      • Facebook
      • MoPub
      • Unity Ads
      • Vungle
      • Ad revenue API
    • Cohort export
  • Reports and Functionality
    • Space-related Reports and Functionality
      • Overview
      • Custom dashboards & Reports
      • SQL
        • SQL tips
        • SQL Query examples
      • Audience overlap
    • Project-related Reports and Functionality
      • Overview
        • Real-Time Dashboard
        • Acquisition reports
        • Engagement reports
        • Monetization reports
        • In-game analysis reports
        • Cohort analysis
      • Reports
      • Push Notifications
        • Android Notifications
        • IOS Notifications
        • Windows Notifications
        • Button Templates
      • Predictions
      • Users & Segments
      • Filters
      • A/B Testing
      • Tuning
      • Settings
  • Metrics and Glossary
    • Ad networks metrics
    • Market Metrics
    • Prediction Metrics
    • SDK Metrics
    • Subscription metrics
  • Space Management
  • User Profile Management
  • Limits
  • Scenarios and Best Practices
    • Analytics use cases
    • Match-3
    • MMORPG Games
    • Hyper-Casual games
    • Social Casino
    • RPG games
    • Farming games
    • Non-gaming app
    • Acquisition Example
  • FAQ
    • Identification
    • Raw Data
    • All about data discrepancies
  • Slack
Powered by GitBook
On this page
  • Last actions before churn
  • User flow
  • Raw data export
  • SQL Wizard
  • Users
  • A/B Tests

Was this helpful?

Export as PDF
  1. Scenarios and Best Practices

Analytics use cases

PreviousScenarios and Best PracticesNextMatch-3

Last updated 10 months ago

Was this helpful?

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.

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

Export Custom events and Sessions there.

After that, 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.

SQL Wizard

  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

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.

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 the last event alone 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 at once 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 the manual on how to run A/B tests in devtodev:

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

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

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

Raw Data Export
SQL Wizard
A/B testing
User flow
Users