What problem does it solve? It turns a single seed keyword into a structured, presentation-ready keyword research deliverable, eliminating the manual work of expanding keywords, estimating metrics, and formatting competitor analysis into a consistent Excel report. ## Core Features & Use Cases - Structured Keyword Expansion: Generates exactly 300 keywords organized into 5 topic clusters with search intent, volume, keyword difficulty, CPC, parent topic, content type, and priority ratings. - Competitor Gap Analysis: Profiles the top 20 organic competitors with traffic share, traffic value, and domain rating, plus 20 keyword gap opportunities with recommended actions. - Locked-In Excel Output: A Python script produces a three-tab .xlsx workbook with a cluster summary, color-coded priority and difficulty columns, and strategic findings and recommendations. - Use Case: An SEO specialist receives a seed keyword like "email marketing software", confirms the target country and data source, and delivers a formatted workbook with prioritized targets and competitor gaps to a client. ## Quick Start Conduct keyword research for the keyword "email marketing software" and create the keyword research Excel workbook.
