วีดีโอ

nice

Hello, and thank you for your effort, it just helped me the best way better than my own teacher at the moment, please keep up the good work.

Hello, your video is very instructive, congratulations! Is it possible to apply this BigQuery date concept using the NATIVE_DIMENSION function in Looker Studio? For example, calculating business days between two dates?"

все получилось, но я хочу теперь на объединенном листе отсортировать по дате все строки БЕЗ разбивки по листам, чтобы данные шли по хронологии вперемешку со всех листов

How to i contact you

:D

I tried this, but it gets messed up if I close the tabs. Is there a way I can perform this task and still make it look visually pleasing when I closing them?

❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

very useful!

Hello Gaille, Thanks for the dashboard, When I use this same logic for calculating add to cart and Checkouts, My checkout is always higher than add to cart in looker studio. But my GA4 purchase funnel reports says otherwise. Is there any fix for this issue ? Can you please help. @gaillereports

It is what I need, thanks a lot.

At minute 7:21, you show a table with sales funnel. I have a problem with sorting my event names. Currently, "View Item" appears in column 1 and "Session Start" in column 2 because there are more "View Item" events than "Session Start" events. How can I change the sorting so that "Session Start" always appears first in column 1? ------- At minute 6:27, you can see a sales funnel, and on the far right, there is a KPI list. As I interpret it, it shows that 74% of the sessions proceed to view a product. How can one easily calculate this? I mean, I get the same result as you on the KPI list on the left side, where we see that 136% of the visitors view a product (based on the number of events). This means that a smaller number of visitors can account for the majority of the clicks. How would you go about calculating a KPI list like the one on the right side? -------- At minute 8:54, we can see the "optional matrics" you show later in the dropdown ("Events" and "% of Total". How do you calulate % of Total)

This is GA4, For GSC its not possible i think

Can you please share the google sheet for practice?

So helpful, thank you!

Gallie, спасибо! Благодаря вашим урокам, получилось настроить совмещение данных (join). Соединяю 2-е таблицы: 1) Данные из Facebook Ads, 2) Данные по сделкам и продажам.))) Столкнулся со следующей ситуацией: Когда создаю Join, после добавления параметров , , помимо дат (Day, Date). Меткрика Amount spend (расходы Facebook Ads) начинают сами автоматически приумножаться и это мешает посчитать цену лида, продажи. Может подскажите, как решаются подобные проблемы, когда из-за параметров начинаются меняться данные в метриках?) Параметры по типу , помогают мне делать фильтры и разбивки))

Can you rebase to Wednesday or Thursday as the start date?

Спасибо за уроки) Особенно ценно, то что вы показываете как работают функции на данных из рекламных кабинетов и CRM))

This is not working for me. Even after grouping, the main date control is influencing the second grouped date control

Hi thanks for explaining the difference. How I sum specific columns in Google Looker? I have five columns that has 5 different certification but I only want to get a sum of 2 columns that has FSC certificate. I attempted the expression below. if(contains(${vw_v_ticket_cert.certification_type}, "FSC"), sum(pivot_row(${vw_v_ticket_cert.nett_total})), null)

Thank you for a great formula! Very helpful :) (could you turn up a bit the sound of your voice?)

Thanks for joining me Gala! I learned so much from what you shared!

Thanks for the tutorial. Learnt how to clean up my Data from your video.

Awesome! I wanted to know about filtering Organic Search data. By any chance do you have a demonstration of comparing Organic Search vs other default session channnels in GA 4?

Hi Gaille, I am very grateful because from your video I can learn to use Looker Studio! There is one question I want to ask, is it possible in Looker Studio to create certain metrics that are taken based on custom columns in Google Ads? Thank you:)

Hi, Thanks for creating this video. Can i make a copy and play around with your template?

Superb thanks for the good video 👍👍

I want to make calendar widget on google looker. Is it possible?

Благодарю, как раз нужна была такая формула

This video was super useful, thank you!

thank you soo much for that

How to filter column in the table? Example, I have 3 column (A, B, C) and when I click Good on Pie Chart, it will shown 2 column (A and B) but when I click Bad on Pie Chart, it only show 1 column?

Where are you getting the data for to put in your spreadsheet? Thanks

awesome!🎉

Hello Gala! Thanks for this super practical tutorial. When I try to put the ratios between the different events like those you created on the left of the tunnel it shows me "no data". When I try to modify the formula and divide by a number directly, it works! Is this an error on Looker studio? THANKS

nice sharing , unfortunately your video not full screen, the left part of the video is cut off

Buenisimo, muy claro todo, gracias por compartir!

You have 1 like so I did it 2 😊go-ahead I'm with you I'll support you 😊

Thank you, Finally got the solution.

Super cool! Diving more into Google Data Studio because Airtable's Interfaces are quite limited when it comes to charts

Thank you for sharing your Ideas. Especially your "Event Count"+"Name Filter" method (you showed in another video) is very helpfull. Best Philippe

Добрый день. так можно выгружать более 1000 строк? есть какой-то лимит по выгрузке по количеству строк?

Hi why the numbers are not the same in the funnel and in the data above

Спасибо! Как же круто! И ничего лишнего, всё по делу!

Thank you!

Hi Gala, nice work. Can you please tell me why view item is more than session start. Thanks

The numbers are apparently not correct! how did you get the Google Cost for 4. august 86??? it does not make sense

Let's say if few of the users accidentally deny the consent, resulting into no data on the dashboard. Is it possible to send the consent again so that they can view the relevant data in the dashboard?

Thanks for the awesome video! Good Solution to row level security for different logged in users of looker studio.

Спасибо вам большое за ваш труд. Очень доходчиво!) На русском youtube мало информации по этому сервису