How do you manage SEO performance across all your content?

I've been writing about software development for a while and my workflow for managing content performance is embarrassingly messy — Google Search Console in one tab, a spreadsheet in another, and a notes app for ideas.
I never really know which articles to update, which to promote, or what to write next. I just kind of guess.
Curious if anyone has a system that actually works? Do you use a specific tool, a spreadsheet setup, or just wing it like me?
I'm actually building a tool for this — happy to share if anyone's interested.