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

Рет қаралды 11,030

2 жыл бұрын

How to use field ID's to fully customize your report interaction without blending.
Read the full article 👉 datastudio.vip/fieldids/
👇 Grab The Dashboard Cheat Sheet 👇
datastudio.vip/youtube
👇Explain It Data Studio Visualization👇
datastudio.vip/youtube
Learn About What I Am Trying to do
👉 datastudio.vip/learn
Apply To Work With Us. (Done for you)
mediauthentic.com/youtube
Learn On Your Own!
datastudio.vip/learn

Пікірлер: 52

@seka9910 5 ай бұрын

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...

@Vision-Labs 5 ай бұрын

It really is!!!

@KrisHardy Жыл бұрын

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.

@matthewpitcock7297 Жыл бұрын

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.

@Vision-Labs Жыл бұрын

Wohoo! Glad I (JJ) could solve this for you!!!!! Love hearing stories like this!

@igorlebich5802 Жыл бұрын

No way, this is sick! Thank you!

@ScottDudley 9 ай бұрын

Brilliant, thanks JJ.

@andrizky Жыл бұрын

Thanks sir! U deserved nobel prize..

@GlennSchmelzle 2 жыл бұрын

This is really helpful!

@Vision-Labs 2 жыл бұрын

Glad it helped! Took me a while to figure out exactly how these worked with each other!

@_shranalytics5390 Жыл бұрын

wow - insane! Thank you!

@Vision-Labs Жыл бұрын

haha! Anytime!!!

@madhusudanansrambikkal6190 2 жыл бұрын

Thank you Bro.

@jkemny88 Жыл бұрын

you're the best!

@Vision-Labs Жыл бұрын

Awe thanks Kemny!

@Augusto_SilvaN 2 ай бұрын

Great.

@user-rq1ev9mw5g Жыл бұрын

Thank you SO MUCH!

@Vision-Labs Жыл бұрын

So glad this could help you!!! - JJ

@user-rq1ev9mw5g Жыл бұрын

@@Vision-Labs It makes my life a lot easier. Although filtering this way works well, when I blend data with the new fields, when I click the new "clean" field it doesn't filter the page. Can you not filter from blended data?

@Vision-Labs Жыл бұрын

@@user-rq1ev9mw5g Correct, you can not filter from Blended Data. Blended data used the underlying data field IDs & structures. MEaning if you want to filter the underlying data you need to add a report filter/interaction that filters the underlying data which will flow up to the blended data. Hopefully you got that LOL - JJ

@DJBlethen Жыл бұрын

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 KZfaq channels' views, probably just into a scorecard (using the default KZfaq 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!

@Vision-Labs Жыл бұрын

Unfortunately, there is no way to do that :( You would need to combine them in a different tool, like Google Sheets or Big Query. Best of luck, - JJ

@corporatereports 11 ай бұрын

Mind officially blown!

@Vision-Labs 11 ай бұрын

LOL glad you enjoyed! - JJ

@marcelaramonbarrenechea7202 Жыл бұрын

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

@Vision-Labs Жыл бұрын

Hmmmmmmmmmm. Not 100% sure. If you join the email list, just hit 'reply' & give as much info as you can & ill get you some help :) Usually its a combination of different scopped dimensions which technically don't work together. but could be something else.

@AB-we9dh Жыл бұрын

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!

@Vision-Labs Жыл бұрын

why Wouldn't an outerjoin with a chart filter not work? If you still need a little help, download the cheatsheet & hit reply with your question! It's easier to help out there. LookerStudio.VIP/cheatsheet - JJ

@lucasurzua5408 5 ай бұрын

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!!

@Vision-Labs 5 ай бұрын

Thanks so much! You will need to blend if you are going to have them in the same chart you need to blend -JJ

@lucasurzua5408 5 ай бұрын

@@Vision-LabsTe proble is when i dont blend, the data added in the amount of month. i think that the solution to his problem is write in the "Real" database all the month with a 0 in the quantity. I think this because the amount of data in the table is added every case the amoint of quantity in the real data base is "NULL".

@emrekentel1170 7 ай бұрын

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

@Vision-Labs 7 ай бұрын

Yeah you can only blend once’s. You might be able to get by with just landing page and destination -JJ

@vinitkumar2273 Жыл бұрын

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 ?

@Vision-Labs Жыл бұрын

Hey Vinit! Yeah you would need to blend them. Then you should be fine! -JJ

@janniemuller2016 Жыл бұрын

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?

@Vision-Labs Жыл бұрын

Hey Jannie! If your two fact tables are a cross join you will be out of luck. But If you have FaceActuals 'table 1' (left join) Face Budget 'table 2' Then add your their table as a cross join to the Fact Actuals 'table 1' This might work.... Might, as I am not sure the schema of how those should work together. Best of luck, - JJ

@rakeshreddy3045 Жыл бұрын

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?

@Vision-Labs Жыл бұрын

It will only filter what is on the page at the moment. So yes, that would work! - JJ

@eArminCom Жыл бұрын

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

@Vision-Labs Жыл бұрын

Unfortunately, to reference two fields you will need to blend them -JJ

@eArminCom Жыл бұрын

@@Vision-Labs Thanks! So in this case is there any way to apply a filter to the blended data? Selector loads from Source A, and should filter the blended data on the table.

@Vision-Labs Жыл бұрын

Yes. Just use the unblended data source as the interaction and you should be good to go. -JJ

@Vision-Labs Жыл бұрын

@@eArminCom I do not believe so. It migght work but haven't tested that in a while.

@samsongstudios5918 2 жыл бұрын

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

@Vision-Labs 2 жыл бұрын

Hey! If I understand you correctly, You have information like this? Sheet1 = January Sheet 2 = February etc If there is a Date Field, That should automatically pull them together. But the problem you will run into is that you will need to have a different scorecard or chart for each sheet. In this case a better idea might be to utilize Data Blending. Let me know if that helps or I missed what you were asking. - JJ

@samsongstudios5918 2 жыл бұрын

Thanks fr the response JJ, yes same problem i need to create separate. Is there a way to have a single table. I used master sheet by importing the range,but it gets bulkier and loads slow.

@Vision-Labs 2 жыл бұрын

@@samsongstudios5918 I would suggest one of two options. Option 1: You Blend the Sheets in GDS (only works if you have 5 or less) Option 2: You create one new Tab which appends them all together. to have 1 master Google Sheet. How many rows are you looking at in your sheets?

@samsongstudios5918 2 жыл бұрын

Hi JJ, Option 1 will not work as i need the results in a single table. Option 2 i am already doing and it is almost over 1 lac rows. Which has 3 years data and I want to continue the same dashboard for further years. It helps to have accurate reports year on year basis. Kindly see if i can do something. Even if there is none, i Appreciate ur reply :)

@Vision-Labs 2 жыл бұрын

@@samsongstudios5918 Got it! Ok shucks :( Most likely you will need to get the Data Into Big Query for the most scaleable and robust solution. Not the easiest of solutions, but would solve for your size problem, speed problem and multiple table problem to visualization in GDS. Unfortunately, I do not have any videos or trainings on how to use bigquery... yet :)