Data Blending in Looker Studio in 2022/2023

No video

Data Blending in Looker Studio in 2022/2023 | Full tutorial on example

Рет қаралды 22,482

Looker Studio dashboards by Gaille Reports

Күн бұрын

Пікірлер: 44

@hathanh1084 Жыл бұрын

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-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 9 ай бұрын

Thank you very much!

@gaillereports 9 ай бұрын

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.

@bharathsp5542 2 ай бұрын

Superb thanks for the good video 👍👍

@gaillereports 2 ай бұрын

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

@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 8 ай бұрын

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.

@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 8 ай бұрын

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 8 ай бұрын

@@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 8 ай бұрын

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

@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 6 ай бұрын

@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 5 ай бұрын

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

@yousefesfahanian2636 5 ай бұрын

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.

@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

@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 :(