anyone could advise if i could filter the report to get unique visitors per page for page view time specifically more than 3 mins? i understand using dimension could filter up to 10 steps but is there a way to only filter more than 3 mins?
First, add the unique visitors to the top of a freeform table.
Next, search for "Time spent on page - bucketed" in the filter.
If you mouse over the dimension in the list you will see a small caret symbol (>). Clicking on that allows you to see which buckets are available.
Since you are interested in buckets over 3 minutes, hold "ctrl" while selecting the buckets that are over 3 minutes.
Drag and drop this selection underneath the unique visitors metric in the freeform table.
Lastly, drag the page dimension you are interested in (e.g. page name, URL, etc.) into the table where it says "Drop a Dimension Here". The table will update with the number of unique visitors broken down by timed bucket and page.
To build above calculated metrics you will need to create a segment and then use that in calculated metrics builder (all in Adobe analytics, can also do in the workspace).
Go to segment builder
Use the dimension @Brent suggested i.e. TIme spent in page - bucket items.
Add all required time slots one by one with OR condition.
Name it and Save it.
Go to calculate metrics builder
First, drop Fx Mean
Drop above segment
Drop unique visitor metrics in it.
Name it, save it, use it.
My snapshot should help you create a segment and calculated metrics condition, also Yes! we can use calculated metrics in report builder. following links will help you use these metrics in report builder (maybe a youtube search can help you better.)
Currently, the max number of rows that you can export is 400 (see this thread: https://forums.adobe.com/thread/2558118). I don't think that there is a limit to the number of pages, however, so if you really wanted to you could copy the table data, paste it in Excel, and then go to the next page (and so on).
Apologize that I could not replicate your steps how to get average time spent on page - bucketed > 3 mins.
Can you provide 2nd level details how to form the metrics above?
Is above done with adobe analytic or adobe report builder? Can Adobe report builder get the average time spent on page - bucketed > 3 mins, and time spent on page - bucket > 3 mins using metrics and not using dimension?
if yes, would you be able to provide steps how to do it in adobe report builder?
1. If I were to pull data from adobe analytic, the maximum that I can pull seems to be 400 rows, but my data has more than 400 row. Is that anywhere that I can expand to include more rows in my report?