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”)
Other Text Functions in Google Data Studio
When you finally decide to get smarter about all things digital and get your first second income stream built to make that WiFi Money. You need to sign up for my Substack below. Start with the article on Your Path to WiFi Money.
If you're looking at how to start your own website, I've created an easy guide for that too.