How allanreda/seo-keyword-cannibalization-detector works
This is a single-file SEO analysis script. Its main workflow imports a URL list, retrieves Google Search Console keyword metrics for those URLs, fetches and processes page HTML, identifies keywords ranking on multiple URLs, aggregates performance, and exports the results to Excel. The README documents URL cleanup and Excel output; the sampled source confirms API access, HTML processing, and aggregation, but not the omitted cleanup and export implementations.
Main entry points: keyword_cannibalization.py Analysis workflow
Components 15
Inputs and access
- URL workbook
- Analysis workflow
keyword_cannibalization.py - GSC authentication
keyword_cannibalization.py - Search Console API
- Page URL filters
keyword_cannibalization.py
Page and keyword analysis
- Keyword data fetch
keyword_cannibalization.py - Keyword metrics
keyword_cannibalization.py - Page HTML fetch
keyword_cannibalization.py - Website pages
- Visible text extraction
keyword_cannibalization.py - Page link extraction
keyword_cannibalization.py
Cannibalization results
- Keyword aggregation
keyword_cannibalization.py - Cannibalization results
keyword_cannibalization.py - Results workbook
Other components
- SEO specialist
Connections 18
- SEO specialist → Analysis workflow: runs
- URL workbook → Analysis workflow: provides URLs
- Analysis workflow → GSC authentication: obtains credentials
- GSC authentication → Search Console API: authorizes access
- Analysis workflow → Page URL filters: builds filters
- Page URL filters → Keyword data fetch: selects pages
- Keyword data fetch → Search Console API: queries metrics
- Keyword data fetch → Keyword metrics: returns rows
- Analysis workflow → Page HTML fetch: fetches pages
- Page HTML fetch → Website pages: requests HTML
- Page HTML fetch → Visible text extraction: passes HTML
- Visible text extraction → Page link extraction: extracts links
- Analysis workflow → Keyword aggregation: groups keyword rows
- Keyword metrics → Keyword aggregation: provides metrics
- Keyword aggregation → Cannibalization results: identifies overlaps
- Analysis workflow → Results workbook: exports results
- Cannibalization results → Results workbook: provides results
- Results workbook → SEO specialist: delivers report