Hi There
First off, I rarely delete pages. Better and easier to noindex. That way you get them out of the SERPs and reduce the poor user metrics, but people can still find the pages otherwise and you don't have to 301 redirect them etc. You can delete if you feel they are just a bad user experience over all of course - but I noindex as a starting point.
Anyhow, regardless, here's how I access it - first I use a custom report with the following metrics (you can play around with them);
- pageviews
- entrances
- new visits
- avg time on page
- exits
- exit rate
- "page" for the dimension
Thresholds - starting point (I use filters)
- pageviews - I start with over 50
- avg time on page - less than 30 seconds
- exit rate - great than 80%
I like to end up with a list of maybe 50-100 pages that fall within the thresholds. Every site is different. But I try to isolate 50-100 of the worst pages (we're assuming maybe a 2,500+ page site).
You can throw a segment on there if you want to segment just Google Organic traffic - that could in some cases be more accurate.
Hope that helps! Interested to see what other people do.
-Dan