Guest User

Untitled

a guest
Oct 23rd, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT
  2. channelGrouping as Default_Channel_Grouping,
  3. SUM (totals.visits) as Sessions,
  4. SUM(case when hits.page.pageTitle CONTAINS ('rafinha - Dugout') then 1 else 0 end) as Rafinha_Sessions
  5. FROM
  6.  
  7. (TABLE_DATE_RANGE([133338516.ga_sessions_],
  8. TIMESTAMP('2017-10-01'),
  9. TIMESTAMP('2017-10-20')))
  10. GROUP BY Default_Channel_Grouping
  11. ORDER BY Sessions DESC
Add Comment
Please, Sign In to add comment