Website Keyword Analysis Needed

My goal is to strengthen my site’s visibility on Google and climb the local search results. To make that happen I need a thorough keyword analysis that tells me exactly which terms to target, how competitive they are, and how they map to my existing pages or future content ideas. The emphasis is on ranking improvement rather than raw traffic volume, with all insights geared toward a local audience.

Please share a recent sample of a keyword analysis you have produced so I can confirm the depth and formatting you provide.

What I expect from the engagement:
• A research report generated with reliable tools such as Ahrefs, SEMrush, Google Keyword Planner (or comparable alternatives) showing search volume, keyword difficulty, and intent for each recommended term.
• Clear grouping or clustering of keywords that makes on-page optimisation straightforward.
• Competitive snapshots of the top-ranking pages in my niche and a brief explanation of what they are doing well.
• Actionable recommendations on on-page optimisation opportunities (title tags, headings, internal links) tailored to local search intent.
• Delivery as an editable spreadsheet plus a concise summary document highlighting quick-win priorities.

I will consider the work complete when the spreadsheet and summary arrive, the numbers make sense against the provided sample, and the recommendations align with a local ranking strategy.