Clicks Don't Lie - Understand ecommerce data
Clicks Don't Lie - Understand ecommerce data
  • 49
  • 37 368
Google Analytics 4: Find what products people view & add-to-cart on your website
KPI Cheat Sheet 👉 clicksdontlie.com/kpi-checklist
Calculated metrics sheet: clicksdontlie.com/ga4-calculated-metrics
I’ll teach you how to find in Google Analytics 4 what products people view and add-to-cart on your site. This way, you will be able to see products with the highest add-to-cart rate, and you can prioritize them in your shop and achieve higher revenue.
Add-to-cart rate formula:
{Items added to cart}/{Items viewed}*100
--------------------------------------------------------------------------------------------------------
👋🏼 WORK WITH ME
🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-for-ecom
📱 Schedule a one-to-one call: clicksdontlie.com/analytics-1to1
zhlédnutí: 31

Video

The Most USEFUL Metrics & Dimensions in Google Analytics 4
zhlédnutí 247Před 14 hodinami
Grab Summary Sheet 👉 clicksdontlie.com/useful-metrics-and-dimensions-in-ga4/ I’ll explain the most useful metrics and dimensions in Google Analytics 4. I’ll cover 26 metrics and 16 dimensions, ranging from user metrics to revenue and engagement metrics. When I talk to my clients, they often tell me they are overwhelmed by the amount of metrics & dimensions that Google Analytics 4 has. There are...
Google Analytics 4: Find Products Frequently Bought Together (GA4)
zhlédnutí 127Před dnem
Grab the Google Sheet 👉 clicksdontlie.com/products-bought-together/ I’ll show you how to Find frequently purchased products together in Google Analytics 4. Unfortunately, we can’t get this information directly in GA4, but I’ll show you two ways you can get this done, first with ChatGPT and second with my google sheets template. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-...
How to Find Your Most Visited Page with Google Analytics 4 (Top pages in GA4)
zhlédnutí 176Před 14 dny
KPI Cheat Sheet 👉 clicksdontlie.com/kpi-checklist I’ll show you how to see your most visited pages in Google Analytics 4. This way, you can see the top pages overall and the top pages where your users started their journey. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-for-ecom 📱 Schedule a one-to-one call: clicksdontlie.com/analytics-1to1
How to Use UTM Parameters in Google Analytics 4 (with free tool)
zhlédnutí 500Před měsícem
Default UTM parameters 👉 clicksdontlie.com/ga4-default-utm-parameters/ UTM Parameters tool: ga-dev-tools.google/campaign-url-builder/ Let me show you how you can easily create a URL with correct UTM parameters using a free Google tool. I see many of my clients get this wrong, and so they don’t track their campaigns correctly. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-fo...
Find Your Top Selling Products in Google Analytics 4 (by Name or SKU)
zhlédnutí 75Před měsícem
KPI Cheat Sheet 👉 clicksdontlie.com/kpi-checklist If you want to know where people leave your ecommerce website, you need to use the User Journey report in Google Analytics 4, also known as the purchase journey report. This is the best report to detect if you have any bottlenecks where proportionally more people abandon your website. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.co...
Google Analytics 4 Tutorial in 10 mins | Quick Start Guide to GA4
zhlédnutí 255Před měsícem
GA4 for e-commerce course: 👉 clicksdontlie.com/ga4-for-ecom So in this quick tutorial, I will teach you the basics of Google analytics 4. You will learn how to use GA4 reports, what reports are useful and when to use them. Because you can basically ignore half of the reports in GA4, But you need to know which half. DEMO ACCOUNT: support.google.com/analytics/answer/6367342?hl=en#access&zippy=,in...
User Journey in Google Analytics 4: Where did people abandon my site?
zhlédnutí 170Před měsícem
KPI Cheat Sheet 👉 clicksdontlie.com/kpi-checklist If you want to know where people leave your ecommerce website, you need to use the User Journey report in Google Analytics 4, also known as the purchase journey report. This is the best report to detect if you have any bottlenecks where proportionally more people abandon your website. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.co...
How to Turn Data into Actionable Insights (6-Step System)
zhlédnutí 257Před 2 měsíci
Grab the summary 👉 clicksdontlie.com/data-to-insights I’ll teach you my 6-step, data to insights system. Which will help you to go from random data to insights you can use to make decisions. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-for-ecom 📱 Schedule a one-to-one call: clicksdontlie.com/analytics-1to1 🔗 RELATED VIDEOS: Most useful reports in GA4: czcams.com/video/NrmV...
Why are Google Analytics 4 Reports lying to you? sort of…
zhlédnutí 116Před 2 měsíci
🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-for-ecom Any time you use Google Analytics 4 reports, they might lie to you-or, not so much lie, but only tell part of the truth. So, in this video, I’ll show you how to see this, why GA4 is doing it, and how that impacts your insights. Now, why would Google do this? Well, first you need to understand what data sampling means. 📈 Grab my free re...
Learn Funnel Exploration in Google Analytics 4 As a BEGINNER (Funnel analysis tutorial in GA4)
zhlédnutí 258Před 2 měsíci
KPI Cheat Sheet 👉 clicksdontlie.com/kpi-checklist I’ll show you how to use the Funnel Explorations report in Google Analytics 4. It’s super useful, especially when you are trying to find out where people are abandoning your website in their journey. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-for-ecom 📱 Schedule a one-to-one call: punchsalad.com/lp/1-on-1 🔗 RELATED VIDEOS...
How to Customize Reports in Google Analytics 4 (GA4 Library)
zhlédnutí 227Před 2 měsíci
Best setup for eCommerce 👉 Now GA4 is super confusing when you start with it, that said there is a powerful way to make it much better and tailored to your needs, and I think this is so underutilized feature. Because you can actually customize what you see in the menus, and remove everything that is confusing to you and then you can do the same to the Google Analytics 4 reports. 👋🏼 WORK WITH ME...
Calculated Metrics in Google Analytics 4 (Add the best ones)
zhlédnutí 159Před 3 měsíci
Grab the cheat sheet 👉 clicksdontlie.com/ga4-calculated-metrics Every Google Analytics 4 user wants to find useful insights from the data. But sometimes, Google makes strange decisions and doesn’t include essential metrics, which makes you waste time and miss crucial insights. So, in this video, I’ll teach you how to add the purchase conversion rate to GA4 reports so that you can easily compare...
Data Specialist Explains: The Best Google Analytics 4 ECOMMERCE Reports (GA4 for Ecom)
zhlédnutí 699Před 3 měsíci
🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-for-ecom I’ll show you the 7 most useful reports in Google Analytics 4 for E-Commerce. These GA4 reports can give you valuable insights into what is working and what you should prioritize. If you work in ecommerce and you use Google Analytics 4, you need data to improve your website and be good at your job. But if you use the wrong reports and ...
Find Google Analytics 4: Measurement ID + Tracking code (GA4 Tracking ID)
zhlédnutí 216Před 3 měsíci
I’ll show you how to find Google Analytics 4 (GA4) measurement id, and the tracking code. 👋🏼 WORK WITH ME 🎓 GA4 for e-commerce course: clicksdontlie.com/ga4-for-ecom 📱 Schedule a one-to-one call: clicksdontlie.com/analytics-1to1 🔗 RELATED VIDEOS: Most useful reports in GA4: czcams.com/video/NrmVm3nnMO4/video.html GA4 Beginner Tutorial: czcams.com/video/WHfKSQafaEw/video.html
How to See Site Search Terms in Google Analytics 4 (GA4)
zhlédnutí 564Před 3 měsíci
How to See Site Search Terms in Google Analytics 4 (GA4)
How to Find Coupon Codes in Google Analytics 4 (Ecommerce Promo codes in GA4)
zhlédnutí 250Před 4 měsíci
How to Find Coupon Codes in Google Analytics 4 (Ecommerce Promo codes in GA4)
How to Create GA4 Ecommerce Dashboard in Looker Studio
zhlédnutí 593Před 4 měsíci
How to Create GA4 Ecommerce Dashboard in Looker Studio
Learning GA4 for e-commerce just got a WHOLE lot easier
zhlédnutí 281Před 4 měsíci
Learning GA4 for e-commerce just got a WHOLE lot easier
How to Find Average Order Value in Google Analytics 4 [GA4]
zhlédnutí 517Před 6 měsíci
How to Find Average Order Value in Google Analytics 4 [GA4]
Beginners Guide to Free-Form Exploration in Google Analytics 4 (GA4)
zhlédnutí 760Před 7 měsíci
Beginners Guide to Free-Form Exploration in Google Analytics 4 (GA4)
The 5 Insights Every GA4 User Should Know about ACQUISITION Report (Google Analytics 4)
zhlédnutí 193Před 8 měsíci
The 5 Insights Every GA4 User Should Know about ACQUISITION Report (Google Analytics 4)
Acquisition Report in GA4 | How to Use & Get Insights in Google Analytics 4
zhlédnutí 589Před 8 měsíci
Acquisition Report in GA4 | How to Use & Get Insights in Google Analytics 4
5 Insights from the LANDING PAGE Report in Google Analytics 4
zhlédnutí 474Před 8 měsíci
5 Insights from the LANDING PAGE Report in Google Analytics 4
Conversion Rate in Google Analytics 4 | Two Ways to Show CVR in GA4
zhlédnutí 526Před 8 měsíci
Conversion Rate in Google Analytics 4 | Two Ways to Show CVR in GA4
How to Mislead Your Boss with Data & Charts 😈
zhlédnutí 131Před 9 měsíci
How to Mislead Your Boss with Data & Charts 😈
Don’t use Google Analytics 4 for Customer Lifetime Value | Use this instead!
zhlédnutí 982Před 9 měsíci
Don’t use Google Analytics 4 for Customer Lifetime Value | Use this instead!
Customer Retention & Churn Rate for Ecommerce (incl. template)
zhlédnutí 1,3KPřed 10 měsíci
Customer Retention & Churn Rate for Ecommerce (incl. template)
Google Analytics 4 Data Analysis with ChatGPT (Get Valuable Insights)
zhlédnutí 8KPřed 10 měsíci
Google Analytics 4 Data Analysis with ChatGPT (Get Valuable Insights)
Automatically Pull GA4 Data into Google Sheets (Free Google Analytics 4 add-on)
zhlédnutí 1,5KPřed 10 měsíci
Automatically Pull GA4 Data into Google Sheets (Free Google Analytics 4 add-on)

Komentáře

  • @johnnyway8667
    @johnnyway8667 Před 6 dny

    Why Advertising/All channels performance report has a discrepancy in comparison to Traffic/Acquisition reports? It would be great if you could create a video on Advertising and the new Google Ads reports.

    • @clicksdontlie
      @clicksdontlie Před 6 dny

      Hi Johnny, good idea! There are a few different reasons for it, here are the biggest (I think). Mostly it is that Google Ads have higher numbers than GA4. Here are top reasons for this: 1. People use ad blockers or browsers that block scripts, so they block your GA4 from firing. From my experience, this can be anywhere from 10%-25% of all your visitors. 2. Google Ads are clicked by bots (Google has protections, but they are not always perfect) 3. People click on ads, but don't accept your cookie policy (and GA4 script is not fired) 4. People click on ads, but never make it to your site (slow loading or they just closed the browser quickly.) 5. Your attribution model is set to first click attribution in GA4, more about this here: support.google.com/analytics/answer/10596866?hl=en I hope this helps!

    • @clicksdontlie
      @clicksdontlie Před 6 dny

      Oh yeah, what can you do about these? 1. You can use server side tracking - this will reduce ad blocker influence 2. Use software services that help you avoid bots 3. Not much you can do about this 4. Also this is hard to address, one thing to do is to make sure your ads are relevant 5. Look at the first click acquisition reports

    • @johnnyway8667
      @johnnyway8667 Před 6 dny

      @@clicksdontlie Thanks! I'm aware that Google Ads and GA4 will always show different numbers as they are working in a different way. I was talking about the difference between Standard session report and Advertising report. In GA4, the revenue data is different for each report. For example, in Traffic Acquisition>Session report the revenue is 100k, but if I go to Advertising report and filter for the same Default channel grouping, the revenue is 90k. It seems like those Advertising reports are using different attribution models. Our default attribution is Data driven.

  • @kavyaseeramsetty5456
    @kavyaseeramsetty5456 Před 12 dny

    Thanks helpful

  • @ishita.vbhandari
    @ishita.vbhandari Před 12 dny

    Wow, it’s a fire strategy, Robert 🔥 How to anonymise data for data analysis using ChatGPT?

    • @clicksdontlie
      @clicksdontlie Před 12 dny

      thanks! You can grab my Google sheet and there is a link to a video of how to anonymize the data. You can grab the sheet here: clicksdontlie.com/products-bought-together/

  • @muhammedemraan527
    @muhammedemraan527 Před 16 dny

    We have PHP website and want to track contact form conversion or may be thank you page. How can we do it. Thanks

    • @clicksdontlie
      @clicksdontlie Před 15 dny

      Hi Muhammed, you can use Google Tag Manager (GTM) and create a data layer event on form submission. You can do this with JS directly in GTM or add the datalayer push through PHP. GTM takes a bit longer to set up, but it will be easier later to install other tracking and also any ad platforms like facebook or google. Here is an intro video about GTM: czcams.com/video/Us8CXant1M4/video.html&pp=ygUSZ29vZ2xlIHRhZyBtYW5hZ2Vy

    • @muhammedemraan527
      @muhammedemraan527 Před 15 dny

      @@clicksdontlie Thanks for your time. I will try to create data layer event on form submission. Lets see if I can do it

  • @muhammedemraan527
    @muhammedemraan527 Před 16 dny

    It means GA has 1000 of reports. I never knew. Thanks for positive contribution

  • @Rowafaedits194
    @Rowafaedits194 Před 29 dny

    Can I edit your CZcams videos?

    • @clicksdontlie
      @clicksdontlie Před 27 dny

      thanks for the offer, but I'm okay to do it myself.

  • @NexusCircuit
    @NexusCircuit Před měsícem

    At 7:55 there's a record of: "Google Unisex Eco Tee Black" with 0 views, 4 added to cart, but 118 items purchased. I see this in my reports too. What's the explanation for this? Doesn't make sense to me.

    • @clicksdontlie
      @clicksdontlie Před měsícem

      I think it's just a naming difference between different pages. So on the product page (data layer) it's named something like "Google Unisex Eco T-Shirt Black" and on purchase (datalayer) it's named "Google Unisex Eco Tee Black". I've seen this before with my clients as well. You either make sure it's all exactly the same, or you can view the same report by product ID. Usually, those are the same.

    • @NexusCircuit
      @NexusCircuit Před 27 dny

      @@clicksdontlie Thanks for replying

  • @roxanagarcia9622
    @roxanagarcia9622 Před měsícem

    thanks for the information!

  • @mariafarre6279
    @mariafarre6279 Před měsícem

    Hi Robert, thank you for this. How would you calculate the Purchase rate in "Cohort_Cal"? For me everything appears as 0. Is it the same as number of orders?

    • @clicksdontlie
      @clicksdontlie Před měsícem

      Hi Maria, thanks for the question, because it made me realize that Cohort_Cal was looking at wrong fields. I've updated the sheet with correct formula. This is the formula it should have (on row 2) =IF(B2="";"";IFERROR(COUNTIF($B$2:B;B2);"")) And then drag it down for other fields. That said, I think Cohort_Cal column is not used in other calculations. I hope this helps! :)

  • @sumitroy2183
    @sumitroy2183 Před měsícem

    Great video

  • @ishita.vbhandari
    @ishita.vbhandari Před měsícem

    Quick and easy to follow! 😊

  • @departamentomarketingdigit3417

    I think tha you miss a very important one: cohorts & advertising

    • @clicksdontlie
      @clicksdontlie Před měsícem

      I agree about the ads, should have included that one. But cohorts… in my opinion they are highly unreliable because of cookies dying. Or have you found them useful?

  • @John-kx8ef
    @John-kx8ef Před měsícem

    Glad you finally have a course so I can return the favour for all the help you've given us

    • @clicksdontlie
      @clicksdontlie Před měsícem

      thanks for the support John! I hope you find the course valuable. Let me know if you have any questions :)

  • @BenHeyworth
    @BenHeyworth Před měsícem

    Great content! Thanks man.

  • @ishita.vbhandari
    @ishita.vbhandari Před měsícem

    I never knew how to read a cohort, thanks for sharing this, Robert 🤩

  • @ishita.vbhandari
    @ishita.vbhandari Před měsícem

    Amazing, Rob This is GOLD! How do you decide on the metrics to include in these different reports?

    • @clicksdontlie
      @clicksdontlie Před měsícem

      Thanks! I think it's easy to decide if you use GA4 for a month or two. Just remove the metrics you never even looked at. Usually you are left with just a few crucial.

  • @yofredgs
    @yofredgs Před 2 měsíci

    Hi CDL! I would like to achieve these same results but for the external searches of a user who does from the Google search engine until an event is generated on my website. Is that possible?

    • @clicksdontlie
      @clicksdontlie Před měsícem

      A little late answer, but yes, you can link your Google search console to GA4. Here is how: czcams.com/video/w2LfG3nG7Qk/video.html&ab_channel=MariahMagazine

  • @Shopify-Fanaat
    @Shopify-Fanaat Před 2 měsíci

    hello, the video you made can also be used for funnelish

  • @nassimbrahimi502
    @nassimbrahimi502 Před 2 měsíci

    Hi Thanks for the tutorial. For some reasons my transactions card show no data. Do you know why? By any chance

  • @EpicLib
    @EpicLib Před 3 měsíci

    And the GA4 is such a horrible product to compile reports to your CEO meetings nova days :D

    • @clicksdontlie
      @clicksdontlie Před 3 měsíci

      yeah, can't argue there. I would use google looker studio to make the reports a bit prettier, and you could automatically generate a report weekly or monthly. You can connect Looker studio & GA4 data

    • @EpicLib
      @EpicLib Před 3 měsíci

      @@clicksdontlie Thank you for the tip on Looker.

  • @juliangarciaquevedo5392
    @juliangarciaquevedo5392 Před 3 měsíci

    Hi, my totals in the freeform report on the top don't add up to the sum of the rows. I'm getting really confused here

  • @arzach_0x
    @arzach_0x Před 3 měsíci

    Actually a better question is, how can I set up a report to pull data once per week for the 7 day period in Google Analytics? Because if I select a 7 day date range in the plugin, it will be fixed to those dates, right? I need it to be updating to the most recent 7 day period

  • @arzach_0x
    @arzach_0x Před 3 měsíci

    Awesome extension! Question, if you schedule the report to run automatically, I'm assuming the original date you choose for the report remains fixed...?

  • @mihaellaa.7911
    @mihaellaa.7911 Před 3 měsíci

    Short, precise and eduational! Thank you!

    • @clicksdontlie
      @clicksdontlie Před 3 měsíci

      Thanks! I'm happy this video was also helpful Mihaella

  • @mihaellaa.7911
    @mihaellaa.7911 Před 3 měsíci

    Very insightful and helpful, thank you!

  • @zayamadin
    @zayamadin Před 3 měsíci

    keep it up

  • @nguyenak730
    @nguyenak730 Před 4 měsíci

    Are we able to export custom events such as “clicked pdf”. I see event count but not event

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @clicksdontlie
    @clicksdontlie Před 4 měsíci

    Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2

  • @dkfkfjfk3681
    @dkfkfjfk3681 Před 5 měsíci

    a lot of jobs just became outdated.

    • @clicksdontlie
      @clicksdontlie Před 5 měsíci

      hehe... I don't think it's that serious yet. The machines can only do so much. But together with a data person it's going to be super powerful.

  • @THookz
    @THookz Před 6 měsíci

    These beginner principles are so important. I think they should never go forgotten!

    • @clicksdontlie
      @clicksdontlie Před 6 měsíci

      I agree, and there are a lot of people in ecommerce that don't know these. Or don't know how to utilize them.

  • @DrKikiOfficial
    @DrKikiOfficial Před 6 měsíci

    great channel bro. I love your "simple" analysis. thanks

  • @vaishnoo1168
    @vaishnoo1168 Před 6 měsíci

    Thanks great tip

  • @enerdanberlin1354
    @enerdanberlin1354 Před 7 měsíci

    Hi, I didn't get the cheat sheet (:

    • @clicksdontlie
      @clicksdontlie Před 7 měsíci

      Hey sorry about it. If you email me to robert(at)punchsalad.com I'll email it to you!

  • @PeakDistrictSEO
    @PeakDistrictSEO Před 7 měsíci

    Hi Robert. Thanks your video was nice and clear. I tried this extension and whilst it worked great for a single report I couldn't get it to work for multiple reports. eg a column for 'all traffic' and a column for 'organic'. Any idea how to get that working, please?

  • @joelpaulkandlapalle8182
    @joelpaulkandlapalle8182 Před 7 měsíci

    I have installed the plugin for Wordpress but I don't see Monetization data at all. Am I missing something please? Thanks

    • @clicksdontlie
      @clicksdontlie Před 7 měsíci

      hey, it depends what plugin. Not all support the ecommerce feature. For example here is a video explaining how to do it with a plugin: czcams.com/video/fwegcsO-yrc/video.html&ab_channel=PixelYourSite But I'm not sure if some of the features are in the pro version.

  • @SwarnaPrasad-um5dz
    @SwarnaPrasad-um5dz Před 8 měsíci

    plus option is not there in chatgpt, where can I find it

    • @clicksdontlie
      @clicksdontlie Před 7 měsíci

      they changed the layout, you can just attached the file in the GPT4 screen (where you type prompts there attachment icon)

  • @Fridja
    @Fridja Před 8 měsíci

    You've helped the so many times over the years. Thank you Robert!

  • @imr4nkhan
    @imr4nkhan Před 8 měsíci

    🔥 Thanks for your video. Great tips to navigate GA4 and derive value!

  • @malcolm5969
    @malcolm5969 Před 8 měsíci

    This is so helpful. Thanks, instantly subbed

  • @mikejh6298
    @mikejh6298 Před 8 měsíci

    the inverted graphs are terrible!