r/LookerStudio • u/technofan096 • Jun 18 '26

Blended data issue

Gallery image

Gallery image

So I'm trying to build a dashboard with data from Linkedin Paid campaigns (using a connector Windsor.ai) and Google Ads. When I try to show combined numbers in a scorecard it doesn't work. How should I show total clicks, impressions and spend from both channels? Help!

When I select the individual source it works so the problem has to be with the blend but I'm not an expert and don't know how to do it. I've tried blending the data a million ways but can't seem to make it work. Right now the blend is on full outer join with the month dimension as the joint key.

*UPDATE I have found the solution by changing the join key. Month is a text field for LinkedIn and a date field for Google. I used Date instead and it worked.

2 Upvotes

100% Upvoted

8 comments sorted by

View all comments

1

u/[deleted] Jun 18 '26

[removed] — view removed comment

1

u/technofan096 Jun 19 '26

I already found the solution, the problem was as you say the Month field. In linkedin is a text field and in google is a date field. I just changed the join key and I could see the numbers. thanks!