Ecommerce crawls drown in faceted navigation. One category with five filters generates thousands of URL combinations, and they overwhelm any attempt to see the actual site structure.
The pattern approach
Rather than filtering each parameter individually, one expression removes any URL containing a query string with a filter parameter in it. Thousands of rows disappear in a single pass and the real page inventory becomes visible.
What you learn from the count
The ratio itself is the finding. A site with 800 real pages generating 240,000 crawlable URLs has a crawl budget problem that will show up as slow indexing of genuinely new content. That number is the argument for fixing it.
Then fix it properly
Filtering your export cleans your report; it does not clean the site. The actual remedies are canonical tags pointing at the unfiltered page, robots directives for parameter combinations that should never be crawled, and internal links that do not point into the facet space.
Try it: Remove Lines Matching Regex on SeoWolf's Notepad.