Segment to display only pages with more than 100 pageviews.

[ValentinCh1]

Hi! 

I would like to build a freeform table that displayed only blog article pages that have more than 100 pageviews. However, the segment I'm creating does not contain any data. 

Please find below how I build my segment. 

Thanks in advance for the help. 

[Jennifer_Dungan · Accepted solution]

Well the problem here is that your segment is looking at "HIT" level, so you cannot have 100 or more "page views" on a single hit.

Visit and Visitor Segments also won't work for you, as those are locked to a single user's Visit (i.e. that page must have been viewed 100 times in the same visit) or to a single Visitor's lifetime (i.e. that page must of been viewed 100 times by the same user).

I don't think there is a way to segment this specifically....

Now, one thing you can do (but it's not the most ideal), is to use a calculated metric using an IF statement and GREATER THAN OR EQUAL statement to restrict the page views for items over X (in your case 100), then if it's not, show "0", however, the pages will still show in the list in your table, but their PV count won't be included in the total.

Again, this may not be the intended display you are looking for... but this is the closest I can think of to get you what you want.

[Jennifer_Dungan]

I've posted an idea about having proper built in features, please add any details or functionality request that you may see could be used, and please upvote so that maybe it will get worked on.

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

[ValentinCh1]

Thanks a lot Jennifer! The pages are still show in the list in my table. However, their PV count are included in the total for me. 

[Jennifer_Dungan]

Oh, you are right.. probably cause the total is above "100"...

In which case, to get the total, you will need to do a separate calculated metric using the IF / Greater than or equal to 100 all inside a "Column Sum" function....

Or take this out of Adobe and use Report Builder in Excel for now, where you can apply Excel formulas to get just the display you need....