Bmansurov has uploaded a new change for review.
https://gerrit.wikimedia.org/r/174055
Change subject: Update UI-Daily
......................................................................
Update UI-Daily
Change-Id: I09ed38d852ec0c82a6f9a42ed6ffc3505ede82ef
---
M mobile/ui-daily.sql
1 file changed, 10 insertions(+), 3 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/limn-mobile-data
refs/changes/55/174055/1
diff --git a/mobile/ui-daily.sql b/mobile/ui-daily.sql
index 699454e..f6af360 100644
--- a/mobile/ui-daily.sql
+++ b/mobile/ui-daily.sql
@@ -1,4 +1,5 @@
select
+ sum(if(event_name = 'hamburger', 1, 0)) as Hamburger,
sum(if(event_name = 'hamburger-home', 1, 0)) as Home,
sum(if(event_name = 'hamburger-random', 1, 0)) as Random,
sum(if(event_name = 'hamburger-uploads', 1, 0)) as Uploads,
@@ -7,11 +8,17 @@
sum(if(event_name = 'hamburger-settings', 1, 0)) as Settings,
sum(if(event_name = 'hamburger-login', 1, 0)) as Login,
sum(if(event_name = 'hamburger-logout', 1, 0)) as Logout,
- sum(if(event_name = 'hamburger-profile', 1, 0)) as 'Profile',
+ sum(if(event_name = 'hamburger-profile', 1, 0)) as Profile,
+ sum(if(event_name = 'search', 1, 0)) as Search,
+ sum(if(event_name = 'notifications', 1, 0)) as Notifications,
+ sum(if(event_name = 'reference', 1, 0)) as Reference,
+ sum(if(event_name = 'languages', 1, 0)) as Languages,
sum(if(event_name = 'lastmodified-history', 1, 0)) as 'Last modified
history',
- sum(if(event_name = 'lastmodified-profile', 1, 0)) as 'Last modified
profile'
+ sum(if(event_name = 'lastmodified-profile', 1, 0)) as 'Last modified
profile',
+ sum(if(event_name = 'page-toc-toggle', 1, 0)) as 'Page TOC toggle',
+ sum(if(event_name = 'page-toc-link', 1, 0)) as 'Page TOC link'
from
MobileWebClickTracking_5929948
where
timestamp >= '{from_timestamp}' and
- timestamp <= '{to_timestamp}'
+ timestamp <= '{to_timestamp}'
\ No newline at end of file
--
To view, visit https://gerrit.wikimedia.org/r/174055
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I09ed38d852ec0c82a6f9a42ed6ffc3505ede82ef
Gerrit-PatchSet: 1
Gerrit-Project: analytics/limn-mobile-data
Gerrit-Branch: master
Gerrit-Owner: Bmansurov <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
