Looker Studio dashboards by Gaille Reports
Looker Studio dashboards by Gaille Reports
  • 205
  • 521 637
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.
Other videos from this series:
Master the IF Function in Google Sheets - ua-cam.com/video/R3Dq6I34L0Q/v-deo.html
Learn the IFS Function with Easy Examples - ua-cam.com/video/3M_LiJaN6AI/v-deo.html
How to Combine Logic with the AND Function in Google Sheets - ua-cam.com/video/MDltt20ha18/v-deo.html
Learn Google Sheets: Master the OR Function Quickly - ua-cam.com/video/K6NmAn-gbTs/v-deo.html
----------------
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
Переглядів: 565

Відео

Pinterest Analytics Looker Studio Template using Windsor.ai connector
Переглядів 1,1 тис.Місяць тому
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,4 тис.4 місяці тому
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,4 тис.4 місяці тому
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,3 тис.5 місяців тому
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,2 тис.5 місяців тому
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,6 тис.5 місяців тому
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,2 тис.7 місяців тому
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
Переглядів 6 тис.8 місяців тому
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,4 тис.8 місяців тому
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]
Переглядів 24 тис.8 місяців тому
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
Переглядів 6958 місяців тому
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
Переглядів 2138 місяців тому
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
Переглядів 1649 місяців тому
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,4 тис.9 місяців тому
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
Переглядів 7649 місяців тому
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
Переглядів 1799 місяців тому
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
Переглядів 78310 місяців тому
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,9 тис.10 місяців тому
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,8 тис.10 місяців тому
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
Переглядів 54610 місяців тому
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,2 тис.11 місяців тому
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,7 тис.11 місяців тому
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,1 тис.11 місяців тому
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.
Переглядів 941Рік тому
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?
Переглядів 7 тис.Рік тому
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,5 тис.Рік тому
RFM analysis in Google Sheets and Looker Studio - dashboard template overview

КОМЕНТАРІ

  • @AS-ym2bp
    @AS-ym2bp 4 години тому

    There are also functions like HSTACK and VSTACK that help in "stacking" arrays with each other.

  • @naumanshehzad3714
    @naumanshehzad3714 2 дні тому

    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)

  • @SoulMe-r3c
    @SoulMe-r3c 2 дні тому

    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

    • @gaillereports
      @gaillereports 2 дні тому

      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

    • @SoulMe-r3c
      @SoulMe-r3c День тому

      ​@@gaillereports well noted, i've tried to reconnect the data source but nothing change. Thank you for your insight

  • @SMhqv
    @SMhqv 4 дні тому

    thanks for your lessons !

  • @RegistrasiBapasSerang
    @RegistrasiBapasSerang 8 днів тому

    6th var not working

    • @gaillereports
      @gaillereports 7 днів тому

      You still have other options to use 😀

    • @RegistrasiBapasSerang
      @RegistrasiBapasSerang 7 днів тому

      correct, I use variation 5 to custom the months name and works, thanks

  • @kraanialepsy
    @kraanialepsy 9 днів тому

    GPT send me this video when I ask it about blending. Great video.

  • @DavidCoats-n4g
    @DavidCoats-n4g 10 днів тому

    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?

    • @gaillereports
      @gaillereports 7 днів тому

      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

  • @pvelco
    @pvelco 10 днів тому

    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

    • @gaillereports
      @gaillereports 7 днів тому

      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

  • @hbasumatary1995
    @hbasumatary1995 26 днів тому

    Suppose I want to have same control fields selection in different pages . How to do it? Please help I am struggling since many days

    • @gaillereports
      @gaillereports 7 днів тому

      This is an easy one! Just click right mouse button and move object from page to report level

  • @laravandooren7286
    @laravandooren7286 Місяць тому

    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 ??

    • @gaillereports
      @gaillereports 7 днів тому

      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

  • @eonedigital
    @eonedigital Місяць тому

    ❤❤

  • @justinvandyk5210
    @justinvandyk5210 Місяць тому

    I wish this wasn't necessary and Looker Studio would just add a UNION function. But thank you!!!

  • @STMTires-g7w
    @STMTires-g7w Місяць тому

    Thanks for sharing

  • @KeshavaReddy-w3t
    @KeshavaReddy-w3t 2 місяці тому

    What if I want the week to start from Friday instead of starting from Sunday or Monday?

    • @gaillereports
      @gaillereports 2 місяці тому

      you can use DATETIME_ADD function - support.google.com/looker-studio/answer/9698326?hl=en&sjid=14096372938909852446-EU

  • @MTan-b8e
    @MTan-b8e 2 місяці тому

    fuck

  • @MTan-b8e
    @MTan-b8e 2 місяці тому

    that's not actually guide, she just want to sell her services

    • @gaillereports
      @gaillereports 2 місяці тому

      It's a complex report that is not possible to explain in 60 sec. I have long video with more details.

  • @MTan-b8e
    @MTan-b8e 2 місяці тому

    just showcase, fucking usefulless

  • @leadership_guru
    @leadership_guru 2 місяці тому

    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?

    • @gaillereports
      @gaillereports 2 місяці тому

      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.

  • @matussensel8026
    @matussensel8026 2 місяці тому

    Thank you Gaille! This exactly matched all my needs with converting a list of values with dates! Amazing!

    • @gaillereports
      @gaillereports 2 місяці тому

      Thank you so much for your kind words! I'm thrilled that you found the video so useful for your needs!

  • @senolcomert7595
    @senolcomert7595 3 місяці тому

    Thank you for the great video. One question: Can we use it on a pivot table?

    • @gaillereports
      @gaillereports 2 місяці тому

      Yes you can! Try it with your data :)

  • @OGanstaRapnaveia...
    @OGanstaRapnaveia... 3 місяці тому

    E hoje estou aqui de passagem 3 da madrugada...20/10/24

  • @sumantade-b1n
    @sumantade-b1n 3 місяці тому

    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 🙏🙏

    • @gaillereports
      @gaillereports 2 місяці тому

      You can import Search Console data to BigQuery, and connect Google Sheets to BigQuery and make all caclulations there. It it helps

  • @menlevan1380
    @menlevan1380 3 місяці тому

    Thank you very much!

  • @Amir_Ansari_Official
    @Amir_Ansari_Official 3 місяці тому

    IT IS VERY GOOD

  • @AKProjectManagement
    @AKProjectManagement 3 місяці тому

    This is the best tutorial I've found online on this type of conditional formatting. Accurate, concise, and clear. Thank you!

  • @PolinaGalaganova
    @PolinaGalaganova 3 місяці тому

    Very useful! Thank you so much!

  • @EduardoSilva-mt4su
    @EduardoSilva-mt4su 3 місяці тому

    This is amazing your analise in Looker Studio! Thank you!

  • @EduardoSilva-mt4su
    @EduardoSilva-mt4su 3 місяці тому

    Amazing, thank you!

  • @Автоматизациябизнеспроцесов

    Добрый день а как решить такую проблемму: в таблице столбик со значениями имеет целые числа и с запятой в looker studio делаю исчисляемое поле по суме этого столбика на почему то суммирует только целые числа(без запитой)

    • @gaillereports
      @gaillereports 3 місяці тому

      это странный случай, такого быть не должно. Надо проверять формат данных в источнике данных и в looker studio

  • @siarheiyarashevich9506
    @siarheiyarashevich9506 3 місяці тому

    много воды

    • @gaillereports
      @gaillereports 3 місяці тому

      это одно из первых видео, ладно уж)

  • @ioannaioannou9212
    @ioannaioannou9212 3 місяці тому

    where is the free dashboard? there is no free one

    • @gaillereports
      @gaillereports 3 місяці тому

      I have a free Looker Studio template that you receive after subscribing to the newsletter

  • @nidaassociates7441
    @nidaassociates7441 3 місяці тому

    Love u

  • @adrianzabalaguzman4718
    @adrianzabalaguzman4718 4 місяці тому

    gracias!!

  • @tienganhtuduy
    @tienganhtuduy 4 місяці тому

    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.

    • @gaillereports
      @gaillereports 3 місяці тому

      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.

    • @tienganhtuduy
      @tienganhtuduy 3 місяці тому

      @@gaillereports thanks a lot i will try to blend dât in studio too

  • @harshadbansal6589
    @harshadbansal6589 4 місяці тому

    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.

    • @gaillereports
      @gaillereports 3 місяці тому

      thank you for adding details, a agree

  • @cobaaja-c1s
    @cobaaja-c1s 4 місяці тому

    nice

  • @mohammadsediqi6571
    @mohammadsediqi6571 4 місяці тому

    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.

  • @renan_bMbk
    @renan_bMbk 4 місяці тому

    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?"

    • @gaillereports
      @gaillereports 4 місяці тому

      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

    • @karthik_askas9930
      @karthik_askas9930 2 місяці тому

      ​@@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

  • @coreaction9912
    @coreaction9912 4 місяці тому

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

    • @gaillereports
      @gaillereports 4 місяці тому

      Я бы для этого использовала новую вкладку и функцию sort, и вкладку с общими данными со всех листов как источник данных.

  • @Esakkiappan-r1u
    @Esakkiappan-r1u 4 місяці тому

    How to i contact you

    • @gaillereports
      @gaillereports 4 місяці тому

      You can use marketing@gaillereports.com

  • @QuackersMcCrackers
    @QuackersMcCrackers 4 місяці тому

    :D

  • @zotopoto
    @zotopoto 5 місяців тому

    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?

    • @gaillereports
      @gaillereports 4 місяці тому

      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.

  • @gyankigudri
    @gyankigudri 5 місяців тому

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

  • @dtps_champion6016
    @dtps_champion6016 5 місяців тому

    very useful!

  • @lostarcprimes8079
    @lostarcprimes8079 5 місяців тому

    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

    • @gaillereports
      @gaillereports 5 місяців тому

      Hmm… i recommend you to check event names, 100% the reason is there.

  • @hermawanyulianto2645
    @hermawanyulianto2645 5 місяців тому

    It is what I need, thanks a lot.

    • @gaillereports
      @gaillereports 5 місяців тому

      Yeaaah! Thank you very much for the comment! It’s a pleasure 🫶

  • @OscarMiller-xh6wk
    @OscarMiller-xh6wk 5 місяців тому

    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)

    • @gaillereports
      @gaillereports 5 місяців тому

      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 - ua-cam.com/video/WDhS3plxtmw/v-deo.htmlsi=5CJR3BmMkb811g1I you can check it

    • @OscarMiller-xh6wk
      @OscarMiller-xh6wk 3 дні тому

      @@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? :)

  • @jeyasuriya3915
    @jeyasuriya3915 5 місяців тому

    This is GA4, For GSC its not possible i think

    • @gaillereports
      @gaillereports 5 місяців тому

      It works for date fields for any data source.

  • @josephmorny3805
    @josephmorny3805 5 місяців тому

    Can you please share the google sheet for practice?

    • @gaillereports
      @gaillereports 5 місяців тому

      Thank you for your interest, but I sell this template for Looker Studio and don’t share it.

  • @RosieCraig-p6j
    @RosieCraig-p6j 5 місяців тому

    So helpful, thank you!