Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P8156
Referer source ratio
Active
Public
Actions
Authored by
dr0ptp4kt
on Mar 5 2019, 10:59 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F28329865: raw.txt
Mar 5 2019, 10:59 AM
2019-03-05 10:59:36 (UTC+0)
Subscribers
•
chelsyx
from (
select
year,
month,
day,
referer_class,
sum(view_count) over (partition by year, month, day, referer_class)
/
sum(view_count) over (partition by year, month, day) as ratio
from
projectview_hourly
where year > 2016
and project = 'id.wikipedia'
and access_method = 'mobile web'
and agent_type = 'user') t1
select distinct *
order by referer_class, year, month, day
limit 20000
;
Event Timeline
dr0ptp4kt
created this paste.
Mar 5 2019, 10:59 AM
2019-03-05 10:59:36 (UTC+0)
dr0ptp4kt
added a subscriber:
•
chelsyx
.
Comment Actions
@chelsyx
possibly helpful for
T212414
, although not conclusive.
•
chelsyx
added a comment.
Mar 6 2019, 4:14 AM
2019-03-06 04:14:00 (UTC+0)
Comment Actions
Thanks
@dr0ptp4kt
!
dr0ptp4kt
mentioned this in
T222154: Determine the pageview (and if possible, search impression) impact of automatic SERP translations
.
Apr 30 2019, 10:50 AM
2019-04-30 10:50:24 (UTC+0)
Log In to Comment