Thank you. This is useful video, it helps me a lot
@gaillereports Жыл бұрын
Thank you very much for the comment! It's my pleasure :) :)
@farooqahmeddpi Жыл бұрын
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.
@gaillereports Жыл бұрын
Thank you very much for this nice feedback
@efyland Жыл бұрын
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
@gaillereports Жыл бұрын
Glad you liked it! 😍
@cheguvareche5752 Жыл бұрын
The explanations are awesome and the commentary is gold. Thanks for the video :D
@gaillereports Жыл бұрын
Glad you enjoyed!
@user-jm5lf5uv3h7 ай бұрын
Thank you very helpful! I have one more question, is there a way to mix in rows instead of columns?
@gaillereports7 ай бұрын
Hey, thank you! No, Join works only like that by columns.
@EdoardoResta9 ай бұрын
Thank you very much!
@gaillereports9 ай бұрын
You are welcome!
@AhmedAli-wn5qv Жыл бұрын
Thank you it was helpful
@gaillereports Жыл бұрын
Glad it helped
@rahulmukherjee5199 Жыл бұрын
Very helpful. Thanks. I guess Data studio kind of changed the name from Join Keys to this new system.
@gaillereports Жыл бұрын
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.
@bharathsp55422 ай бұрын
Superb thanks for the good video 👍👍
@gaillereports2 ай бұрын
Thank you very much
@lauren5638 Жыл бұрын
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?
@gaillereports Жыл бұрын
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.
@raushankumar-ry7so Жыл бұрын
@@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.
@semiraldabagh6385 Жыл бұрын
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
@gaillereports Жыл бұрын
Hi Semir, you can select and change field for join - disk.yandex.ru/i/WHHtIAne293DKw
@heronimotasyo9 ай бұрын
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?
@gaillereports8 ай бұрын
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.
@natalirivero4679 ай бұрын
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.
@gaillereports8 ай бұрын
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.
@natalirivero4678 ай бұрын
@@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!
@askelenaaboutrealestate8 ай бұрын
All this arranging of data vertically takes 1/3 of the video LOL. Let it go, girl!
@gaillereports8 ай бұрын
I want to record a new video with the new microphone. It was one of the first I made ever in my life :D
@raushankumar-ry7so Жыл бұрын
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
@gaillereports Жыл бұрын
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!
@joshuamoraga1101 Жыл бұрын
@@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
@user-dg2ut7ox9v6 ай бұрын
@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.
@user-sf7fy8dh6u5 ай бұрын
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
@yousefesfahanian26365 ай бұрын
The numbers are apparently not correct! how did you get the Google Cost for 4. august 86??? it does not make sense
@gaillereports5 ай бұрын
I don't remember already, it was some small issue in the video, that I fixed in the lined report.
@guyoimano Жыл бұрын
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
@gaillereports Жыл бұрын
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.
@user-gx6kv2xg2r Жыл бұрын
Why when I blend data does it only allow me to choose one of the tables for my data in my tables?
@gaillereports Жыл бұрын
Sorry, can't get your question
@piotrzolnowski932010 ай бұрын
no info on connecting 2 different data sources :(
@gaillereports10 ай бұрын
The logic is the same, doesn't matter your data sources
@piotrzolnowski932010 ай бұрын
@@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 :(