Help! My site has been hit by an algorithm update
summary
A large US publishing site loses 70% traffic overnight; investigation uses Semrush + Google Analytics + Screaming Frog to compare peak vs worst months, export top 20 keywords by estimated traffic, pull landing pages, crawl status codes, and combine with VLOOKUP and pivot tables to spot patterns. Findings: many top category pages are mixed-topic or 404s, core web vitals are poor, and intent shifts (informational→transactional) explain rank drops. Recovery focuses on fixing content/metadata, quick wins for positions 4–30, rebuild missing pages, and expect months to recover.
AI-written summary · about
