Mobile Data Usage Pattern Dataset
This dataset provides detailed, time-segmented records of mobile data, call, and SMS usage for telecom customers, including network type, device, and location context. It enables in-depth analysis of user consumption patterns, peak usage periods, and regional trends, supporting telecom plan optimization, network planning, and customer segmentation.
Sample rows
preview · 8 of 90 rows · all 14 columns| usage_idstring | time_blockstring | call_minutesfloat | is_roamingboolean | location_citystring | user_idstring | plan_idstring | usage_datedate | data_used_mbfloat | sms_countinteger | network_typestring | device_typestring | location_statestring | location_countrystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| USG0001 | 08:00-11:59 | 15.8 | false | San Francisco | USR102 | PLAN_B | 2024-05-27 | 583.2 | 2 | 4G | smartphone | CA | USA |
| USG0002 | 16:00-19:59 | 0 | false | Los Angeles | USR104 | PLAN_A | 2024-05-27 | 1202.5 | 1 | 5G | smartphone | CA | USA |
| USG0003 | 12:00-15:59 | 23.6 | false | Austin | USR108 | PLAN_B | 2024-05-28 | 322.9 | 0 | 3G | tablet | TX | USA |
| USG0004 | 04:00-07:59 | 0 | false | Madison | USR101 | PLAN_C | 2024-05-28 | 48.3 | 0 | 2G | dongle | WI | USA |
| USG0005 | 20:00-23:59 | 5.3 | false | Seattle | USR105 | PLAN_D | 2024-05-29 | 1766.7 | 4 | 5G | smartphone | WA | USA |
| USG0006 | 00:00-03:59 | 0 | false | Portland | USR103 | PLAN_B | 2024-05-27 | 75.1 | 0 | 2G | other | OR | USA |
| USG0007 | 08:00-11:59 | 8.1 | true | Vancouver | USR107 | PLAN_A | 2024-05-29 | 650.8 | 3 | 4G | smartphone | BC | Canada |
| USG0008 | 16:00-19:59 | 0 | false | New York | USR110 | PLAN_B | 2024-05-30 | 1095.4 | 1 | 5G | smartphone | NY | USA |
| USG0009 | 12:00-15:59 | 11.2 | false | Dallas | USR106 | PLAN_C | 2024-05-28 | 210.2 | 0 | 3G | tablet | TX | USA |
| USG0010 | 20:00-23:59 | 0 | false | San Francisco | USR102 | PLAN_B | 2024-05-30 | 1421.3 | 2 | 5G | smartphone | CA | USA |
| USG0011 | 08:00-11:59 | 2.5 | false | Los Angeles | USR104 | PLAN_A | 2024-05-28 | 380.7 | 0 | 4G | smartphone | CA | USA |
| USG0012 | 12:00-15:59 | 0 | false | Seattle | USR105 | PLAN_D | 2024-05-29 | 825.6 | 1 | 4G | tablet | WA | USA |
| USG0013 | 20:00-23:59 | 0 | false | Austin | USR108 | PLAN_B | 2024-05-29 | 1620.3 | 2 | 5G | smartphone | TX | USA |
| USG0014 | 16:00-19:59 | 0 | false | New York | USR110 | PLAN_B | 2024-05-27 | 1100.8 | 0 | 5G | tablet | NY | USA |
| USG0015 | 04:00-07:59 | 0 | false | Madison | USR101 | PLAN_C | 2024-05-29 | 55.9 | 1 | 3G | dongle | WI | USA |
| USG0016 | 00:00-03:59 | 0 | false | Portland | USR103 | PLAN_B | 2024-05-29 | 62.3 | 0 | 2G | other | OR | USA |
| USG0017 | 12:00-15:59 | 14.2 | false | Dallas | USR106 | PLAN_C | 2024-05-29 | 285.4 | 0 | 3G | tablet | TX | USA |
| USG0018 | 08:00-11:59 | 0 | false | Denver | USR109 | PLAN_A | 2024-05-28 | 340.5 | 4 | 4G | tablet | CO | USA |
| USG0019 | 12:00-15:59 | 7.4 | true | Vancouver | USR107 | PLAN_A | 2024-05-27 | 275.2 | 0 | 4G | smartphone | BC | Canada |
| USG0020 | 16:00-19:59 | 0 | false | San Francisco | USR102 | PLAN_B | 2024-05-29 | 1183.1 | 2 | 5G | smartphone | CA | USA |
What the 90 rows show
from the 90-row sample12:00-15:59 (time block) stands out: mean call_
- 12%is_
roaming = true - 0.0median call_
minutes - 4network types
- 4device types
- 17location countries
- 21plans
Median 0.0, from 0.0 to 23.6.
- string 9
- integer 1
- float 2
- date 1
- boolean 1
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
usage_id | string | Unique identifier for each mobile data usage recordunique | USG0001 |
user_id | string | Unique identifier for the mobile user | USR102 |
plan_id | string | Identifier for the telecom plan subscribed by the user at the time of usage | PLAN_B |
time_block | string | Time block during which data usage was recorded (e.g., '00:00-03:59', '04:00-07:59')6 blocks | 08:00-11:59 |
network_type | string | Type of mobile network used (e.g., '4G', '5G', '3G')2G · 3G · 4G · 5G | 4G |
device_type | string | Type of device used (e.g., 'smartphone', 'tablet', 'dongle')smartphone · tablet · dongle · other · optional | smartphone |
location_city | string | City where the data usage occurredoptional | San Francisco |
location_state | string | State or region where the data usage occurredoptional | CA |
location_country | string | Country where the data usage occurredoptional | USA |
| Numbers 3 columns | |||
data_used_mb | float | Amount of mobile data used in megabytes during the time block0 or more | 583.2 |
call_minutes | float | Total voice call minutes used during the time block0 or more · optional | 15.8 |
sms_count | integer | Number of SMS messages sent during the time block0 or more · optional | 2 |
| Dates and times 1 column | |||
usage_date | date | Date of the recorded data usage | 2024-05-27 |
| True or false 1 column | |||
is_roaming | boolean | Indicates if the user was roaming during the data usageoptional | false |
Use it for
A telecommunications dashboard
The is_
roaming rate, call_ minutes by time_ block and a breakdown of location_ city. Excel, Power BI or Tableau. Why do the 20 12:00-15:59 rows have a mean call_
minutes of 12.0? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Usages90USG000115.808:00-11…USG00078.108:00-11…USG00197.412:00-15…
A software demo
Believable usages with user_
id, plan_ id and usage_ date to fill a screen in front of a buyer.
blueprint · mobile-data-usage-pattern-dataset
Behind this dataset
Same schema. As many rows as you need.
These 90 rows came out of a blueprint — 14 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.
- Usage measured in MB per hour block
- Top 10% users flagged as heavy users
- Aggregate usage by weekday/weekend
- Identify usage spikes exceeding plan limits
- Breakdown by device type
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-data-usage-pattern-dataset