-- 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 | +-------+