![Looker Studio dashboards by Gaille Reports](/img/default-banner.jpg)
- 203
- 427 345
Looker Studio dashboards by Gaille Reports
Portugal
เข้าร่วมเมื่อ 12 ธ.ค. 2011
Let's automate your Marketing and Sales reports!
Want to try our services for free?
Subscribe to the blog on the website and get a FREE Looker Studio template “Google Analytics 4 sales funnel” as a welcome gift - gaillereports.com/bonus-for-subscription/
Google's tools we work with:
- (Google Data Studio) Looker Studio,
- Google Spreadsheets,
- Google BigQuery.
What do we offer:
- Custom Looker Studio reports
- Looker Studio ready-to-use templates in my Gaille Reports store
- Learn Looker Studio with my online course
Data connector services I like to work with:
- Supermetrics - affiliate.supermetrics.com/5836.html
- Power My Analytics - shareasale.com/r.cfm?b=2301940&u=3572277&m=29056&urllink=&afftrack=
- Windsor.ai - www.windsor.ai/?fpr=gaillereports
--------------------------
Looker Studio (Google Data Studio) marketing and sales automated dashboards | Google Sheets | Google BigQuery | Google Analytics | Google Spreadsheets
Want to try our services for free?
Subscribe to the blog on the website and get a FREE Looker Studio template “Google Analytics 4 sales funnel” as a welcome gift - gaillereports.com/bonus-for-subscription/
Google's tools we work with:
- (Google Data Studio) Looker Studio,
- Google Spreadsheets,
- Google BigQuery.
What do we offer:
- Custom Looker Studio reports
- Looker Studio ready-to-use templates in my Gaille Reports store
- Learn Looker Studio with my online course
Data connector services I like to work with:
- Supermetrics - affiliate.supermetrics.com/5836.html
- Power My Analytics - shareasale.com/r.cfm?b=2301940&u=3572277&m=29056&urllink=&afftrack=
- Windsor.ai - www.windsor.ai/?fpr=gaillereports
--------------------------
Looker Studio (Google Data Studio) marketing and sales automated dashboards | Google Sheets | Google BigQuery | Google Analytics | Google Spreadsheets
Google BigQuery date functions tutorial | Looke Studio by Gaille Reports
In this video, I walk you through a simple tutorial on Google BigQuery date functions. If you've ever needed to find specific dates like the first or last day of the current, previous, or next month, this video is for you! I'll show you how to use date_trunc, date_add, date_sub, and last_day functions in BigQuery with easy-to-follow examples.
Here’s what we’ll cover:
Getting the first and last day of the current month
Finding the first and last day of the previous month
Determining the first and last day of the next month
By the end of this tutorial, you'll have a solid understanding of how to manipulate dates in BigQuery, which will be a valuable skill for your data analysis tasks.
If you find this tutorial helpful, don't forget to like, share, and subscribe for more BigQuery tips and tricks!
----------------
Video prepared by Gaille Reports - gaillereports.com/
Free Looker Studio template - gaillereports.com/bonus-for-subscription/
Looker Studio Online Course - gaillereports.com/google-looker-studio-online-course/
Blog about Looker Studio and Google Sheets - gaillereports.com/blog/
Our Telegram group - t.me/gaillereports
Here’s what we’ll cover:
Getting the first and last day of the current month
Finding the first and last day of the previous month
Determining the first and last day of the next month
By the end of this tutorial, you'll have a solid understanding of how to manipulate dates in BigQuery, which will be a valuable skill for your data analysis tasks.
If you find this tutorial helpful, don't forget to like, share, and subscribe for more BigQuery tips and tricks!
----------------
Video prepared by Gaille Reports - gaillereports.com/
Free Looker Studio template - gaillereports.com/bonus-for-subscription/
Looker Studio Online Course - gaillereports.com/google-looker-studio-online-course/
Blog about Looker Studio and Google Sheets - gaillereports.com/blog/
Our Telegram group - t.me/gaillereports
มุมมอง: 46
วีดีโอ
Dimension Control in Looker Studio: Make Your Dashboard Even Fancier | Gaille Reports
มุมมอง 8321 วันที่ผ่านมา
Learn how to make your Looker Studio dashboard even fancier with Dimension Control! In this video, I demonstrate how to add and use Dimension Control, allowing report viewers to change dimensions on charts without editing the report. This feature eliminates the need for multiple charts and reports, simplifying data presentation and analysis. Key topics include: Adding Dimension Control to your ...
Interactive Date Aggregation in Looker Studio: Easy Date Switch! | Looke Studio by Gaille Reports
มุมมอง 12628 วันที่ผ่านมา
Discover the magic of Interactive Date Aggregation in Looker Studio with this easy date switch trick! In this video, I showcase advanced Looker Studio tools like parameters and calculated fields to effortlessly switch between daily, weekly, and monthly reports. This impressive technique not only enhances your reports but also makes the life of report users much easier. Learn how to: Use paramet...
Missing data in Looker Studio: IFNULL and COALESCE | Looke Studio by Gaille Reports
มุมมอง 80หลายเดือนก่อน
Discover how to handle missing data in Looker Studio using the IFNULL and COALESCE functions! In this video, I dive into these powerful functions, showcasing a few scenarios where I use them in practice. The key difference is that IFNULL works with 2 parameters, while COALESCE can handle multiple. Learn how these functions can improve your data analysis and reporting. For more tips and tricks, ...
Google Ads Extended Analytics template overview | Looke Studio by Gaille Reports
มุมมอง 71หลายเดือนก่อน
In this video, I’m excited to share my Looker Studio dashboard for Google Ads! After working with Google Ads for many clients, I created detailed reports in Looker Studio. Based on all that experience, I developed a comprehensive Looker Studio report for Google Ads analytics. Template page in the Gaille Reports store - gaillereports.com/product/google-ads-extended-analytics-report/ This templat...
Automating Marketing for Efficiency - Gala from Gaille Reports in "It's Marketing's Fault"
มุมมอง 872 หลายเดือนก่อน
I am honoured to present you the "It's Marketing's Fault" podcast session I was invited to. For your knowledge "It's Marketing's Fault" is the podcast about successful marketing cases, innovations in marketing and sharing insights with marketers around the world! Eric is an awesome marketer with a rich experience, besides that he is a great host and interlocutor. He made the conversation flow s...
Filters and blended data in Looker Studio. Why do I like Windosor.ai?
มุมมอง 3K3 หลายเดือนก่อน
Use promo code "gaillereports' and get 10% discount for any Windsor.ai plan - www.windsor.ai/?fpr=gaillereports In this video, you will find a detailed guide on using filters and blending data in Looker Studio. This process can be quite challenging, but I'll show you some tips and tricks to make it easier. I'm Gala, a Looker Studio expert and the founder of Gaille Reports, where we help automat...
Blended GA4 and Google Search Console data source in Looker Studio: Expert Tips
มุมมอง 6K3 หลายเดือนก่อน
Hey there! In this video, we will talk about how to join Google Analytics 4 data with Google Search Console in Google Looker Studio (Google Data Studio) First, I'll show you how to create a filter for Google organic sessions and source medium. After adding the filter, we can see users, conversions, sessions, and revenue from Google Search Console, along with impressions, clicks, CTR, and averag...
Master Blended Data in Looker Studio: GA4 & Google Ads Deep Dive!
มุมมอง 7044 หลายเดือนก่อน
In this installment of our video series on Blended Data in Looker Studio, we delve into the process of blending data from Google Analytics 4 (GA4) and Google Ads. Building upon our previous tutorials covering various join types and data sources, this tutorial focuses on integrating two of the most widely used platforms for digital marketing analytics. As marketers, we understand the importance ...
From Data Mess to Success: Find the first day of the week in Looker Studio [DATETIME_TRUNC function]
มุมมอง 1924 หลายเดือนก่อน
From Data Mess to Success: Find the first day of the week in Looker Studio [DATETIME_TRUNC function]
Blending data source based on Google Analytics 4 in Looker Studio | Part 3 | Gaille Reports
มุมมอง 2504 หลายเดือนก่อน
Blending data source based on Google Analytics 4 in Looker Studio | Part 3 | Gaille Reports
Blend Data in Looker Studio 2024 Part 2 | Sales Analysis for SaaS business | Gaille Reports
มุมมอง 1424 หลายเดือนก่อน
Blend Data in Looker Studio 2024 Part 2 | Sales Analysis for SaaS business | Gaille Reports
Blending Data in Looker Studio (Google Data Studio) in 2024 on Google Sheets example
มุมมอง 904 หลายเดือนก่อน
Blending Data in Looker Studio (Google Data Studio) in 2024 on Google Sheets example
Blended Data in Looker Studio: Join Types. The Full Tutorial | 2024 | Looke Studio by Gaille Reports
มุมมอง 9254 หลายเดือนก่อน
Blended Data in Looker Studio: Join Types. The Full Tutorial | 2024 | Looke Studio by Gaille Reports
New and Return customers growth Looker Studio report template overview | Gaille Reports
มุมมอง 1895 หลายเดือนก่อน
New and Return customers growth Looker Studio report template overview | Gaille Reports
Google Search Console bulk data export to Google BigQuery | Looke Studio by Gaille Reports
มุมมอง 4395 หลายเดือนก่อน
Google Search Console bulk data export to Google BigQuery | Looke Studio by Gaille Reports
How to use XLOOKUP in Google Sheets and comparison with VLOOKUP | Looke Studio by Gaille Reports
มุมมอง 1275 หลายเดือนก่อน
How to use XLOOKUP in Google Sheets and comparison with VLOOKUP | Looke Studio by Gaille Reports
How to use Google Sheets IMPORTRANGE function? | Looke Studio by Gaille Reports
มุมมอง 7365 หลายเดือนก่อน
How to use Google Sheets IMPORTRANGE function? | Looke Studio by Gaille Reports
Looker Studio template for Advertising Agencies: Plan & Fact spending trajectory for paid ads
มุมมอง 6106 หลายเดือนก่อน
Looker Studio template for Advertising Agencies: Plan & Fact spending trajectory for paid ads
3 levels of filters in Looker Studio: report, page, chart filters | Looke Studio by Gaille Reports
มุมมอง 1.4K6 หลายเดือนก่อน
3 levels of filters in Looker Studio: report, page, chart filters | Looke Studio by Gaille Reports
Cohort Analysis in Looker Studio and Google Sheets Template Overview. LTV and Customer Retention
มุมมอง 2.5K6 หลายเดือนก่อน
Cohort Analysis in Looker Studio and Google Sheets Template Overview. LTV and Customer Retention
Collect Shopify data in Google Sheets with Supermetrics connector | Looke Studio by Gaille Reports
มุมมอง 4686 หลายเดือนก่อน
Collect Shopify data in Google Sheets with Supermetrics connector | Looke Studio by Gaille Reports
Paid Ads Looker Studio template based on Windsor.ai connector
มุมมอง 1.2K7 หลายเดือนก่อน
Paid Ads Looker Studio template based on Windsor.ai connector
How to install Windsor.ai add-on to Google Sheets? | Looke Studio by Gaille Reports
มุมมอง 1.6K7 หลายเดือนก่อน
How to install Windsor.ai add-on to Google Sheets? | Looke Studio by Gaille Reports
How to install Supermetrics add-on to Google Sheets? | Looke Studio by Gaille Reports
มุมมอง 2.1K7 หลายเดือนก่อน
How to install Supermetrics add-on to Google Sheets? | Looke Studio by Gaille Reports
How to do analysis for individual blogs and content websites? Looker Studio Template.
มุมมอง 8239 หลายเดือนก่อน
How to do analysis for individual blogs and content websites? Looker Studio Template.
Two date range controls in Looker Studio on one page. How to deal with that?
มุมมอง 5K10 หลายเดือนก่อน
Two date range controls in Looker Studio on one page. How to deal with that?
RFM analysis in Google Sheets and Looker Studio - dashboard template overview
มุมมอง 2.3K10 หลายเดือนก่อน
RFM analysis in Google Sheets and Looker Studio - dashboard template overview
How to tag someone in Google Sheets? | Looke Studio and Google Sheets by Gaille Reports
มุมมอง 30610 หลายเดือนก่อน
How to tag someone in Google Sheets? | Looke Studio and Google Sheets by Gaille Reports
Looker Studio Customer Chum Analysis Template for SaaS and E-commerce
มุมมอง 1K10 หลายเดือนก่อน
Looker Studio Customer Chum Analysis Template for SaaS and E-commerce
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.
Wow! Thank you very much!
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?"
Thank you for your comments! Not for 100%. Syntacsys and a number of supporting formulas are different in BQ and LS. I always check support articles for that. For example - support.google.com/looker-studio/topic/7583292?sjid=1691447405445381925-EU
все получилось, но я хочу теперь на объединенном листе отсортировать по дате все строки БЕЗ разбивки по листам, чтобы данные шли по хронологии вперемешку со всех листов
Я бы для этого использовала новую вкладку и функцию sort, и вкладку с общими данными со всех листов как источник данных.
How to i contact you
You can use marketing@gaillereports.com
: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?
Thank you for your comment! Conditional formatting works when you close the tab. Did you click to save the rule when you create it? On the bottom of the conditional formatting panel.
❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
🙏
very useful!
Thank you very much!
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
Hmm… i recommend you to check event names, 100% the reason is there.
It is what I need, thanks a lot.
Yeaaah! Thank you very much for the comment! It’s a pleasure 🫶
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)
Hi Oscar, 1) for sorting you can add numbers or letters to your steps, like in my example: 1 Session start, 2 View Item, etc. Also, check the field sorting, it's below dimensions and metric. 2) Looker Studio just shows what do you have in your GA4 account. So, I recommend you to check event tracking there. 3) I made video about it - th-cam.com/video/WDhS3plxtmw/w-d-xo.htmlsi=5CJR3BmMkb811g1I you can check it
This is GA4, For GSC its not possible i think
It works for date fields for any data source.
Can you please share the google sheet for practice?
Thank you for your interest, but I sell this template for Looker Studio and don’t share it.
So helpful, thank you!
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?
Sure! You can do +/- several days in the formula. Try to add +1 for example
Спасибо за уроки) Особенно ценно, то что вы показываете как работают функции на данных из рекламных кабинетов и CRM))
Спасибо большое за такой приятный отзыв!
This is not working for me. Even after grouping, the main date control is influencing the second grouped date control
I can suggest just check grouping. One date control should be grouped with part of charts. And the second one with another. And they can’t be mixed.
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)
sorry, I didn't answer, because I don't know what to answer to be honest.
Thank you for a great formula! Very helpful :) (could you turn up a bit the sound of your voice?)
Thank you for your comment! Yeah, I know about the voice 😬 last videos are good already
Thanks for joining me Gala! I learned so much from what you shared!
I'm so glad! Thank you Eric!
Thanks for the tutorial. Learnt how to clean up my Data from your video.
You're welcome! So nice to hear that it was usefull!
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?
Thank you! I did video, TH-cam doesn't think that it should be popular :D But I have another opinion. Here is the link - th-cam.com/video/NVw3vc6JXk0/w-d-xo.htmlsi=NynAj8rzd5sw22th
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:)
Thank you for your comment! Any connector can take data from API. And depend on the connector services fields could be different. What do you mean custom columns in Google Ads? You can see how this metric calls in the webinterface and check it in the support document to connector. Sometimes it could have different names.
Hi, Thanks for creating this video. Can i make a copy and play around with your template?
Thank you! I sell my templates on my online store - gaillereports.com/product/plan-and-fact-spending-trajectory-template-for-paid-ads-traffic-sources/
Superb thanks for the good video 👍👍
Thank you very much
I want to make calendar widget on google looker. Is it possible?
Hey, there is a date range control field. Do you mean this or something different?
Благодарю, как раз нужна была такая формула
Очень приятно, что вам было полезно 🙏
This video was super useful, thank you!
Thank you for your comment!
thank you soo much for that
You're welcome! :)
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?
It is not clear what is good and what is bad, actually. I'm not sure that it is possible that you asking for.
Where are you getting the data for to put in your spreadsheet? Thanks
For videos? I just generate random datasets :)
awesome!🎉
Thanks! 😄
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
it could be related to "null" values for some of your fields. You can try to use the IFNULL() function to change null to 0. Try it.
nice sharing , unfortunately your video not full screen, the left part of the video is cut off
This is so embarrassing 😳 I think, when i finished it i was tired. Will post it again soon. Thank you!
Buenisimo, muy claro todo, gracias por compartir!
I don’t speak Spanish but i understood that you like my video 😀 thank you! I do speak English, Portuguese, and Russian
You have 1 like so I did it 2 😊go-ahead I'm with you I'll support you 😊
Thank you! So nice from you 😍
Thank you, Finally got the solution.
Thank you very much for this comment!
Super cool! Diving more into Google Data Studio because Airtable's Interfaces are quite limited when it comes to charts
Happy it's usefull! And thank you for the comment!
Thank you for sharing your Ideas. Especially your "Event Count"+"Name Filter" method (you showed in another video) is very helpfull. Best Philippe
Glad it was helpful! Yeah, it's a great trick :)
Добрый день. так можно выгружать более 1000 строк? есть какой-то лимит по выгрузке по количеству строк?
да нет, у Google сквозная интеграция между сервисами. Ограничения: у вас не будет исторических данных в BQ, данные начнут загружаться только с дня настройки интеграции.
Актуально для сеошников, в самом GSC нельзя выгрузить более 1000 строк в отчётах, тут получается можно обойти это ограничение
А, я никогда напрямую не выгружала больше 1000 строк из GSC напрямую. Но в BQ у меня больше. Только данные в веб интерфейсе и через API не много в разных форматах. Настройте себе выгрузку и посмотрите, там чуть другие таблицы.
Hi why the numbers are not the same in the funnel and in the data above
true, there is some discrepancy because of blended data and aggregations of users in GA4. If you use raw data or some SQL database, Google Sheets tables it will be fine.
Спасибо! Как же круто! И ничего лишнего, всё по делу!
Спасибо большое! Очень приятно, что оказалось полезно
Thank you!
You're welcome!
Hi Gala, nice work. Can you please tell me why view item is more than session start. Thanks
Hi, thank you. Session start event is one per session. During one session user can view several items several times. So, it is normal to have more view items events than session start events.
Hi Gala, @@gaillereports That's totally understandable, but when it comes to explore or report section in GA4, there the session is way higher that product view. Could you please explain this. Thanks
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.
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?
sure, you can send them invite one more time.
@@gaillereports Can you guide, how that can be done?
Thanks for the awesome video! Good Solution to row level security for different logged in users of looker studio.
Thank you for your comment! It’s a great option, right? Totally agree with you
@@gaillereports yes a great option indeed. Actually I was struggling to have RLS using bigquery I couldn't think that we could get it this way in Looker.
Спасибо вам большое за ваш труд. Очень доходчиво!) На русском youtube мало информации по этому сервису
Спасибо большое за комментарий!