If you think a bug might affect users in the 57 release, please set the correct tracking and status flags for Release Management.

I'd like to be able to see what's our new contributor return rate for the first 4 month of their contributions

RESOLVED FIXED in 2015Q2

Status

support.mozilla.org
Users and Groups
P2
normal
RESOLVED FIXED
3 years ago
3 years ago

People

(Reporter: atopal, Assigned: mythmon)

Tracking

(Blocks: 1 bug)

unspecified
2015Q2

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: u=sumo-team c=community-hub p=2 s=2015.6)

User Story

[M] I as a community manager would like to be able to see what's our new contributor return rate for the first 4 month of their contributions

Acceptance Criteria:

* Community managers can request a report that displays the following for each area separately (L10n and Forum)
** Number of new contributors for each month of the last 12 month
** Number of contributors from each cohort still active in each of the following 3 month
** Percentage of contributors from each cohort still active in each of the following 3 month
* This report should be sent out once a month
* Recipient is sumo-reports@mozilla.org
(Reporter)

Description

3 years ago
I as a community manager would like to be able to see what's our new contributor return rate for the first 4 month of their contributions
(Reporter)

Updated

3 years ago
User Story: (updated)
(Reporter)

Updated

3 years ago
Blocks: 1131149
(Reporter)

Updated

3 years ago
Summary: I'd like to be able to see what's our new contributor return rate for the first 4 month of their contributios → I'd like to be able to see what's our new contributor return rate for the first 4 month of their contributions
(Reporter)

Updated

3 years ago
User Story: (updated)
(Reporter)

Updated

3 years ago
User Story: (updated)
(Reporter)

Updated

3 years ago
Target Milestone: 2015Q1 → 2015Q2
(Reporter)

Updated

3 years ago
Whiteboard: u=sumo-team c=community-hub p= s= → u=sumo-team c=community-hub p= s=2015.6
(Assignee)

Comment 1

3 years ago
This can be just  a script in `/scripts/`, it doesn't have to be a page on the site. Because of that, 2pt.
Whiteboard: u=sumo-team c=community-hub p= s=2015.6 → u=sumo-team c=community-hub p=2 s=2015.6
(Assignee)

Comment 2

3 years ago
PR: https://github.com/mozilla/kitsune/pull/2454
Merged: https://github.com/mozilla/kitsune/commit/ab0615bc20100f39bae04759e6d3300d7965066a

Usage:

$ ./manage.py runscript cohort_analysis

L10n        Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec    Jan    Feb    Mar
--------  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----
Apr 2014     54     13      8      6      4      4      5      4      4      5      2      3
May 2014            48     16      4      5      3      3      3      4      5      1      2
Jun 2014                   50      9      4      2      1      0      0      2      2      0
Jul 2014                          57     20     15     12     10      2      5      2      1
Aug 2014                                 60     18     11     11      6      7      7      6
Sep 2014                                        73     11      8      4      7      6      5
Oct 2014                                               49     11      6      4      4      3
Nov 2014                                                      45      7      3      4      0
Dec 2014                                                             23      5      3      3
Jan 2015                                                                    47      9      4
Feb 2015                                                                           42      5
Mar 2015                                                                                  28

KB          Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec    Jan    Feb    Mar
--------  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----
Apr 2014     16      4      2      4      4      4      2      2      2      2      1      3
May 2014            15      0      1      1      0      1      0      0      0      0      0
Jun 2014                    7      1      1      0      1      0      0      1      0      1
Jul 2014                          11      4      0      0      2      1      2      1      1
Aug 2014                                 17      7      3      2      3      3      2      2
Sep 2014                                        11      0      0      0      0      0      0
Oct 2014                                               16      3      0      1      0      0
Nov 2014                                                      11      2      1      0      2
Dec 2014                                                              6      0      0      0
Jan 2015                                                                     9      1      3
Feb 2015                                                                            2      0
Mar 2015                                                                                   6

Questions      Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec    Jan    Feb    Mar
-----------  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----  -----
Apr 2014      1890    137     33     33     21     20     18     15     17     17     12     10
May 2014             2622    171     56     42     29     24     29     21     22     15     20
Jun 2014                    1766    101     33     39     19     15     15     18     13     18
Jul 2014                           1611    129     38     28     17     18     21     10     14
Aug 2014                                  1606    109     33     37     26     21     15     10
Sep 2014                                         1919    119     31     27     24     20     14
Oct 2014                                                1838    128     34     22     15     15
Nov 2014                                                       1667     96     30     26     18
Dec 2014                                                              1741    117     39     25
Jan 2015                                                                     1742    106     34
Feb 2015                                                                            1680    110
Mar 2015                                                                                   1916


This takes a while to run. About 2.5 minutes on my laptop. It uses Python and the database, but not ElasticSearch. Using ES would have probably made the script a bit faster, but it would have been harder to set up to run, so I opted to only use the DB.

This is only a script, it doesn't effect the site, so this is resolved.
Status: NEW → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
(Assignee)

Comment 3

3 years ago
This was me.
Assignee: nobody → mcooper
You need to log in before you can comment on or make changes to this bug.