Google Data Studio Blending: Examples, analogies, & explanations - every use case explained

[@zahey97]

best video ever!😲

[@RameshK_yt]

This video is simply awesome. Thanks for this video.

[@Vision-Labs]

So glad you enjoyed it! - JJ

[@sarahmontoro4484]

I really appreciate the creativity, time, and attention you put into this video. It was super helpful!

[@Vision-Labs]

Thank you letting me know it was worth it @sarah!! - JJ

[@harleysilva9303]

Coolest guy on the data planet!🤩🔥✨️

[@Vision-Labs]

AWEEEE you are too kind @Harly Silva!!! - JJ

[@Gert-JanMStoop]

Thx a lot. Clear and very helpfull

[@craigparker-m3i]

Hey, great video. I am trying to blend some search console data and add a filter. I am coming up against issues and I am not sure why. Can you tell me the best way to blend data to show search console queries matched with URLs that shows the metrics of clicks, impressions, ctr & avg. position. Then once that is shown how I can filter it to just show position 1. Then a table to show positions 2-5 etc. I can't find anything online that shows me how to do this. Appreciate any help.

[@Vision-Labs]

Hey! Search console data can be fairly wonky when trying to blend with others. Feel free to shoot me an email [e-mail] & ill try to help you out if I can.

[@nickplay11]

Thanks for this amazing explanation! I have a question, let's say that we are using this same example of yours regarding total amount spend + rep + hard costs and I would like add total sales revenue amount in the table. And the main goal is to have a column where I can see what is my daily profit (total sales amount by day - total spend by day). How should I do that? Thumbs up from Brazil, my friend.

[@Vision-Labs]

Thanks for leaving a comment! Love hearing this is helping people! You can create a new field at the chart level which is just that. Sum( Sum(spend 1 + spend 2 + spend 3) - Profit) Or whatever your system looks like :)

[@BrokenRecord-i7q]

Great :)

[@fungi2732]

As always a great video, thanks for sharing. I have an issue after I've blended two sources by country name (google sheets with SA360). In G sheet I've just used a full country name and in SA360 I've used the following code to extract country code and convert it into full name. (CASE WHEN LEFT_TEXT(Account name / description,2)="CZ" THEN "Czech Republic" else TOCOUNTRY(LEFT_TEXT(Account name / description,2),'COUNTRY_ISO_CODE') end altough the names appear to be exactly the same in both sources they don't get combined (most countries do) for some reasons. any idea? Edit: Well i think i found a culprit - in SA360 the countries that don't get blended are ones that have 2 different accounts within themselves. So a problematic country Itally has 2 accounts (account 1 and account 2) and when combining with Italy from Gsheet Italy is left out. Probably I guess it's because it doesnn't know which instance to combine. will try to blend sa360 with sa360 first

[@Vision-Labs]

Yay!!! Glad you have figured it out!!!!!!! Keep us posed if you get it working!!

[@fungi2732]

@@Vision-Labs I haven't. not sure how to go about it

[@Vision-Labs]

@@fungi2732 Shucks, if you can. Send me an email with as much detail as you can. Just join the email list & reply to any email (you can unsubscribe as soon as you want) Datastudio.vip/cheatsheet

[@roycemekolle7334]

I still don't understand how blend works in Data studio and would appreciate your feedback. I have 2 data set 1- has unique product ID (key) and for each product i have opening stock, closing stock and Cost of sales 2- the 2nd Data set(Fact table) also has product ID and the corresponding sales (multiple instances do exist for the Product ID My objective is to show on a visual the Product ID, Cost of Sales, Rev and Gross Margin (rev-cost of sales) but when I use any of the blends (left, right, or full outer) the Cost sales is like 500x the amount and hence margins are negative. I have no clue why this is so. this is something I pull off in Excel or Power BI very easily but with data studio I cant seem to figure it out how blend work. please your feedback on this is highly appreciated

[@Vision-Labs]

Hey Royce, Blends should work the same GDS is more sensitive to things like spaces & invisible charicters so you might want to double check that the join keys are the exact same. The way i really like to do this is to have two tables on a page. Filter them by the same field and blend them together by selecting both tables. This makes sure you have the same key if you are doing something complex.