My 15+ clients’ SEO expert friend uses this way to automate their biweekly keyword audits (and it saves him 675 clicks and 150 minutes of screen work every two weeks)
It is from a client (now a very good friend) who runs an SEO agency. I suggested it to him this way, and I'm sharing it with his permission.
I don’t provide SEO services, so please don't DM me for SEO services.
Connect Semrush or Ahrefs MCP to Claude/ChatGPT and ask:
Find every organic keyword my client's [domain] ranks for in [country/state/city]. Include the keyword, position, KD, monthly volume and ranking page. Group them by positions 2–15, 16–50 and 51–100. Sort each group by volume.
Now prioritize them:
- Positions 2 to 15 are the low-hanging opportunities. These pages already rank well, so just improve content, title, internal links, and backlinks to push them higher.
- Positions 16 to 50 are second priority. These keywords need a little more work, but what he has observed is that if the keywords from positions 2 to 15 are optimized, then these keywords also become optimized. More like a domino effect (because these are more or less related to the keywords shown in positions 2 to 15).
- Positions 51 to 100: These are potential opportunities. Your clients may rank for some of these accidentally by writing these keywords somewhere in the post or page. Better manually review each of them and work on only relevant keywords. For local businesses, ask Claude to filter for keywords containing the city, neighborhood, or service area.
Finally, manually check the intent of each keyword. For example:
”How does a dry freezer work?” It's an informational keyword.
”Buy a dry freezer in NYC.” It's a transactional keyword.
Once you have built a workflow, create a recurring CoWork task to run it every 14 days.
Calculations:
- 675 clicks: He roughly makes 45 clicks per client to manually do this.
- 150 mins: He roughly spends 10 mins per client to manually pull this data.
I’m writing this post because it aligns with my mission. My mission is to free people from the boring parts of their work, so they can do more of what they enjoy.