Core Network Signaling and Session Management KPIs
This dataset provides granular KPIs for core mobile network signaling and session management, covering MME, AMF, and SMF functions. It includes attach rates, session establishment success, interface load, and GTP tunnel metrics, enabling operators to monitor, optimize, and troubleshoot network performance across regions and time periods.
Sample rows
preview · 8 of 250 rows · all 23 columns| record_idstring | network_functionstring | attach_success_ratefloat | regionstring | function_instance_idstring | site_idstring | datedate | measurement_period_startdatetime | measurement_period_enddatetime | attach_attemptsinteger | attach_successesinteger | tau_rau_attemptsinteger | tau_rau_successesinteger | tau_rau_success_ratefloat | pdn_pdu_session_attemptsinteger | pdn_pdu_session_successesinteger | pdn_pdu_session_success_ratefloat | s1_n2_interface_loadfloat | s1_n2_interface_peak_loadfloat | gtp_tunnel_countinteger | gtp_tunnel_failuresinteger | gtp_tunnel_success_ratefloat | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KPI-0001 | MME | 99.5 | North-America | MME-1001 | NYC-01 | 2024-06-01 | 2024-06-01T08:00:00Z | 2024-06-01T09:00:00Z | 32150 | 31989 | 25500 | 25400 | 99.61 | 24100 | 24050 | 99.79 | 1350.7 | 1509.8 | 24000 | 2 | 99.99 | Peak morning traffic observed in downtown NYC. |
| KPI-0002 | AMF | 99.81 | West-Europe | AMF-2057 | Paris-02 | 2024-06-02 | 2024-06-02T19:00:00Z | 2024-06-02T20:00:00Z | 46310 | 46220 | 38000 | 37789 | 99.45 | 31500 | 31495 | 99.98 | 2110.5 | 3899.1 | 31500 | 3 | 99.99 | Heavy evening load due to local event attendance surge. |
| KPI-0003 | SMF | 99.56 | East-Asia | SMF-3002 | Tokyo-05 | 2024-06-03 | 2024-06-03T07:00:00Z | 2024-06-03T08:00:00Z | 28794 | 28667 | 21780 | 21695 | 99.61 | 19800 | 19799 | 99.99 | 1041.3 | 1128.8 | 19780 | 1 | 99.99 | Rush hour traffic; systems performing optimally. |
| KPI-0004 | MME | 87.5 | Northern-Canada | MME-1007 | Remote-CA-13 | 2024-06-01 | 2024-06-01T10:00:00Z | 2024-06-01T11:00:00Z | 128 | 112 | 94 | 83 | 88.3 | 72 | 66 | 91.67 | 1.9 | 2.2 | 70 | 10 | 85.71 | Remote site, moderate reliability, weather impact. |
| KPI-0005 | AMF | 98.03 | Oceania | AMF-2099 | Rural-OCE-02 | 2024-06-04 | 2024-06-04T15:00:00Z | 2024-06-04T16:00:00Z | 305 | 299 | 200 | 196 | 98 | 160 | 157 | 98.13 | 4.7 | 7.2 | 159 | 3 | 98.11 | Rural site, stable with minimal errors. |
| KPI-0006 | SMF | 80.65 | West-Africa | SMF-3044 | Rural-WA-19 | 2024-06-02 | 2024-06-02T12:00:00Z | 2024-06-02T13:00:00Z | 62 | 50 | 28 | 26 | 92.86 | 14 | 11 | 78.57 | 0.8 | 1.2 | 14 | 3 | 78.57 | Weather impact, low attach rates, intermittent service. |
| KPI-0007 | AMF | 0 | Lab | AMF-2121 | blank | 2024-06-03 | 2024-06-03T00:00:00Z | 2024-06-03T01:00:00Z | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Lab test: no traffic recorded in this period. |
| KPI-0008 | SMF | 100 | blank | SMF-3155 | blank | 2024-06-04 | 2024-06-04T23:00:00Z | 2024-06-05T00:00:00Z | 2 | 2 | 1 | 1 | 100 | 2 | 2 | 100 | 0.01 | 0.02 | 2 | 0 | 100 | Experimental validation, minimal attach attempts. |
| KPI-0009 | MME | 0 | Antarctica | MME-1211 | blank | 2024-06-02 | 2024-06-02T00:00:00Z | 2024-06-03T00:00:00Z | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Site switched off for maintenance in Antarctica. |
| KPI-0010 | AMF | 95.25 | Global-Roaming | AMF-2218 | Roam-CA-04 | 2024-06-01 | 2024-06-01T13:00:00Z | 2024-06-01T14:00:00Z | 2001 | 1906 | 1410 | 1378 | 97.73 | 1443 | 1426 | 98.82 | 181.6 | 203.5 | 1440 | 52 | 96.39 | Roaming scenario, mixed device profiles, border crossing. |
| KPI-0011 | SMF | 85.14 | Global-Roaming | SMF-3233 | Roam-EU-08 | 2024-06-05 | 2024-06-05T18:00:00Z | 2024-06-05T19:00:00Z | 1189 | 1012 | 1056 | 1006 | 95.26 | 1272 | 1172 | 92.14 | 161.8 | 179.5 | 1270 | 198 | 84.43 | Roaming: packet drop and congestion at border area. |
| KPI-0012 | MME | 99.51 | East-Asia | MME-1333 | Tokyo-07 | 2024-06-03 | 2024-06-03T20:00:00Z | 2024-06-03T21:00:00Z | 38600 | 38410 | 31911 | 31811 | 99.69 | 29500 | 29499 | 99.99 | 1560.2 | 1739.2 | 29500 | 1 | 99.99 | Evening event, sustained high attach successes. |
| KPI-0013 | AMF | 99.9 | West-Europe | AMF-2351 | Berlin-03 | 2024-06-02 | 2024-06-02T08:00:00Z | 2024-06-02T09:00:00Z | 17890 | 17872 | 15621 | 15615 | 99.96 | 14500 | 14500 | 100 | 855.4 | 1312.5 | 14500 | 0 | 100 | High reliability during weekday morning rush hour. |
| KPI-0014 | SMF | 99.77 | North-America | SMF-3398 | LA-04 | 2024-06-04 | 2024-06-04T07:00:00Z | 2024-06-04T08:00:00Z | 21350 | 21300 | 19200 | 19194 | 99.97 | 18400 | 18399 | 99.99 | 701.8 | 1372.2 | 18400 | 1 | 99.99 | Routine weekday traffic; stable KPIs. |
| KPI-0015 | MME | 99.69 | East-Asia | MME-1444 | Seoul-09 | 2024-06-05 | 2024-06-05T18:00:00Z | 2024-06-05T19:00:00Z | 32500 | 32400 | 29900 | 29899 | 99.99 | 27100 | 27090 | 99.96 | 1301.5 | 1501.6 | 27100 | 10 | 99.96 | High mobile usage during game launch event in Seoul. |
| KPI-0016 | AMF | 97.11 | West-Europe | AMF-2412 | London-06 | 2024-06-01 | 2024-06-01T17:00:00Z | 2024-06-01T18:00:00Z | 13900 | 13580 | 11200 | 11189 | 99.9 | 9000 | 8998 | 99.98 | 458.2 | 526.5 | 9000 | 2 | 99.98 | Event traffic, minor attach failures noted. |
| KPI-0017 | SMF | 99.94 | North-America | SMF-3456 | Chicago-02 | 2024-06-02 | 2024-06-02T08:00:00Z | 2024-06-02T09:00:00Z | 15890 | 15880 | 13456 | 13455 | 99.99 | 11500 | 11500 | 100 | 609.1 | 1224.1 | 11500 | 0 | 100 | Morning rush hour, excellent reliability. |
| KPI-0018 | MME | 83.89 | West-Africa | MME-1555 | Remote-WA-29 | 2024-06-05 | 2024-06-05T13:00:00Z | 2024-06-05T14:00:00Z | 211 | 177 | 188 | 157 | 83.51 | 142 | 125 | 88.03 | 2.8 | 4.3 | 140 | 13 | 90.71 | Rural site, low attach reliability due to storms. |
| KPI-0019 | AMF | 99.23 | Oceania | AMF-2525 | Remote-OCE-24 | 2024-06-03 | 2024-06-03T18:00:00Z | 2024-06-03T19:00:00Z | 130 | 129 | 110 | 110 | 100 | 90 | 90 | 100 | 2.1 | 2.7 | 90 | 0 | 100 | Remote rural site, optimal attach and session rates. |
| KPI-0020 | SMF | 0 | Lab | SMF-3577 | Test-03 | 2024-06-04 | 2024-06-04T03:00:00Z | 2024-06-04T04:00:00Z | 3 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 0.01 | 0.02 | 1 | 1 | 0 | Lab test: all attach/session attempts failed. |
What the 250 rows show
from the 250-row sample- 99.7median attach_
success_ rate - 14,699median attach_
attempts - 14,398median attach_
successes - 11,111median tau_
rau_ attempts - 10,559median tau_
rau_ successes - 99.9median tau_
rau_ success_ rate
Median 99.7, from 0.0 to 100.0.
- string 6
- integer 8
- float 6
- date 1
- datetime 2
Columns
23 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
record_id | string | Unique identifier for each KPI recordunique | KPI-0001 |
network_function | string | Type of core network function (MME, AMF, SMF)MME · AMF · SMF | MME |
function_instance_id | string | Unique identifier for the specific network function instance | MME-1001 |
region | string | Geographical region or area of the network functionoptional | North-America |
site_id | string | Identifier for the network site or locationoptional | NYC-01 |
notes | string | Additional comments or observations for the KPI recordoptional | Peak morning traffic obse… |
| Numbers 14 columns | |||
attach_attempts | integer | Total number of attach attempts during the period0 or more · optional | 32150 |
attach_successes | integer | Number of successful attach procedures0 or more · optional | 31989 |
attach_success_rate | float | Percentage of successful attach attempts (0-100)0 to 100 · optional | 99.5 |
tau_rau_attempts | integer | Total number of TAU (Tracking Area Update) or RAU (Routing Area Update) attempts0 or more · optional | 25500 |
tau_rau_successes | integer | Number of successful TAU/RAU procedures0 or more · optional | 25400 |
tau_rau_success_rate | float | Percentage of successful TAU/RAU attempts (0-100)0 to 100 · optional | 99.61 |
pdn_pdu_session_attempts | integer | Total number of PDN (Packet Data Network) or PDU (Protocol Data Unit) session establishment attempts0 or more · optional | 24100 |
pdn_pdu_session_successes | integer | Number of successful PDN/PDU session establishments0 or more · optional | 24050 |
pdn_pdu_session_success_rate | float | Percentage of successful PDN/PDU session establishments (0-100)0 to 100 · optional | 99.79 |
s1_n2_interface_load | float | Average load on S1 (LTE) or N2 (5G) interface during the period (Mbps)0 or more · optional | 1350.7 |
s1_n2_interface_peak_load | float | Peak load on S1/N2 interface during the period (Mbps)0 or more · optional | 1509.8 |
gtp_tunnel_count | integer | Number of GTP (GPRS Tunneling Protocol) tunnels established0 or more · optional | 24000 |
gtp_tunnel_failures | integer | Number of failed GTP tunnel establishments0 or more · optional | 2 |
gtp_tunnel_success_rate | float | Percentage of successful GTP tunnel establishments (0-100)0 to 100 · optional | 99.99 |
| Dates and times 3 columns | |||
date | date | Date of KPI measurement | 2024-06-01 |
measurement_period_start | datetime | Start timestamp of the KPI measurement period | 2024-06-01T08:00:00Z |
measurement_period_end | datetime | End timestamp of the KPI measurement period | 2024-06-01T09:00:00Z |
15 SQL practice questions for the Core Network Signaling and Session Management 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.
Ten lowest attach success records
Return record_id, region, site_id and attach_success_rate for the 10 records with the lowest attach_success_rate, considering only rows where attach_attempts is greater than 0. Order by attach_success_rate ascending, then record_id ascending.
Tables: core_network_signaling_and_session_management_kp · your result: 4 columns, 10 rowsList the distinct regions
Return the distinct non-null region values in a single column named region, sorted alphabetically.
Tables: core_network_signaling_and_session_management_kp · your result: 1 columns, 13 rowsRecords per network function
Count the records for each network_function. Return network_function and record_count, ordered by network_function.
Tables: core_network_signaling_and_session_management_kp · your result: 2 columns, 3 rows
- 04Attach attempts and average rate by functionBeginner
- 05Power BI: GTP failures by functionPower BI
- 06Regions with heavy attach attemptsIntermediate
- 07Interface load bucketsIntermediate
- 08Records below the overall attach averageIntermediate
- 09Monthly PDU session successIntermediate
- 10Power BI: Weighted TAU success by functionPower BI
- 11Top 3 attach rates per functionAdvanced
- 12Daily change in attach attemptsAdvanced
- 13Running total of GTP failuresAdvanced
- 14Region share of GTP tunnelsAdvanced
- 15Power BI: Peak load anomalies by functionPower 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 telecommunications dashboard
Attach_
success_ rate by network_ function and a breakdown of region. Excel, Power BI or Tableau. What pattern can you find in 250 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 250 rows.
- Records250KPI-000199.5MMEKPI-000299.81AMFKPI-000399.56SMF
A software demo
Believable records with network_
function, function_ instance_ id and region to fill a screen in front of a buyer.
blueprint · core-network-signaling-and-session-management-kpis
Behind this dataset
Same schema. As many rows as you need.
These 250 rows came out of a blueprint — 23 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.
- Network element ID: MME (4G) or AMF (5G) instance identifier
- Attach/registration success rate percentage and failure causes
- TAU (Tracking Area Update) or RAU (Routing Area Update) success rate
- PDN connection (4G) or PDU session (5G) establishment success
- Average number of attached/registered subscribers per NE
- S1/N2 interface load: messages per second and bandwidth utilization
- GTP (GPRS Tunneling Protocol) tunnel setup time in milliseconds
- Paging success rate and paging response time
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
- core-network-signaling-and-session-management-kpis