Page MenuHomePhabricator

GSoC 2022: Micro-task 1 for Campaigns Retention Metrics Dashboard
Closed, ResolvedPublic

Description

Microtask - 1 of T304826

[Time estimate to complete: 1-3 hours]

Task: Write a SQL query on https://quarry.wmcloud.org/ to get a list of "unique" uploaders to the Wikimedia Commons category: Images from Wiki Loves Earth 2014, who have created their Wikimedia account during the campaign period i.e. May and June 2014. The output should include user_name and their account registration timestamp.

Submission instructions: After a successful output, submit the link (copy from url) along with Phabricator username privately to me @KCVelaga on Zulip (don't post the link publicly). Along with the code, do write explanatory comments about the approach and purpose of various steps. I will confirm whoever has submitted the micro-task here and your application as well.

Hints:

Note:

  • If during evaluation, if it is identified that the code is copied, the micro-task submission will be considered as invalid.
  • For any doubts, you can post them to this ticket or ask on Zulip stream #gsoc2022: campaign retention metrics dashboard

Event Timeline

KCVelaga renamed this task from Micro-task 1: to GSoC 2022: Micro-task 1 for Campaigns Retention Metrics Dashboard.Mar 29 2022, 4:40 PM
KCVelaga updated the task description. (Show Details)
KCVelaga updated the task description. (Show Details)

Confirming @Ramu_ummadishetty has successfully submitted the first micro-task.

Confirming @Nivas10798 has successfully submitted the first micro-task.

Confirming @akashsuper2000 has successfully submitted the first micro-task.

Confirming @Vidya816 has successfully submitted the first micro-task.

Confirming @LKalia has successfully submitted the first micro-task before the proposal deadline.