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
@hathanh1084
Жыл бұрын
Thank you. This is useful video, it helps me a lot
@gaillereports
Жыл бұрын
Thank you very much for the comment! It's my pleasure :) :)
@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!
@bharathsp5542
3 ай бұрын
Superb thanks for the good video 👍👍
@gaillereports
3 ай бұрын
Thank you very much
@user-jm5lf5uv3h
7 ай бұрын
Thank you very helpful! I have one more question, is there a way to mix in rows instead of columns?
@gaillereports
7 ай бұрын
Hey, thank you! No, Join works only like that by columns.
@EdoardoResta
10 ай бұрын
Thank you very much!
@gaillereports
9 ай бұрын
You are welcome!
@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.
@AhmedAli-wn5qv
Жыл бұрын
Thank you it was helpful
@gaillereports
Жыл бұрын
Glad it helped
@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-dg2ut7ox9v
7 ай бұрын
@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-sf7fy8dh6u
6 ай бұрын
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
@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.
@heronimotasyo
9 ай бұрын
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?
@gaillereports
9 ай бұрын
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.
@yousefesfahanian2636
6 ай бұрын
The numbers are apparently not correct! how did you get the Google Cost for 4. august 86??? it does not make sense
@gaillereports
5 ай бұрын
I don't remember already, it was some small issue in the video, that I fixed in the lined report.
@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
@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
@natalirivero467
9 ай бұрын
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.
@gaillereports
9 ай бұрын
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.
@natalirivero467
9 ай бұрын
@@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!
@askelenaaboutrealestate
9 ай бұрын
All this arranging of data vertically takes 1/3 of the video LOL. Let it go, girl!
@gaillereports
8 ай бұрын
I want to record a new video with the new microphone. It was one of the first I made ever in my life :D
@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.
@piotrzolnowski9320
10 ай бұрын
no info on connecting 2 different data sources :(
@gaillereports
10 ай бұрын
The logic is the same, doesn't matter your data sources
@piotrzolnowski9320
10 ай бұрын
@@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 :(
Пікірлер: 44