Hey everyone, I’m struggling with data visualization in Looker Studio.
So, let me start from the beginning. I have a few calculated fields that collect and group creatives from Pmax and GDN campaigns, and then combine them under a single name. Here are the fields…
Pmax:
CASE
WHEN REGEXP_MATCH(Asset Group Name, ‘(?i).*family.*’)
THEN ‘Family’
WHEN REGEXP_MATCH(Asset Group Name, ‘(?i).*розтермінування.*’)
THEN ‘Розтермінування’
WHEN REGEXP_MATCH(Asset Group Name, ‘(?i).*єОселя.*’)
THEN ‘єОселя’
WHEN REGEXP_MATCH(Asset Group Name, ‘(?i).*документами.*’)
THEN ‘Квартира з документами’
WHEN REGEXP_MATCH(Asset Group Name, ‘(?i).*знижк.*до.*20.*’)
THEN ‘Знижка до 20’
WHEN REGEXP_MATCH(Asset Group Name, ‘(?i).*готовий.*будин.*’)
THEN ‘Готовий будинок’
WHEN REGEXP_MATCH(Asset Group Name, ‘(?i).*комерція.*’)
THEN ‘Комерція’
ELSE ‘Other’
END
GDN:
CASE
WHEN Ad ID IN (758111863338, 758874043822, 758874043831, 758965659746, 762729083967)
AND REGEXP_MATCH(Campaign ID, ‘22662188851’)
THEN ‘Family’
WHEN Ad ID IN (762729083937, 762729083970, 762729083955, 762729083931, 76272908394)
AND REGEXP_MATCH(Campaign ID, ‘22662188851’)
THEN ‘єОселя 1’
WHEN Ad ID IN (757310801479, 758874043816, 758874043825, 758965659740, 762729083961)
AND REGEXP_MATCH(Campaign ID, ‘22662188851’)
THEN ‘Знижка до 20’
WHEN Ad ID IN (758965659743, 762729083964, 758874043828, 757310801482, 758874043819)
AND REGEXP_MATCH(Campaign ID, ‘22662188851’)
THEN ‘Інфраструктура’
WHEN Ad ID IN (762729083940, 762729083973, 762729083958, 762729083934, 762729083952)
AND REGEXP_MATCH(Campaign ID, ‘22662188851’)
THEN ‘єОселя 2’
ELSE ‘Інші GDN’
END
I also have some additional calculated fields that, based on the name, create links for the preview formula, like this:
Pmax:
CASE
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*єОселя.*’) THEN “URL_1”
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*new\\s*\\|\\s*єОселя.*’) THEN “URL_2”
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*документами.*’) THEN ‘URL_3’
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*знижк.*до.*20.*’) THEN ‘URL_4’
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*готовий.*будин.*’) THEN ‘URL_5’
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*розтермінування.*’) THEN ‘URL_6’
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*family.*’) THEN ‘URL_7’
WHEN REGEXP_MATCH(Creative Grouping PMax, ‘(?i).*комерція.*’) THEN ‘URL_8’
ELSE “Other”
END
GDN:
CASE
WHEN REGEXP_MATCH(Creative Grouping GDN, ‘(?i).*інфраструк.*’) THEN “URL_1”
WHEN REGEXP_MATCH(Creative Grouping GDN, ‘(?i).*єОселя.*’) THEN “URL_2”
WHEN REGEXP_MATCH(Creative Grouping GDN, ‘(?i).*єОселя.*1.*’) THEN ‘URL_3’
WHEN REGEXP_MATCH(Creative Grouping GDN, ‘(?i).*єОселя.*2.*’) THEN ‘URL_4’
WHEN REGEXP_MATCH(Creative Grouping GDN, ‘(?i).*Family.*’) THEN ‘URL_5’
ELSE “Other”
END
And from these, I get tables like this:
Pmax and GDN similar only stats different
Next, I blend them using these parameters, and I end up with a table like this:
The first field, Name, is implemented with this formula:
COALESCE(Creative Grouping PMax, Creative Grouping GDN)
Then, I have previews with links, and that’s where the issue starts. If I add each of the fields that generate previews for the creatives (without blending them), everything works fine. However, if I blend them using the formula COALESCE(Creative preview PMax, Creative preview GDN), the preview links show up correctly. But, if I change the field type from text to image, it results in a blank field… (New Field in this case)
Has anyone encountered this issue or know how to fix it? I’d really appreciate any help. If you need more details, feel free to ask.