Gaming Session Retention Trends
This dataset provides detailed, time-series retention metrics for gaming sessions across multiple platforms, regions, and game studios. It enables studios to analyze user engagement, session durations, and in-game purchases, supporting data-driven strategies to improve player retention and maximize lifetime value. The schema is designed for flexible segmentation and trend analysis.
Sample rows
preview · 8 of 200 rows · all 13 columns| session_idstring | session_typestring | retention_dayinteger | regionstring | game_idstring | studio_idstring | user_idstring | session_start_datetimedatetime | session_end_datetimedatetime | session_duration_minutesfloat | retention_ratefloat | platformstring | in_game_purchasesfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A9x_3kT2 | Solo | 1 | NA | game_001 | studio_QA | user_1001 | 2024-05-03T13:24:10Z | 2024-05-03T14:07:34Z | 43.4 | 87.5 | Mobile | 0 |
| bH4_zQ8w | Multiplayer | 7 | EU | game_002 | studio_TT | user_1002 | 2024-05-03T16:54:36Z | 2024-05-03T17:37:36Z | 43 | 34.2 | Console | 0 |
| kT8_MnN9 | Co-op | 14 | APAC | game_003 | studio_AW | user_1003 | 2024-05-04T07:39:12Z | 2024-05-04T08:31:27Z | 52.3 | 43.1 | PC | 4.99 |
| Lw3_8kT4 | Solo | 1 | NA | game_004 | studio_LX | user_1004 | 2024-05-05T20:10:55Z | 2024-05-05T20:38:12Z | 27.3 | 91 | Mobile | 0 |
| yQ2_5vRt | Multiplayer | 30 | EU | game_005 | studio_GP | user_1005 | 2024-05-06T11:02:00Z | 2024-05-06T13:02:00Z | 120 | 27.3 | PC | 12.5 |
| vT3_AqW8 | Solo | 0 | SA | game_006 | studio_XY | user_1006 | 2024-05-06T23:51:10Z | 2024-05-07T00:03:10Z | 12 | 100 | Console | 0 |
| T7w_bZ9j | Co-op | 14 | NA | game_001 | studio_QA | user_1007 | 2024-05-08T15:29:48Z | 2024-05-08T17:29:48Z | 120 | 46.9 | Mobile | 0.99 |
| P8v_DhA3 | Solo | 1 | EU | game_002 | studio_TT | user_1008 | 2024-05-09T12:00:16Z | 2024-05-09T12:40:16Z | 40 | 82.3 | Mobile | 0 |
| xR2_nK3f | Multiplayer | 7 | APAC | game_003 | studio_AW | user_1009 | 2024-05-10T21:45:23Z | 2024-05-10T22:34:23Z | 49 | 28.4 | Console | 0 |
| Q4s_2pEr | Co-op | 30 | OC | game_004 | studio_LX | user_1010 | 2024-05-11T10:36:00Z | 2024-05-11T11:36:00Z | 60 | 17.8 | PC | 10 |
| W7z_6nUr | Solo | 0 | EU | game_005 | studio_GP | user_1011 | 2024-05-12T18:12:40Z | 2024-05-12T18:24:40Z | 12 | 0 | Console | 0 |
| sQ1_4vTr | Multiplayer | 60 | NA | game_006 | studio_XY | user_1012 | 2024-05-13T23:59:59Z | 2024-05-14T03:59:59Z | 240 | 100 | PC | 99.99 |
| hG8_Pz2c | Solo | 1 | blank | game_007 | studio_AW | user_1013 | 2024-05-14T17:15:01Z | 2024-05-14T17:15:01Z | 0 | 0 | Web | 0 |
| uJ3_dQ6m | Co-op | 7 | AF | game_008 | studio_LX | user_1014 | 2024-05-15T09:22:30Z | 2024-05-15T09:32:45Z | 10.25 | 15 | Web | 0 |
| pK9_wV1x | Solo | 0 | NA | game_001 | studio_QA | user_1015 | 2024-05-16T11:45:10Z | 2024-05-16T12:15:10Z | 30 | 100 | Mobile | 0 |
| Z2v_bK6w | Multiplayer | 7 | EU | game_002 | studio_TT | user_1016 | 2024-05-17T20:33:00Z | 2024-05-17T21:13:00Z | 40 | 39.2 | Console | 19.99 |
| kM5_2wJz | Solo | 1 | APAC | game_003 | studio_AW | user_1017 | 2024-05-18T08:12:01Z | 2024-05-18T08:42:39Z | 30.63 | 61.2 | Mobile | 2.49 |
| eN2_pK4v | Co-op | 14 | OC | game_004 | studio_LX | user_1018 | 2024-05-19T16:00:00Z | 2024-05-19T18:46:00Z | 166 | 41.7 | PC | 0 |
| V1g_rQ3s | Multiplayer | 60 | NA | game_005 | studio_GP | user_1019 | 2024-05-20T14:30:30Z | 2024-05-20T17:10:30Z | 160 | 0 | PC | 250 |
| rT4_zK1e | Multiplayer | 7 | EU | game_006 | studio_XY | user_1020 | 2024-05-21T22:22:22Z | 2024-05-22T01:22:22Z | 180 | 48.6 | Console | 0 |
What the 200 rows show
from the 200-row sampleCo-op (session type) stands out: mean retention_
- 7median retention_
day - 4platforms
- 6studios
- 9games
- 61.5median session_
duration_ minutes - 42.7median retention_
rate
Median 7, from 0 to 60.
- string 7
- integer 1
- float 3
- datetime 2
Columns
13 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
session_id | string | Unique identifier for each gaming session.unique | A9x_3kT2 |
game_id | string | Unique identifier for the game in which the session occurred.9 games | game_001 |
studio_id | string | Unique identifier for the game studio.6 studios | studio_QA |
user_id | string | Unique identifier for the user/player. | user_1001 |
platform | string | Platform on which the session was played (e.g., PC, mobile, console).PC · Mobile · Console · Web | Mobile |
region | string | Geographical region of the user (e.g., NA, EU, APAC).7 regions · optional | NA |
session_type | string | Type of session (e.g., solo, multiplayer, co-op).Solo · Multiplayer · Co-op · optional | Solo |
| Numbers 4 columns | |||
session_duration_minutes | float | Total duration of the session in minutes.0 or more | 43.4 |
retention_day | integer | Day number after the initial session used to measure retention (e.g., 1 for Day 1, 7 for Day 7).0 or more | 1 |
retention_rate | float | Percentage of users retained on the specified retention day (0-100).0 to 100 | 87.5 |
in_game_purchases | float | Total value of in-game purchases made during the session (in USD).0 or more · optional | 0 |
| Dates and times 2 columns | |||
session_start_datetime | datetime | Timestamp when the gaming session started. | 2024-05-03T13:24:10Z |
session_end_datetime | datetime | Timestamp when the gaming session ended. | 2024-05-03T14:07:34Z |
15 SQL practice questions for the Gaming Session Retention Trends
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
Long Mobile Sessions
Return session_id, user_id and session_duration_minutes for all Mobile sessions longer than 120 minutes. Sort by session_duration_minutes from highest to lowest, then by session_id ascending.
Tables: gaming_session_retention_trends · your result: 3 columns, 3 rowsDistinct Regions and Platforms
Return each distinct combination of region and platform, leaving out rows where region is null. Return the columns region and platform, ordered by region and then platform.
Tables: gaming_session_retention_trends · your result: 2 columns, 21 rowsSessions per Platform
Count the sessions for each platform. Return the columns platform and session_count, ordered by session_count from highest to lowest, then by platform.
Tables: gaming_session_retention_trends · your result: 2 columns, 4 rows
- 04Average Duration by Session TypeBeginner
- 05Purchases by Studio VisualPower BI
- 06Studios with High Average RetentionIntermediate
- 07Session Length BucketsIntermediate
- 08Regions Above Overall RetentionIntermediate
- 09Monthly Sessions and RevenueIntermediate
- 10Payer Share by PlatformPower BI
- 11Rank Games by PurchasesAdvanced
- 12Running Daily PurchasesAdvanced
- 13Gap Since Previous SessionAdvanced
- 14Platform Share of PurchasesAdvanced
- 15Duration Anomaly TablePower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
A gaming dashboard
Retention_
day by session_ type and a breakdown of region. Excel, Power BI or Tableau. Why do the 51 Co-op rows have a mean retention_
day of 29.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sessions200A9x_3kT21SolobH4_zQ8w7Multipla…kT8_MnN914Co-op
A software demo
Believable sessions with game_
id, studio_ id and user_ id to fill a screen in front of a buyer.
blueprint · gaming-session-retention-trends
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 13 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.
- Include game title, session date, retention rate
- Capture user segment (new/returning)
- Include platform type
- Aggregate by weekly cohort
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- gaming-session-retention-trends