Calculating the Overall Average Time in Adobe Analytics

[Nakueshimu]

Hi everyone,

I've encountered an issue in Adobe Analytics while trying to calculate the overall average time spent on my web pages. The automatic total at the top of my column currently sums up the average times, resulting in a total of 27 minutes, which isn't the correct overall average I'm looking for.

I believe there must be a straightforward way to achieve this, but I seem to be stuck. Any advice on how to get the correct overall average calculation would be greatly appreciated!
Thanks you by advance ! 

[igupta]

Hey @Nakueshimu ,

Can you please specify which metric you are using? If you use Average Time on Site metric with page dimension, you should be able to get overall average time spent on site as well as individual page breakdown as specified in below screenshot.

Hope this helps!

Best,

Isha

[Nakueshimu]

Hi Isha, 

Thanks for your answer 

Yes I used the same metric "Average time on the site" (in French) but the total of 27 minutes is a sum and not an average ^^

Regards,
Lukas

[igupta]

Ok, so few things to check-

1. Can you please try to use "All Visits" instead of page dimension and see what value you are getting?

2. Can you try to use two more metrics "Total Seconds Spent" and "Page Views" against page dimension and then create a calculated metric with definition Total Seconds Spent divided by Page Views and use format time and see what value you are getting? Attaching screenshots!

Best,

Isha

[Harveer_SinghGi1]

Hi @Nakueshimu ,

The standard Adobe provided metric "Average time on the site" should be giving you the data you want as it is working as expected for me on multiple reports.

Does this screen shot contain all the items returned for the report that you ran? Why I'm asking is because the total at top does not exactly match with sum of the rows visible in screen shot. The value at top is 00:27:38 but the sum of individual values in screen shot is 00:27:35, it is very close but not exactly same thing. I believe you have more rows in this report and one (or more) of those rows have high time spent values contributing to the high time spent number at top.

Can you sort this metric column in decreasing order and see if you find any high time spent values in this report?

Cheers!

[igupta]

I second @Harveer_SinghGi1 and I suspect the same thing! 27 minutes in average sounds like too high for web pages. Is this a news/article/video etc. type of content website which may potentially have such high averages?

[Josh__Stephens]

Hi @Nakueshimu - Are you using segments as your breakouts?  Or did you select only certain values?  In these cases, the "total" actually adds up all the rows shown below.  Instead, if you filter your dimension for just the pages you want, the total should be correct.

[Amruthesh_AG]

Hi @Nakueshimu  Its shows the average depends upon what dimension you use.

I have attached the screenshot where I have break down with different dimensions for same date range.

[kayawalton]

Hi @Nakueshimu -- Are you using segments as dimensions? I suspect that is why you are getting totals instead of averages at the top of the table. 

If you are trying to get the average time spent on any of the webpages (that apply from your segments) during any visit, I would recommend:

1. Creating a segment that includes all of the segments you want to analyze
2. Using Time Spent Per Visit as the metric/column

If you are trying to get the average time spent on any of the webpages within your segment per pageview, use the same steps as above, but instead of Time Spent Per Visit, use Average Time on Site. 

[Sukrity_Wadhwa]

Hi @Nakueshimu,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'
Thank you!