Homepage Keyword Audit & Report

I have 37 SEO–oriented websites that need a focused keyword research report limited to each site’s home page. Using only Google Keyword Planner data, I want to know three things for every domain:

• The strongest primary keyword and two to three closely-related variants that should sit in the home page title tag (no long-tail phrases, since we’re keeping the target broad).
• Any internal URL that currently cannibalizes the chosen keyword so I can consolidate or retarget that page.
• Current average monthly searches and the opportunity volume I should be aiming for once the new title tag is in place.

Please deliver your findings in a single spreadsheet, one tab per site, with clear columns for:
– Recommended title tag (≤60 characters)
– Primary keyword
– Supporting keywords
– Cannibalizing URL(s) detected
– Current search volume
– Suggested target volume

Accuracy and clarity are key; I will move straight from your sheet into on-page optimisation, so the data must be ready to paste.