Page MenuHomePhabricator
Create Task
Maniphest T180541

Calculate monthly mobile Wikipedia edits for Major Gifts report [due Dec 6]
Closed, ResolvedPublic
Actions

Description

Hi Neil,

You've done these calculations several times for me -- the last time in May 2017 for a funding report -- and I'm doing a new funding report that requires updated mobile edits. Can you run the numbers again? I'd need mobile edits from May 2017 through (hopefully) October 2017. You've been able to broke them down into:

All mobile Wikipedia edits: > Article edits > Non-article edits > English Wikipedia edits > Non-English Wikipedia edits > App edits

I'd love to get these numbers in three weeks -- by December 6 -- but if you need another week, till December 13, that's good, too. I'm attaching a screen shot of the last mobile editing chart that I used based on numbers that you calculated.

Thanks so much. I always appreciate your help on these calculations!

Jonathan

Mobile editing October 2014 to April 2017.png (648×484 px, 145 KB)

Related Objects

Event Timeline

JCuriel created this task.Nov 14 2017, 11:47 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 14 2017, 11:47 PM
nshahquinn-wmf renamed this task from Calculate monthly mobile Wikipedia edits for Major Gifts report to Calculate monthly mobile Wikipedia edits for Major Gifts report [due Dec 6].Nov 14 2017, 11:49 PM
nshahquinn-wmf triaged this task as Medium priority.
nshahquinn-wmf added a comment.Nov 14 2017, 11:53 PM

Hey @JCuriel!

I'm happy to do this, and I'm pretty sure I can get it by December 6 as well.

Also, big thanks for filing a Phab task directly—it makes that much easier for me!

nshahquinn-wmf moved this task from Backlog to Next up on the Contributors-Analysis board.Nov 21 2017, 8:36 PM
nshahquinn-wmf added a comment.Nov 28 2017, 2:30 AM

Past episodes of this task for reference: T119925, T149710, T164545.

nshahquinn-wmf added a comment.Dec 6 2017, 6:45 PM

I've been working on this over the past couple of days. It's taking longer than normal because I'm trying to get it fully automated so future iterations will be easier, but I'm still hoping to finish by the end of the day.

nshahquinn-wmf moved this task from Next up to Neil's in progress on the Contributors-Analysis board.Dec 8 2017, 8:38 PM
nshahquinn-wmf added a comment.Dec 8 2017, 10:39 PM

Another update: I'm through the infrastructure automation, and now I'm actually running the queries. I should be finished by the end of the day.

nshahquinn-wmf closed this task as Resolved.Dec 9 2017, 3:27 AM

Done! As before, the results are in this spreadsheet (this time in a tab named "2017-12 run").

I've made the calculations a lot more automated, so it should be much easier to do other runs of this in the future or to hand it off to another analyst. The code is in this GitHub repo.

JCuriel added a comment.Dec 11 2017, 11:35 PM

Thanks so much Neil! Really appreciate your help on this!!!!

nshahquinn-wmf raised the priority of this task from Medium to Needs Triage.Mar 30 2018, 10:27 AM
nshahquinn-wmf moved this task from Neil's in progress to Done on the Contributors-Analysis board.
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL