How do I make a dimension from word in a string?
I have a adwords campaign name syntax that look something like this:
From this campaign name I would like to make a dimension called Campaign type that looks if the campaign name has RMKT or PRSP in the string.
How do I do this in data studio?
In sql I would use "Like" so the function would look something like this:
when campaign like '%RMKT%' then 'Remarketing'
when campaign like '%PRSP%' then 'Prospecting'
else 'other' end as campaign_type