Supermetrics Support Forum

How to create agregated stat

Hi


We use coupon codes on our website, and wometimes people do not spell them right. For instance, the code "Welcome" is spelled : welcome or WELCOME, or Welcome,,...

What I would like to do is to create one new stat that regroups several items. For example, create a new stat called "Welcome" that gives me all the used coupons associated, only in 1 line in my tab

WELCOME = 45

Welcome = 10

welcome = 5


I would have a new tab with only one line:

Welcome = 60


How can I do so ?

  • i think you shall create a regexp dimension in the google data studio that will convert all of those words into upper . the name of the funciton was UPPER(), so whatever you get will become WELCOME¬†


    1 person likes this
  • Hi,


    Thanks for the answer.

    Question: what is a regexp and how do I create that ? :-)

Login to post a comment