{{indexmenu_n>5}}
====== Speed test services ======
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.
<code>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/</code>

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:
<code>match host (?i)(\W|^)(speedtest|2ip.ru|fast.com|internetometer.ru|speedtestt.ru|rt-internet.ru|skoromer.ru/|www.bandwidthplace.com)(\W|$)</code>
<code>(?i)(\W|^)(speedtest|2ip|nperf|internetometer|bandwidthplace.com|test.byfly.by|skoromer.ru)(\W|$)</code>

Example of a database query:\\
{{ :dpi:qoe_analytics:cases:queries_from_database:subs_speedtest_sample.sh |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