This is insane. Go to Google Search Console, click performance, then search results. Toggle on average position.
Scroll down to queries, filter by position. Is greater than 3, change rows per page is 500. You don't even have to export.
Copy everything, paste it into Claude, use the prompt. My business is this. Give your business.
Give me keywords that are valuable, have clicks impressions that I'm already close to ranking for if I optimize better. Prioritize by low hanging fruit. God will give you your keywords prioritized right there.
Pick a keyword that looks good to you, find it on the page, click your keyword, Google Search Console will show you the page that is ranking for it. all you have to do is use that keyword exactly high up on your page. This tells Google you are more relevant to that valuable keyword so you show higher for it.
When you're done, submit the updated page in this bar at the top of Google Search Console. Click request indexing. That tells Google to look again at your page so Google can see your change and learn.
My SEO method that targets specifically paying customers, users and warm leads at compactkeywords com.