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

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

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


Updated September 27, 2018 15:03 PM

Updated May 01, 2019 09:03 AM

Updated March 27, 2019 11:03 AM

Updated June 25, 2019 08:03 AM