Thank you so much @leocwlau! Your answers were super thorough and make complete sense to me!

Hi All, I am trying to align pageviews for a given URL for July 2024 in our org. Here is the SQL query I have in the downstream environment attached below. I'm wondering why I am coming up 3K pageviews short compared to what we have in adobe workspace for the same URL and time frame. I apply the fil...

Hi @leocwlau, See my response to your first response for additional clarity!

Hi @leocwlau,  Thank you for the prompt response. I want to exclude visitors who viewed more than 1 page during their visit. The reason being that our bounce rate is off and we are trying to mitigate that. We essentially want to know if a user goes to a next page or not. For Example, if a user lands...

Hi @Jennifer_Dungan, This makes sense. Thank you. I did just add the sample code and resource link in my edited post on how to calculate the time spent between 2 hits. How can this be done on the page level to only include time spent on a page with more than 1 page view and add that up and take the ...

Hi, Are there any resources that would show how to calculate in SQL basic web metrics or any metrics for that matter on the Analytics Data Feed Downstream Data? I have this Data Column Reference that sort of helps, but I know every row is every hit. I was wondering if there is anything out there for...

Hi @philschmidt, How would I then filter it down to get the average time spent on particular sets of pages? For example, getting each page (and url) on dimensions and then have average time spent on that page in columns for metrics? I understand your segments in that time won't exist in a last hit s...

Hi All, I'm trying to calculate Time Spent Per Page View in our Downstream Data Lake. I was referencing the Data Columns reference to try to understand this, but unsure how to calculate it in SQL. It's my understand each row is a hit. How would I look at the average time spent on a particular page t...

Hi @Nick_Walter , Thank you. Can you provide a visual mock up and explanation?

Hi @rameshpennam , Thank you for this!