skills.rest
AnderHonorato
AnderHonoratoCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

seo-competitor-analysis

Generate analytical SEO competitor reports with charts from Ahrefs, Semrush, and Similarweb data.

Updated Aug 28, 2026
Search Tags:#backlinks#report generation#competitor analysis#seo#organic traffic#semrush#ahrefs
One-click install
npx skills add https://github.com/AnderHonorato/Mem-rias-IA---Infinity --skill seo-competitor-analysis-anderhonorato
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: seo-competitor-analysis
Source: https://github.com/AnderHonorato/Mem-rias-IA---Infinity/tree/main/Manus/Skills/seo-competitor-analysis
Command: npx skills add https://github.com/AnderHonorato/Mem-rias-IA---Infinity --skill seo-competitor-analysis-anderhonorato

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires matplotlib, pandas, and includes scripts (resource) and references (resource) components.

What problem does it solve? It turns raw organic search exports from tools like Ahrefs, Semrush, Similarweb, and GSC into a structured, evidence-cited SEO competitor report, eliminating manual chart building and inconsistent report formatting. ## Core Features & Use Cases - Automated Chart Generation: The generate_seo_charts.py script builds trend, country, page-type, branded vs non-branded, loss, and backlink charts from normalized CSVs, with an asset manifest. - Standardized Report Structure: Enforces a target-first report template covering organic performance, backlink strategy, and key dependencies, with numeric reference-style citations. - Asset and Tone Validation: validate_report_assets.py checks that charts exist and flags prescriptive language so the report stays purely analytical. - Use Case: Given Semrush country exports and Similarweb traffic data for a rival domain, produce a complete competitive-intelligence report explaining that domain's SEO strategy, dependencies, and vulnerabilities. ## Quick Start Analyze the attached Ahrefs and Similarweb exports for competitor.com and generate an SEO competitor report with charts.

Frequently Asked Questions about seo-competitor-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create an SEO competitor analysis report from Semrush or Ahrefs data?▼

Export organic traffic, keyword, country, and backlink data from Semrush or Ahrefs, normalize it into the CSV filenames listed in the data dictionary, then run generate_seo_charts.py to build charts before writing the report following the standard structure.

What data sources does this SEO report workflow support?▼

It supports Ahrefs, Semrush, Similarweb, Google Search Console, GA4, sitemaps, robots.txt, and public page evidence. Third-party metrics are treated as directional estimates and cited as numeric references in the report.

Can the report include recommendations for the target domain?▼

No. The report is purely analytical competitive intelligence and must not contain recommendations, action plans, or roadmaps. The validation script scans for prescriptive language patterns and every warning must be resolved before delivery.

What happens if a required chart cannot be generated?▼

If a CSV input is missing or lacks required columns, the chart script logs it in the asset manifest instead of failing. The report must then state the data limitation explicitly rather than inventing values.

Why does report validation fail on missing images?▼

validate_report_assets.py requires at least three image references and critical chart categories such as trend, page type, countries, and branded versus non-branded. Missing files or categories produce errors unless --allow-missing-critical is used with documented limitations.

Related Skills

Explore More Marketing & Sales Skills→
Arianna-LupiArianna-Lupi

auditoria-de-backlinks-toxicos

Classifies referring domains by risk and generates a Google-ready disavow.txt file.

Official
Intermediate
belokonmbelokonm
8

bmad-bmm-analyst

Analyze markets and validate business requirements for BMAD project discovery.

Community
Advanced
rampstackcorampstackco
523

seo-competitor

Analyze a target site against competitors across SERP overlap, content depth, backlinks, technical posture, and brand signals.

Official
Advanced
skytiger6724skytiger6724
2

sql-queries

Convert natural language data requests into executable SQL queries.

Community
Advanced