Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- channelGrouping as Default_Channel_Grouping,
- SUM (totals.visits) as Sessions,
- SUM(case when hits.page.pageTitle CONTAINS ('rafinha - Dugout') then 1 else 0 end) as Rafinha_Sessions
- FROM
- (TABLE_DATE_RANGE([133338516.ga_sessions_],
- TIMESTAMP('2017-10-01'),
- TIMESTAMP('2017-10-20')))
- GROUP BY Default_Channel_Grouping
- ORDER BY Sessions DESC
Add Comment
Please, Sign In to add comment