Josh Michaels

09/14/2022, 6:47 PM
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


09/15/2022, 9:13 AM
Have you tried using a SQL query to do this?