Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Average Time Spent on Site giving different values based on order of dimensions

Avatar

Level 2

Looking at determining Average Time someone spends for a set of pages in a process - getting different values depending on the order of the breakdown:

 

For June 2021 (see image):

  • By month by page gives me 18 seconds on page
  • By page by month gives me 21 seconds on page

Thoughts

 

Thx

 

 

SM_AP1_0-1631810018080.png

 

2 Replies

Avatar

Moderator

Dear SM_AP1,

For sure it would be, because it is important to understand how the metric is calculated.

I have used the same metric along with the total seconds spent (Screen grab below):

PratheepArunRaj_0-1632158606457.png

If you see, the total seconds spent is same, but the Average Time Spent is different because the denominator is based on the dimensions. Checkout the link to understand the calculation in detail.

Thank You, Pratheep Arun Raj B | Xerago | Terryn Winter Analytics 

Avatar

Level 2

Just confirming my understanding

 

  • By Month by Page has 2 sequences
  • By Page by Month has 1 sequence

 

 

Timestamp

Page name

Month

12:00:00

Home

Aug 2021

12:00:30

Product

Aug 2021

12:02:10

Home

Aug 2021

12:02:20

(None; exit link click)

(None; exit link click)