canmove, Confirmed users, Bureaucrats and Sysops emeriti
2,798
edits
Mobile/Metrics/Redash: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
MarkFinkle (talk | contribs) mNo edit summary |
MarkFinkle (talk | contribs) mNo edit summary |
||
| Line 73: | Line 73: | ||
submissiondate > current_date - interval '7' day and sessions like '%firstrun%' | submissiondate > current_date - interval '7' day and sessions like '%firstrun%' | ||
group by 1, 2, 3, 4, 5 | group by 1, 2, 3, 4, 5 | ||
Let's breakdown <code>loadurl.1</code> events into some subgroups over the last 7 days: | |||
select | |||
submissiondate as date, | |||
count(action) as allloads, | |||
sum(case when extras = 'bookmarks' then 1 else 0 end) as bookmarks, | |||
sum(case when extras = 'reading_list' then 1 else 0 end) as readinglist, | |||
sum(case when extras = 'top_sites' then 1 else 0 end) as topsites, | |||
sum(case when extras = 'history' then 1 else 0 end) as history, | |||
sum(case when extras = 'frecency' then 1 else 0 end) as frecency, | |||
sum(case when method = 'actionbar' and extras = 'user' then 1 else 0 end) as user_typed, | |||
count(distinct clientid) as users | |||
from | |||
android_events_v1 | |||
where | |||
submissiondate > current_date - interval '7' day and action = 'loadurl.1' | |||
group by 1 | |||