Closed
Bug 1131143
Opened 9 years ago
Closed 9 years ago
I'd like to be able to see what's our new contributor return rate for the first 4 month of their contributions
Categories
(support.mozilla.org :: Users and Groups, task, P2)
support.mozilla.org
Users and Groups
Tracking
(Not tracked)
RESOLVED
FIXED
2015Q2
People
(Reporter: atopal, Assigned: mythmon)
References
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
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•9 years ago
|
User Story: (updated)
|
|
Reporter | |
Updated•9 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•9 years ago
|
User Story: (updated)
|
|
Reporter | |
Updated•9 years ago
|
User Story: (updated)
|
|
Reporter | |
Updated•9 years ago
|
Target Milestone: 2015Q1 → 2015Q2
|
|
Reporter | |
Updated•9 years ago
|
Whiteboard: u=sumo-team c=community-hub p= s= → u=sumo-team c=community-hub p= s=2015.6
|
Assignee | |
Comment 1•9 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•9 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
Closed: 9 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•