Radio Access Network (RAN) Key Performance Indicators (KPIs)

This dataset provides comprehensive cell-level and base station KPIs for 4G and 5G radio access networks, including signal quality, throughput, resource utilization, handover and RACH success rates, call drop rates, and coverage hole detection. It enables granular performance monitoring, troubleshooting, and optimization of mobile networks across regions and vendors.

  • opened 30 times
  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Cellular network performance monitoring and benchmarking

Sample rows

preview · 8 of 350 rows · all 25 columns
record_idstringcoverage_hole_severitystringrach_success_ratefloatcoverage_hole_detectedbooleanregionstringtimestampdatetimetechnologystringcell_idstringenodeb_gnodeb_idstringsite_namestringcell_namestringcell_sectorintegerrsrp_avgfloatrsrq_avgfloatthroughput_dlfloatthroughput_ulfloatprb_utilization_dlfloatprb_utilization_ulfloathandover_attemptsintegerhandover_successesintegerhandover_success_ratefloatcall_drop_ratefloatrach_attemptsintegerrach_successesintegervendorstring
REC-00001None98.85falseNortheast2024-05-01T08:15:32Z5GCELL-3421AGNB-8872Downtown_HubDowntown_Hub_Sector11-56.3-4.81120.5440.295.897.565063898.150.3870860Ericsson
REC-00002High0trueMountain2024-05-01T09:05:48Z4GCELL-1983BENB-3554Rural_NodeRural_Node_Sector44-137.9-19.7000000089.300Huawei
REC-00003None97.17falsePacific2024-05-01T09:44:14Z5GCELL-4208CGNB-1903Airport_PlazaAirport_Plaza_Sector22-61.5-5.7978.6376.192.693.248547096.910.7600583Samsung
REC-00004High0trueSouthwest2024-05-01T10:13:50Z4GCELL-5412DENB-7681Edge_StationEdge_Station_Sector55-139.1-18.6000000072.600ZTE
REC-00005None99.49falseSoutheast2024-05-01T10:22:11Z5GCELL-6349EGNB-4027Mall_CenterMall_Center_Sector33-45.8-3.51161.241599.899.278077399.10.2990985Ericsson
REC-00006None94.52falseMidwest2024-05-01T10:37:26Z4GCELL-4830FENB-8112Suburban_OakSuburban_Oak_Sector22-78.5-9.566.717.837.630.1635993.652.17369Nokia
REC-00007None95.12falseWest2024-05-01T11:08:43Z5GCELL-2501GGNB-5621Seaside_ParkSeaside_Park_Sector44-76.2-9.1335.492.854.357.221520695.813410390Samsung
REC-00008None80falseNortheast2024-05-01T11:19:05Z4GCELL-9992HENB-4328Tech_CampusTech_Campus_Sector33-90.5-11.147.212.526.923.4241979.177.63528Samsung

What the 350 rows show

from the 350-row sample

High (coverage hole severity) stands out: mean rach_success_rate is 0.0, against 93.6 for the rest.

  • 26%coverage_hole_detected = true
  • 95.6median rach_success_rate
  • 2technologies
  • 5vendors
  • 3median cell_sector
  • -76.2median rsrp_avg
Mean rach_success_rate by coverage_hole_severity350 rows
05010094.5None258 rows36.5Medium4 rows0.0High88 rows
rach_success_rate350 rows, in bands of 10
0110220890011022022215050100rach_success_rate →

Median 95.6, from 0.0 to 100.0.

region350 rows · 7 values
  1. Pacific94
  2. Midwest64
  3. West49
  4. Northeast43
  5. Mountain39
  6. Southeast32
  7. Southwest29
25 columns by typefrom the column list below
  • string 9
  • integer 5
  • float 9
  • datetime 1
  • boolean 1

Columns

25 columns in four groups
blueprint · 25 columns
columntypedescriptionexample
Text 9 columns
record_idstringUnique identifier for each KPI recorduniqueREC-00001
technologystringRadio access technology type (e.g., 4G, 5G)4G · 5G5G
cell_idstringUnique identifier for the cellCELL-3421A
enodeb_gnodeb_idstringUnique identifier for the eNodeB (4G) or gNodeB (5G) base stationGNB-8872
site_namestringName of the physical site where the base station is locatedoptionalDowntown_Hub
cell_namestringDescriptive name for the celloptionalDowntown_Hub_Sector1
coverage_hole_severitystringSeverity level of the detected coverage hole (if any)None · Low · Medium · High · optionalNone
regionstringGeographical region or market where the cell is deployed7 regions · optionalNortheast
vendorstringEquipment vendor for the cell/base station5 vendors · optionalEricsson
Numbers 14 columns
cell_sectorintegerSector number of the cell within the site1 to 6 · optional1
rsrp_avgfloatAverage Reference Signal Received Power (RSRP) in dBm-140 to -44 · optional-56.3
rsrq_avgfloatAverage Reference Signal Received Quality (RSRQ) in dB-19.5 to -3 · optional-4.8
throughput_dlfloatAverage downlink throughput in Mbps0 or more · optional1120.5
throughput_ulfloatAverage uplink throughput in Mbps0 or more · optional440.2
prb_utilization_dlfloatPercentage of downlink Physical Resource Block (PRB) utilization0 to 100 · optional95.8
prb_utilization_ulfloatPercentage of uplink Physical Resource Block (PRB) utilization0 to 100 · optional97.5
handover_attemptsintegerTotal number of handover attempts during the measurement period0 or more · optional650
handover_successesintegerTotal number of successful handovers during the measurement period0 or more · optional638
handover_success_ratefloatPercentage of successful handovers (successes/attempts * 100)0 to 100 · optional98.15
call_drop_ratefloatPercentage of calls dropped in the cell during the measurement period0 to 100 · optional0.3
rach_attemptsintegerTotal number of Random Access Channel (RACH) attempts0 or more · optional870
rach_successesintegerTotal number of successful RACH attempts0 or more · optional860
rach_success_ratefloatPercentage of successful RACH attempts (successes/attempts * 100)0 to 100 · optional98.85
Dates and times 1 column
timestampdatetimeDate and time when the KPI measurement was taken2024-05-01T08:15:32Z
True or false 1 column
coverage_hole_detectedbooleanIndicates whether a coverage hole was detected in the cell during the measurement periodoptionalfalse

15 SQL practice questions for the Radio Access Network (RAN) Key Performance Indicators (KPIs)

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

    High severity coverage holes

    Return record_id, site_name, region and rsrp_avg for every record where coverage_hole_severity is 'High'. Order the results by rsrp_avg ascending, then by record_id ascending.

    Tables: radio_access_network_ran_key_performance_indicat · your result: 4 columns, 88 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct vendor and technology pairs

    Return each distinct combination of vendor and technology, using the columns vendor and technology. Order the results by vendor, then by technology.

    Tables: radio_access_network_ran_key_performance_indicat · your result: 2 columns, 7 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Record count per region

    Count the records in each region. Return the columns region and record_count, ordered by record_count descending, then by region ascending.

    Tables: radio_access_network_ran_key_performance_indicat · your result: 2 columns, 7 rows
  1. 04Average downlink throughput by technologyBeginner
  2. 05Handover totals by vendorPower BI
  3. 06Regions with high average call dropsIntermediate
  4. 07Signal quality bucketsIntermediate
  5. 08Vendors above overall average drop rateIntermediate
  6. 09Monthly records and coverage holesIntermediate
  7. 10Coverage hole rate by regionPower BI
  8. 11Top 2 throughput ranks per regionAdvanced
  9. 12Change in monthly drop rateAdvanced
  10. 13Running total of coverage holesAdvanced
  11. 14Vendor share of total RACH attemptsAdvanced
  12. 15Anomalous cells vs technology averagePower 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

  • coverage hole …26%92 of 350 rowsmean rach success rat…94.5None36.5Medium0.0High

    A telecommunications dashboard

    The coverage_hole_detected rate, rach_success_rate by coverage_hole_severity and a breakdown of region. Excel, Power BI or Tableau.

  • Why do the 88 High rows have a mean rach_success_rate of 0.0?

    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 records with timestamp, technology and cell_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 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 dataset350 rows25 columns
Yours1,000 rows25 columnssite_name: UK only

blueprint · radio-access-network-ran-key-performance-indicators-kpis

Behind this dataset

Same schema. As many rows as you need.

These 350 rows came out of a blueprint — 25 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
  • Cell ID (eNodeB ID + cell index) and sector information
  • Timestamp: hourly or 15-minute granularity for performance monitoring
  • RSRP (Reference Signal Received Power) in dBm: -80 to -120 dBm typical
  • RSRQ (Reference Signal Received Quality) in dB: -10 to -20 dB typical
  • Downlink/uplink throughput (Mbps) average and peak
  • PRB (Physical Resource Block) utilization percentage
  • Handover success rate percentage and handover failure causes
  • Call drop rate (CDR) and RRC connection establishment success rate
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
radio-access-network-ran-key-performance-indicators-kpis

What should your data show?

Preview 20 rows free
No signup. No card.