When L1 is generating EventLogging data with the https://meta.wikimedia.org/wiki/Schema:FlowReplies schema, we need to write queries to visualize it
https://www.mediawiki.org/wiki/Flow/Analytics
Description
Details
Subject | Repo | Branch | Lines +/- | |
---|---|---|---|---|
Initial graphs of FlowReplies EventLogging schema | analytics/limn-flow-data | master | +36 -0 |
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | None | T76424 M2. Evaluate the initial data from Flow EventLogging and back-end analytics | |||
Resolved | EBernhardson | T76423 M1. Write queries to visualize Flow EventLogging |
Event Timeline
We don't want officewiki's EventLogging to be in the report card, since officewiki's back-end board activity isn't part of the report card.
Also i'm just noticing that the FlowReplies schema is not recording the wiki the event happens on
wiki is a freebie that comes with all EventLogging events. See https://meta.wikimedia.org/wiki/Schema:EventCapsule . In the DB table, it's one of the fields that is not prefixed with event_ .
12:32 <+dannyh> ebernhardson|lch spagewmf The questions that I want to answer are: Are people actually clicking on the top Rep 12:32 <+ebernhardson|lch> dannyh: that takes about 1 minute. anything else? :) 12:32 <+dannyh> ebernhardson|lch spagewmf top Reply link, or should we remove it because nobody uses it anyway? Are people clicking on the Reply link, or in the entry field box? 12:33 <+ebernhardson|lch> do you just want to know if they clicked it, or if they clicked it and made a successfull post? 12:33 <+ebernhardson|lch> or do we want both ? 12:33 <+dannyh> ebernhardson|lch spagewmf Are people clicking the Reply link more likely to follow through with the post than people clicking in the entry field, or are people trying the Reply link and then going down to the entry field to actually post? 12:34 <+dannyh> ebernhardson|lch Yeah, I'd like to see how many people click & compare to how many succeed 12:34 <+ebernhardson|lch> ok i'll work out some queries for that 12:35 <+dannyh> what I want is basically what I got from Google Analytics at Wikia -- I put in some dates and I get a table with numbers. 12:35 <+ebernhardson|lch> i would be happy to install GA, but never happen with our privacy policy :P 12:35 <+dannyh> yeah, I know :) 12:36 <+ebernhardson|lch> but relatedly, i've never used GA and have no clue what it reports 12:36 <+dannyh> it's kind of like reading the tea leaves -- if I have a week's worth of numbers in a table, then I can see how many clicks there are on the different links, and compare to % of success 12:38 <+dannyh> so it can be as simple as: I put in Nov 8-14, 2014, and I get a table that says new-topic initiate: X clicks, new-topic cancel-attempt: Y clicks 12:38 <+dannyh> and I can figure it out from there 12:39 <+ebernhardson|lch> are those normalized by session or user at all? 12:39 <+ebernhardson|lch> i mean, if we have 3 theoretical users, and one of them posts 100 topics and the other post 1 topic each, does it say 3 topics or 102? 12:40 <+ebernhardson|lch> (topics might be wrong word in this context....wording is hard:P)
Change 178646 had a related patch set uploaded (by EBernhardson):
Initial graphs of FlowReplies EventLogging schema
Change 178646 merged by EBernhardson:
Initial graphs of FlowReplies EventLogging schema
@EBernhardson @DannyH Is this done, or should we include querying the data from T76574: L3. Event-logging: Log menu actions (FlowMenu) (2) when that's implemented?