Hi all,
I am trying to find a way to calculate the number of (specific) hits until a specific page in a visit, so basically something like the Adobe Metric 'Average Page Depth' but for hits. I found the presentation from Audrey Salerno from one of the Adobe Summits on sequential segmentation and excluding the 'after sequence' hit. I wanted to use this for counting the hits before my target page, but before I built it with page views to check whether the result will be the same as with the metric 'average page depth'. I understand the native Adobe metric counts including the target page and this workaround with the sequential segments excludes the target page. So I expected a slight difference. Unfortunately it is quite big. I used Audrey's approach with Visit instead of Visitor, because I only want to see the number of pages within a visit. I also added the segment 'Entry page = homepage' as I wanted to count the number of pages to the target page starting from the homepage. Whereas the average page depth (Adobe metric) is 26 for the respective page, it is 7 with the sequential segment approach. Does someone know why this does not match / is so far apart?