Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Analytics Champion Program are open!
SOLVED

Average Time Spent On Site metric in Adobe Data Warehouse

Avatar

Level 1

Hi,

I am trying to pull a report from Adobe Data Warehouse to get daily stats for average time spent on my site. I can do it easily in Site Catalyst but the requirement is that I need to pull it from DW. Time spent per visit/page is available as a dimension(Breakdown) in DW(that too in a range format) but not as a metric. The only related metric available is Total Seconds Spent. If I want to get average time spent per visit in minutes through DW, is there an alternative to it? Please help.

1 Accepted Solution

Avatar

Correct answer by
Level 2

You can try Report Builder tool for this kind of reports. It is very easy to generate these reports in excel itself with Report Builder. and there is no limit of rows there as well.

View solution in original post

2 Replies

Avatar

Level 2

ashborges​ Can you suggest how can we get the average time spent for all pages in the one go. As we could not find this feature in the Data Warehouse and we need to get the time spent for all the pages. If we go via workspace then we can only export 200 rows at once.

Avatar

Correct answer by
Level 2

You can try Report Builder tool for this kind of reports. It is very easy to generate these reports in excel itself with Report Builder. and there is no limit of rows there as well.