Unique Page Views/Visit

[skatofiabah]

Hi All,

I know Pages/Visit is a common and core KPI for Adobe Analytics. Is there an easy way to get unique number of pages viewed per visit on a website? For example, if I see "Page A" 4 times, "Page B" 8 times, and "Page C" 6 times in a visit, that's 18 pages/visit total, but 3 unique pages/visit. I want the latter. Any suggestions?

Thanks!

[Jennifer_Dungan]

How about using a calculated metric using the Approximate Count Distinct:

Now, you would have to pair this with your Users (so if you are trying your internal User ID, or tracking your ECID), you can use this and Visits as columns, and create your Unique Pages / Visit...

But be aware, if you have too many users, you will need to remove the "(Low Traffic)" from the table, since this will mess up both calculated metrics.

[skatofiabah]

HI @Jennifer_Dungan,

Is there a way to do it at an aggregate level for a specific page. Like what are the unique pages/visit for a given page? It doesn't seem like there is a way to do it upstream in workspace. You'd have to use SQL downstream to add up the net unique pages and divide by visits to get the "average" unique pages/visit for a given page. Above it only does that on an individual user/visitor ID level so it doesn't really work in aggregate or at scale.

Thanks.

[Jennifer_Dungan · Accepted solution]

Err.. I don't think what you are asking for makes sense??

A specific page is already a "unique page"... so I don't understand how you could do something like "unique pages/visit for a given page"??  That would just be 1 divided by the number of visits that hit the page.... which doesn't sound useful at all.

However, what I think you are asking for, is more like an average "unique pages in a visit"

So if you had:

Visit 1:

• Page A
• Page B
• Page C
• Page A

(this would be 3 unique pages in this visit)

Visit 2:

• Page A
• Page D

(this would be 2 unique pages in this visit)

So (3 pages + 2 pages)/2 visits = 2.5 average, right?

I don't think this is possible in workspace... since you can't stack metrics to get an approximate distinct count per visit....

However, you might be able to create some custom code to support something like this.... 

Now, this would require figuring out a way to track what pages a user has visited on the front end (so that you only count each unique page once)... this would be the biggest challenge....

But, if you could get that logic working... you could increment a custom event on each "new" page, and then divide that by visits?

So:

Visit 1:

• Page A
  • eventX sent
• Page B
  • eventX sent
• Page C
  • eventX sent
• Page A
  • eventX not sent, since this page has already been seen in the visit

Otherwise, I think what you are looking for would have to be done outside of Adobe in SQL....