- 49
- 37 368
Clicks Don't Lie - Understand ecommerce data
Netherlands
Registrace 3. 07. 2023
I’m here to help you to understand and analyze data to make better decisions in Ecommerce.
I focus on tutorials that are designed for non-data people.
So YOU can extract & generate insights from Ecommerce data.
I use Google Analytics and Google Looker Studio as my tools.
But you can apply the same lessons to any web analytics tool.
I've spent the last 5 years perfecting data-driven and data-informed decision-making in Ecommerce,
so YOU can reach your KPIs & Goals.
I focus on tutorials that are designed for non-data people.
So YOU can extract & generate insights from Ecommerce data.
I use Google Analytics and Google Looker Studio as my tools.
But you can apply the same lessons to any web analytics tool.
I've spent the last 5 years perfecting data-driven and data-informed decision-making in Ecommerce,
so YOU can reach your KPIs & Goals.
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
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)
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.
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!
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
@@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.
Thanks helpful
Glad it helped!
Wow, it’s a fire strategy, Robert 🔥 How to anonymise data for data analysis using ChatGPT?
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/
We have PHP website and want to track contact form conversion or may be thank you page. How can we do it. Thanks
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
@@clicksdontlie Thanks for your time. I will try to create data layer event on form submission. Lets see if I can do it
It means GA has 1000 of reports. I never knew. Thanks for positive contribution
Glad this helped you!
Can I edit your CZcams videos?
thanks for the offer, but I'm okay to do it myself.
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.
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.
@@clicksdontlie Thanks for replying
thanks for the information!
No problem!
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?
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! :)
Great video
Glad you enjoyed it!
Quick and easy to follow! 😊
So glad!
I think tha you miss a very important one: cohorts & advertising
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?
Glad you finally have a course so I can return the favour for all the help you've given us
thanks for the support John! I hope you find the course valuable. Let me know if you have any questions :)
Great content! Thanks man.
My pleasure!
I never knew how to read a cohort, thanks for sharing this, Robert 🤩
glad I could help! :)
Amazing, Rob This is GOLD! How do you decide on the metrics to include in these different reports?
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.
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?
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
hello, the video you made can also be used for funnelish
Hi Thanks for the tutorial. For some reasons my transactions card show no data. Do you know why? By any chance
And the GA4 is such a horrible product to compile reports to your CEO meetings nova days :D
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
@@clicksdontlie Thank you for the tip on Looker.
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
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
Awesome extension! Question, if you schedule the report to run automatically, I'm assuming the original date you choose for the report remains fixed...?
Short, precise and eduational! Thank you!
Thanks! I'm happy this video was also helpful Mihaella
Very insightful and helpful, thank you!
Glad you enjoyed it!
keep it up
thank! :)
Are we able to export custom events such as “clicked pdf”. I see event count but not event
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
Get ECOMMERCE insights from Google Analytics 4 (Course) - clicksdontlie.com/ga4-for-ecom2
a lot of jobs just became outdated.
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.
These beginner principles are so important. I think they should never go forgotten!
I agree, and there are a lot of people in ecommerce that don't know these. Or don't know how to utilize them.
great channel bro. I love your "simple" analysis. thanks
I appreciate that!
Thanks great tip
Happy to help!
Hi, I didn't get the cheat sheet (:
Hey sorry about it. If you email me to robert(at)punchsalad.com I'll email it to you!
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?
I have installed the plugin for Wordpress but I don't see Monetization data at all. Am I missing something please? Thanks
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.
plus option is not there in chatgpt, where can I find it
they changed the layout, you can just attached the file in the GPT4 screen (where you type prompts there attachment icon)
You've helped the so many times over the years. Thank you Robert!
Happy to help!
🔥 Thanks for your video. Great tips to navigate GA4 and derive value!
Happy I could help!
This is so helpful. Thanks, instantly subbed
Awesome, thank you!
the inverted graphs are terrible!
yeah they mess with your head :)