The content audit spreadsheet I actually use

The content audit spreadsheet I actually use

Killed 40 zombie pages on a site last quarter with this. Five columns, that's it:

— URL
— Clicks (last 90 days, from GSC)
— Last meaningful update
— Action: Keep / Refresh / Merge / Redirect / Kill
— Linked-from count (internal)

Rule of thumb I follow: under 5 clicks in 90 days AND zero internal links = Kill or Merge. Decent impressions but no clicks = Refresh the title. Two thin posts on the same topic = Merge into one and 301.

Fill it in one sitting. Decide ruthlessly. Sites get faster when you cut the dead weight.