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

[SM_AP1]

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

[PratheepArunRaj · Accepted solution]

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):

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 

[SM_AP1]

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)