Thank you for the nice explanation. I totally got the point. There are a lot of tutorial videos but most of them didn't talk about it. I subscribed and liked
Thank you for your comment! As I remember GDS always called this tool "Blends" and not Joins as in SQL. Or do you mean, that they added the option to change from left to right, etc. joins? They added this in 2022, several months ago.
Hello, great explanation, thank you. What would you do if you have two tables but the index field are named differently (imagine that two given fields for date are Data and Datum, so Studio says missing (obviously "data" on left is not on the right table) thanks
Hi Galina, thank you for this video! The issue I'm having is pulling data from Google Ads and Facebook ads via Supermetrics (and NOT blending data from Google Sheets). Is it possible to blend to figure out total cost without Google sheets?
hi, theoretically yes, but in fact Fb and Google have different field names and it is not so obvious as in Google Sheets. For me use Google Sheets or BigQuery much clear than merge data in GDS directly.
@@gaillereports means if we want to blend facebook ad and google ad data then have to do in bigquery or google sheet only . we cannot blend data directly in GDS.
It was helpful, but it is a little too obvious when you work with sheets, what I found to be tough is attempting to do advanced data modeling from the standard GA4 connector, for things like turning metrics into dimensions to be able to use them together on custom fields to make formulas. For instance, by blending data I was able to make a formula to count 2 different (but related) events together, but when I wanted to also filter by page location (inside the calculated field, not by using a filter) It didn't work, I tried blending the data in diff ways but I am new to this stuff.
This is related how to Google storage their data. Not all of combinations of metrics and dimensions work together. Probably, your case is impossible to solve. To check it I use API documentations. This video is about logic of joins. Great that you can match 2 different events together.
@@gaillereports yeah maybe it has to do with Scopes, on a diff video I learned a little about them, so we have "user", "event" and "item" scopes (if I remember well), but I think we should be able to mix them with joints. If not, since all I want is to filter my events, I also learned about custom dimensions, that would do it for me, if only I could get the previous data instead of starting blank, that'd be great, but that's not how GA4 works. Thanks for your comments, I'd like to know more of your thoughts!
I am currently creating a Keyword Comparison table vs our competitors, data is from SemRush but cant merge all keywords in one column. Is there a way to do that?
Hi, sorry for the delay. You have 2 Keywords fields, right? So, in the table where you want to see all keywords in the same column, create a calculation field with IFNULL() formula.
Hi Gala, Thanks for such amazing tutorial, however I wanted to ask if its possible to do "Union all" . for example I have sales report every monday, since spreadsheet can not hold more than some specific rows , I will hve different google sheet every week on monday, all have identical column name, I am wondering if its possible to join the data every week such that column names are maintained but data is stacked down under the previous one
Total google cost and Total facebook cost number is not showing correct after blend . on 6th August total google cost should be 45 but after blending it showing total google cost on 6th August is 90. why getting different figure after blend. Plz check and guide. I have tested that when i add single dimension as date then figure is showing correct but when i add campaign dimension also with date dimension at the time of blending then the figure is showing incorrect. Why this happening? Thanks & Regard Raushan Kumar , India
Hi, thank you for your question. If you check the example dashboard, I fixed it several months ago and it shows correct numbers. For 2 dimensions I added the second page to the report - lookerstudio.google.com/reporting/6c074bf2-6511-4e70-957c-e87f41f4cea2/page/p_1jmez59r4c because got several times questions about it. You can find an answer there ;) Good luck!
@@gaillereports hi gaille I have checked your report however I am not able to extract how you corrected these numbers. I don't quite understand how the formula in the "Bonus" page was used to correct, let's say, the Google Cost of 45 for August 6th. Hoping some clarification on this especially on how you corrected those visuals in the "Data blending" page. Appreciate your response, thanks
@gaillereports What did you do to fix the numbers? I checked out the link you posted, but it seems the joing config is the same. The difference that I see is that the Google Ads table has the dates aggregated on a single line.
Not able to understand why i am getting wrong number after data blending, i am trying to solve this issue since last two days but not solved yet, please help
@@gaillereports I understand the logic, but certain cases are different. I'm currently struggling with blending GA4 with Google Ads. I want to use time series chart for 1 metrics from GA4 and other from Google Ads and I fail to do so :(
Thank you very helpful! I have one more question, is there a way to mix in rows instead of columns?
Hey, thank you!
No, Join works only like that by columns.
So beautifully explained. This was my first attempt to learn blending and i feel i am comfortable now. thanks a lot for this video module, sister.
Thank you very much for this nice feedback
The explanations are awesome and the commentary is gold. Thanks for the video :D
Glad you enjoyed!
Thank you for the nice explanation. I totally got the point. There are a lot of tutorial videos but most of them didn't talk about it. I subscribed and liked
Glad you liked it! 😍
Thank you. This is useful video, it helps me a lot
Thank you very much for the comment! It's my pleasure :) :)
Thank you very much!
My pleasure
Very helpful. Thanks. I guess Data studio kind of changed the name from Join Keys to this new system.
Thank you for your comment! As I remember GDS always called this tool "Blends" and not Joins as in SQL. Or do you mean, that they added the option to change from left to right, etc. joins? They added this in 2022, several months ago.
Superb thanks for the good video 👍👍
Thank you very much
Thank you very much!
You are welcome!
Thank you it was helpful
Glad it helped
Hello, great explanation, thank you. What would you do if you have two tables but the index field are named differently (imagine that two given fields for date are Data and Datum, so Studio says missing (obviously "data" on left is not on the right table) thanks
Hi Semir,
you can select and change field for join - disk.yandex.ru/i/WHHtIAne293DKw
Hi Galina, thank you for this video! The issue I'm having is pulling data from Google Ads and Facebook ads via Supermetrics (and NOT blending data from Google Sheets). Is it possible to blend to figure out total cost without Google sheets?
hi, theoretically yes, but in fact Fb and Google have different field names and it is not so obvious as in Google Sheets. For me use Google Sheets or BigQuery much clear than merge data in GDS directly.
@@gaillereports means if we want to blend facebook ad and google ad data then have to do in bigquery or google sheet only . we cannot blend data directly in GDS.
It was helpful, but it is a little too obvious when you work with sheets, what I found to be tough is attempting to do advanced data modeling from the standard GA4 connector, for things like turning metrics into dimensions to be able to use them together on custom fields to make formulas.
For instance, by blending data I was able to make a formula to count 2 different (but related) events together, but when I wanted to also filter by page location (inside the calculated field, not by using a filter) It didn't work, I tried blending the data in diff ways but I am new to this stuff.
This is related how to Google storage their data. Not all of combinations of metrics and dimensions work together. Probably, your case is impossible to solve. To check it I use API documentations.
This video is about logic of joins.
Great that you can match 2 different events together.
@@gaillereports yeah maybe it has to do with Scopes, on a diff video I learned a little about them, so we have "user", "event" and "item" scopes (if I remember well), but I think we should be able to mix them with joints. If not, since all I want is to filter my events, I also learned about custom dimensions, that would do it for me, if only I could get the previous data instead of starting blank, that'd be great, but that's not how GA4 works. Thanks for your comments, I'd like to know more of your thoughts!
I am currently creating a Keyword Comparison table vs our competitors, data is from SemRush but cant merge all keywords in one column. Is there a way to do that?
Hi, sorry for the delay.
You have 2 Keywords fields, right? So, in the table where you want to see all keywords in the same column, create a calculation field with IFNULL() formula.
Hi Gala, Thanks for such amazing tutorial, however I wanted to ask if its possible to do "Union all" . for example I have sales report every monday, since spreadsheet can not hold more than some specific rows , I will hve different google sheet every week on monday, all have identical column name, I am wondering if its possible to join the data every week such that column names are maintained but data is stacked down under the previous one
Hi Guio, thank you for your comment, but I recommend you to use Google Big Query for this needs. Looker Studio can't do what you want.
Total google cost and Total facebook cost number is not showing correct after blend . on 6th August total google cost should be 45 but after blending it showing total google cost on 6th August is 90. why getting different figure after blend. Plz check and guide.
I have tested that when i add single dimension as date then figure is showing correct but when i add campaign dimension also with date dimension at the time of blending then the figure is showing incorrect. Why this happening?
Thanks & Regard
Raushan Kumar , India
Hi, thank you for your question.
If you check the example dashboard, I fixed it several months ago and it shows correct numbers.
For 2 dimensions I added the second page to the report - lookerstudio.google.com/reporting/6c074bf2-6511-4e70-957c-e87f41f4cea2/page/p_1jmez59r4c
because got several times questions about it. You can find an answer there ;)
Good luck!
@@gaillereports hi gaille I have checked your report however I am not able to extract how you corrected these numbers. I don't quite understand how the formula in the "Bonus" page was used to correct, let's say, the Google Cost of 45 for August 6th. Hoping some clarification on this especially on how you corrected those visuals in the "Data blending" page. Appreciate your response, thanks
@gaillereports What did you do to fix the numbers? I checked out the link you posted, but it seems the joing config is the same. The difference that I see is that the Google Ads table has the dates aggregated on a single line.
Not able to understand why i am getting wrong number after data blending, i am trying to solve this issue since last two days but not solved yet, please help
Why when I blend data does it only allow me to choose one of the tables for my data in my tables?
Sorry, can't get your question
The numbers are apparently not correct! how did you get the Google Cost for 4. august 86??? it does not make sense
I don't remember already, it was some small issue in the video, that I fixed in the lined report.
All this arranging of data vertically takes 1/3 of the video LOL. Let it go, girl!
I want to record a new video with the new microphone. It was one of the first I made ever in my life :D
no info on connecting 2 different data sources :(
The logic is the same, doesn't matter your data sources
@@gaillereports I understand the logic, but certain cases are different. I'm currently struggling with blending GA4 with Google Ads. I want to use time series chart for 1 metrics from GA4 and other from Google Ads and I fail to do so :(