Google Data Studio by default has a formula to convert all text to uppercase, but what if you want to capitalize only the first letter of your traffic sources in Google Analytics and create a report of the same. The power of using the dot lies in combining it together with other characters. Go.gle matches google, goagle and gosgle but not gogle. CASE WHEN REGEXP_MATCH(meduim,"^paid") THEN "Paid" ELSE "Organic" End Dot. And you want to group any medium that starts with the string paid under a channel grouping called “Paid” and anything else under “Organic”. Let’s say you have 3 paid social sources in your Google Analytics (facebook / paid-social, instagram/paid-social, twitter/paid-social).
^social matches social media and social network, but not online social. In other words, it means something begins with. In this post, I will be covering most of the metacharacters along with practical examples from Google Data Studio.īefore we start, I recommend you have a look and understand the formulas in the article below, because all of our regex examples are based on these formulas.Ĭreate Advanced Di mensions in Google Data Studio via these 6 Formulas Caret ^ And to build a pattern you need learn the regex metacharacters. You can think of regex as specific sequences of characters that broadly or narrowly match patterns in your data. They add extra flexibility to the way you create definitions or include & exclude data from your reports.
Regular expressions (regex or regexp) can help save time and effort when working with Google Analytics, Google Tag Manager and now Google Data Studio.
0 kommentar(er)
