Hello!
I am trying to set up a data blend where I want to combine and summarize the ad spend from Google Ads, Facebook Ads and Microsoft ads. Is this possible to do?
I have tried searching around on this subject and found different answers. Some says this cant be done and some says that it should be possible. I am able to set up the blend and get numbers from one of the sources at the time, but they will not combine. I have tried all the different Join data configurations and have seen some say that left outer is the only one that works. If this is true or not I m not sure. I know that name of dimension and metrics can differ from source to source, but I have even tried to change the dimension names in the data source to make them match each other. In addition to this I have also added the IFNULL formula to be sure that all sources gives me 0 instead of "missing data" or something similar. Is there anything that I am missing regarding setting up this blend? Can this blend work with Looker Studio's own data blend function? If anyone has the answer here, it would be greatly appreciated.
Thank you in advance.
LinkedIn
Twitter
