Filter a freeform table by Visits or Page Views

[suchindra]

I am looking to develop a detailed table that focuses exclusively on those web pages that have received more than 1,000 visits within the last six months. Is there a way for me to create a specific filter or segment to isolate and display this data effectively?

[Jennifer_Dungan · Accepted solution]

Unfortunately, segments are HIT, VISIT, or VISITOR based, and while you can sort of do a calculated metric that looks at volumes, the behaviour is a little wonky, and the totals won't be restricted to the filtered pages.

You might be better off trying to use something like Report Builder, to pull in data, then use Excel functions to display items that match your criteria?

I posted an idea a while ago asking for the ability to filter based on metric values, you can like it to give it an upvote:

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/add-the-ability-to-filter-fre...

[christel_guidon]

Hello,

So i think you can do this by building a calculated metric

However, it's going to return a boolean (1=true/0=false) and does not do exactly what you want. That's the closest I could get

You may be able to play with that metric by putting it into a segment or finding a way to use it in your report?

My example below is based on 200 instead of 1,000

Here is the summary of that calculated metric:

Hope this helps along the way even if it's not a perfect answer....

Thanks - Christel

[Jennifer_Dungan]

Yes, this is one of those "imperfect" calculated metrics...

You can also return "Visits" if true, and "0" if false, but it won't be a true filter... the other items will still appear in the list, they will just show 0.. Which is why I said the behaviour is wonky... the items will still appear, just without the associated Visits, but ALL the visits for those "filtered out items" will still appear in your total....

[christel_guidon]

Yeah I hear you, Jen. It's not a solution to the post, just the closest I could get. On that note, I'm going to go upvote your idea 🙂

[Jennifer_Dungan]

Yep, we really need a true filter... I've tied using the calculated metric before with limited success.