Google Data Studio Data Blending + Create Field
I'm trying to blend data in Google Data Studio that will show my directors the combined local campaigns for Google AdWords and Facebook Ads.
I think I've cracked the data blending with the link data being the date (really wanted it to be more Ad Set/ Ad Group base but it didn't work), the bit I am struggling with is to combine the Ad Group names from Google and the Ad Set names from Facebook so they show in one column on a table. I've tried CONCAT but it doesn't recognise it as a valid formula.
I'm sure I'm not the only person who's tried this so any help is much appreciated.