Page MenuHomePhabricator

M1. Write queries to visualize Flow EventLogging
Closed, ResolvedPublic

Description

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

Event Timeline

Spage raised the priority of this task from to Medium.
Spage updated the task description. (Show Details)
Spage changed Security from none to None.
Spage subscribed.
DannyH renamed this task from write queries to visualize Flow EventLogging to M1. Write queries to visualize Flow EventLogging.Dec 3 2014, 6:48 PM

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.

It seems we have left out what the actual queries we want are?

Also i'm just noticing that the FlowReplies schema is not recording the wiki the event happens on

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

https://gerrit.wikimedia.org/r/178646

Patch-For-Review

Change 178646 merged by EBernhardson:
Initial graphs of FlowReplies EventLogging schema

https://gerrit.wikimedia.org/r/178646