- 205
- 519 774
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 Sheets Logic Functions: Full Overview (IF, IFS, AND, OR Explained) | Gaille Reports
Master the power of Google Sheets logic functions in this comprehensive tutorial! 🚀 Whether you're a beginner or an experienced user, this video breaks down the essential logic functions in Google Sheets, including:
IF: Make decisions with single-condition logic.
IFS: Work with multiple conditions seamlessly.
AND: Combine multiple criteria to refine your results.
OR: Provide flexibility with alternative conditions.
📊 With real-life examples and step-by-step explanations, you'll learn how to use these powerful tools to analyze and automate your spreadsheets effectively.
What You'll Learn in This Video:
✅ The syntax and practical applications of IF, IFS, AND, and OR.
✅ How to troubleshoot common errors with logic functions.
✅ Pro tips for combining logic functions for advanced calculations.
✅ Practical use cases for finance, data analysis, and project management.
This tutorial is perfect for anyone looking to streamline their work with Google Sheets, whether you're a student, professional, or small business owner.
----------------
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
IF: Make decisions with single-condition logic.
IFS: Work with multiple conditions seamlessly.
AND: Combine multiple criteria to refine your results.
OR: Provide flexibility with alternative conditions.
📊 With real-life examples and step-by-step explanations, you'll learn how to use these powerful tools to analyze and automate your spreadsheets effectively.
What You'll Learn in This Video:
✅ The syntax and practical applications of IF, IFS, AND, and OR.
✅ How to troubleshoot common errors with logic functions.
✅ Pro tips for combining logic functions for advanced calculations.
✅ Practical use cases for finance, data analysis, and project management.
This tutorial is perfect for anyone looking to streamline their work with Google Sheets, whether you're a student, professional, or small business owner.
----------------
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
มุมมอง: 245
วีดีโอ
Pinterest Analytics Looker Studio Template using Windsor.ai connector
มุมมอง 800หลายเดือนก่อน
Today, we’ll explore an essential tool for anyone managing Pinterest or Pinterest Ads: the Looker Studio Pinterest Template. This dashboard template is designed to make your Pinterest analytics seamless and actionable. You can find it in our online store here: Looker Studio Pinterest Analytics Template - gaillereports.com/product/pinterest-analytics-using-windsor-ai-connector/. If you’re active...
Google BigQuery date functions tutorial | Looke Studio by Gaille Reports
มุมมอง 2.4K4 หลายเดือนก่อน
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 ...
Dimension Control in Looker Studio: Make Your Dashboard Even Fancier | Gaille Reports
มุมมอง 2.3K4 หลายเดือนก่อน
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
มุมมอง 2.3K5 หลายเดือนก่อน
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
มุมมอง 3.2K5 หลายเดือนก่อน
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
มุมมอง 3.6K5 หลายเดือนก่อน
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"
มุมมอง 2207 หลายเดือนก่อน
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?
มุมมอง 3.2K7 หลายเดือนก่อน
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
มุมมอง 6K8 หลายเดือนก่อน
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!
มุมมอง 1.4K8 หลายเดือนก่อน
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]
มุมมอง 24K8 หลายเดือนก่อน
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
มุมมอง 6898 หลายเดือนก่อน
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
มุมมอง 2128 หลายเดือนก่อน
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
มุมมอง 1628 หลายเดือนก่อน
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
มุมมอง 1.4K9 หลายเดือนก่อน
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
มุมมอง 2659 หลายเดือนก่อน
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
มุมมอง 7619 หลายเดือนก่อน
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
มุมมอง 1789 หลายเดือนก่อน
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
มุมมอง 7839 หลายเดือนก่อน
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
มุมมอง 70910 หลายเดือนก่อน
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.9K10 หลายเดือนก่อน
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.8K10 หลายเดือนก่อน
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
มุมมอง 54210 หลายเดือนก่อน
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.2K11 หลายเดือนก่อน
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.7K11 หลายเดือนก่อน
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.1K11 หลายเดือนก่อน
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.
มุมมอง 940ปีที่แล้ว
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?
มุมมอง 7Kปีที่แล้ว
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.5Kปีที่แล้ว
RFM analysis in Google Sheets and Looker Studio - dashboard template overview
Thank you! I was facing sorting issue (sorting by Quarter) in bar chart which resolved by watching your video. Keep it up! (My data source was blended table)
So nice to hear! Thank you!
Hello Mis, Thnks For sharing I have trouble with my data, the value is "DRA25000000162" but looker show as "null", i tried to edit type data in "Resource menu" as "Text" but nothing change. can you help me with this? Thank You
Sometimes, there is a bug and you just can reconnect the data source. But you are right, more probably the issue with the data format
thanks for your lessons !
Happy you liked it
6th var not working
You still have other options to use 😀
correct, I use variation 5 to custom the months name and works, thanks
GPT send me this video when I ask it about blending. Great video.
Wow! This is funny fact 😀
Hi Gaille - I am brand new at Google Studio and just came across your great channel! Have you ever embedded your dashboards into an existing web app? If so, how did you handle your data refreshing?
Hi, you can click to File -> Embed Report and copy link from the pop-up. Data will be updated on your website when it updates in Looker Studio. About Apps specifically I can't advice
how do you order ISO Weeks correctly when you have dates across 2 years 2024 and 2025 so the order is WK50 - WK51 - WK52 - WK01-WK02 in that order on a graph
It’s a good question, I create some supporting fields, that I use for sorting where use CONCAT() formula to join with years, in your case. You can use custom formulas for sorting
Suppose I want to have same control fields selection in different pages . How to do it? Please help I am struggling since many days
This is an easy one! Just click right mouse button and move object from page to report level
Hi, I love this However, when I use this, my x-axis does not adapt based on the element chosen in the dropdown. This gives weird graphs How do I prevent this ??
It should work. Maybe you miss some little step, have different names, maybe have some issues with formulas, or data format. Debugging is a big part of the analytics work, this is true. Could be annoying, I know
❤❤
🥰
I wish this wasn't necessary and Looker Studio would just add a UNION function. But thank you!!!
There are some limitations, yeah
Thanks for sharing
😇
What if I want the week to start from Friday instead of starting from Sunday or Monday?
you can use DATETIME_ADD function - support.google.com/looker-studio/answer/9698326?hl=en&sjid=14096372938909852446-EU
fuck
that's not actually guide, she just want to sell her services
It's a complex report that is not possible to explain in 60 sec. I have long video with more details.
just showcase, fucking usefulless
Awesome. This is more direct than most videos I've watched on this subject. But I have a question though, is this different from when one wants to perform Row-Level Security on the data?
Thank you very much for your comment! To be honest, emails filtration for me looks much easier than Row-Level Security. This is a Google Support article about it - developers.google.com/looker-studio/connector/embed-row-level-security I believe that for 80-90% of cases email filters are more than enough.
Thank you Gaille! This exactly matched all my needs with converting a list of values with dates! Amazing!
Thank you so much for your kind words! I'm thrilled that you found the video so useful for your needs!
Thank you for the great video. One question: Can we use it on a pivot table?
Yes you can! Try it with your data :)
E hoje estou aqui de passagem 3 da madrugada...20/10/24
Is it possible to connect Bigquery +Search Console + Sheets For Marketers Google Sheet & fetch all the search console data in the Sheet connected to search console ? Pls reply 🙏🙏
You can import Search Console data to BigQuery, and connect Google Sheets to BigQuery and make all caclulations there. It it helps
Thank you very much!
My pleasure
IT IS VERY GOOD
thank you Amir
This is the best tutorial I've found online on this type of conditional formatting. Accurate, concise, and clear. Thank you!
Wow, thanks!
Very useful! Thank you so much!
Glad it was helpful!
This is amazing your analise in Looker Studio! Thank you!
Glad you enjoyed it!
Amazing, thank you!
Thank you too!
Добрый день а как решить такую проблемму: в таблице столбик со значениями имеет целые числа и с запятой в looker studio делаю исчисляемое поле по суме этого столбика на почему то суммирует только целые числа(без запитой)
это странный случай, такого быть не должно. Надо проверять формат данных в источнике данных и в looker studio
много воды
это одно из первых видео, ладно уж)
where is the free dashboard? there is no free one
I have a free Looker Studio template that you receive after subscribing to the newsletter
Love u
:)
gracias!!
Why do i got invalid configuration message when creating a table with with Dimention:"page title" and metric:"organic impression on google search", "organic click from google search", the combination just fine on my google analytic. As already connect search console to my analytic do i need to blend Google analytic and google search console on looker? i just started using this and really doesn't know my way around onlooker.
what you see in the web interface and what is available via API is not always the same. You should connect separate Google Search Console data sources, and GA4 and blend data in Looker Studio.
@@gaillereports thanks a lot i will try to blend dât in studio too
The problem with this approach is : non-additive metrics (eg. Users) are taken day-wise then summed into Week. Which is incorrect. But this approach works just fine for additive metrics like pageviews, revenue.
thank you for adding details, a agree
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
@@gaillereports I need to check the engagement rate of each search term. The data is not showing when I blend the data of GA4 and GSC
все получилось, но я хочу теперь на объединенном листе отсортировать по дате все строки БЕЗ разбивки по листам, чтобы данные шли по хронологии вперемешку со всех листов
Я бы для этого использовала новую вкладку и функцию 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
@@gaillereports 3) At minute 8:54, we can see the "optional matrics" you show later in the dropdown ("% of Total". How do you calulate % of Total. Could you please explain which optional metric values and settings you use? :)
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) начинают сами автоматически приумножаться и это мешает посчитать цену лида, продажи. Может подскажите, как решаются подобные проблемы, когда из-за параметров начинаются меняться данные в метриках?) Параметры по типу , помогают мне делать фильтры и разбивки))
Все уже решил ситуацию теперь все считается как нужно)) Рад, что вы ведете канал по построению дашбордов 👍
я не много выпала) спасибо! Супер, что все получилось :)