Post Deployment data QA for bucketedUserEditCount added to PrefUpdate schema.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Goal | ovasileva | T242131 [GOAL] Deploy new header to at least one test wiki | ||
| Resolved | Jdlrobson | T240856 [EPIC] New header for desktop improvements project | |||
| Resolved | ovasileva | T236176 [EPIC] Build opt-in/opt-out mechanism for desktop improvements project | |||
| Resolved | Mayakp.wiki | T243071 Update PrefUpdate schema to include edit count | |||
| Resolved | Mayakp.wiki | T246028 Data QA for Editcount on PrefUpdate schema |
Event Timeline
Comment Actions
bucketedUserEditCount was added to production last Thursday. Check on Production data and let the team know if everything looks good and close T243071 and this ticket.
Comment Actions
I am seeing the count of events go up for bucketedUserEditCount field, but since this was released last thursday 2/27, I need atleast 5-6 days of production data to make sure everything looks good.
In the meanwhile it would help to see if any user specific preference change and editcount has been recorded or not.
Comment Actions
Checked this week's data and it looks like we are missing data for Mar-03 and Mar-04. Also Mar-02 only shows users in the 100-999 bucket which doesn't seem right.
@ovasileva can we have someone look into this?Comment Actions
Thanks for looking into this @Mayakp.wiki.
I see
after running
T246028
select year, month, day, sum(1) as n, sum(if(event.bucketedusereditcount = '0 edits', 1, 0)) as `0 edits`, sum(if(event.bucketedusereditcount = '1-4 edits', 1, 0)) as `1-4 edits`, sum(if(event.bucketedusereditcount = '5-99 edits', 1, 0)) as `5-99 edits`, sum(if(event.bucketedusereditcount = '100-999 edits', 1, 0)) as `100-999 edits`, sum(if(event.bucketedusereditcount = '1000+ edits', 1, 0)) as `1000+ edits` from event.prefupdate where year = 2020 and ( (month = 2 and day >= 25) -- The change was deployed to group0 wikis on Tuesday, 25th February or month = 3 ) group by year, month, day ;



