An average user usually remembers these services only when problems occur. Possible sources of issues include:

• low tariff speed, the subscriber has reached the “ceiling”
• problems in the operator’s network
• uplink problems (including unstable operation of a service required by the subscriber)
• weak Wi-Fi

All these issues can be identified using DPI statistics metrics or network monitoring data.

To obtain a data export, you can use a ready-made query that takes into account usage of the most popular services. If you want to add a new service, specify it in the query.

https://www.speedtest.net/
internet.yandex.ru
https://2ip.ru/speed/
https://internetometer.ru/
https://speedtestt.ru/
https://rt-internet.ru/proverit-skorost
https://skoromer.ru/
https://www.bandwidthplace.com/

It is recommended to work with subscribers from the export who visit sites from the list 3 or more times per week. To do this, you can:

• export data daily to your own IS via API or directly from ClickHouse QoE, and apply filters there;
• create a trigger in the GUI with specified parameters;
• achieve more accurate results when combined with competitor-related queries.

Example of a query filter for the GUI:

match host (?i)(\W|^)(speedtest|2ip.ru|fast.com|internetometer.ru|speedtestt.ru|rt-internet.ru|skoromer.ru/|www.bandwidthplace.com)(\W|$)

(?i)(\W|^)(speedtest|2ip|nperf|internetometer|bandwidthplace.com|test.byfly.by|skoromer.ru)(\W|$)

Example of a database query:
Download the script here

Run sh subs_speedtest_sample.sh

Script parameters:
format="CSV" — output format. Default is CSV. Available formats: https://clickhouse.com/docs/en/interfaces/formats/
periodSecs=24*3600 — period in seconds. Default is 24 hours
hostsMatch="(?i)(\W|)(speedtest.net|internet.yandex.ru|2ip.ru|internetometer.ru|speedtestt.ru|rt-internet.ru|skoromer.ru| — regular expression for searching by multiple hosts