Creating a segment using a calculated metric for Average Time Spent on Site | Community
Skip to main content
dani_sartori
dani_sartori
October 16, 2015
Solved

Creating a segment using a calculated metric for Average Time Spent on Site

  • October 16, 2015
  • 3 replies
  • 1451 views

I would like to segment out the number of visitors who spent more than 20% of the average time on site during the month.

For example, the average time on site for June was 3.53 minutes (or 3:32) and we had 65,000 visitors. Of those 65,000 visitors, how many of them spent 0.71 minutes (or :43) OR MORE on the site (which is 20% of the average)?

I created a calculated metric (see attached), but I don't think I'm doing it correctly. So first I need help figuring out the correct calculated metric.

Once the calculated metric is created, how do I create a segment using that calculated metric? I don't see it as an option with the tools I have available.

FYI, I only have access to Reports & Analytics (not Ad Hoc Analysis or Report Builder). I appreciate your help!

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 martijn_123

If you have access to Datawarehouse you could extract "Visitor ID" and "total seconds spent" for a month. Then you can calculate average time spent and calalculate the % of visitors above 20% of that average time (Excel). This should be fairly easy but doesn't give you a segment.

 

It might get problematic if you have a lot of unique visitors (+/- 1 million)  because of the file size. But I don't see an option with the other tools, maybe others do.

3 replies

A
Adobe Employee
ankitshAdobe Employee
Adobe Employee
October 16, 2015

Dani,

First of all, currently the functionality of using calculated metrics into segments are not possible, however you can use segment into calculated metrics.

Talking about the scenario where you want to calculate average time spent on site, unfortunately we can't get the average time spent on site to this granular level.

Let me know if that helps.

 

Regards,

Ankit Sharma

dani_sartori
dani_sartoriAuthor
October 16, 2015

To be clear, I cannot create a calculated metric to understand what 20% of the average time on site is? If that is correct, is what I'm trying to accomplish possible using one of the other Analytics tools (Ad Hoc Analysis or Report Builder)?

 

Thanks!

Dani

martijn_123
martijn_123Accepted solution
Level 3
October 16, 2015

If you have access to Datawarehouse you could extract "Visitor ID" and "total seconds spent" for a month. Then you can calculate average time spent and calalculate the % of visitors above 20% of that average time (Excel). This should be fairly easy but doesn't give you a segment.

 

It might get problematic if you have a lot of unique visitors (+/- 1 million)  because of the file size. But I don't see an option with the other tools, maybe others do.

Terms & ConditionsAccessibility statement

Loading footer...