EBernhardson has uploaded a new change for review.
https://gerrit.wikimedia.org/r/178646
Change subject: Initial graphs of FlowReplies EventLogging schema
......................................................................
Initial graphs of FlowReplies EventLogging schema
Change-Id: Iafff3cefb2e8eb2ea638e43c1cb851bedeed34c5
---
M flow/config.yaml
A flow/flow-replies-summary.sql
A flow/top-reply-link.sql
3 files changed, 36 insertions(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-flow-data
refs/changes/46/178646/1
diff --git a/flow/config.yaml b/flow/config.yaml
index 5f1dd6b..b6abe2b 100644
--- a/flow/config.yaml
+++ b/flow/config.yaml
@@ -11,6 +11,7 @@
db: flowdb
# for convenience, define unions of different event logging schemas here:
tables:
+ replies: FlowReplies_10561344
intervals:
running_average: 30
output:
@@ -34,3 +35,11 @@
moderation-actions:
title: "Moderation actions"
frequency: hourly
+ flow-replies-summary:
+ title: "Total event counts by entrypoint and action"
+ frequency: hourly
+ db: el
+ top-reply-link:
+ title: "Are people actually clicking on the top Reply link?"
+ frequency: hourly
+ db: el
diff --git a/flow/flow-replies-summary.sql b/flow/flow-replies-summary.sql
new file mode 100644
index 0000000..906f61c
--- /dev/null
+++ b/flow/flow-replies-summary.sql
@@ -0,0 +1,12 @@
+/* Note that limn will probably not graph this appropriatly, it expects each
column to be
+ * a data point but in this query the data is per row. The hope is limn will
still offer
+ * up the table view of this data without graphing.
+ */
+SELECT DATE(timestamp) as Date,
+ event_entrypoint,
+ event_action,
+ count(event_action)
+ FROM {{ tables.replies }}
+ WHERE wiki NOT IN ('testwiki', 'test2wiki', 'officewiki')
+ GROUP BY DATE(timestamp), event_entrypoint, event_action;
+
diff --git a/flow/top-reply-link.sql b/flow/top-reply-link.sql
new file mode 100644
index 0000000..cc8194c
--- /dev/null
+++ b/flow/top-reply-link.sql
@@ -0,0 +1,15 @@
+/* Are people actually clicking on the top Reply link? */
+SELECT DATE(timestamp) as Date,
+ SUM(IF(event_entrypoint = 'reply-top' AND event_action = 'initiate', 1,
0)) as "Top reply initiated",
+ SUM(IF(event_entrypoint = 'reply-top' AND event_action =
'save-attempt', 1, 0)) as "Top reply save attempt",
+
+ SUM(IF(event_entrypoint = 'reply-top' AND event_action =
'save-success', 1, 0)) as "Top reply save success",
+ SUM(IF(event_entrypoint = 'reply-bottom' AND event_action = 'initiate',
1, 0)) as "Bottom reply initiated",
+ SUM(IF(event_entrypoint = 'reply-bottom' AND event_action =
'save-attempt', 1, 0)) as "Bottom reply save attempt",
+ SUM(IF(event_entrypoint = 'reply-bottom' AND event_action =
'save-success', 1, 0)) as "Bottom reply save success"
+ FROM {{ tables.replies }}
+ WHERE event_entrypoint IN ('reply-top', 'reply-bottom')
+ AND event_action IN ('initiate', 'save-attempt', 'save-success')
+ AND wiki NOT IN ('testwiki', 'test2wiki', 'officewiki')
+ GROUP BY DATE(timestamp);
+
--
To view, visit https://gerrit.wikimedia.org/r/178646
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Iafff3cefb2e8eb2ea638e43c1cb851bedeed34c5
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-flow-data
Gerrit-Branch: master
Gerrit-Owner: EBernhardson <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
