Table of Contents

ClickStream analytics

1. Detecting Internet service reselling

DPI exports unique UserAgents sent in HTTP requests. The QoE module aggregates information for each IP (or login, if used). The statistics record every phone and PC behind subscriber NAT. Usually, up to 30 unique UserAgents are detected per household — any number higher may indicate reselling the Internet connection to other apartments via the main router.

Steps to find such cases:

  1. Go to QoE Analytics → Subscribers → ClickStream
  2. Create a filter (use Shift+Enter to add entries) where:

Interpreting the statistics:

2. Churn prevention (detecting interest in competitors)

DPI exports ClickStream — all HTTP/HTTPS user requests on the Internet. The QoE module aggregates information per IP (or login, if used). The statistics include URLs for HTTP and domain names for HTTPS.

Steps to detect interest in competitors:

  1. Go to QoE Analytics → Subscribers → ClickStream
  2. Create a filter with competitor websites in your region
  3. Or use the “Telecom operators” category

Interpreting results:

3. Detecting Smart TV devices

DPI exports unique UserAgents sent in HTTP requests. The QoE module aggregates information per IP (or login, if used). The statistics include each Smart TV detected behind subscriber NAT.

Steps to detect Smart TVs:

  1. Go to QoE Analytics → Subscribers → ClickStream
  2. Create a filter using math and enter a regular expression `(?i)(\W|^)(smart|LG|samsung)(\W|$)` to find specific devices:

Interpreting results:

4. Subscriber profiling by interests

ClickStream allows identifying clients’ usage of popular services or interest in certain website categories.

QoE Stor provides a categorized list that includes resources divided into 54 categories.

OTT services usage

Steps to find:

  1. Go to QoE Analytics → Subscribers → ClickStream
  2. Create a Host filter, use math and enter the regular expression `(?i)(\W|^)(smotreshka|ivi|okko|netflix)(\W|$)` to search for OTT services:

Example: segmenting the subscriber base

Steps to find:

  1. Go to QoE Analytics → Subscribers → ClickStream
  2. Create a Host category filter, use the desired category:

Example: finding subscribers with high traffic usage

Steps to find:

  1. Go to QoE Analytics → NetFlow → High traffic top (right side) → Top subscribers
  2. Sort by traffic volume