Player Daily Session Durations
This dataset provides daily aggregated session metrics for individual players, including total and average session durations, session counts, and timestamps for first and last play. It enables deep analysis of player engagement trends, retention patterns, and behavioral segmentation across platforms and regions, supporting data-driven game design and marketing strategies.
Sample rows
preview · 8 of 110 rows · all 9 columns| player_idstring | platformstring | total_session_duration_minutesfloat | regionstring | session_datedate | session_countinteger | average_session_duration_minutesfloat | first_session_start_timedatetime | last_session_end_timedatetime |
|---|---|---|---|---|---|---|---|---|
| 2c7bf8d1-13c1-43e2-8491-9a8d2b0a1d55 | Web | 0 | US | 2024-06-01 | 0 | 0 | blank | blank |
| alexPanda99 | Android | 5.5 | IN | 2024-06-01 | 1 | 5.5 | 2024-06-01T12:45:17Z | 2024-06-01T12:50:42Z |
| 5E7XF9PA | PC | 90.3 | DE | 2024-06-01 | 8 | 11.2875 | 2024-06-01T08:01:00Z | 2024-06-01T21:14:26Z |
| luna-fox | Console | 60 | BR | 2024-06-01 | 5 | 12 | 2024-06-01T10:12:34Z | 2024-06-01T18:45:56Z |
| d4e6a-9e5f-44f2-8f82-7e71d7b5f7a1 | iOS | 0 | JP | 2024-06-01 | 0 | 0 | blank | blank |
| DARKSTAR_17 | Web | 12.5 | ZA | 2024-06-01 | 2 | 6.25 | 2024-06-01T06:17:02Z | 2024-06-01T08:12:28Z |
| b6c9f3c4-7d4b-45c1-8fb1-0e51a3fa2d99 | PC | 1440 | RU | 2024-06-02 | 24 | 60 | 2024-06-02T00:00:00Z | 2024-06-02T23:59:59Z |
| fox-2024 | iOS | 7 | GB | 2024-06-02 | 1 | 7 | 2024-06-02T18:07:25Z | 2024-06-02T18:14:25Z |
| 07822381 | Android | 37.9 | FR | 2024-06-02 | 4 | 9.475 | 2024-06-02T09:10:44Z | 2024-06-02T14:32:09Z |
| dawn_runner | Other | 1800 | KR | 2024-06-02 | 50 | 36 | 2024-06-02T00:00:13Z | 2024-06-02T23:59:54Z |
| 4f9e8b5b-6b21-46e2-ae11-17b3a0e9b0b3 | Console | 55 | CA | 2024-06-02 | 3 | 18.3333333333 | 2024-06-02T13:19:18Z | 2024-06-02T22:54:03Z |
| VALKYRIE-88 | PC | 0.8 | MX | 2024-06-03 | 1 | 0.8 | 2024-06-03T15:22:18Z | 2024-06-03T15:23:06Z |
| amethyst_owl | Android | 11 | SG | 2024-06-03 | 2 | 5.5 | 2024-06-03T07:23:09Z | 2024-06-03T07:29:49Z |
| b3a6edc2-2b19-4d7b-9c7d-4e3aaaf6a7b7 | Web | 100 | CN | 2024-06-03 | 8 | 12.5 | 2024-06-03T08:51:23Z | 2024-06-03T20:19:40Z |
| zetaWolf | iOS | 8 | AU | 2024-06-03 | 1 | 8 | 2024-06-03T19:01:44Z | 2024-06-03T19:09:44Z |
| 7d31e2d7-cf17-4ef3-9b13-1e3cc04a6511 | Other | 652.5 | SE | 2024-06-03 | 15 | 43.5 | 2024-06-03T00:00:55Z | 2024-06-03T23:57:58Z |
| Archer-55 | Web | 3 | UA | 2024-06-03 | 1 | 3 | 2024-06-03T02:00:50Z | 2024-06-03T02:03:50Z |
| pixel_ranger | Android | 13.1 | NZ | 2024-06-04 | 2 | 6.55 | 2024-06-04T11:32:17Z | 2024-06-04T12:12:01Z |
| eagle777 | PC | 0 | IT | 2024-06-04 | 0 | 0 | blank | blank |
| 9f8d7ab2-5e5b-4c98-9f16-c2c7d90c45e7 | Web | 2.2 | US | 2024-06-04 | 1 | 2.2 | 2024-06-04T22:56:36Z | 2024-06-04T22:58:49Z |
What the 110 rows show
from the 110-row sampleOther platform stands out: mean total_
- 14.6median total_
session_ duration_ minutes - 2median session_
count - 7.6median average_
session_ duration_ minutes
Median 14.6, from 0.0 to 1,800.
- string 3
- integer 1
- float 2
- date 1
- datetime 2
Columns
9 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 3 columns | |||
player_id | string | A unique identifier for each player, such as a UUID or platform-specific user ID. | alexPanda99 |
platform | string | Platform or device type used by the player (e.g., 'iOS', 'Android', 'PC', 'Console').6 values · optional | Web |
region | string | Geographical region or country code associated with the player (e.g., 'US', 'EU', 'JP').optional | US |
| Numbers 3 columns | |||
total_session_duration_minutes | float | Total time in minutes the player spent in sessions on the given date.0 or more | 0 |
session_count | integer | Number of distinct play sessions the player had on the given date.0 or more | 0 |
average_session_duration_minutes | float | Average duration in minutes per session for the player on the given date.0 or more | 0 |
| Dates and times 3 columns | |||
session_date | date | The calendar date (YYYY-MM-DD) for which the session duration is recorded. | 2024-06-01 |
first_session_start_time | datetime | Timestamp of the player's first session start on the given date (in UTC).optional | 2024-06-01T12:45:17Z |
last_session_end_time | datetime | Timestamp of the player's last session end on the given date (in UTC).optional | 2024-06-01T12:50:42Z |
Use it for
A gaming dashboard
Total_
session_ duration_ minutes by platform and a breakdown of region. Excel, Power BI or Tableau. Why do the 10 Other rows have a mean total_
session_ duration_ minutes of 574.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Players1102c7bf8d1-13c1-43e2-8491-9a8d2b0a1d550WebalexPanda995.5Android5E7XF9PA90.3PC
A software demo
Believable players with session_
date, total_ session_ duration_ minutes and session_ count to fill a screen in front of a buyer.
blueprint · player-daily-session-durations
Behind this dataset
Same schema. As many rows as you need.
These 110 rows came out of a blueprint — 9 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.
- Record session start and end times
- Aggregate total daily duration per player
- Flag players with declining activity
- Summarize by player segment
- Highlight top 10% most active users
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
- player-daily-session-durations