Usage statistics of the dashboard per tld

[stitch]

the most popular extensions on all non-deleted lists which are not created by a test account

select computed_suffix, count() from url inner join internet_nl_dashboard_urllist_x_tagged_url as x on x.url_id = url.id inner join internet_nl_dashboard_urllist as u on u.id = x.urllist_id inner join internet_nl_dashboard_account as a on u.account_id = a.id where a.id not in (1) and u.is_deleted=false group by computed_suffix order by count() desc limit 25;

 computed_suffix | count
-----------------+--------
 nl              | 250091
 dk              |  91319
 com             |  18916
 cz              |  12550
 eu              |  10515
 se              |   7366
 at              |   6390
 de              |   6130
 org             |   4353
 fi              |   4285
 org.uk          |   3066
 net             |   2971
 co.uk           |   2747
 pt              |   2681
 bg              |   2326
 be              |   2300
 ee              |   2057
 finance         |   1923
 fr              |   1566
 info            |   1485
 nu              |   1269
 ch              |   1144
 com.br          |   1108
 no              |    980
 it              |    798
(25 rows)

the most popular extensions per list and an idea of the list name (censored) where the domain is not .nl

This shows that users have a strong preference to order extensions per list.

select computed_suffix, u.name, a.name, count() from url inner join internet_nl_dashboard_urllist_x_tagged_url as x on x.url_id = url.id inner join internet_nl_dashboard_urllist as u on u.id = x.urllist_id inner join internet_nl_dashboard_account as a on u.account_id = a.id where a.id not in (1) and u.is_deleted=false and computed_suffix not in ('nl') group by computed_suffix, u.id, a.id order by count() desc limit 200;

 computed_suffix |                            name                             |        name        | count
-----------------+-------------------------------------------------------------+--------------------+-------
 abc              | abc                                                        | user 1             |  10000
 def              | def                                                        | user 2             |  9000
 ghi              | ghi                                                        | user 3             |  8000