skills.rest
Arianna-Lupi
Arianna-LupiOFFICIAL
Explore all skills by this author →
GitHub

reporte-seo-gsc

Generates monthly SEO client reports from Google Search Console performance data.

Updated Jun 3, 2026
Search Tags:#seo#gsc#google search console#client reporting#monthly report#ctr analysis#csv comparison
One-click install
npx skills add https://github.com/Arianna-Lupi/SEO-Skills --skill reporte-seo-gsc-arianna-lupi
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: reporte-seo-gsc
Source: https://github.com/Arianna-Lupi/SEO-Skills/tree/main/skills/reporte-seo-gsc
Command: npx skills add https://github.com/Arianna-Lupi/SEO-Skills --skill reporte-seo-gsc-arianna-lupi

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve? Turning raw Google Search Console exports (clicks, impressions, CTR, average position) into a client-ready monthly SEO report is repetitive and error-prone. This Skill converts GSC data into an executive month-over-month report with business interpretation, following the "De Cero a SEO" diploma method, and never invents missing metrics. ## Core Features & Use Cases - Month-over-month comparison: Computes deltas for clicks, impressions, CTR, and average position from two GSC CSV exports, with a deterministic Python script that lists winning and losing queries/pages. - Diploma interpretation rules: Applies the course's diagnostic patterns, e.g. impressions up plus clicks down signals a CTR/meta title problem, and translates metrics into business value for clients. - Executive report structure: Produces a four-section report (executive summary, organic performance analysis, winning keywords and pages, tasks completed and next steps) ready to deliver. - Use Case: At month end, paste the client's GSC export for the current and previous month and receive a written executive report explaining what changed, why, and what actions come next. ## Quick Start Ask the assistant to build this month's SEO report for a client using the attached current and previous month Search Console CSV exports.

Frequently Asked Questions about reporte-seo-gsc

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

FAQPage Schema
How do I create a monthly SEO report from Google Search Console data?▼

Export the Performance report from GSC for the current and previous month with Query or Page, Clicks, Impressions, CTR, and Position columns. The Skill compares both periods, computes deltas, and writes an executive report with interpretation and next steps.

How to compare two GSC CSV exports month over month?▼

Run the included gsc_report.py script with --current and --previous pointing to the two CSV files. It outputs JSON with totals, percentage deltas, winning and losing queries or pages, and diagnostic insights, using only the Python standard library.

What metrics should a monthly SEO report include?▼

This method uses the four Google Search Console metrics: clicks, impressions, CTR, and average position, compared month over month. The report also covers winning keywords and pages, tasks completed, and actionable next steps framed as business value.

Does this work without connecting Google Search Console via API or MCP?▼

Yes, it works fully in manual mode by pasting or providing the GSC CSV export. Optional MCP connections such as mcp-gsc, Ahrefs MCP, or SerpApi can fetch data directly, but none are required.

What does it mean when impressions rise but clicks fall in GSC?▼

That pattern indicates a CTR or meta title problem, not a ranking problem: the content is visible but the snippet is not attracting clicks. The recommended action is rewriting titles and meta descriptions on the affected pages.

What are the limitations of the GSC report script?▼

The script only reads CSV exports with recognizable dimension and metric columns and uses simple averaging for position. If a file is missing or unreadable it returns an error JSON, and the workflow falls back to manual delta calculation.

Related Skills

Explore More Marketing & Sales Skills→
MCERQUAMCERQUA
1

google-search-console

Extract and analyze search performance metrics from Google Search Console.

Community
Advanced
HillBombCreationsHillBombCreations

vivreal-deploy-tracker

Track AWS deployment statuses, Step Functions executions, and Amplify build jobs.

Official
Advanced
jmanuelrosajmanuelrosa
2

seo

Audit website SEO health and diagnose technical and on-page issues.

Community
Advanced
delta-and-betadelta-and-beta

analyst-business-intelligence

Configure BI dashboards and reporting pipelines using Braze data exports.

Community
Intermediate