US20180270678A1 - Determining network performance metrics using customer-specific information - Google Patents

Determining network performance metrics using customer-specific information Download PDF

Info

Publication number
US20180270678A1
US20180270678A1 US15/462,746 US201715462746A US2018270678A1 US 20180270678 A1 US20180270678 A1 US 20180270678A1 US 201715462746 A US201715462746 A US 201715462746A US 2018270678 A1 US2018270678 A1 US 2018270678A1
Authority
US
United States
Prior art keywords
communications network
customer
network
csts
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
US15/462,746
Other versions
US10091679B1 (en
Inventor
Le Roy Munar
Doris Ho
Ting Zhang
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
T Mobile USA Inc
Original Assignee
T Mobile USA Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by T Mobile USA Inc filed Critical T Mobile USA Inc
Priority to US15/462,746 priority Critical patent/US10091679B1/en
Assigned to T-MOBILE USA, INC. reassignment T-MOBILE USA, INC. ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: ZHANG, TING, HO, DORIS, MUNAR, LE ROY
Publication of US20180270678A1 publication Critical patent/US20180270678A1/en
Priority to US16/147,309 priority patent/US10757592B2/en
Application granted granted Critical
Publication of US10091679B1 publication Critical patent/US10091679B1/en
Assigned to DEUTSCHE BANK TRUST COMPANY AMERICAS reassignment DEUTSCHE BANK TRUST COMPANY AMERICAS SECURITY AGREEMENT Assignors: ASSURANCE WIRELESS USA, L.P., BOOST WORLDWIDE, LLC, CLEARWIRE COMMUNICATIONS LLC, CLEARWIRE IP HOLDINGS LLC, CLEARWIRE LEGACY LLC, ISBV LLC, Layer3 TV, Inc., PushSpring, Inc., SPRINT COMMUNICATIONS COMPANY L.P., SPRINT INTERNATIONAL INCORPORATED, SPRINT SPECTRUM L.P., T-MOBILE CENTRAL LLC, T-MOBILE USA, INC.
Assigned to IBSV LLC, T-MOBILE USA, INC., SPRINT INTERNATIONAL INCORPORATED, BOOST WORLDWIDE, LLC, ASSURANCE WIRELESS USA, L.P., T-MOBILE CENTRAL LLC, CLEARWIRE IP HOLDINGS LLC, SPRINTCOM LLC, CLEARWIRE COMMUNICATIONS LLC, SPRINT COMMUNICATIONS COMPANY L.P., LAYER3 TV, LLC, SPRINT SPECTRUM LLC, PUSHSPRING, LLC reassignment IBSV LLC RELEASE BY SECURED PARTY (SEE DOCUMENT FOR DETAILS). Assignors: DEUTSCHE BANK TRUST COMPANY AMERICAS
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04WWIRELESS COMMUNICATION NETWORKS
    • H04W24/00Supervisory, monitoring or testing arrangements
    • H04W24/08Testing, supervising or monitoring using real traffic
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M3/00Automatic or semi-automatic exchanges
    • H04M3/22Arrangements for supervision, monitoring or testing
    • H04M3/2218Call detail recording
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M3/00Automatic or semi-automatic exchanges
    • H04M3/22Arrangements for supervision, monitoring or testing
    • H04M3/2227Quality of service monitoring
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M3/00Automatic or semi-automatic exchanges
    • H04M3/42Systems providing special services or facilities to subscribers
    • H04M3/50Centralised arrangements for answering calls; Centralised arrangements for recording messages for absent or busy subscribers ; Centralised arrangements for recording messages
    • H04M3/51Centralised call answering arrangements requiring operator intervention, e.g. call or contact centers for telemarketing
    • H04M3/5175Call or contact centers supervision arrangements
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04WWIRELESS COMMUNICATION NETWORKS
    • H04W24/00Supervisory, monitoring or testing arrangements
    • H04W24/10Scheduling measurement reports ; Arrangements for measurement reports
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M2203/00Aspects of automatic or semi-automatic exchanges
    • H04M2203/40Aspects of automatic or semi-automatic exchanges related to call centers
    • H04M2203/401Performance feedback
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M2203/00Aspects of automatic or semi-automatic exchanges
    • H04M2203/55Aspects of automatic or semi-automatic exchanges related to network data storage and management
    • H04M2203/551Call history
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M2203/00Aspects of automatic or semi-automatic exchanges
    • H04M2203/55Aspects of automatic or semi-automatic exchanges related to network data storage and management
    • H04M2203/555Statistics, e.g. about subscribers but not being call statistics
    • H04M2203/556Statistical analysis and interpretation
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M2203/00Aspects of automatic or semi-automatic exchanges
    • H04M2203/55Aspects of automatic or semi-automatic exchanges related to network data storage and management
    • H04M2203/558Databases
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04MTELEPHONIC COMMUNICATION
    • H04M2207/00Type of exchange or network, i.e. telephonic medium, in which the telephonic communication takes place
    • H04M2207/18Type of exchange or network, i.e. telephonic medium, in which the telephonic communication takes place wireless networks

Definitions

  • KPIs key performance indicators
  • Example KPIs include and/or reflect dropped call rates, wireless leakage, network usage, network quality, network speed, network reliability, costs to customers, and many other indicators.
  • a network provider measures and determines network-centric KPIs, such as KPIs that are based on data associated with the operation or performance of network components, such as cells, base stations, and so on. For example, given a network of 60,000 or so cell sites, the provider may determine KPIs associated with voice dropped call rates, network registration metrics, network availability data, and so on.
  • KPIs network-centric KPIs
  • the provider may face various issues associated with identifying and determining KPIs of value to various stakeholders for the network, such as customers, subscribers, vendors, and so on.
  • FIG. 1 is a block diagram illustrating a suitable network environment for generating a customer stats table (CST) for a communications network.
  • CST customer stats table
  • FIG. 2 is a block diagram illustrating information flows between network data sources and a database module.
  • FIG. 3 is a diagram illustrating an example CST database of customer stats tables.
  • FIG. 4 is a flow diagram illustrating a method for performing actions using key performance indicators (KPIs) determined from customer-specific data sources.
  • KPIs key performance indicators
  • FIGS. 5A-5D are display diagrams illustrating reports based on KPIs generated from the customer stats table (CST).
  • FIG. 6 is a flow diagram illustrating a method for identifying suboptimal network components using data from the customer stats table (CST).
  • CST customer stats table
  • FIGS. 7A-7D are display diagrams illustrating an example scenario of identifying poor performing network cells using CST data.
  • FIGS. 8A-8C are display diagrams illustrating an example scenario of identifying high LTE leakage network cells using CST data.
  • Systems and methods are described herein for analyzing the performance of a communications network (e.g., a mobile telecommunications network) using customer-centric and/or subscriber-centric data and information. For example, the systems and methods may access and aggregate records for every call (e.g., voice call, message, or data session) within a network over a period of time, and determine various key performance indicators (KPIs) for the overall network (or portions of the network) that are based on the records and the customers associated with the calls within the network.
  • KPIs key performance indicators
  • the systems and method may determine key performance indicators for a communications network by accessing call detail records from multiple communications network sources, generating a database of one or more customer stats table (CSTs) based on the accessed call records, wherein the CSTs include records for each individual customers of the communications network, and determining one or more key performance indicators (KPIs) for the overall network based on the records stored by the one or more customer stats tables.
  • CSTs customer stats table
  • KPIs key performance indicators
  • a customer stats table, or CST may store various customer-centric information, including customer usage data for customers of the communications network, customer profile data for the customers of the communications network, customer top cell usage data for the customers of the communications network, and so on. Using such data, the systems and methods determine many different KPIs that represent the overall performance of the network, including dropped call rates, LTE leakage metrics, and so on, for the network.
  • the systems and methods may utilize the CSTs storing subscriber-centric data when troubleshooting a network in an attempting to identify weak points or pain points for subscribers of the network. For example, the systems and methods may identify network cells within a communications network providing a suboptimal performance for subscribers of the communications network by determining one or more key performance indicators (KPIs) for the communications network based on subscriber-centric information stored by one or more customer stats tables (CSTs), identifying individual subscribers experiencing suboptimal performance based on the determined KPIs for the communications network; and determining one or more network cells within the communications network that share the most identified individual subscribers experiencing the suboptimal performance.
  • KPIs key performance indicators
  • CSTs customer stats tables
  • the systems and methods utilize customer-centric data, organized and/or stored as different CSTs within a database, to act as building blocks for determining performance indicators that represent customer experience issues (e.g., pain points), customer profiles, network usage, and other network performance indicators.
  • customer experience issues e.g., pain points
  • customer-specific data as opposed to conventional network-specific and/or network-derived data, enables the systems and methods to provide a more granular and accurate insight into the performance of a network, as well as business insights into how the network affects its customers and users and how the network is used by different groups of customers, markets of customers and so on, among other benefits.
  • FIG. 1 is a block diagram illustrating a suitable network environment 100 for generating customer stats tables (CSTs) for a communications network.
  • CSTs customer stats tables
  • a CST database module such as a module hosted by a server, may access, receive, obtain, and/or retrieve data from various communications network data sources over a network 125 , such as a call detail record (CDR) data source 110 , an event data record (EDR) data source 112 , one or more data log sources 114 that log data associated with network performance, and so on.
  • CDR call detail record
  • EDR event data record
  • an IMS network includes a Telephone Application Server (TAS) that creates or generates call detail records (CDR) for each call session within or facilitated by the IMS network 130 .
  • a call detail record includes various details associated with each call within the IMS network, including information (e.g., the phone number) identifying the calling party, information (e.g., phone number) identifying the called (or, answering party), the date and time of the call, the duration of the call, billing information associated with the call, information identifying the access components, information identifying the call handling components, various codes (e.g., cause codes or response codes) or indicators associated with faults or errors in handling or connecting the call, information identifying the disposition of the call, and so on.
  • the CST database module 120 may collect data from other sources within different networks.
  • the CST database module uses the accessed CDR, EDR, and/or log data to generate a database of customer stats tables (CST), which include records that relate individual customers and/or subscribers with various calls (e.g., voice calls, messages, and/or data sessions) and associated events (e.g., completed calls, dropped calls, network leakage, cell usage, and so on). Further details regarding the generating of the CSTs, the data stored in the CSTs, and the use of the CSTs are described herein.
  • CST customer stats tables
  • FIG. 1 and the discussion herein provide a brief, general description of the suitable computing environment 100 in which the systems and methods can be supported and implemented.
  • a general-purpose computer e.g., mobile device, a server computer, or personal computer.
  • PDAs personal digital assistants
  • the system can be practiced with other communications, data processing, or computer system configurations, including: Internet appliances, hand-held devices (including tablet computers and/or personal digital assistants (PDAs)), all manner of cellular or mobile phones, multi-processor systems, microprocessor-based or programmable consumer electronics, set-top boxes, network PCs, mini-computers, mainframe computers, and the like.
  • PDAs personal digital assistants
  • the terms “computer,” “host,” and “host computer,” and “mobile device” and “handset” are generally used interchangeably herein, and refer to any of the above devices and systems, as well as any data processor.
  • aspects of the system can be embodied in a special purpose computing device or data processor that is specifically programmed, configured, or constructed to perform one or more of the computer-executable instructions explained in detail herein.
  • aspects of the system may also be practiced in distributed computing environments where tasks or modules are performed by remote processing devices, which are linked through a communications network, such as a Local Area Network (LAN), Wide Area Network (WAN), or the Internet.
  • LAN Local Area Network
  • WAN Wide Area Network
  • program modules may be located in both local and remote memory storage devices.
  • aspects of the system may be stored or distributed on computer-readable media (e.g., physical and/or tangible non-transitory computer-readable storage media), including magnetically or optically readable computer discs, hard-wired or preprogrammed chips (e.g., EEPROM semiconductor chips), nanotechnology memory, or other data storage media.
  • computer implemented instructions, data structures, screen displays, and other data under aspects of the system may be distributed over the Internet or over other networks (including wireless networks), on a propagated signal on a propagation medium (e.g., an electromagnetic wave(s), a sound wave, etc.) over a period of time, or they may be provided on any analog or digital network (packet switched, circuit switched, or other scheme).
  • portions of the system reside on a server computer, while corresponding portions reside on a client computer such as a mobile or portable device, and thus, while certain hardware platforms are described herein, aspects of the system are equally applicable to nodes on a network.
  • the mobile device or portable device may represent the server portion, while the server may represent the client portion.
  • the communication network being measured and providing data may be comprised of multiple networks, even multiple heterogeneous networks, such as one or more border networks, voice networks, broadband networks, service provider networks, Internet Service Provider (ISP) networks, and/or Public Switched Telephone Networks (PSTNs), interconnected via gateways operable to facilitate communications between and among the various networks.
  • networks such as one or more border networks, voice networks, broadband networks, service provider networks, Internet Service Provider (ISP) networks, and/or Public Switched Telephone Networks (PSTNs), interconnected via gateways operable to facilitate communications between and among the various networks.
  • ISP Internet Service Provider
  • PSTNs Public Switched Telephone Networks
  • the communications network may also include third-party communications networks such as a Global System for Mobile (GSM) mobile communications network, a code/time division multiple access (CDMA/TDMA) mobile communications network, a 3rd or 4th generation (3G/4G) mobile communications network (e.g., General Packet Radio Service (GPRS/EGPRS)), Enhanced Data rates for GSM Evolution (EDGE), Universal Mobile Telecommunications System (UMTS), Long Term Evolution (LTE) network), Voice over LTE (VoLTE), IMS network, or other communications network.
  • GSM Global System for Mobile
  • CDMA/TDMA code/time division multiple access
  • 3G/4G 3rd or 4th generation
  • GPRS/EGPRS General Packet Radio Service
  • EDGE Enhanced Data rates for GSM Evolution
  • UMTS Universal Mobile Telecommunications System
  • LTE Long Term Evolution
  • VoIP Voice over LTE
  • IMS IMS network
  • FIG. 2 is a block diagram illustrating information flows between network data sources and the database module 120 , which generates the CSTs 130 using the received data.
  • KPIs key performance indicators
  • the CST database module 120 may include functional modules or systems that are implemented with a combination of software (e.g., executable instructions, or computer code) and hardware (e.g., at least a memory and processor). Accordingly, as used herein, in some examples a module or system is a processor-implemented module, system, or set of code and represents a computing device having a processor that is at least temporarily configured and/or programmed by executable instructions stored in memory to perform one or more of the particular functions that are described herein.
  • software e.g., executable instructions, or computer code
  • hardware e.g., at least a memory and processor
  • An EBDA (evidence based data analysis) module 220 may access and obtain data (e.g., records, logs, and so on) from various network monitoring data sources 210 .
  • a voice unified model (UM) module receives voice call CDRs from different network data sources (e.g., “Ericsson Voice,” “TAS Voice,” and so on), a data UM module receives data CDRs from a network data source (e.g., “Cisco Data”), an EDR module receives EDR data from various event modules, an SMS USM module receives message CDRs from an SMSC (Short Message Service Center), an RCS USM receives RCS (Rich Communication Services) data from an RCS server, a Customer Profile module receives information from a customer provisioning data source (e.g., “BQR”), an enterprise data module (TDEDW) receives data from a billing and marketing data source, and a user trace module receives user or subscriber user trace data.
  • the EBDA module 220 performs evidence based data analysis to generate CSTs 230 that are based on the data received from the network data sources 210 .
  • the CSTs may store different types of data, and may include a customer profile CST 231 , a voice KPI CST 232 , a data KPI CST 233 , an SMS KPI CST 234 , a messaging KPI CST 235 , a top cell usage CST 236 , a user trace metrics CST 237 , and so on.
  • one or more copies 250 of the CSTs 230 are generated, and the systems and methods may perform actions using the data stored within the CSTs, such as generate reports 260 that present many different views representative of the KPIs determined for the communications network.
  • the system in some embodiments, includes a database module that accesses call detail records from multiple communications network sources and generates a database of one or more customer stats table (CSTs) based on the accessed call records, wherein the CSTs include records for each individual customers of the communications network, and a performance module that determines one or more key performance indicators (KPIs) for the overall network based on the records stored by the one or more customer stats tables.
  • CSTs customer stats table
  • KPIs key performance indicators
  • the database of CSTs 120 acts as a single repository that stores customer-centric analytics data, such as various KPIs.
  • the CST database 120 may include CSTs storing customer usage data, customer profile data, and customer top cell usage data (e.g., data that indicates the cells most utilized by specific customers in a time period), as well as other CSTs.
  • Table 1 represents example data stored in a customer usage data CST (e.g., CST.BR.1.0) for a customer/subscriber:
  • CST customer usage data
  • the CST may include various other data, including data upload and download amounts across various bands or networks (e.g., LTE or 3G), the time using various networks, number of answered calls, number of dropped calls, number of messages received and/or missed, amount or identification of throttled subscribers, and so on.
  • data upload and download amounts across various bands or networks e.g., LTE or 3G
  • time using various networks e.g., number of answered calls, number of dropped calls, number of messages received and/or missed, amount or identification of throttled subscribers, and so on.
  • a customer profile data CST for a customer/subscriber stores other types of data associated with a profile of a customer and his/her plan or device, such as identification information (e.g., IMSI), account status and inception information, device information (e.g., brand), data plan information, previous carrier information, and so on.
  • identification information e.g., IMSI
  • account status and inception information e.g., account status and inception information
  • device information e.g., brand
  • data plan information e.g., previous carrier information, and so on.
  • a customer top cell usage data CST for a customer/subscriber stores data associated with a customer's interactions with the communications network, such as information identifying the top cells for data usage (e.g., top 5 cells for data usage), information identifying a total amount of data usage for each cell, information identifying the top cells for voice or messaging calls, information identifying the top cells for dropped calls and/or the number of dropped calls per cell, and so on.
  • FIG. 3 is a diagram illustrating an example CST database 130 of customer stats tables.
  • the CST includes an overall usage branch 310 that splits into a general usage CST 312 and a top cell usage CST 314 , such as the CSTs shown in Table 1.
  • the general usage CST 312 may further split based on time period data, and store various data types in a weekly CST 315 and a daily CST 317 .
  • the CST database 130 may include a separate CST 320 for customer profile data, as described herein, as well as a CST copy 330 or duplicate that includes the data utilized when generating reports 160 and/or performing actions.
  • the systems and methods utilize the customer-centric and customer-level data stored in various different CSTs to determine key performance indicators for a communications network and/or portions (e.g., areas, markets, network types, and so on) of the network.
  • FIG. 4 is a flow diagram illustrating a method 400 for performing actions using key performance indicators (KPIs) determined from customer-specific data sources.
  • the method 400 may be performed by the CST database module 120 , the EBDA module 220 , or other systems described herein, and, accordingly, is described herein merely by way of reference thereto. It will be appreciated that the method 400 may be performed on any suitable hardware.
  • KPIs key performance indicators
  • the system accesses call records from multiple communications network sources, such as sources 110 , 112 , 114 , and/or 210 .
  • the accessed call records (e.g., call detail records) include individual records for each occurrence of a call, message, and data session within the communications network.
  • the system generates a database of one or more customer stats table (CSTs) based on the accessed call records.
  • CSTs customer stats table
  • the EBDA module 220 performs evidence based data analysis to generate CSTs 230 that are based on the data received from the network data sources 210 .
  • the EBDA module 220 transforms raw call, event, and/or log data into navigable CSTs of customer-centric data that provide a historical record of the network and include CSTs that stores customer usage data for customers of the communications network, customer profile data for the customers of the communications network, and customer top cell usage data for the customers of the communications network.
  • the CST database module 120 may generate a database of CSTs that includes one or more CSTs that store customer-centric information for calls placed within the communications network over a weekly time period, one or more CSTs that store customer-centric information for calls placed within the communications network over a daily time period, and one or more CSTs that store customer-centric information for highest usage cells within the communications network with respect to data usage and voice call usage by customers of the communications network, as shown in FIG. 3 .
  • the system determines one or more key performance indicators (KPIs) based on the one or more customer stats tables.
  • KPIs key performance indicators
  • the CSTs may store different types of data
  • the EBDA module 220 may generate a customer profile CST 231 , a voice KPI CST 232 , a data KPI CST 233 , an SMS KPI CST 234 , a messaging KPI CST 235 , a top cell usage CST 236 , a user trace data metrics CST 237 , and so on.
  • the system performs an action that is based on the determined one or more key performance indicators (KPIs). For example, the system may generate various reports that present information associated with the determined KPIs, may utilize the determined KPIs to identify and/or determine one or more network cells that most affect the determined one or more key performance indicators (KPIs), and so on.
  • KPIs key performance indicators
  • FIGS. 5A-5D present some example reports based on KPIs generated from the customer stats table (CST) described herein.
  • FIG. 5A presents a report that shows, for many different areas and markets (e.g., Minneapolis, Update NY, Puerto Rico, and so on), a graph 510 representing a KPI associated with a number of voice calls per user and a graph 520 representing a KPI associated with the number of users having zero dropped calls in a certain time period.
  • the system may identify various areas or cells within the network providing high quality of service and/or poor or suboptimal quality of service.
  • FIG. 5B presents a report, for many different areas and markets, that shows a graph 550 representing a KPI associated with a percentage of device connection time to a network (e.g., the amount of time in a week or day at which a customer device, when on, is connected to the network).
  • a network e.g., the amount of time in a week or day at which a customer device, when on, is connected to the network.
  • the system may identify various areas or cells within the network providing good or optimal coverage, poor or suboptimal coverage, and so on.
  • the system presents a report, for various different markets and different rate plans, that shows a graph 560 representing a KPI associated with a percentage of “extreme” users (e.g., users with the highest data usage of the network, such as a top or high threshold percentage (e.g., 2 or 5 percent) of overall subscribers).
  • FIG. 5D presents a report, for many different areas and markets, that shows a graph 590 representing a KPI associated with subscriber data usage distribution.
  • the graph identifies, for each market, the percentage of extreme data usage subscribers, high data usage subscribers, medium data usage subscribers, and low data usage subscribers.
  • the system may adjust or target certain users or devices for modified plans, and/or may modify network resources to maintain high quality of service for the users.
  • the systems and methods utilizing the determined KPIs, perform various network analyses for the performance of the network and the impact on the network's performance on its subscribers.
  • FIG. 6 is a flow diagram illustrating a method 600 for identifying suboptimal network components using data from the customer stats table (CST).
  • CST customer stats table
  • the system determines one or more key performance indicators (KPIs) for the communications network based on subscriber-centric information stored by one or more customer stats tables (CSTs). As described herein, the system may generate a customer profile CST 231 , a voice KPI CST 232 , a data KPI CST 233 , an SMS KPI CST 234 , a messaging KPI CST 235 , a top cell usage CST 236 , a user trace data metrics CST 237 , and so on.
  • KPIs key performance indicators
  • the system identifies individual subscribers experiencing suboptimal performance based on the determined KPIs for the communications network. For example, the system may identify an area or market having a high number of subscribers experiencing a certain unintended level of performance (e.g., higher than average number of dropped calls).
  • the system determines one or more network cells within the communications network that share the most identified individual subscribers experiencing the suboptimal performance. For example, after identifying the subscribers experiencing suboptimal network performance, the system, via the data stored in the relevant CSTs, identifies one or more network components (e.g., network cells or access points), shared by or in common with the identified subscribers.
  • network components e.g., network cells or access points
  • the system performs an action to modify performance of the determined one or more network cells that share the most identified individual subscribers experiencing the suboptimal performance. For example, the system may cause network optimization processes to modify the operation of the network components, adjust the coverage or assignment of the network components, add or remove network components to the market, area, or location providing suboptimal performance, and so on.
  • FIGS. 7A-7D depict an example scenario of identifying poor performing network cells using CST data.
  • the presented KPI information includes a graph 710 illustrating a KPI of voice mean hold times for subscribers across different markets, a graph 720 of the number of voice calls per user for the week across the markets, and a graph 730 of the percentage of users experiencing zero dropped calls in the week.
  • FIG. 7B follows with a graph 740 that illustrates the percentage of users experiencing at least 10 dropped calls in the week. The graphs, therefore, depict the voice call experiences for every user of the network across different markets in the week.
  • FIG. 7C depicts a table 750 of each subscriber experiencing more than 10 dropped calls per week.
  • the system may identify, as shown in the map 760 of FIG. 7D , the cells in common with the subscribers providing the suboptimal performance with respect to dropped calls. For example, the system identifies site “LA03379C” as having a certain number of total dropped calls, the number of cells servicing the site, and the top IMSIs affected by the cells.
  • the system may determine dropped call rates for subscribers of the communications network and identify a network cell or site that is associated with a high number of individual subscribers experiencing dropped calls within the communications network.
  • FIGS. 8A-8C depict an example scenario of identifying high LTE leakage network cells using CST data.
  • FIG. 8A presents a graph 800 that identifies the number of subscribers across different markets experience LTE leakage in more than half of all data usage events, and a graph 810 that identifies a number of subscribers across the markets that experience low (less than 10%) LTE leakage problems.
  • the KPIs depicted in the graphs present information reflecting LTE leakage issues for every single subscriber of a network.
  • a table 820 presents the granular CST data (e.g., IMSI data payload, and LTE coverage information), which is utilized by the system to identify the subscribers having leakage issues within a specific market.
  • the system uses the data, as depicted by the map 840 of FIG. 8C , identifies a network cell site 845 , cell site “7WAC182E”, as having the most impacted subscribers (“Impacted IMSI 109”).
  • the network using the information, may perform actions to modify the performance of the cell site, as described herein.
  • the system may determine LTE leakage metrics for subscribers of the communications network, and identify a network cell or cell site that is associated with a high number of individual subscribers experiencing LTE leakage within the communications network.
  • the system and methods utilize raw, subscriber-level (e.g., customer-centric) data obtained from various network sources (call detail records from a TAS) to determine network-, area-, and/or market-wide key performance indicators (KPIs), which provide insights into the customer experiences (good and/or pain point type experiences) within the communications network.
  • KPIs key performance indicators
  • the words “comprise,” “comprising,” and the like are to be construed in an inclusive sense, as opposed to an exclusive or exhaustive sense; that is to say, in the sense of “including, but not limited to.”
  • the terms “connected,” “coupled,” or any variant thereof means any connection or coupling, either direct or indirect, between two or more elements; the coupling of connection between the elements can be physical, logical, or a combination thereof.
  • the words “herein,” “above,” “below,” and words of similar import when used in this application, shall refer to this application as a whole and not to any particular portions of this application.
  • words in the above Detailed Description using the singular or plural number may also include the plural or singular number respectively.
  • the word “or,” in reference to a list of two or more items, covers all of the following interpretations of the word: any of the items in the list, all of the items in the list, and any combination of the items in the list.
  • processes, message/data flows, or blocks are presented in a given order, alternative embodiments may perform routines having steps, or employ systems having blocks, in a different order, and some processes or blocks may be deleted, moved, added, subdivided, combined, and/or modified to provide alternative or subcombinations.
  • Each of these processes, message/data flows, or blocks may be implemented in a variety of different ways.
  • processes or blocks are at times shown as being performed in series, these processes or blocks may instead be performed in parallel, or may be performed at different times. Further any specific numbers noted herein are only examples: alternative implementations may employ differing values or ranges.
  • database is used herein in the generic sense to refer to any data structure that allows data to be stored and accessed, such as tables, linked lists, arrays, etc.

Landscapes

  • Engineering & Computer Science (AREA)
  • Signal Processing (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Quality & Reliability (AREA)
  • Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Mobile Radio Communication Systems (AREA)

Abstract

Systems and methods are described herein for analyzing the performance of a communications network (e.g., a mobile telecommunications network) using customer-centric and/or subscriber-centric data and information. In some embodiments, the systems and method may determine key performance indicators for a communications network by accessing call detail records from multiple communications network sources, generating a database of one or more customer stats table (CSTs) based on the accessed call records, wherein the CSTs include records for each individual customers of the communications network, and determining one or more key performance indicators (KPIs) for the overall network based on the records stored by the one or more customer stats tables.

Description

    BACKGROUND
  • The performance of a communications network (or, mobile network) is often reflected by various key performance indicators (KPIs). Example KPIs include and/or reflect dropped call rates, wireless leakage, network usage, network quality, network speed, network reliability, costs to customers, and many other indicators.
  • Typically, a network provider measures and determines network-centric KPIs, such as KPIs that are based on data associated with the operation or performance of network components, such as cells, base stations, and so on. For example, given a network of 60,000 or so cell sites, the provider may determine KPIs associated with voice dropped call rates, network registration metrics, network availability data, and so on. However, in merely using network and/or component specific data, a network provider may face various issues associated with identifying and determining KPIs of value to various stakeholders for the network, such as customers, subscribers, vendors, and so on.
  • BRIEF DESCRIPTION OF THE DRAWINGS
  • FIG. 1 is a block diagram illustrating a suitable network environment for generating a customer stats table (CST) for a communications network.
  • FIG. 2 is a block diagram illustrating information flows between network data sources and a database module.
  • FIG. 3 is a diagram illustrating an example CST database of customer stats tables.
  • FIG. 4 is a flow diagram illustrating a method for performing actions using key performance indicators (KPIs) determined from customer-specific data sources.
  • FIGS. 5A-5D are display diagrams illustrating reports based on KPIs generated from the customer stats table (CST).
  • FIG. 6 is a flow diagram illustrating a method for identifying suboptimal network components using data from the customer stats table (CST).
  • FIGS. 7A-7D are display diagrams illustrating an example scenario of identifying poor performing network cells using CST data.
  • FIGS. 8A-8C are display diagrams illustrating an example scenario of identifying high LTE leakage network cells using CST data.
  • DETAILED DESCRIPTION
  • Systems and methods are described herein for analyzing the performance of a communications network (e.g., a mobile telecommunications network) using customer-centric and/or subscriber-centric data and information. For example, the systems and methods may access and aggregate records for every call (e.g., voice call, message, or data session) within a network over a period of time, and determine various key performance indicators (KPIs) for the overall network (or portions of the network) that are based on the records and the customers associated with the calls within the network.
  • In some embodiments, the systems and method may determine key performance indicators for a communications network by accessing call detail records from multiple communications network sources, generating a database of one or more customer stats table (CSTs) based on the accessed call records, wherein the CSTs include records for each individual customers of the communications network, and determining one or more key performance indicators (KPIs) for the overall network based on the records stored by the one or more customer stats tables.
  • A customer stats table, or CST may store various customer-centric information, including customer usage data for customers of the communications network, customer profile data for the customers of the communications network, customer top cell usage data for the customers of the communications network, and so on. Using such data, the systems and methods determine many different KPIs that represent the overall performance of the network, including dropped call rates, LTE leakage metrics, and so on, for the network.
  • In some embodiments, the systems and methods may utilize the CSTs storing subscriber-centric data when troubleshooting a network in an attempting to identify weak points or pain points for subscribers of the network. For example, the systems and methods may identify network cells within a communications network providing a suboptimal performance for subscribers of the communications network by determining one or more key performance indicators (KPIs) for the communications network based on subscriber-centric information stored by one or more customer stats tables (CSTs), identifying individual subscribers experiencing suboptimal performance based on the determined KPIs for the communications network; and determining one or more network cells within the communications network that share the most identified individual subscribers experiencing the suboptimal performance.
  • Thus, in some embodiments, the systems and methods utilize customer-centric data, organized and/or stored as different CSTs within a database, to act as building blocks for determining performance indicators that represent customer experience issues (e.g., pain points), customer profiles, network usage, and other network performance indicators.
  • Using customer-specific data, as opposed to conventional network-specific and/or network-derived data, enables the systems and methods to provide a more granular and accurate insight into the performance of a network, as well as business insights into how the network affects its customers and users and how the network is used by different groups of customers, markets of customers and so on, among other benefits.
  • The following description provides specific details for a thorough understanding of, and enabling description for, various embodiments of the technology. One skilled in the art will understand that the technology may be practiced without these details. In some instances, well-known structures and functions have not been shown or described in detail to avoid unnecessarily obscuring the description of the embodiments of the technology. It is intended that the terminology used in the description presented below be interpreted in its broadest reasonable manner, even though it is being used in conjunction with a detailed description of certain embodiments of the technology. Although certain terms may be emphasized below, any terminology intended to be interpreted in any restricted manner will be overtly and specifically defined as such in this Detailed Description section.
  • Example Network Configurations
  • FIG. 1 is a block diagram illustrating a suitable network environment 100 for generating customer stats tables (CSTs) for a communications network.
  • A CST database module, such as a module hosted by a server, may access, receive, obtain, and/or retrieve data from various communications network data sources over a network 125, such as a call detail record (CDR) data source 110, an event data record (EDR) data source 112, one or more data log sources 114 that log data associated with network performance, and so on.
  • For example, an IMS network includes a Telephone Application Server (TAS) that creates or generates call detail records (CDR) for each call session within or facilitated by the IMS network 130. A call detail record includes various details associated with each call within the IMS network, including information (e.g., the phone number) identifying the calling party, information (e.g., phone number) identifying the called (or, answering party), the date and time of the call, the duration of the call, billing information associated with the call, information identifying the access components, information identifying the call handling components, various codes (e.g., cause codes or response codes) or indicators associated with faults or errors in handling or connecting the call, information identifying the disposition of the call, and so on. Similarly, the CST database module 120 may collect data from other sources within different networks.
  • Using the accessed CDR, EDR, and/or log data, the CST database module generates a database of customer stats tables (CST), which include records that relate individual customers and/or subscribers with various calls (e.g., voice calls, messages, and/or data sessions) and associated events (e.g., completed calls, dropped calls, network leakage, cell usage, and so on). Further details regarding the generating of the CSTs, the data stored in the CSTs, and the use of the CSTs are described herein.
  • FIG. 1 and the discussion herein provide a brief, general description of the suitable computing environment 100 in which the systems and methods can be supported and implemented. Although not required, aspects of the systems and methods are described in the general context of computer-executable instructions, such as routines executed by a general-purpose computer, e.g., mobile device, a server computer, or personal computer. Those skilled in the relevant art will appreciate that the system can be practiced with other communications, data processing, or computer system configurations, including: Internet appliances, hand-held devices (including tablet computers and/or personal digital assistants (PDAs)), all manner of cellular or mobile phones, multi-processor systems, microprocessor-based or programmable consumer electronics, set-top boxes, network PCs, mini-computers, mainframe computers, and the like. Indeed, the terms “computer,” “host,” and “host computer,” and “mobile device” and “handset” are generally used interchangeably herein, and refer to any of the above devices and systems, as well as any data processor.
  • Aspects of the system can be embodied in a special purpose computing device or data processor that is specifically programmed, configured, or constructed to perform one or more of the computer-executable instructions explained in detail herein. Aspects of the system may also be practiced in distributed computing environments where tasks or modules are performed by remote processing devices, which are linked through a communications network, such as a Local Area Network (LAN), Wide Area Network (WAN), or the Internet. In a distributed computing environment, program modules may be located in both local and remote memory storage devices.
  • Aspects of the system may be stored or distributed on computer-readable media (e.g., physical and/or tangible non-transitory computer-readable storage media), including magnetically or optically readable computer discs, hard-wired or preprogrammed chips (e.g., EEPROM semiconductor chips), nanotechnology memory, or other data storage media. Indeed, computer implemented instructions, data structures, screen displays, and other data under aspects of the system may be distributed over the Internet or over other networks (including wireless networks), on a propagated signal on a propagation medium (e.g., an electromagnetic wave(s), a sound wave, etc.) over a period of time, or they may be provided on any analog or digital network (packet switched, circuit switched, or other scheme). Those skilled in the relevant art will recognize that portions of the system reside on a server computer, while corresponding portions reside on a client computer such as a mobile or portable device, and thus, while certain hardware platforms are described herein, aspects of the system are equally applicable to nodes on a network. In an alternative embodiment, the mobile device or portable device may represent the server portion, while the server may represent the client portion.
  • In some cases, the communication network being measured and providing data may be comprised of multiple networks, even multiple heterogeneous networks, such as one or more border networks, voice networks, broadband networks, service provider networks, Internet Service Provider (ISP) networks, and/or Public Switched Telephone Networks (PSTNs), interconnected via gateways operable to facilitate communications between and among the various networks. As described herein, the communications network may also include third-party communications networks such as a Global System for Mobile (GSM) mobile communications network, a code/time division multiple access (CDMA/TDMA) mobile communications network, a 3rd or 4th generation (3G/4G) mobile communications network (e.g., General Packet Radio Service (GPRS/EGPRS)), Enhanced Data rates for GSM Evolution (EDGE), Universal Mobile Telecommunications System (UMTS), Long Term Evolution (LTE) network), Voice over LTE (VoLTE), IMS network, or other communications network.
  • Examples of Determining Key Performance Indicators for a Network
  • As described herein, the systems and methods utilize customer-specific data and information when determining key performance indicators (KPIs) for a communications network. FIG. 2 is a block diagram illustrating information flows between network data sources and the database module 120, which generates the CSTs 130 using the received data.
  • The CST database module 120 may include functional modules or systems that are implemented with a combination of software (e.g., executable instructions, or computer code) and hardware (e.g., at least a memory and processor). Accordingly, as used herein, in some examples a module or system is a processor-implemented module, system, or set of code and represents a computing device having a processor that is at least temporarily configured and/or programmed by executable instructions stored in memory to perform one or more of the particular functions that are described herein.
  • An EBDA (evidence based data analysis) module 220 may access and obtain data (e.g., records, logs, and so on) from various network monitoring data sources 210. For example, a voice unified model (UM) module receives voice call CDRs from different network data sources (e.g., “Ericsson Voice,” “TAS Voice,” and so on), a data UM module receives data CDRs from a network data source (e.g., “Cisco Data”), an EDR module receives EDR data from various event modules, an SMS USM module receives message CDRs from an SMSC (Short Message Service Center), an RCS USM receives RCS (Rich Communication Services) data from an RCS server, a Customer Profile module receives information from a customer provisioning data source (e.g., “BQR”), an enterprise data module (TDEDW) receives data from a billing and marketing data source, and a user trace module receives user or subscriber user trace data.
  • The EBDA module 220 performs evidence based data analysis to generate CSTs 230 that are based on the data received from the network data sources 210. The CSTs may store different types of data, and may include a customer profile CST 231, a voice KPI CST 232, a data KPI CST 233, an SMS KPI CST 234, a messaging KPI CST 235, a top cell usage CST 236, a user trace metrics CST 237, and so on.
  • In some cases, one or more copies 250 of the CSTs 230 are generated, and the systems and methods may perform actions using the data stored within the CSTs, such as generate reports 260 that present many different views representative of the KPIs determined for the communications network.
  • Therefore, the system, in some embodiments, includes a database module that accesses call detail records from multiple communications network sources and generates a database of one or more customer stats table (CSTs) based on the accessed call records, wherein the CSTs include records for each individual customers of the communications network, and a performance module that determines one or more key performance indicators (KPIs) for the overall network based on the records stored by the one or more customer stats tables.
  • As described herein, in some embodiments, the database of CSTs 120 acts as a single repository that stores customer-centric analytics data, such as various KPIs. For example, the CST database 120 may include CSTs storing customer usage data, customer profile data, and customer top cell usage data (e.g., data that indicates the cells most utilized by specific customers in a time period), as well as other CSTs.
  • Table 1 represents example data stored in a customer usage data CST (e.g., CST.BR.1.0) for a customer/subscriber:
  • TABLE 1
    CST BRID KPI Function
    CST.BR.1.2 IMSI The IMSI Number
    CST.BR.1.9 DATA_PLAN The data plan for the
    subscriber
    CST.BR.1.12 DATA_MAX_UPLOAD_RATE The maximum upload
    rate
    CST.BR.1.17 VOICE_AVG_DISTANCE Average moving distance
    on voice call
    CST.BR.1.18 ROAMING_RADIUS Median distance of each
    call to central location
    point of all calls
  • Of course, the CST may include various other data, including data upload and download amounts across various bands or networks (e.g., LTE or 3G), the time using various networks, number of answered calls, number of dropped calls, number of messages received and/or missed, amount or identification of throttled subscribers, and so on.
  • A customer profile data CST for a customer/subscriber stores other types of data associated with a profile of a customer and his/her plan or device, such as identification information (e.g., IMSI), account status and inception information, device information (e.g., brand), data plan information, previous carrier information, and so on.
  • Furthermore, a customer top cell usage data CST for a customer/subscriber stores data associated with a customer's interactions with the communications network, such as information identifying the top cells for data usage (e.g., top 5 cells for data usage), information identifying a total amount of data usage for each cell, information identifying the top cells for voice or messaging calls, information identifying the top cells for dropped calls and/or the number of dropped calls per cell, and so on.
  • As described herein, the CSTs, in some embodiments, may store data in tree or hierarchical structures. FIG. 3 is a diagram illustrating an example CST database 130 of customer stats tables. As depicted, the CST includes an overall usage branch 310 that splits into a general usage CST 312 and a top cell usage CST 314, such as the CSTs shown in Table 1. For example, the general usage CST 312 may further split based on time period data, and store various data types in a weekly CST 315 and a daily CST 317.
  • Also, the CST database 130 may include a separate CST 320 for customer profile data, as described herein, as well as a CST copy 330 or duplicate that includes the data utilized when generating reports 160 and/or performing actions.
  • Thus, in some embodiments, the systems and methods utilize the customer-centric and customer-level data stored in various different CSTs to determine key performance indicators for a communications network and/or portions (e.g., areas, markets, network types, and so on) of the network.
  • FIG. 4 is a flow diagram illustrating a method 400 for performing actions using key performance indicators (KPIs) determined from customer-specific data sources. The method 400 may be performed by the CST database module 120, the EBDA module 220, or other systems described herein, and, accordingly, is described herein merely by way of reference thereto. It will be appreciated that the method 400 may be performed on any suitable hardware.
  • In operation 410, the system accesses call records from multiple communications network sources, such as sources 110, 112, 114, and/or 210. In some cases, the accessed call records (e.g., call detail records) include individual records for each occurrence of a call, message, and data session within the communications network.
  • In operation 420, the system generates a database of one or more customer stats table (CSTs) based on the accessed call records. For example, the EBDA module 220 performs evidence based data analysis to generate CSTs 230 that are based on the data received from the network data sources 210. The EBDA module 220 transforms raw call, event, and/or log data into navigable CSTs of customer-centric data that provide a historical record of the network and include CSTs that stores customer usage data for customers of the communications network, customer profile data for the customers of the communications network, and customer top cell usage data for the customers of the communications network.
  • As a result, the CST database module 120 may generate a database of CSTs that includes one or more CSTs that store customer-centric information for calls placed within the communications network over a weekly time period, one or more CSTs that store customer-centric information for calls placed within the communications network over a daily time period, and one or more CSTs that store customer-centric information for highest usage cells within the communications network with respect to data usage and voice call usage by customers of the communications network, as shown in FIG. 3.
  • In operation 430, the system determines one or more key performance indicators (KPIs) based on the one or more customer stats tables. For example, The CSTs may store different types of data, and the EBDA module 220 may generate a customer profile CST 231, a voice KPI CST 232, a data KPI CST 233, an SMS KPI CST 234, a messaging KPI CST 235, a top cell usage CST 236, a user trace data metrics CST 237, and so on.
  • The following examples illustrate various different KPIs determined by the system for a communications network. Of course, the system may generate many other KPIs not described herein:
  • A KPI associated with dropped call rates for certain customers of the communications network or groups of customers of the communications network;
  • A KPI associated with network type usage metrics for multiple different markets within the communications network;
  • A KPI associated with device connection metrics for multiple different markets within the communications network;
  • A KPI associated with a data usage distribution for customers across multiple different markets within the communications network;
  • A KPI associated with a network management customer distribution for customers across multiple different markets within the communications network;
  • A KPI associated with LTE leakage occurrences for certain customers of the communications network or groups of customers of the communications network; and so on.
  • In operation 440, the system performs an action that is based on the determined one or more key performance indicators (KPIs). For example, the system may generate various reports that present information associated with the determined KPIs, may utilize the determined KPIs to identify and/or determine one or more network cells that most affect the determined one or more key performance indicators (KPIs), and so on.
  • As an example, FIGS. 5A-5D present some example reports based on KPIs generated from the customer stats table (CST) described herein. FIG. 5A presents a report that shows, for many different areas and markets (e.g., Minneapolis, Update NY, Puerto Rico, and so on), a graph 510 representing a KPI associated with a number of voice calls per user and a graph 520 representing a KPI associated with the number of users having zero dropped calls in a certain time period. Using this information, the system may identify various areas or cells within the network providing high quality of service and/or poor or suboptimal quality of service.
  • As another example, FIG. 5B presents a report, for many different areas and markets, that shows a graph 550 representing a KPI associated with a percentage of device connection time to a network (e.g., the amount of time in a week or day at which a customer device, when on, is connected to the network). Using this information, the system may identify various areas or cells within the network providing good or optimal coverage, poor or suboptimal coverage, and so on.
  • In FIG. 5C, the system presents a report, for various different markets and different rate plans, that shows a graph 560 representing a KPI associated with a percentage of “extreme” users (e.g., users with the highest data usage of the network, such as a top or high threshold percentage (e.g., 2 or 5 percent) of overall subscribers). Similarly, FIG. 5D presents a report, for many different areas and markets, that shows a graph 590 representing a KPI associated with subscriber data usage distribution. As depicted, the graph identifies, for each market, the percentage of extreme data usage subscribers, high data usage subscribers, medium data usage subscribers, and low data usage subscribers. Using this information, the system may adjust or target certain users or devices for modified plans, and/or may modify network resources to maintain high quality of service for the users.
  • Thus, in some embodiments, the systems and methods, utilizing the determined KPIs, perform various network analyses for the performance of the network and the impact on the network's performance on its subscribers.
  • As described herein, the system may utilize the results of such analyses to identify and/or troubleshoot areas within a communications network providing suboptimal and/or poor coverage or quality of service to its customers. FIG. 6 is a flow diagram illustrating a method 600 for identifying suboptimal network components using data from the customer stats table (CST). The method 600 may be performed by the systems described herein, and, accordingly, is described herein merely by way of reference thereto. It will be appreciated that the method 600 may be performed on any suitable hardware.
  • In operation 610, the system determines one or more key performance indicators (KPIs) for the communications network based on subscriber-centric information stored by one or more customer stats tables (CSTs). As described herein, the system may generate a customer profile CST 231, a voice KPI CST 232, a data KPI CST 233, an SMS KPI CST 234, a messaging KPI CST 235, a top cell usage CST 236, a user trace data metrics CST 237, and so on.
  • In operation 620, the system identifies individual subscribers experiencing suboptimal performance based on the determined KPIs for the communications network. For example, the system may identify an area or market having a high number of subscribers experiencing a certain unintended level of performance (e.g., higher than average number of dropped calls).
  • In operation 630, the system determines one or more network cells within the communications network that share the most identified individual subscribers experiencing the suboptimal performance. For example, after identifying the subscribers experiencing suboptimal network performance, the system, via the data stored in the relevant CSTs, identifies one or more network components (e.g., network cells or access points), shared by or in common with the identified subscribers.
  • In operation 640, the system performs an action to modify performance of the determined one or more network cells that share the most identified individual subscribers experiencing the suboptimal performance. For example, the system may cause network optimization processes to modify the operation of the network components, adjust the coverage or assignment of the network components, add or remove network components to the market, area, or location providing suboptimal performance, and so on.
  • FIGS. 7A-7D depict an example scenario of identifying poor performing network cells using CST data. Referring first to FIG. 7A, the presented KPI information includes a graph 710 illustrating a KPI of voice mean hold times for subscribers across different markets, a graph 720 of the number of voice calls per user for the week across the markets, and a graph 730 of the percentage of users experiencing zero dropped calls in the week. FIG. 7B follows with a graph 740 that illustrates the percentage of users experiencing at least 10 dropped calls in the week. The graphs, therefore, depict the voice call experiences for every user of the network across different markets in the week.
  • FIG. 7C depicts a table 750 of each subscriber experiencing more than 10 dropped calls per week. Using data in the table, which represents data stored by a CST, the system may identify, as shown in the map 760 of FIG. 7D, the cells in common with the subscribers providing the suboptimal performance with respect to dropped calls. For example, the system identifies site “LA03379C” as having a certain number of total dropped calls, the number of cells servicing the site, and the top IMSIs affected by the cells.
  • Thus, using the granular CST data, the system may determine dropped call rates for subscribers of the communications network and identify a network cell or site that is associated with a high number of individual subscribers experiencing dropped calls within the communications network.
  • As another example, FIGS. 8A-8C depict an example scenario of identifying high LTE leakage network cells using CST data. FIG. 8A presents a graph 800 that identifies the number of subscribers across different markets experience LTE leakage in more than half of all data usage events, and a graph 810 that identifies a number of subscribers across the markets that experience low (less than 10%) LTE leakage problems. Thus, the KPIs depicted in the graphs present information reflecting LTE leakage issues for every single subscriber of a network.
  • In FIG. 8B, a table 820 presents the granular CST data (e.g., IMSI data payload, and LTE coverage information), which is utilized by the system to identify the subscribers having leakage issues within a specific market. Using the data, the system, as depicted by the map 840 of FIG. 8C, identifies a network cell site 845, cell site “7WAC182E”, as having the most impacted subscribers (“Impacted IMSI 109”). The network, using the information, may perform actions to modify the performance of the cell site, as described herein.
  • Thus, using the granular CST data, the system may determine LTE leakage metrics for subscribers of the communications network, and identify a network cell or cell site that is associated with a high number of individual subscribers experiencing LTE leakage within the communications network.
  • As described herein, in some embodiments, the system and methods utilize raw, subscriber-level (e.g., customer-centric) data obtained from various network sources (call detail records from a TAS) to determine network-, area-, and/or market-wide key performance indicators (KPIs), which provide insights into the customer experiences (good and/or pain point type experiences) within the communications network.
  • The system has been described using various CST and KPI examples, however, other CST data and KPIs not explicitly described herein, may be generated by the system using the modules and techniques described herein.
  • Conclusion
  • Unless the context clearly requires otherwise, throughout the description and the claims, the words “comprise,” “comprising,” and the like are to be construed in an inclusive sense, as opposed to an exclusive or exhaustive sense; that is to say, in the sense of “including, but not limited to.” As used herein, the terms “connected,” “coupled,” or any variant thereof, means any connection or coupling, either direct or indirect, between two or more elements; the coupling of connection between the elements can be physical, logical, or a combination thereof. Additionally, the words “herein,” “above,” “below,” and words of similar import, when used in this application, shall refer to this application as a whole and not to any particular portions of this application. Where the context permits, words in the above Detailed Description using the singular or plural number may also include the plural or singular number respectively. The word “or,” in reference to a list of two or more items, covers all of the following interpretations of the word: any of the items in the list, all of the items in the list, and any combination of the items in the list.
  • The above detailed description of embodiments of the system is not intended to be exhaustive or to limit the system to the precise form disclosed above. While specific embodiments of, and examples for, the system are described above for illustrative purposes, various equivalent modifications are possible within the scope of the system, as those skilled in the relevant art will recognize. For example, some network elements are described herein as performing certain functions. Those functions could be performed by other elements in the same or differing networks, which could reduce the number of network elements. Alternatively or additionally, network elements performing those functions could be replaced by two or more elements to perform portions of those functions. In addition, while processes, message/data flows, or blocks are presented in a given order, alternative embodiments may perform routines having steps, or employ systems having blocks, in a different order, and some processes or blocks may be deleted, moved, added, subdivided, combined, and/or modified to provide alternative or subcombinations. Each of these processes, message/data flows, or blocks may be implemented in a variety of different ways. Also, while processes or blocks are at times shown as being performed in series, these processes or blocks may instead be performed in parallel, or may be performed at different times. Further any specific numbers noted herein are only examples: alternative implementations may employ differing values or ranges. Those skilled in the art will also appreciate that the actual implementation of a database may take a variety of forms, and the term “database” is used herein in the generic sense to refer to any data structure that allows data to be stored and accessed, such as tables, linked lists, arrays, etc.
  • The teachings of the methods and system provided herein can be applied to other systems, not necessarily the system described above. The elements and acts of the various embodiments described above can be combined to provide further embodiments.
  • Any patents and applications and other references noted above, including any that may be listed in accompanying filing papers, are incorporated herein by reference. Aspects of the technology can be modified, if necessary, to employ the systems, functions, and concepts of the various references described above to provide yet further embodiments of the technology.
  • These and other changes can be made to the invention in light of the above Detailed Description. While the above description describes certain embodiments of the technology, and describes the best mode contemplated, no matter how detailed the above appears in text, the invention can be practiced in many ways. Details of the system may vary considerably in its implementation details, while still being encompassed by the technology disclosed herein. As noted above, particular terminology used when describing certain features or aspects of the technology should not be taken to imply that the terminology is being redefined herein to be restricted to any specific characteristics, features, or aspects of the technology with which that terminology is associated. In general, the terms used in the following claims should not be construed to limit the invention to the specific embodiments disclosed in the specification, unless the above Detailed Description section explicitly defines such terms. Accordingly, the actual scope of the invention encompasses not only the disclosed embodiments, but also all equivalent ways of practicing or implementing the invention under the claims.
  • While certain aspects of the technology are presented below in certain claim forms, the inventors contemplate the various aspects of the technology in any number of claim forms. For example, while only one aspect of the invention is recited as embodied in a computer-readable medium, other aspects may likewise be embodied in a computer-readable medium. Accordingly, the inventors reserve the right to add additional claims after filing the application to pursue such additional claim forms for other aspects of the technology.

Claims (20)

1. A method for modifying performance of a communications network, the method comprising:
accessing call records from multiple sources of the communications network,
wherein the accessed call records include individual records for each occurrence of a call, message, and data session within the communications network;
generating a database of one or more customer stats table (CSTs) based on the accessed call records,
wherein the one or more customer stats tables store customer-centric data over a certain period of time, the customer-centric data including:
customer usage data for customers of the communications network,
customer profile data for the customers of the communications network, and
customer top cell usage data for the customers of the communications network;
determining one or more key performance indicators (KPIs) based on data contained in the one or more customer stats tables;
identifying one or more cells of the communications network that are performing sub-optimally based on the determined one or more key performance indicators; and
performing an action with respect to the identified one or more cells of the communications network.
2. The method of claim 1, wherein accessing call records from multiple communications network sources includes accessing call detail records (CDRs) event data records (EDRs), and data logs from components of the communications network.
3. The method of claim 1, wherein generating a database of one or more customer stats table (CSTs) based on the accessed call records includes generating a hierarchical database of CSTs having a first grouping of CSTs associated with a general usage KPI for the communications network, and a second grouping of CSTs associated with top cell usage for cells within the communications network.
4. The method of claim 1, wherein generating a database of one or more customer stats table (CSTs) based on the accessed call records includes generating a hierarchical database of CSTs that include:
one or more CSTs that store customer-centric information for calls placed within the communications network over a weekly time period;
one or more CSTs that store customer-centric information for calls placed within the communications network over a daily time period; and
one or more CSTs that store customer-centric information for highest usage cells within the communications network with respect to data usage and voice call usage by customers of the communications network.
5. (canceled)
6. The method of claim 1, wherein determining one or more key performance indicators (KPIs) based on the one or more customer stats tables includes determining dropped call rates for certain customers of the communications network or for groups of customers of the communications network.
7. The method of claim 1, wherein determining one or more key performance indicators (KPIs) based on the one or more customer stats tables includes determining network type usage metrics for multiple different markets within the communications network.
8. The method of claim 1, wherein determining one or more key performance indicators (KPIs) based on the one or more customer stats tables includes determining device connection metrics for multiple different markets within the communications network.
9. The method of claim 1, wherein determining one or more key performance indicators (KPIs) based on the one or more customer stats tables includes determining a data usage distribution for customers across multiple different markets within the communications network.
10. The method of claim 1, wherein determining one or more key performance indicators (KPIs) based on the one or more customer stats tables includes determining a network management customer distribution for customers across multiple different markets within the communications network.
11. The method of claim 1, wherein determining one or more key performance indicators (KPIs) based on the one or more customer stats tables includes determining LTE leakage occurrences for certain customers of the communications network or for groups of customers of the communications network.
12. The method of claim 1, further comprising:
identifying one or more network cells that most affect the determined one or more key performance indicators (KPIs).
13. A non-transitory computer-readable medium whose contents, when executed by a computing system, cause the computing system to perform a method for modifying network cells within a communications network providing a suboptimal performance for subscribers of the communications network, the method comprising:
determining one or more key performance indicators (KPIs) for the communications network based on subscriber-centric information stored by one or more customer stats tables (CSTs),
wherein the one or more customer stats tables include:
one or more CSTs that store subscriber-centric information for calls placed within the communications network over a weekly time period;
one or more CSTs that store subscriber-centric information for calls placed within the communications network over a daily time period; and
one or more CSTs that store subscriber-centric information for highest usage cells within the communications network with respect to data usage and voice call usage by customers of the communications network;
identifying individual subscribers experiencing suboptimal performance based on the determined KPIs for the communications network;
determining one or more network cells within the communications network that share the most identified individual subscribers experiencing the suboptimal performance; and
performing an action within the communications network to modify performance of the determined one or more network cells.
14. The non-transitory computer-readable medium of claim 13, wherein determining one or more key performance indicators (KPIs) for the communications network based on subscriber-centric information stored by one or more customer stats tables (CSTs) includes determining dropped call rates for subscribers of the communications network; and
wherein determining one or more network cells within the communications network that share the most identified individual subscribers experiencing the suboptimal performance includes identifying a network cell that is associated with a high number of individual subscribers experiencing a dropped call within the communications network.
15. The non-transitory computer-readable medium of claim 13, wherein determining one or more key performance indicators (KPIs) for the communications network based on subscriber-centric information stored by one or more customer stats tables (CSTs) includes determining LTE leakage metrics for subscribers of the communications network; and
wherein determining one or more network cells within the communications network that share the most identified individual subscribers experiencing the suboptimal performance includes identifying a network cell that is associated with a high number of individual subscribers experiencing LTE leakage within the communications network.
16. (canceled)
17. The non-transitory computer-readable medium of claim 13, wherein the one or more customer stats tables (CSTs) are part of a hierarchical database of CSTs having a first grouping of CSTs associated with a general usage KPI for the communications network, and a second grouping of CSTs associated with top cell usage for network cells within the communications network.
18. A system of hardware components configured to determine key performance indicators for a communications network, the system comprising:
a database module that accesses call detail records from multiple sources of the communications network and generates a database of one or more customer stats table (CSTs) based on the accessed call records, wherein the CSTs include records for each individual customers of the communications network; and
a performance module that determines one or more key performance indicators (KPIs) for the overall network based on the records stored by the one or more customer stats tables and causes performance of network optimization processes based on the determined KPIs for the overall network.
19. The system of claim 18, wherein the database module generates one or more customer stats tables that store customer-centric data over a certain period of time, the customer-centric data including:
customer usage data for customers of the communications network,
customer profile data for the customers of the communications network, and
customer top cell usage data for the customers of the communications network.
20. The system of claim 18, wherein the performance module determines dropped call rates and LTE leakage metrics for the communications network based on the records stored by the one or more customer stats tables.
US15/462,746 2017-03-17 2017-03-17 Determining network performance metrics using customer-specific information Active US10091679B1 (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
US15/462,746 US10091679B1 (en) 2017-03-17 2017-03-17 Determining network performance metrics using customer-specific information
US16/147,309 US10757592B2 (en) 2017-03-17 2018-09-28 Determining network performance metrics using customer-specific information

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US15/462,746 US10091679B1 (en) 2017-03-17 2017-03-17 Determining network performance metrics using customer-specific information

Related Child Applications (1)

Application Number Title Priority Date Filing Date
US16/147,309 Continuation US10757592B2 (en) 2017-03-17 2018-09-28 Determining network performance metrics using customer-specific information

Publications (2)

Publication Number Publication Date
US20180270678A1 true US20180270678A1 (en) 2018-09-20
US10091679B1 US10091679B1 (en) 2018-10-02

Family

ID=63520456

Family Applications (2)

Application Number Title Priority Date Filing Date
US15/462,746 Active US10091679B1 (en) 2017-03-17 2017-03-17 Determining network performance metrics using customer-specific information
US16/147,309 Active US10757592B2 (en) 2017-03-17 2018-09-28 Determining network performance metrics using customer-specific information

Family Applications After (1)

Application Number Title Priority Date Filing Date
US16/147,309 Active US10757592B2 (en) 2017-03-17 2018-09-28 Determining network performance metrics using customer-specific information

Country Status (1)

Country Link
US (2) US10091679B1 (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20210112438A1 (en) * 2019-10-09 2021-04-15 Qualomm Incorporated Application client performance indicator management
US20220086276A1 (en) * 2020-09-16 2022-03-17 Douglas Ranalli Verified Calling Party Information Display Confirmation System
US11343373B1 (en) 2021-01-29 2022-05-24 T-Mobile Usa, Inc. Machine intelligent isolation of international calling performance degradation
US11470490B1 (en) 2021-05-17 2022-10-11 T-Mobile Usa, Inc. Determining performance of a wireless telecommunication network
US20230084355A1 (en) * 2021-09-13 2023-03-16 Guavus, Inc. RESOLVING UNSATISFACTORY QoE FOR 5G NETWORKS OR HYBRID 5G NETWORKS

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10091679B1 (en) 2017-03-17 2018-10-02 T-Mobile Usa, Inc. Determining network performance metrics using customer-specific information
US10555191B1 (en) 2019-08-01 2020-02-04 T-Mobile Usa, Inc. Optimum network performance improvement solutions selection systems and methods
US11343683B2 (en) 2020-04-22 2022-05-24 T-Mobile Usa, Inc. Identification and prioritization of optimum capacity solutions in a telecommunications network
US11064382B1 (en) 2020-05-07 2021-07-13 T-Mobile Usa, Inc. Management of telecommunications network congestion on roadways
US11350289B2 (en) 2020-05-14 2022-05-31 T-Mobile Usa, Inc. Identification of indoor and outdoor traffic usage of customers of a telecommunications network
US11153765B1 (en) 2020-05-15 2021-10-19 T-Mobile Usa, Inc. Capacity planning of telecommunications network by detecting anomalies in site behavior
US12095628B2 (en) 2022-10-19 2024-09-17 T-Mobile Usa, Inc. Machine learning system for predicting network abnormalities

Family Cites Families (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6246886B1 (en) * 1998-12-21 2001-06-12 Bell Atlantic Mobile System and methods for controlling access to digital wireless network in a dual mode wireless system
US6304754B1 (en) * 1999-06-02 2001-10-16 Avaya Technology Corp. System and method for laying out wireless cells to account for cell handoff
US20070099561A1 (en) * 2005-11-02 2007-05-03 Juergen Voss System and method for tracking UMTS cell traffic
JP5413372B2 (en) * 2008-11-14 2014-02-12 日本電気株式会社 Quality monitoring system, quality monitoring apparatus and quality monitoring method for wireless communication network
EP2501172B1 (en) * 2009-11-11 2017-10-25 Nec Corporation Wireless communication system, autonomous optimization system, wireless base station, and wireless parameter setting method
US9369886B2 (en) * 2011-09-09 2016-06-14 Viavi Solutions Inc. Methods and apparatus for implementing a self optimizing-organizing network manager
CN103298040B (en) * 2012-02-24 2016-02-03 华为技术有限公司 The method of radio network optimization, Apparatus and system
US9608875B2 (en) * 2013-11-15 2017-03-28 At&T Intellectual Property I, L.P. Individually unique key performance indicator management
US20160142917A1 (en) * 2014-11-19 2016-05-19 International Business Machines Corporation Customer demographic information system and method
US10181982B2 (en) * 2015-02-09 2019-01-15 TUPL, Inc. Distributed multi-data source performance management
US9615242B2 (en) * 2015-07-07 2017-04-04 T-Mobile Usa, Inc. Determining a service leakage rate within a wireless communication network
US9491569B1 (en) * 2015-09-17 2016-11-08 Global Technology Associates, LLC Method of and apparatus for homogenizing expected data-harvest yields
US9585036B1 (en) * 2015-12-21 2017-02-28 United States Cellular Corporation Determining cell site performance impact for a population of cell sites of a mobile wireless data network
US10091679B1 (en) 2017-03-17 2018-10-02 T-Mobile Usa, Inc. Determining network performance metrics using customer-specific information

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20210112438A1 (en) * 2019-10-09 2021-04-15 Qualomm Incorporated Application client performance indicator management
US20220086276A1 (en) * 2020-09-16 2022-03-17 Douglas Ranalli Verified Calling Party Information Display Confirmation System
US11343373B1 (en) 2021-01-29 2022-05-24 T-Mobile Usa, Inc. Machine intelligent isolation of international calling performance degradation
US11627217B2 (en) 2021-01-29 2023-04-11 T-Mobile Usa, Inc. Machine intelligent isolation of international calling performance degradation
US12047530B2 (en) 2021-01-29 2024-07-23 T-Mobile Usa, Inc. Machine intelligent isolation of international calling performance degradation
US11470490B1 (en) 2021-05-17 2022-10-11 T-Mobile Usa, Inc. Determining performance of a wireless telecommunication network
US20230084355A1 (en) * 2021-09-13 2023-03-16 Guavus, Inc. RESOLVING UNSATISFACTORY QoE FOR 5G NETWORKS OR HYBRID 5G NETWORKS
US11683421B2 (en) * 2021-09-13 2023-06-20 Guavus, Inc. Resolving unsatisfactory QoE for an application for 5G networks or hybrid 5G networks

Also Published As

Publication number Publication date
US20190104427A1 (en) 2019-04-04
US10091679B1 (en) 2018-10-02
US10757592B2 (en) 2020-08-25

Similar Documents

Publication Publication Date Title
US10757592B2 (en) Determining network performance metrics using customer-specific information
US10674388B2 (en) Wireless communication data analysis and reporting
US9924386B2 (en) Method and system for wireless network optimization and remote control of mobile handset operation
US11005705B1 (en) Network fault detection and quality of service improvement systems and methods
US9026851B2 (en) System and method for intelligent troubleshooting of in-service customer experience issues in communication networks
US12015936B2 (en) Proactively adjusting network infrastructure in response to reporting of real-time network performance
US11323856B2 (en) System, process, and device for multiple network usage tracking
US10264447B2 (en) Communication record privacy protection validation
US20120303413A1 (en) Methods and systems for network traffic forecast and analysis
Diaz-Aviles et al. Towards real-time customer experience prediction for telecommunication operators
US9210600B1 (en) Wireless network performance analysis system and method
US9986418B2 (en) Determining a service leakage rate within a wireless communication network
US8989776B2 (en) Location aggregation system
US20200068411A1 (en) System and Process for Using Cellular Connectivity Analysis to Determine Optimal Wireless Equipment and Service for a Geographical Area
US20120028603A1 (en) System and method for capturing real time telecommunications usage data from mobile devices and comparing that data to life cycle telecommunications expense management (tem) data
KR101598068B1 (en) Capacity allocation in communications
US11397606B2 (en) Systems and methods for automated monitoring and troubleshooting of unknown dependencies in a virtual infrastructure
US12089289B2 (en) System and process for configuring a dynamic roaming public land mobile network (PLMN)
US11711709B2 (en) System and process for using cellular connectivity analysis to determine optimal wireless equipment and service for a geographical area
CN110708706A (en) Area evaluation method, apparatus and storage medium
US20230208702A1 (en) Systems and methods for determining and correcting network failures in a wireless telecommunications network
US12021710B2 (en) Network analytics engine incorporating geospatial mapping and area of interest information and associated methods
Sneps-Sneppe et al. On Open Gateway from GSMA–Is It a Revolutionary or Too Little and Too Late Deal?

Legal Events

Date Code Title Description
AS Assignment

Owner name: T-MOBILE USA, INC., WASHINGTON

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:MUNAR, LE ROY;HO, DORIS;ZHANG, TING;SIGNING DATES FROM 20170822 TO 20170915;REEL/FRAME:043636/0601

STCF Information on status: patent grant

Free format text: PATENTED CASE

AS Assignment

Owner name: DEUTSCHE BANK TRUST COMPANY AMERICAS, NEW YORK

Free format text: SECURITY AGREEMENT;ASSIGNORS:T-MOBILE USA, INC.;ISBV LLC;T-MOBILE CENTRAL LLC;AND OTHERS;REEL/FRAME:053182/0001

Effective date: 20200401

MAFP Maintenance fee payment

Free format text: PAYMENT OF MAINTENANCE FEE, 4TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1551); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

Year of fee payment: 4

AS Assignment

Owner name: SPRINT SPECTRUM LLC, KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: SPRINT INTERNATIONAL INCORPORATED, KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: SPRINT COMMUNICATIONS COMPANY L.P., KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: SPRINTCOM LLC, KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: CLEARWIRE IP HOLDINGS LLC, KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: CLEARWIRE COMMUNICATIONS LLC, KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: BOOST WORLDWIDE, LLC, KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: ASSURANCE WIRELESS USA, L.P., KANSAS

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: T-MOBILE USA, INC., WASHINGTON

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: T-MOBILE CENTRAL LLC, WASHINGTON

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: PUSHSPRING, LLC, WASHINGTON

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: LAYER3 TV, LLC, WASHINGTON

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822

Owner name: IBSV LLC, WASHINGTON

Free format text: RELEASE BY SECURED PARTY;ASSIGNOR:DEUTSCHE BANK TRUST COMPANY AMERICAS;REEL/FRAME:062595/0001

Effective date: 20220822