Google Analytics/Data studio- Counting number of campaign per users

by Aleath   Last Updated October 19, 2019 04:03 AM - source

I'm trying to bucket users by how many distinct email campaigns they receive. I want to be able to visualize similar to how "Count of Sessions" works. I can get count distinct of campaign as a metric but need to turn it into a dimension. I've tried writing:

Case when COUNT_DISTINCT(Campaign = 1) then "1" When COUNT_DISTINCT(Campaign =2) then "2" When COUNT_DISTINCT(Campaign =3) then "3" else "more"

End



Related Questions





Google Data Studio Multiple Date Range

Updated June 25, 2019 08:03 AM