Hi everyone,
I’m encountering an issue in Looker Studio where filtering sessions using result charts for specific events (e.g., session_start, add_to_cart, purchase) yields different numbers compared to a dynamic table that uses the following CASE statement:
CASE WHEN REGEXP_MATCH(Fuente/medio de la sesión, “^(Marketing / Whatsapp|whatsapp / messaging_app)$”) THEN “Mkt” WHEN REGEXP_MATCH(Fuente/medio de la sesión, “^(email / brevo|I.instagram.com / referral|Brevo / Email|(not set) / brevo|Marketing / insgram|fidelizador / Email|Marketing / Email|Marketing / Facebook|Marketing)$”) THEN “Mkt” WHEN REGEXP_MATCH(Fuente/medio de la sesión, “^(Callcenter / carrito|Whatsapp / callcenter|amo.to / referral|farmaloop.kommo.com / referral|carrito / callcenter)$”) THEN “Callcenter” WHEN REGEXP_MATCH(Fuente/medio de la sesión, “^(google / organic|direct / (none)|google / cpc|email / producto-requerido|Ecommerce / Email|email / cliente-notificado-precio|cl.search.yahoo.com / referral|(not set)|bing / organic|aws_ses / Email|Ecommerce.|programanuevoyo.com / referral|QR|convenios|email / redgesam|Convenio|Convenio / Whatsapp|Convenio / Email|Convenio / Instagram|Convenio / Linkedin|Convenio.)$”) THEN “Ecommerce” ELSE “Otros” END
The differences are minimal but consistent, even though I’m using “Sessions” as the metric in both cases.
Has anyone encountered something similar? Could there be differences in how Looker Studio processes data between filters and CASE statements?
Any insights or recommendations for troubleshooting would be appreciated!
Thanks in advance.
IMAGE REPORT:
