Most content audits I see delivered by agencies are 80-page PDFs that summarize traffic per page in exhaustive detail and end with a vague "improve content quality" recommendation nobody can act on. The version below fits on one sheet, takes an afternoon, and ends with a decision for every URL — not a description of it.
The four columns that matter
Pull every indexed URL, its last-12-months organic sessions, and its last-12-months conversions (or a proxy — email signups, calls, whatever counts for the business), then sort into one of four actions:
| Signal | Traffic | Converts? | Action |
|---|---|---|---|
| Strong performer | High | Yes | Leave alone, monitor quarterly |
| Traffic without payoff | High | No | Rework the call-to-action, not the content |
| Quiet earner | Low | Yes | Expand — it's working, it just needs reach |
| Dead weight | Low | No | Consolidate into a stronger page, or remove |
That's the whole framework. No page is exempt from a decision — "leave it as is" is still a decision, made deliberately rather than by default.
Why this beats a traffic-only audit
A traffic-only view tells you a page is quiet. It doesn't tell you whether that's a problem. Cross-referencing against conversions is what turns "this page gets 40 visits a month" from a red flag into either a non-issue (it's a high-intent 40 visits) or a real one (it's 40 visits and none of them do anything).
Running it in an afternoon
- Export your indexed URLs (Search Console → Pages) and their last-12-months clicks.
- Join against your conversion data by URL — GA4's landing-page dimension makes this a five-minute pivot table.
- Bucket each row into one of the four actions above.
- Batch the "rework the CTA" bucket first — it's almost always the highest-leverage fix, since the traffic is already there.
If you get through the export and the pivot table but stall on interpreting the buckets, that's usually a sign the conversion tracking itself needs a second look before the audit's conclusions can be trusted.