Use Data Studio Field IDs to Combine Two Data Sources Without Blending! 

This feature is SO underrated. It solves so many problems. Thanks for pointing that out! Also, I think Google chose a total misnomer for this. "Field ID" suggests that it should be unique among all data sources, which is the opposite of what it is intended for...

Brother... You just solved a problem I've had since 2020... Oh my god, the number of headaches with weird blending you have saved me. Thank you so much for this.

This is great! We just switched our Looker reporting from the GA4 API to BigQuery and I have been struggling with filters for the different scoped tables on a single page, this will be a great solution for that too. Thanks for sharing.

Thanks sir! U deserved nobel prize..

No way, this is sick! Thank you!

God Tier Tutorial man, you save my work. I am a student in practice from Chile, at work they ask me to make an indicator report. With your tutorial you fixed a problem where the program repeated the data from the actual months vs. the budget months. Thank you so much. One question, in the line graph, I want to make a historical comparison of the actual data vs the budget. The budget is displayed correctly month by month, but the actual data is added (example: January + February) over all months in the chart. You know how to fix that or the problem that causes it. Greetings!!

Brilliant, thanks JJ.

Mind officially blown!

you're the best!

This is really helpful!

Great video! This is super helpful for some issues I've had along the way, and it's nice to know that there are some good knowledge sources out there. Say I needed to combine 30 or so RU-vid channels' views, probably just into a scorecard (using the default RU-vid connector from Looker Studio). Is there any way to use this method toward that goal? Currently, I just have 6 blends that I then add together, but I'm trying to figure out a way to automate the combination. Many thanks!

Hi this video has been more than helpful. Thank you! What would you do in this case? Suppose I have only 1 column (Names) in 2 data sources. The names in both the datasources do not have anything/name in common Now if I want to create a table with all the names from both the data sources I can simply do that by blending (outer join as nothing is in common) the two datasources. How do I create a filter that lists all the names from both the datasources and help me filter the blended table I just created? Thanks for the video once again Cheers!

Great.

Thank you SO MUCH!

ohh this is great mate can anybody help me for the following issue; I would like to add calculated items which is Conversions Rate but like this: Clicks (from Google Ads) Conversions (from Google analytics and only Google ads conversions) >>>> blend with inner option but when I choose above score cards in looker and right click to blend the above metrics looker says you can't blend because you already blended conversion scorecard

wow - insane! Thank you!

Thank you Bro.

How we can do calculation between fields from different sources without blending them? I have "sales" column in source A and "Total" column in source B, and I'd like to add a "Remaining" column to my table, so by filtering each product, which has the "same filed ID" on both sources, I'd like to show the amount left in the inventory. Thanks

Thank you very much! I have tested it with the "Campaign" dimension for Google Ads and Google Analytics data and everything is updated, but with metrics with results in currency or percentage (CTR, cost/conversion) I get the following error: "Invalid setting. Invalid combination of metrics or dimensions". Why can I get this error? Thanks for your help

What if Source-C google filter value is coming as parameter from previous report. Will it filter both the tables? Can we have a video on that pls?

Will this work in scorecard as well ?

How to do it for one table or for graph from 2 different data source. for ex one data source has sales no. and one has customer visit count. do i need to blend them ?

what if I want to link two or multiple sheets with same data month on month, it should just be a source in continuation of next month and so on. Please advise. No blending here

Hi , I have two fact tables (data sources), factACTUAL and factBUDGET, and two dimension tables, dimCOA and dimDate. I can link/blend one of the two dimension tables to both fact tables, but I can only link the second dimension table to one of the two fact tables. Has anyone overcome this problem before?