Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

how to calculate Average number of pages per visit in Adobe

Avatar

Level 1

Can anyone share thoughts on how to calculate Average number of pages per visit. ( not page views) 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Try this:

1. Create a Calculated Metric with this: APPROX COUNT DISTINCT (Page)

2. Create another Calculated Metric with this: the above calculated metric / Visits

View solution in original post

6 Replies

Avatar

Correct answer by
Community Advisor

Try this:

1. Create a Calculated Metric with this: APPROX COUNT DISTINCT (Page)

2. Create another Calculated Metric with this: the above calculated metric / Visits

Avatar

Level 1
i tried but its not making sense...giving 0.1 as average for a ecommerce website..

Avatar

Community Advisor

@bobbytrk_29well, yes, that is a correct result.

Consider this simple example:

Visit 1: viewed pages in this sequence: A, B, C, A

Visit 2: viewed pages in this sequence: A, B, A, B, D

Pages per Visit for:

Page A = (1 + 1) / 2 = 1

Page B = (1 + 1) / 2 = 1

Page C = (1 + 0) / 2 = 0.5

Page D = (0 + 1) / 2 = 0.5