Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Average time on site = Infinity

Avatar

Level 3

Hi,

Although I see similar questions have been asked by different users before, but still I'm not able to find a satisfactory answer and I'm not sure if it's a bug specific to workspace analysis?

If I just want to see an overall view of avg.time spent on site, I see 'infinity' but if I break it down by months or some other dimension then I can the values being populated. However, it's also not the case, when we apply segment. Let me share with few screengrabs.

Overall along with segments:-

1622534_pastedImage_0.png

Monthly breakdown:-

1622535_pastedImage_1.png

Can you anyone help me here?

Thanks!

Madhur

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

per definition, the "time spent" metrics are calculated against a dimension! since bothe time ranges (first table) and segments (second table) are not dimensions, it can't find any visits with that dimension (since there is no dimension) so any average is divided by 0 (equals infinity).

from a technical view I believe that the data request wants to check at a hit-level where a certain dimension exists. and since both "date ranges" and "segments" are no dimensions, the request will fail or return 0.

link to help page: Time Spent

i hope some of the adobe pros can confirm, maybe Gigazelle​ or ericmatisoff​?

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

per definition, the "time spent" metrics are calculated against a dimension! since bothe time ranges (first table) and segments (second table) are not dimensions, it can't find any visits with that dimension (since there is no dimension) so any average is divided by 0 (equals infinity).

from a technical view I believe that the data request wants to check at a hit-level where a certain dimension exists. and since both "date ranges" and "segments" are no dimensions, the request will fail or return 0.

link to help page: Time Spent

i hope some of the adobe pros can confirm, maybe Gigazelle​ or ericmatisoff​?

Avatar

Employee Advisor

Yes, Infinity is Workspace's version of #DIV/0! which was seen in prior versions of Adobe Analytics.

When you use other dimensions instead of segments/dates, do you also see infinity?

Avatar

Level 3

Thank you, this is helpful. Is it only in workspace that it shows infinity as when we run the same in Report builder, then it doesn't show infinity.

Avatar

Employee Advisor

It should be pretty easily tested, but I believe it returns #DIV/0! in Report Builder.

Avatar

Level 1

I think when we choose wrong metric then only we got like that outcome.