I'm trying to get an overview of all page views based on session source using BigQuery, but I see very large differences compared to the user interface.
What I am wondering, does Google use last non-direct click for this metric (that explains the differences)? I know it uses it for calculating conversions but I just want to understand how it assigns the source and medium at the start of a session.