Concatenating is one of the easier formulas to build in Data Studio. Today I’ll give you some ideas on how to make this function useful.
Google uses Google RE2 regular expressions, so it’s worth a read to get a handle on how to use regular expressions in Google Data Studio.
If you still don’t understand REGEX after reading that link, keep trying. I’ve read it 5 times and I still don’t have a full grasp like I should.
Example #1 – Grouping Day of Week with CONCAT
When you want to track your traffic or sales by week day name and year to compare. Use the formula below.
CONCAT(Day of Week Name,” “,YEAR(Year))
The formula will turn the above into the below once you remove the date column.
Example #2 – Grouping Browser and Browser Size with CONCAT
Sometimes your site has issues on certain browsers and sometimes on certain browser size. Combining the two with CONCAT will let you break them apart in your reporting numbers.
CONCAT(Browser,” “,Browser Size)
Example #3 – Combining Demographic Data with CONCAT
Combing Gender and Age together for reporting purposes. Use the formula below.
CONCAT(Age,” Year Old “,Gender,”s”)
