Grouping URLs by Issue Type
In this lesson
- Why grouping beats URL-by-URL reporting
- Three ways to group: issue, template, and pattern
- How to use pivot tables and regex for grouping
- How to name a finding group clearly
Short answer
Grouping URLs by issue type turns thousands of rows into a few findings. Group first by issue category, then by page template, then by URL pattern using regex or folder. Use pivot tables to count affected URLs per group, and name each finding by what is broken and where, such as 'Product pages missing canonical tags.'
A first-time auditor sent a Batangas resort a 3,200-row spreadsheet titled “Issues.” The developer opened it, scrolled for a minute, and closed it. The same data, grouped, became 18 findings on two pages. Those got fixed.
Three levels of grouping
- By issue category (Lesson 1.4): crawlability, indexability, status codes, duplicates, on-page, performance, rendering, schema.
- By page template: homepage, category, product, post, location, landing page.
- By URL pattern: folders, parameters, subdomains.
How to do it
- Add a page type column with a formula or regex, for example a URL containing
/rooms/is “Room.” - Use segments in your crawler (Screaming Frog Config, Segments) so every tab shows groups automatically.
- Build pivot tables: rows = page type, columns = issue flags, values = count of URLs.
Naming findings
A good finding name says what is wrong, where, and how many:
- Weak: “Canonical issues”
- Strong: “Room pages (48) canonicalize to the HTTP version of the URL”
Practice: well-named finding?
Sort each item into the right group.
-
Blog tag pages (312) indexable with under 50 words
Answer: Clear finding.
-
Duplicate content
Answer: Too vague.
-
All product pages missing Product schema price
Answer: Clear finding.
-
Various redirect problems
Answer: Too vague.
-
Footer links (on 1,200 pages) point to 301 URLs
Answer: Clear finding.
Common mistakes
- One finding per URL.
- Groups too broad, mixing unrelated causes.
- No counts. Readers cannot judge scale.
Your action
Next, you will separate root causes from symptoms.
Key terms
- Finding
- One reportable problem, describing an issue across a defined group of URLs.
- URL pattern
- A shared structure, such as /blog/tag/ or ?sort=, used to group URLs.
- Pivot table
- A spreadsheet tool that summarizes rows into counts by category.
- Regex grouping
- Using regular expressions to classify URLs into groups by path or parameter.
Questions beginners ask
How many findings should an audit have?
Most good audits have 15 to 40 findings. Hundreds of findings usually means issues were not grouped.
What if one URL has many issues?
That is normal. It can belong to several findings. Grouping happens per issue, not per URL.
How do I group without regex skills?
Use the folder from the URL with a simple formula, such as splitting by /, or use your crawler's segments feature.
Should I include every affected URL in the report?
Summarize in the report and attach the full URL list in an appendix or spreadsheet.
Related lessons
Want someone to handle SEO for your business while you learn? The team at Remar Digital can help.