Date: 2026-05-11
Source: keyword_audit.csv (550 keywords audited)
Total new-content opportunities: 76 keywords requiring new pages or posts
Working folder: C:\Users\SAguiar\Documents\Projects\keyword-targeting-audit
XLSX deliverable: keyword_audit.xlsx (6 sheets, brand-colored)
Slug-token-overlap fuzzy match against aguiarinjurylawyers.com/sitemap_index.xml (554 unique URLs across page-sitemap, post-sitemap, category-sitemap, video-sitemap).
Ahrefs ranking data was unavailable on this run due to API quota exhaustion. Quota refresh is monthly. Recommend re-running with Ahrefs data on next pass to upgrade matches from slug-only to slug + ranking signal.
Distribution across 550 keywords:
No em dashes anywhere. 6th-grade reading level on client-facing copy. "Car accident" beats "car crash" for search volume. Aguiar Blue #0B212D for headers. Use sa-template-reference for location/practice-area builds, web-content-new for blog posts. Run pre-publish-qa before deploy via wp-content-deployer, then playwright-visual-qa.
| Vol | Keyword | Suggested Slug |
|---|---|---|
| ---: | --- | --- |
| 40 | louisville negligence lawyer | /locations/louisville-negligence-lawyer/ |
| Vol | Keyword | Suggested Slug |
|---|---|---|
| ---: | --- | --- |
| 1,900 | golf cart accident lawyer | /practice-areas/golf-cart-accident-lawyer/ |
| 1,300 | tractor trailer accident attorney | /practice-areas/tractor-trailer-accident-attorney/ |
| 210 | ride share accident attorney | /practice-areas/ride-share-accident-attorney/ |