Use Data Studio Field IDs to Combine Two Data Sources Without Blending!
Vložit
- čas přidán 5. 09. 2024
- How to use field ID's to fully customize your report interaction without blending.
Read the full article 👉 datastudio.vip...
👇 Grab The Dashboard Cheat Sheet 👇
datastudio.vip...
👇Explain It Data Studio Visualization👇
datastudio.vip...
Learn About What I Am Trying to do
👉 datastudio.vip...
Apply To Work With Us. (Done for you)
mediauthentic....
Learn On Your Own!
datastudio.vip...
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...
It really is!!!
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.
Wohoo! Glad I (JJ) could solve this for you!!!!! Love hearing stories like 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!
Mind officially blown!
LOL glad you enjoyed!
- JJ
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!!
Thanks so much!
You will need to blend if you are going to have them in the same chart you need to blend
-JJ
@@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".
Brilliant, thanks JJ.
you're the best!
Awe thanks Kemny!
This is really helpful!
Glad it helped! Took me a while to figure out exactly how these worked with each other!
Great.
Thank you SO MUCH!
So glad this could help you!!!
- JJ
@@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?
@@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
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 CZcams channels' views, probably just into a scorecard (using the default CZcams 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!
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
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
Yeah you can only blend once’s.
You might be able to get by with just landing page and destination
-JJ
wow - insane! Thank you!
haha! Anytime!!!
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!
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
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
Unfortunately, to reference two fields you will need to blend them
-JJ
@@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.
Yes. Just use the unblended data source as the interaction and you should be good to go.
-JJ
@@eArminCom I do not believe so. It migght work but haven't tested that in a while.
Thank you Bro.
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
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.
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?
It will only filter what is on the page at the moment. So yes, that would work!
- JJ
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 ?
Hey Vinit! Yeah you would need to blend them.
Then you should be fine!
-JJ
Will this work in scorecard as well ?
Absolutely
- JJ
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
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
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.
@@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?
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 :)
@@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 :)
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?
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