I built a tool that uses Ahrefs Top Pages to analyze the correlation between indexed pages, rankings and traffic.
What I've seen from using this tool across many websites and date ranges:
- Sites that increase pages too quickly lose rankings
- Sites that are losing traffic can often recover by removing low performers
- Sites that go dormant or inactive for too long tend to lose traffic
- Indexing new pages slowly and consistently gets the best results
Why? Outpacing the rate of which your site can acquire and distribute "link juice" (PageRank) causes negative ranking states.
You can also use this with GSC data, you just need to format it a bit.