Hello all,
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.
Example:
Table 1
campaign_1
clicks 5
table 2
campaign_1
clicks 8
what im looking for is
campaign_1
clicks 13
If this is wrong place to post this let me know and I will take down. Newer to community. Thank you