• Gaming
  • 13 columns
  • 200 rows
  • 8 formats

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.

  • opened 14 times
  • last updated 21 Aug 2025
  • by GoMask
The brief that made it

Analyzing player retention trends over time for different games and platforms

Sample rows

preview · 8 of 200 rows · all 13 columns
session_idstringsession_typestringretention_dayintegerregionstringgame_idstringstudio_idstringuser_idstringsession_start_datetimedatetimesession_end_datetimedatetimesession_duration_minutesfloatretention_ratefloatplatformstringin_game_purchasesfloat
A9x_3kT2Solo1NAgame_001studio_QAuser_10012024-05-03T13:24:10Z2024-05-03T14:07:34Z43.487.5Mobile0
bH4_zQ8wMultiplayer7EUgame_002studio_TTuser_10022024-05-03T16:54:36Z2024-05-03T17:37:36Z4334.2Console0
kT8_MnN9Co-op14APACgame_003studio_AWuser_10032024-05-04T07:39:12Z2024-05-04T08:31:27Z52.343.1PC4.99
Lw3_8kT4Solo1NAgame_004studio_LXuser_10042024-05-05T20:10:55Z2024-05-05T20:38:12Z27.391Mobile0
yQ2_5vRtMultiplayer30EUgame_005studio_GPuser_10052024-05-06T11:02:00Z2024-05-06T13:02:00Z12027.3PC12.5
vT3_AqW8Solo0SAgame_006studio_XYuser_10062024-05-06T23:51:10Z2024-05-07T00:03:10Z12100Console0
T7w_bZ9jCo-op14NAgame_001studio_QAuser_10072024-05-08T15:29:48Z2024-05-08T17:29:48Z12046.9Mobile0.99
P8v_DhA3Solo1EUgame_002studio_TTuser_10082024-05-09T12:00:16Z2024-05-09T12:40:16Z4082.3Mobile0

What the 200 rows show

from the 200-row sample

Co-op (session type) stands out: mean retention_day is 29.1, against 6.9 for the rest.

  • 7median retention_day
  • 4platforms
  • 6studios
  • 9games
  • 61.5median session_duration_minutes
  • 42.7median retention_rate
Mean retention_day by session_type200 rows
020401.6Solo96 rows16.4Multiplayer53 rows29.1Co-op51 rows
retention_day200 rows, in bands of 10
0701401322802002003060retention_day →

Median 7, from 0 to 60.

region180 rows with a value · 20 left blank
  1. EU63
  2. NA55
  3. APAC19
  4. OC19
  5. AF15
  6. SA7
  7. AS2
13 columns by typefrom the column list below
  • string 7
  • integer 1
  • float 3
  • datetime 2

Columns

13 columns in three groups
blueprint · 13 columns
columntypedescriptionexample
Text 7 columns
session_idstringUnique identifier for each gaming session.uniqueA9x_3kT2
game_idstringUnique identifier for the game in which the session occurred.9 gamesgame_001
studio_idstringUnique identifier for the game studio.6 studiosstudio_QA
user_idstringUnique identifier for the user/player.user_1001
platformstringPlatform on which the session was played (e.g., PC, mobile, console).PC · Mobile · Console · WebMobile
regionstringGeographical region of the user (e.g., NA, EU, APAC).7 regions · optionalNA
session_typestringType of session (e.g., solo, multiplayer, co-op).Solo · Multiplayer · Co-op · optionalSolo
Numbers 4 columns
session_duration_minutesfloatTotal duration of the session in minutes.0 or more43.4
retention_dayintegerDay number after the initial session used to measure retention (e.g., 1 for Day 1, 7 for Day 7).0 or more1
retention_ratefloatPercentage of users retained on the specified retention day (0-100).0 to 10087.5
in_game_purchasesfloatTotal value of in-game purchases made during the session (in USD).0 or more · optional0
Dates and times 2 columns
session_start_datetimedatetimeTimestamp when the gaming session started.2024-05-03T13:24:10Z
session_end_datetimedatetimeTimestamp 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.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    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 rows
  2. 02BeginnerFreeDISTINCT · IS NOT NULL · ORDER BY

    Distinct 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 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Sessions 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
  1. 04Average Duration by Session TypeBeginner
  2. 05Purchases by Studio VisualPower BI
  3. 06Studios with High Average RetentionIntermediate
  4. 07Session Length BucketsIntermediate
  5. 08Regions Above Overall RetentionIntermediate
  6. 09Monthly Sessions and RevenueIntermediate
  7. 10Payer Share by PlatformPower BI
  8. 11Rank Games by PurchasesAdvanced
  9. 12Running Daily PurchasesAdvanced
  10. 13Gap Since Previous SessionAdvanced
  11. 14Platform Share of PurchasesAdvanced
  12. 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.99

Use it for

  • median retenti…7200 rowsmean retention day by…1.6Solo16.4Multip…29.1Co-op

    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.

  • A software demo

    Believable sessions with game_id, studio_id and user_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 13 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows13 columns
Yours1,000 rows13 columnsregion: UK only

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.

Rules it was built with
  • Include game title, session date, retention rate
  • Capture user segment (new/returning)
  • Include platform type
  • Aggregate by weekly cohort
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.