Is there a way to see the number of Page URLs with more than 100 visits in Omniture?

[dar34829299]

Could you please advice me on how to automatically get the number of page URLs with 100+ visits in Month, not by manual exporting and counting?

Sorry, I'm novice, haven't managed to find similar question here.

Thanks in advance!

[PratheepArunRaj]

Dear Dar,

Create a New Calculated Metrics and add the function 'Approximate Distinct Count' with Dimension 'Page' or 'URL'.

Create a segment with 'Visits' greater than 100 and apply to it.

Thank You

Arun

[dar34829299]

Hi Arun,

Thanks for your help!

I've tried to make steps as you described, but unfortunately the segment with Visits>100 doesn't work.

Segment definition:

Metric definition:

Maybe I'm doing something wrong?

Thanks in advance!

Daria

[PratheepArunRaj]

Dear Dar,

Can you change the below highlighted to Visit and check?

Thank You

Arun

[nickh86417692 · Accepted solution]

Building a segment that filters by hits with greater than 100 visits will show how many visitors who have been to the site 100+ times have seen each page, but what I think the OP is trying to do is see how many pages have received more than 100 visits.

Because visits are attached to visitors and not pages, I don't know that there is a way to build a segment based on page behavior rather than visitor behavior. The only way to do this might be to pull a pages report and scroll down until the pages have less than 100 visits per month.

[laetizia_w]

I think the same that there is no real way to do so only using the exports. Adobe should create a feature on this to filter tables like that just like Google Analytics already does for years. The segment mentioned above with the calculated metric doesnt work, because it looks for visits with more than 100 visit. And a visit cant have more than one visit. Also when using this on visitor level. It checks if the visitor had a specific amount of visit and not the page itself.

Maybe Adobe should include filters for that as a feature request

[BrandonKern-6Rh]

Not sure if your company has this but Data Workbench has this built in. If you are looking to do advanced analytics and dive deeper into pieces that Analytics can't provide, Data Workbench is something I would highly recommend.

[JimKultgen]

This should work.  You could then tie a summary number to the column total.