Did not work for me. I cannot find the word Life Cycle.

Fred is as good as always. I don't have a technical background so the Console and Network tabs always kinda scared me, not any more. Thank you for that.

Very interesting and helpful! Thank you! Can we download the data of the "exploration" flows?

I do not see the Unit of Measurement for the Event Parameter engagement_time_msec. I can only guess because its by default now? This is at 6:44 of your video here

loved the Kings comment.

Thank you 💙

I'm having trouble filtering out the development traffic in webflow. It always shows as "Ashburn" as a city.

still relevant in 2025?

Notes 37:10 quick summary 40:30 analytics to support ideas

hi! really helpful, is these Unique users?

Also if you're trying to open the website yourself to see if it registers in the analytics, DONT FORGET TO DISABLE ADBLOCKER/UBLOCK IF YOU USE THAT

Hi there! Active Users = 1-Day Active User Metric in Looker Studio. If I sumup all 1-Day Active Users in one month and divided by 30 I get Avg DAU, right? As I checked, LS deduplicate active users, so I guess I am right.

good video, thanks.

Hi, have followed your structure, everything seems to be in place, but my table is empty - any suggestions? I tried to change the no. of characters in my domain for the LP_no_domain dimension, but nothing seems to make data populate!

Hi, thanks for the video. It is very great and useful. I'm just wondering if is possible to schedule the new exploration to run every month and be sent by email?

Great video! Fred you are AWESOME!!

Great vid. On the topic of copying over/merging data. How can we do this? Scenario: We've setup a client project under our GCP for testing, we cover billing. I've created another project with a nicer structure/naming, and want to move/merge the data over. It seems it can only copy tables but not in it's full table structure. Eg. the events_ table for GA4 isn't date partitioned in the new destination. I'm using the BQ UI.

@DataDrivenU how I can exclude some dates from all my overview reports? I have a few days with anomalies and I would like for example when I see the overview of users during the last 12 months, the information of those days are excluded directly

I used this kind of tools with GA3 but thanks a lot for the update on GA4 now, very useful!! it is also more detail :)

Is there a way to see the average amount of time users spend on the homepage before clicking an event into another page from that homepage?

Thanks for sharing so much info It is really great video debugging Analytics tool.Thanks for sharing so much info .Really a gem.

Hey man, IDK if you still see this comment section. I have a problem that the spam bot traffic is coming from Direct sources, so I cannot identify user source. What could I do?

How did you get the 'keyword' dimension? TY

Super helpful!

Hi, Thank you for your video! I have a question regarding the interval. If I schedule this report on a weekly basis, will the date range be updated automatically?

Are you supposed to create separate accounts for websites or create new streams for websites in one account? How do you view analytics for one stream if you have multiple streams?

Here's the formula for LP_no_domain: TRIM(SUBSTR(Landing Page,31,100))

Super important. however, a part of the convention is the casing and its consistency, and in the examples in this video there is no consistency. for example all the campaigns were in uppercase except for the brand ('_Brand'). IMO lowercase is best, but the key is to be consistent in any convention you choose.

great material, thank you for the inspiration

Hey, thanks for the tutorial. In my case the accounts are connected but I still cannot see the Google Ads metrics available, do you know why?

Do you use standard Search Console connector from Google in this video? Because I was trying to do the same I've noticed that standard GSC connector doesn't provide "Landing Page" dimension. Or maybe it's not for everyone

This is extremely helpful, thanks so much.

How create a filter to combine URL that has unique ID at the end ? I have many URLs that are showing separately because of a unique user property like the following: ie app/boards/d73d3994/ app/boards/d73d3243234 etc... I want to see all the views in the boards in total regardless userID...

what if you don't have session conversion rate

thank you!! This is really helpful! Im having one problem. Because the length in the SUBSTR syntax is 100, the table only grabs URL will 100 characters in the page path and nothing else. Is there a way to make Looker grab any and all page paths?

This is helpful, thank you!

legend

Thanks for sharing the method. Is there any way to see this directly in GA4?

Thanks a lot!

Hey, thanks for your videos, they're great and very informative. I've created a user explorer report to try and find users who started a session last previous 3 month period, but did not start a session this 3 month period. I hope that it will give us a list of users who have not returned, 'non returning users'. The only problem is that I see all users in this list at the moment and I would like to filter out the users who did start a session this month, so I am left with the users who did not start a session. Do you know if this is possible with a custom filter? I hope I'm making sense :) Thanks in advance!

Tq bro for providing a solution for my problem. The way you explained the concept was good.

ive done as described in the video but unfortuantly my reports are still tarnished by all the fake spam data. is there any way to exlude data from blacklisted sites from your reports

Bit confused - I don't have the landing page dimension in Looker Studio - am I doing something wrong?

Very helpful report. Cant believe i haven't thou6of that in all my years of digital marketing 😑 Thanks for this video, data riven u always has the best stuff for analytics and reporting!

Hi and thanks for sharing your work :) Your solution is based on the assumption that the revenue is evenly distributed between all the sessions and the landing pages, which is wrong. There can be users discovering the product/looking up reviews, which makes it possible to have zero-conversion keywords too, resulting in uneven transaction distribution. While the offered solution is good as a very simplified proxy, I would avoid using it for keyword prioritisation.

This is cool, but in my client's GA4, I'm seeing a Search Console section, but no "SEO Reports" section like you have. Was that taken away?

it helped me a lot. Thanks a lot... Love from Bihar, India...

Thank you for your video! If I am sending a custom event from inside my project's code base, I can see the custom event logged in ga4 but I just want to see the parameters that I send, I go and create the custom dimension for that custom event, do I still need to set up GTM in order to populate a custom dimension?

You Are A Legend! This video is niche but super helpful

i filtered using Country but still bots are coming, I need Help