| Addshore moved this task from Doing to Peer Review on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞) board. Addshore added a comment. |
Query getting data from hadoop for January 2019
SELECT e.month AS month, e.day AS day, hideCount, showCount, allCount, termboxEntityViews, ( hideCount / termboxEntityViews * 100 ) as percHideCount, ( showCount / termboxEntityViews * 100 ) as percShowCount, ( allCount / termboxEntityViews * 100 ) as percAllCount FROM (
SELECT e.month AS month, e.day AS day, COUNT(case e.event.actionType when 'hide' then 1 else null end) as hideCount, COUNT(case e.event.actionType when 'show' then 1 else null end) as showCount, COUNT(case e.event.actionType when 'all' then 1 else null end) as allCount FROM event.wikibasetermboxinteraction e WHERE e.year = 2019 AND e.month = 1 AND e.wiki = 'wikidatawiki' GROUP BY e.month, e.day ORDER BY e.month, e.day LIMIT 100000 ) e LEFT OUTER JOIN ( SELECT p.month AS month, p.day AS day, SUM(p.view_count) as termboxEntityViews FROM wmf.pageview_hourly p WHERE p.year = 2019 AND p.month = 1 AND p.project = 'wikidata' AND p.access_method = 'desktop' AND p.agent_type = 'user' AND ( p.namespace_id = 0 OR p.namespace_id = 120 ) GROUP BY p.month, p.day ORDER BY p.month, p.day LIMIT 100000 ) p ON e.month = p.month AND e.day = p.day
And said data:
month day hidecount showcount allcount termboxentityviews perchidecount percshowcount percallcount 1 9 41 59 135 309963 0.01322738520404048 0.01903452992776557 0.04355358542793818 1 10 342 440 734 304415 0.11234663206477997 0.14453952663305028 0.24111821033786113 1 11 328 413 747 385801 0.08501792374825363 0.10705000764642911 0.19362313731690692 1 12 247 319 858 421485 0.05860232273983653 0.0756847811903152 0.20356596320153741 1 13 305 391 837 389771 0.0782510756315888 0.10031531335065974 0.2147414764053765 1 14 354 466 972 407247 0.0869251338868058 0.1144268711617274 0.23867579135021252 1 15 334 451 776 387644 0.08616152965091682 0.11634386189390265 0.2001836736799744 1 16 382 508 797 304297 0.1255352501010526 0.16694216505585005 0.26191516840455215
Data explanation:
- termboxentityviews = number of item or property page views by users on desktop on the given day on wikidata.org
- hidecount = number of those pageviews that had an interaction with "more languages" to collapse the box
- showcount = number of those pageviews that had an interaction with "more languages" to expand the box
- allcount = number of those pageviews that had an interaction with "all entered languages" to expand the box to all languages
- perc*count = percentage of those pageviews that the given interaction occurred on
TASK DETAIL
EMAIL PREFERENCES
To: Addshore
Cc: Michael, Addshore, gerritbot, Lydia_Pintscher, D3r1ck01, Aklapper, WMDE-leszek, Lea_WMDE, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, Jonas, Wikidata-bugs, aude, Mbch331
Cc: Michael, Addshore, gerritbot, Lydia_Pintscher, D3r1ck01, Aklapper, WMDE-leszek, Lea_WMDE, CucyNoiD, Nandana, NebulousIris, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Maathavan, _jensen, Jonas, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
