# Blog Cluster Mapping Coverage Audit

**Last Updated:** 2026-03-18 06:52

## Summary

| Metric | Count |
|--------|-------|
| Total blog posts (JSON) | 361 |
| Posts in cluster mapping | 361 |
| Posts missing from mapping | 0 |
| Coverage | 100.0% |
| Posts with clusters in JSON | 111 |

## By Category

| Category | Total | In Mapping | Missing |
|----------|-------|------------|---------|
| lexikon | 310 | 310 | 0 |
| ratgeber | 43 | 43 | 0 |
| inside-ordio | 8 | 8 | 0 |

## Mapping URLs Not Resolving to Post JSON

URLs in cluster mapping that do not match an existing post file:

None.

## Missing Posts (First 50)

| Category | Slug | Has clusters in JSON | Suggested primary_cluster |
|----------|------|----------------------|---------------------------|

## Topics vs Cluster Mapping Alignment

Comparison of `blog-topics-extracted.json` (topic extraction) vs `blog-cluster-mapping.json`:

| Metric | Count |
|--------|-------|
| Unique URLs in topics | 89 |
| URLs in cluster mapping | 360 |
| In both (overlap) | 88 |
| Only in topics | 1 |
| Only in mapping | 272 |

*Topics and clusters are separate systems; topics are extracted from content, clusters are assigned for pillar/tools linking. Full sync deferred.*

## Recommendations

1. Run `add-missing-posts-to-cluster-mapping.php --dry-run` to preview additions.
2. Run `add-missing-posts-to-cluster-mapping.php --write` to add missing posts.
3. Fix any mapping URLs that do not resolve (redirects or stale entries).