Mforns has uploaded a new change for review.
https://gerrit.wikimedia.org/r/212276
Change subject: Productionize failure types by user type
......................................................................
Productionize failure types by user type
1) Modifies the report query to add a first 'day' column, and
also to accept exploding by wiki and by editor.
2) Adds configuration to config.yaml to run the report through
reportupdater.
Bug: T91123
Change-Id: Ib521e9be71a60f372006ae8ed43ca0e6d0de7935
---
M edit/config.yaml
M edit/failure_types_by_user_type.sql
2 files changed, 19 insertions(+), 10 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-edit-data
refs/changes/76/212276/1
diff --git a/edit/config.yaml b/edit/config.yaml
index f797ee9..4ad2f9a 100644
--- a/edit/config.yaml
+++ b/edit/config.yaml
@@ -90,3 +90,13 @@
by_wiki: true
explode_by:
editor: "visualeditor, wikitext"
+
+ failure_types_by_user_type:
+ frequency: days
+ granularity: days
+ timeboxed: true
+ funnel: true
+ starts: 2015-05-01
+ by_wiki: true
+ explode_by:
+ editor: "visualeditor, wikitext"
diff --git a/edit/failure_types_by_user_type.sql
b/edit/failure_types_by_user_type.sql
index 6eefc0b..235e362 100644
--- a/edit/failure_types_by_user_type.sql
+++ b/edit/failure_types_by_user_type.sql
@@ -1,6 +1,5 @@
-set @from_time = '20150101000000';
-set @to_time = '20150201000000';
select
+ date(timestamp) as day,
case
when `event_user.class` = 'IP' then 'anonymous'
when `event_user.editCount` >= 1000 then 'over1000'
@@ -9,8 +8,7 @@
when `event_user.editCount` >= 1 then 'over1'
when `event_user.editCount` = 0 then 'firstEdit'
else 'unknown-user-type'
- end as State, -- This column needs to be named like this for now.
- -- See stacked-bar-prototype.js's TODOs.
+ end as user_type,
sum(`event_action.saveFailure.type` = 'userBadToken') as userBadToken,
sum(`event_action.saveFailure.type` = 'userNewUser') as userNewUser,
sum(`event_action.saveFailure.type` = 'extensionAbuseFilter') as
extensionAbuseFilter,
@@ -20,11 +18,12 @@
sum(`event_action.saveFailure.type` = 'responseUnknown') as
responseUnknown,
sum(`event_action.saveFailure.type` = 'editPageDeleted') as
editPageDeleted,
sum(`event_action.saveFailure.type` = 'editConflict') as editConflict
-from milimetric_edit
+from Edit_11448630
where
- `event_action.saveFailure.type` is not null and
- event_editor = 'visualeditor' and
- timestamp >= @from_time and
- timestamp < @to_time
-group by 1
+ event_editor = '{editor}' and
+ ('{wiki}' = 'all' or wiki = '{wiki}') and
+ timestamp >= '{from_timestamp}' and
+ timestamp < '{to_timestamp}' and
+ `event_action.saveFailure.type` is not null
+group by 1, 2
;
--
To view, visit https://gerrit.wikimedia.org/r/212276
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ib521e9be71a60f372006ae8ed43ca0e6d0de7935
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-edit-data
Gerrit-Branch: master
Gerrit-Owner: Mforns <mfo...@wikimedia.org>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
