Dados e Análise

Identifica palavras-chave que concorrentes posicionam, mas o domínio alvo não, usando dados do Ahrefs, revelando oportunidades de conteúdo e lacunas de tópicos.

Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especial

Analisa a divisão do tráfego orgânico entre termos de marca e não-marca usando dados do Google Search Console, mostrando a porcentagem de cliques de buscas pelo nome da marca versus consultas genéricas. Requer que o usuário confirme os termos de marca antes da análise.

Analyze language learning progress from local data. Use when the user runs /language-coach:language-review or asks to review their progress, see their band history, check improvement trends, or analyze their IELTS score data.

Generate a structured SEO content brief for a keyword using live Ahrefs SERP data and optional GSC overlay. Use when user says "content brief", "write a brief for", "content plan for keyword", "what should I write about", "brief for article", "content strategy for keyword", "help me write content for", or "create a brief for".

Perform SQL-based data analysis — exploratory queries, aggregations, funnels, cohorts, and insight narratives.

Load this skill whenever the project contains SVG graphics — inline SVGs, external SVG files, SVG icons, SVG illustrations, or SVG-based data visualizations. Under no circumstances use SVG without proper accessible titles, descriptions, and ARIA roles where required. Absolutely always add <title> and <desc> to meaningful SVGs and set role="img" with aria-labelledby pointing to those elements.

Detect ranking drops and lost traffic using Google Search Console data. Compares the last 28 days against the prior 28-day period to surface pages and keywords with the biggest declines. Use when user says "GSC drops", "ranking drops", "lost traffic", "pages losing rankings", or "keyword drops".

Validate SEO preservation during site migrations. Checks redirect chains (301 vs 302, hop count), canonical consistency, title/meta preservation, HTTP status codes, content similarity, and schema preservation. Accepts single URL pair or CSV file of URL pairs. Use when user says "migration check", "site migration", "redirect audit", "URL mapping", "domain change", "relaunch", "site move".

Master pandas operations — DataFrames, Series, groupby, merge, time-series resampling, and memory optimization.

Load this skill whenever the project contains HTML data tables (<table> elements). Under no circumstances use tables for layout purposes. Absolutely always include <th> elements with appropriate scope attributes, a <caption> or aria-labelledby, and ensure complex tables have headers associated with data cells. Apply these rules to every data table without exception.

Programmatic GIF creation using Remotion (React-based). Generates text animations, loading spinners, logo reveals, meme templates, data visualizations, typewriter effects, and motion graphics as GIFs. Claude writes React components, Remotion renders frames, FFmpeg assembles with palette optimization. Use when user says "text animation gif", "loading spinner gif", "logo reveal gif", "meme template"