I am looking for some help with google data studio. I pretty familiar with both but stuck on a problem.
I have 2 google sheets data reports that I am trying to merge in data studio. I understand google sheets and data studio pretty well. I have campaigns running that go to 2 different companies. I want to use the campaign name to merge them, but be able to sum the clicks, conversions, etc from the 2 tables. Basically, I want to see the total clicks each campaign got. I have blended them, and tried to sum the clicks but they dont actually merge into one campaign.
what im looking for is
If this is wrong place to post this let me know and I will take down. Newer to community. Thank you