Unique Page Views/Visit | Community
Skip to main content
skatofiabah
Level 5
November 5, 2024
Solved

Unique Page Views/Visit

  • November 5, 2024
  • 1 reply
  • 1014 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

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.... 

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
November 5, 2024

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
Level 5
November 5, 2024

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
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
November 5, 2024

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....