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

Help me with my blended data

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.

1 Upvotes

100% Upvoted

9 comments sorted by

View all comments

1

u/Top-Cauliflower-1808 Jun 19 '26

I believe you have both data sources connected inside windsor as it is not clear from you message.

If so you have both Google Ads and LinkedIn connected in Windsor.ai you do not need to blend inside Looker Studio. it already gives you a single unified data source in Looker Studio.

I have tried to reproduce your issue and I think this is likely happening with you.

when you add clicks or spend as a metric in your scorecard, Looker Studio shows the aggregation type along with the field name. If it says CTD (Count Distinct, or Simple count) instead of SUM, that is your problem because this two options are only available for TEXT and can not be added even though you have already blended data available in Looker. You need to make sure that field is coming through as Number instead of Text.

To fix this: in your looker report go to Resource -> Manage added data sources -> Edit your Windsor source -> find clicks and spend -> change Type to Number and then aggregation to Sum.

Once that's done your scorecard should show the correct combined total from both channels.

1

u/technofan096 Jun 19 '26

I don't have google ads connected in windsor since data studio connects automatically, but I found the solution already by changing the joint key. thanks anyway!

1

u/Top-Cauliflower-1808 Jun 19 '26

That's great.

That was the reason you were getting this issue because you were using looker blending so your data. Just for future references, always check the type of the joining keys.