Hi Robert

From the `WHERE` clause here:

https://github.com/wikimedia/analytics-refinery-source/blob/master/refinery-job/src/main/scala/org/wikimedia/analytics/refinery/job/ClickstreamBuilder.scala#L283

you can see that we bundloe altogether desktop, mobile-web and mobile-app rows.

As for the reason of so many empty referrers, I don't know myself, but I know it's been a topic already discussed.

IIRC Nuria and Jon Katz looked into it a bit, and more recently Isaac Johnson (all in direct copy).

Cheers

Joseph

On Tue, Jun 9, 2020 at 9:03 AM Robert West <west@cs.stanford.edu> wrote:

Hi Analytics team,

Quick question:

Does the Clickstream data lump together mobile and desktop?

It seems to be hinted at here, but it's not mentioned explicitly. It just says that the 2015 data is for desktop only, which seems to imply that after that it's desktop + mobile.

Also, I was wondering if anyone has any insights into what might cause referrers to be empty? I tried googling, but the issue is clouded in mystery and seems to depend a lot on browser and website specificities. Any insights (small or big) would be appreciated!

Thanks a lot!

Bob

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics

--

Joseph Allemandou (joal) (he / him)

Sr Data Engineer

Wikimedia Foundation