Page MenuHomePhabricator
Paste P6549

(An Untitled Masterwork)
ActivePublic

Authored by Catrope on Jan 5 2018, 11:26 PM.
Tags
None
Referenced Files
F12270164:
Jan 5 2018, 11:26 PM
Subscribers
None
-- Sessions on RC on dewiki before 2017-11-15 19:10 UTC (when RCF went default there)
-- Broken out by day and by beta vs non-beta user
mysql:research@analytics-slave [log]> select substring(timestamp,1,8) as day, event_enhancedFiltersEnabled as betaEnabled, count(distinct event_userId, substring(timestamp,1,10)) as sessions from ChangesListFilters_16837986 where event_pagename='Recentchanges' and wiki='dewiki' and timestamp <= '20171115191000' group by day, event_enhancedFiltersEnabled;
+----------+-------------+----------+
| day | betaEnabled | sessions |
+----------+-------------+----------+
| 20171007 | 0 | 502 |
| 20171007 | 1 | 44 |
| 20171008 | 0 | 689 |
| 20171008 | 1 | 70 |
| 20171009 | 0 | 820 |
| 20171009 | 1 | 85 |
| 20171010 | 0 | 727 |
| 20171010 | 1 | 64 |
| 20171011 | 0 | 786 |
| 20171011 | 1 | 67 |
| 20171012 | 0 | 735 |
| 20171012 | 1 | 57 |
| 20171013 | 0 | 750 |
| 20171013 | 1 | 67 |
| 20171014 | 0 | 662 |
| 20171014 | 1 | 56 |
| 20171015 | 0 | 646 |
| 20171015 | 1 | 66 |
| 20171016 | 0 | 747 |
| 20171016 | 1 | 73 |
| 20171017 | 0 | 735 |
| 20171017 | 1 | 56 |
| 20171018 | 0 | 737 |
| 20171018 | 1 | 68 |
| 20171019 | 0 | 708 |
| 20171019 | 1 | 69 |
| 20171020 | 0 | 688 |
| 20171020 | 1 | 56 |
| 20171021 | 0 | 683 |
| 20171021 | 1 | 72 |
| 20171022 | 0 | 659 |
| 20171022 | 1 | 68 |
| 20171023 | 0 | 730 |
| 20171023 | 1 | 68 |
| 20171024 | 0 | 779 |
| 20171024 | 1 | 72 |
| 20171025 | 0 | 744 |
| 20171025 | 1 | 55 |
| 20171026 | 0 | 707 |
| 20171026 | 1 | 54 |
| 20171027 | 0 | 742 |
| 20171027 | 1 | 37 |
| 20171028 | 0 | 659 |
| 20171028 | 1 | 44 |
| 20171029 | 0 | 723 |
| 20171029 | 1 | 61 |
| 20171030 | 0 | 744 |
| 20171030 | 1 | 59 |
| 20171031 | 0 | 761 |
| 20171031 | 1 | 58 |
| 20171101 | 0 | 742 |
| 20171101 | 1 | 55 |
| 20171102 | 0 | 773 |
| 20171102 | 1 | 65 |
| 20171103 | 0 | 736 |
| 20171103 | 1 | 68 |
| 20171104 | 0 | 665 |
| 20171104 | 1 | 57 |
| 20171105 | 0 | 711 |
| 20171105 | 1 | 77 |
| 20171106 | 0 | 807 |
| 20171106 | 1 | 64 |
| 20171107 | 0 | 762 |
| 20171107 | 1 | 56 |
| 20171108 | 0 | 747 |
| 20171108 | 1 | 80 |
| 20171109 | 0 | 737 |
| 20171109 | 1 | 83 |
| 20171110 | 0 | 735 |
| 20171110 | 1 | 60 |
| 20171111 | 0 | 659 |
| 20171111 | 1 | 86 |
| 20171112 | 0 | 703 |
| 20171112 | 1 | 69 |
| 20171113 | 0 | 755 |
| 20171113 | 1 | 87 |
| 20171114 | 0 | 754 |
| 20171114 | 1 | 95 |
| 20171115 | 0 | 590 |
| 20171115 | 1 | 78 |
+----------+-------------+----------+
-- Total sessions on dewiki per day (beta+non-beta). After 11/15 the beta vs non-bea distinction isn't relevant any more (and sadly we didn't track opt-outed-ness)
mysql:research@analytics-slave [log]> select substring(timestamp,1,8) as day, count(distinct event_userId, substring(timestamp,1,10)) as sessions from ChangesListFilters_16837986 where event_pagename='Recentchanges' and wiki='dewiki' group by day;
+----------+----------+
| day | sessions |
+----------+----------+
| 20171007 | 544 |
| 20171008 | 753 |
| 20171009 | 899 |
| 20171010 | 789 |
| 20171011 | 849 |
| 20171012 | 792 |
| 20171013 | 816 |
| 20171014 | 716 |
| 20171015 | 709 |
| 20171016 | 817 |
| 20171017 | 787 |
| 20171018 | 802 |
| 20171019 | 774 |
| 20171020 | 740 |
| 20171021 | 753 |
| 20171022 | 724 |
| 20171023 | 794 |
| 20171024 | 847 |
| 20171025 | 795 |
| 20171026 | 760 |
| 20171027 | 777 |
| 20171028 | 701 |
| 20171029 | 781 |
| 20171030 | 799 |
| 20171031 | 814 |
| 20171101 | 793 |
| 20171102 | 835 |
| 20171103 | 801 |
| 20171104 | 717 |
| 20171105 | 786 |
| 20171106 | 867 |
| 20171107 | 817 |
| 20171108 | 822 |
| 20171109 | 818 |
| 20171110 | 794 |
| 20171111 | 741 |
| 20171112 | 769 |
| 20171113 | 837 |
| 20171114 | 848 |
| 20171115 | 866 |
| 20171116 | 983 |
| 20171117 | 735 |
| 20171118 | 700 |
| 20171119 | 754 |
| 20171120 | 871 |
| 20171121 | 794 |
| 20171122 | 857 |
| 20171123 | 787 |
| 20171124 | 860 |
| 20171125 | 787 |
| 20171126 | 765 |
| 20171127 | 894 |
| 20171128 | 828 |
| 20171129 | 881 |
| 20171130 | 816 |
| 20171201 | 762 |
| 20171202 | 706 |
| 20171203 | 762 |
| 20171204 | 802 |
| 20171205 | 735 |
| 20171206 | 744 |
| 20171207 | 759 |
| 20171208 | 801 |
| 20171209 | 735 |
| 20171210 | 786 |
| 20171211 | 859 |
| 20171212 | 862 |
| 20171213 | 880 |
| 20171214 | 837 |
| 20171215 | 835 |
| 20171216 | 737 |
| 20171217 | 714 |
| 20171218 | 853 |
| 20171219 | 798 |
| 20171220 | 857 |
| 20171221 | 795 |
| 20171222 | 816 |
| 20171223 | 706 |
| 20171224 | 722 |
| 20171225 | 657 |
| 20171226 | 695 |
| 20171227 | 723 |
| 20171228 | 797 |
| 20171229 | 732 |
| 20171230 | 783 |
| 20171231 | 719 |
| 20180101 | 734 |
| 20180102 | 823 |
| 20180103 | 143 |
+----------+----------+
-- Number of opted-out users on dewiki as of 2017-01-05 23:22 UTC
mysql:research@s3-analytics-slave [dewiki]> select count(*) from user_properties where up_property='rcenhancedfilters-disable' and up_value=1;
+----------+
| count(*) |
+----------+
| 110 |
+----------+
-- Number of distinct logged-in users who used the RC page in the last 3 months (2017-10-07 through 2017-01-05)
mysql:research@analytics-slave [log]> select count(distinct event_userId) as users from ChangesListFilters_16837986 where event_pagename='Recentchanges' and wiki='dewiki';
+-------+
| users |
+-------+
| 3400 |
+-------+