Page MenuHomePhabricator

"Magic Button" seems broken for gather newly registered user counts.
Closed, ResolvedPublic

Description

Reke and I are writing our rapid grant repor[1]t. While using the Magic button to create the newly registered users, we find every time we run the accounts, the newly registered number is always 0. However, there are actually many of the participants in our workshop created their own user accounts during the workshop. We don't know why it's not working properly as we expected. How can we debug?

Event Timeline

Abit subscribed.

@Shangkuanlc, can you please provide a list of usernames and the start and end dates for the event? I will try to see what went wrong.

Here it is:

Jadychen0825
chaoannricardo
Ambermml6
S.sam
Aa136038
Jasonzhuocn
YanbinHao
冷月无声念桥边
Domo925
Asura1981

Start date: 2016-10-15 10:00 (UTC+8)
End date: 2016-10-15 17:00 (UTC+8)

Besides input the users directly, I also created a cohort, FYI.

@Shangkuanlc I just ran a Magic Button report with the usernames and dates you provided, these are the results I got:

rolling_active_editorbytes_addednewly_registeredpages_editedpages_createdexisting_editors
2388076704

https://metrics.wmflabs.org/reports/result/5146fccf-fee1-4121-a77c-bd22cd588f1d.json

I think these results are more in line with the results you were expecting?

Hi Abit,
It seems right. I will check with our staff and confirm with you later.
It's weird that the first couple of time we use the CSV file keep shows
0.000 newly registers users. Would this be caused by wrongly operating the
magic button? I wonder.
Abit <no-reply@phabricator.wikimedia.org>於 2017年1月20日 週五,08:16寫道:

Abit added a comment.

@Shangkuanlc https://phabricator.wikimedia.org/p/Shangkuanlc/ I just
ran a Magic Button report with the usernames and dates you provided, these
are the results I got:
rolling_active_editor bytes_added newly_registered pages_edited
pages_created existing_editors
2 38807 6 7 0 4

https://metrics.wmflabs.org/reports/result/5146fccf-fee1-4121-a77c-bd22cd588f1d.json

I think these results are more in line with the results you were expecting?

*TASK DETAIL*
https://phabricator.wikimedia.org/T155612

*EMAIL PREFERENCES*
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

*To: *egalvezwmf, Abit
*Cc: *Abit, Legoktm, Aklapper, Shangkuanlc, JAnstee_WMF, egalvezwmf

It's weird that the first couple of time we use the CSV file keep shows 0.000 newly registers users. Would this be caused by wrongly operating the magic button? I wonder.

It could be. I know the magic button is finicky about how you enter dates--if you don't include the entire date string it will revert to the day you are running the report. So if I enter 2016-10-15 17:00 as the end date, it would revert to 2017-01-20 00:00:00. I need to enter 2016-10-15 17:00:00 (including the 00 for seconds) to get it to recognize the date.

It looks like the Magic Button is now working correctly for this report, so I'm closing this task.