Grouping acquisition channels together

[alexandret]

Hello,

I have a graph with sessions per channel group and a graph with turnover per channel group.

I have all the channel groups, but I would like to group some of them together.

For example, I'd like to combine ‘Paid Search’, ‘Cross network’ and ‘Paid other’ into a single ‘SEA’ channel.

Just as I'd like to combine ‘Organic Search’ and ‘Organic shopping’ into a single ‘SEO’ channel.

Could someone please tell me how to do this?

Thanks in advance

[sam8]

This sounds like a use case for the CASE function! You could write a calculated field like this:

CASE Channel Group
    WHEN "Paid Search" THEN "SEA"
    WHEN "Cross network" THEN "SEA"
    WHEN "Paid other" THEN "SEA"
    WHEN "Organic Search" THEN "SEO"
    WHEN "Organic shopping" THEN "SEO"
    ELSE "Other"
END

[alexandret]

Hello, 

Thanks, I dit it ! 

Have a nice day.

Alexandre

[sam8]

Wonderful!

[lauratilton]

Or, if you prefer not to have to write out a CASE statement you can create a custom group.

https://support.google.com/looker-studio/answer/14258973?hl=en&ref_topic=7570421&sjid=11435120031847...