Mobile Game Session Durations
This dataset provides detailed, session-level metrics for mobile games, including user identifiers, session timing, device and OS information, in-app purchases, and gameplay events. It is ideal for retention modeling, player segmentation, and optimizing game design for studios and publishers seeking actionable insights on user engagement and monetization.
Sample rows
preview · 8 of 200 rows · all 16 columns| session_idstring | device_typestring | session_level_reachedinteger | in_app_purchaseboolean | countrystring | user_idstring | game_idstring | session_start_timedatetime | session_end_timedatetime | session_duration_secondsinteger | session_datedate | os_typestring | session_numberinteger | retention_dayinteger | session_events_countinteger | session_scorefloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A1b3C9dE-12Xy | smartphone | 2 | false | IN | user1001 | game_A1 | 2024-06-01T09:12:45Z | 2024-06-01T09:17:05Z | 260 | 2024-06-01 | Android | 1 | 0 | 6 | 125 |
| QwErTy1234_1 | tablet | 2 | false | BR | user1002 | game_CX9 | 2024-06-01T11:33:20Z | 2024-06-01T11:37:05Z | 225 | 2024-06-01 | Android | 1 | 0 | 9 | 280.5 |
| user1001-game_A1-2 | smartphone | 7 | true | IN | user1001 | game_A1 | 2024-06-02T10:00:02Z | 2024-06-02T10:45:12Z | 2700 | 2024-06-02 | Android | 2 | 1 | 45 | 3200 |
| XyZ_abc987 | other | 1 | false | RU | user1003 | game_B22 | 2024-05-31T22:54:33Z | 2024-05-31T22:54:34Z | 1 | 2024-05-31 | Other | 1 | 0 | 0 | 0 |
| 9Zx-_eRtyB4 | tablet | 6 | true | JP | user1004 | game_MH5 | 2024-06-03T08:22:44Z | 2024-06-03T09:07:44Z | 2700 | 2024-06-03 | iOS | 1 | 0 | 35 | 2100 |
| user1002-game_CX9-2 | tablet | 9 | true | BR | user1002 | game_CX9 | 2024-06-02T12:08:00Z | 2024-06-02T13:08:00Z | 3600 | 2024-06-02 | Android | 2 | 1 | 88 | 4100.6 |
| user1001-game_A1-3 | smartphone | 5 | false | IN | user1001 | game_A1 | 2024-06-03T13:47:01Z | 2024-06-03T15:17:09Z | 5408 | 2024-06-03 | Android | 3 | 2 | 22 | 1850.4 |
| user1002-game_CX9-3 | tablet | 10 | true | BR | user1002 | game_CX9 | 2024-06-03T14:45:10Z | 2024-06-03T15:45:10Z | 3600 | 2024-06-03 | Android | 3 | 2 | 90 | 4300.2 |
| QWERTY-0987 | smartphone | 1 | false | ZA | user1005 | game_XPZ | 2024-06-02T19:21:33Z | 2024-06-02T19:22:33Z | 60 | 2024-06-02 | Android | 1 | 0 | 1 | 10 |
| user1005-game_XPZ-2 | smartphone | 3 | false | ZA | user1005 | game_XPZ | 2024-06-03T20:10:15Z | 2024-06-03T20:25:15Z | 900 | 2024-06-03 | Android | 2 | 1 | 18 | 375.5 |
| 22xyZ_Abcdef | other | 1 | false | EG | user1006 | game_B22 | 2024-06-01T07:31:05Z | 2024-06-01T07:31:07Z | 2 | 2024-06-01 | Other | 1 | 0 | 0 | 0 |
| AbC-9001_Xy | tablet | 8 | true | FR | user1007 | game_A1 | 2024-06-03T09:55:44Z | 2024-06-03T10:45:44Z | 3000 | 2024-06-03 | iOS | 1 | 0 | 52 | 3500.7 |
| user1007-game_A1-2 | tablet | 13 | true | FR | user1007 | game_A1 | 2024-06-04T10:15:44Z | 2024-06-04T11:15:44Z | 3600 | 2024-06-04 | iOS | 2 | 1 | 90 | 4700 |
| X1Y2Z3W4_56 | smartphone | 2 | false | GB | user1008 | game_MH5 | 2024-06-02T15:28:15Z | 2024-06-02T15:33:15Z | 300 | 2024-06-02 | iOS | 1 | 0 | 8 | 130 |
| user1008-game_MH5-2 | smartphone | 5 | true | GB | user1008 | game_MH5 | 2024-06-03T16:15:00Z | 2024-06-03T16:49:00Z | 2040 | 2024-06-03 | iOS | 2 | 1 | 44 | 2100.5 |
| user1008-game_MH5-3 | smartphone | 15 | true | GB | user1008 | game_MH5 | 2024-06-04T17:00:00Z | 2024-06-04T18:00:00Z | 3600 | 2024-06-04 | iOS | 3 | 2 | 100 | 5000 |
| Xyz_12345678 | other | 1 | false | SG | user1009 | game_XPZ | 2024-06-01T21:00:00Z | 2024-06-01T21:00:02Z | 2 | 2024-06-01 | Other | 1 | 0 | 0 | 0 |
| XY-456zQW | smartphone | 1 | false | CN | user1010 | game_B22 | 2024-06-02T05:15:00Z | 2024-06-02T05:18:00Z | 180 | 2024-06-02 | Android | 1 | 0 | 5 | 50 |
| user1010-game_B22-2 | smartphone | 11 | true | CN | user1010 | game_B22 | 2024-06-03T06:00:00Z | 2024-06-03T07:00:00Z | 3600 | 2024-06-03 | Android | 2 | 1 | 72 | 3800 |
| user1010-game_B22-3 | smartphone | 8 | true | CN | user1010 | game_B22 | 2024-06-04T07:00:00Z | 2024-06-04T07:40:00Z | 2400 | 2024-06-04 | Android | 3 | 2 | 60 | 3100 |
What the 200 rows show
from the 200-row sampleOther (device type) stands out: mean session_
- 57%in_
app_ purchase = true - 8median session_
level_ reached - 3os types
- 5games
- 3,147median session_
duration_ seconds - 1median retention_
day
Median 8, from 1 to 99.
- string 6
- integer 5
- float 1
- date 1
- datetime 2
- boolean 1
Columns
16 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
session_id | string | Unique identifier for each game sessionunique | A1b3C9dE-12Xy |
user_id | string | Unique identifier for the player/user | user1001 |
game_id | string | Unique identifier for the mobile game5 games | game_A1 |
device_type | string | Type of device used (e.g., smartphone, tablet)smartphone · tablet · other · optional | smartphone |
os_type | string | Operating system type (e.g., iOS, Android)iOS · Android · Other · optional | Android |
country | string | Country code of the user (ISO 3166-1 alpha-2)optional | IN |
| Numbers 6 columns | |||
session_duration_seconds | integer | Total duration of the session in seconds1 or more | 260 |
session_number | integer | Sequential session number for the user in this game1 or more | 1 |
retention_day | integer | Retention bucket: 0 for first session, 1 for next day, etc.0 to 30 · optional | 0 |
session_events_count | integer | Number of tracked events/actions during the session0 or more · optional | 6 |
session_score | float | Score or points earned during the session (if applicable)0 or more · optional | 125 |
session_level_reached | integer | Highest game level reached in this session (if applicable)1 or more · optional | 2 |
| Dates and times 3 columns | |||
session_start_time | datetime | Timestamp when the session started | 2024-06-01T09:12:45Z |
session_end_time | datetime | Timestamp when the session ended | 2024-06-01T09:17:05Z |
session_date | date | Calendar date of the session (derived from start time) | 2024-06-01 |
| True or false 1 column | |||
in_app_purchase | boolean | Indicates if an in-app purchase occurred during this sessionoptional | false |
Use it for
A gaming dashboard
The in_
app_ purchase rate, session_ level_ reached by device_ type and a breakdown of country. Excel, Power BI or Tableau. Why do the 30 other rows have a mean session_
level_ reached of 1.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sessions200A1b3C9dE-12Xy2smartpho…user1001-game_A1-27smartpho…9Zx-_eRtyB46tablet
A software demo
Believable sessions with user_
id, game_ id and session_ start_ time to fill a screen in front of a buyer.
This dataset200 rows16 columns
Yours10,000 rows16 columnscountry: UK only
blueprint · mobile-game-session-durations
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 16 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Include game title, session start/end time
- Capture user device type
- Include location (city level)
- Exclude sessions shorter than 1 minute
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- mobile-game-session-durations