Analytics

Comprehensive US stock analysis including fundamental analysis (financial metrics, business quality, valuation), technical analysis (indicators, chart patterns, support/resistance), stock comparisons, and investment report generation. Use when user requests analysis of US stock tickers (e.g., "analyze AAPL", "compare TSLA vs NVDA", "give me a report on Microsoft"), evaluation of financial metrics, technical chart analysis, or investment recommendations for American stocks.

Specialized knowledge for real estate marketing analytics, including SEM campaign optimization, lead generation analysis, marketing channel performance, and geographic market insights. Use when working with real estate marketing data, Snowflake databases (RDC_ANALYTICS, RDC_MARKETING schemas), analyzing paid search campaigns, lead pricing trends, conversion funnels, or cross-channel attribution. Triggers include queries about Google Ads performance, lead quality analysis, market-level metrics, campaign budget optimization, or any real estate marketing KPIs.

Performance measurement, attribution modeling, and marketing ROI analysis. Use when setting up tracking, analyzing campaign performance, building attribution models, or creating marketing reports.

Generate interactive HTML dashboards and visualizations from LimaCharlie data using Jinja2 templates and D3.js charts. Creates professional, self-contained HTML reports with pie charts, bar charts, line graphs, gauges, sortable tables, and responsive layouts. Supports MSSP multi-tenant dashboards, single-org details, sensor health reports, detection analytics, and billing summaries. Integrates with reporting, sensor-health, and detection-engineering skills. Built with strict data accuracy guardrails - NEVER fabricates, estimates, or infers data. Use for "visual report", "dashboard", "HTML output", "interactive charts", "export HTML", "generate visualization", "graphical report".

Use when analyzing website traffic, investigating SEO issues, diagnosing high bounce rates, evaluating content performance, or optimizing site conversions - proactive SEO consultant with Plausible Analytics access that investigates patterns, fetches actual page content, and provides specific actionable recommendations based on real data analysis

Design Looker Studio reports and dashboards. Use when creating Looker Studio reports, designing data sources, or writing visualization specifications. Trigger on "Looker Studio", "レポート設計", "ダッシュボード".

Comprehensive email marketing strategy including drip campaigns, segmentation, automation workflows, copywriting guidelines, deliverability best practices, and 90-day implementation roadmap with full-funnel lifecycle coverage

Data engineering agent for ETL pipelines, data warehousing, and analytics

View cost dashboard and spending analytics (project)

PPM system for resource allocation, budget tracking, and portfolio analytics

Generate QR codes with URLs and UTM tracking. Exports PNG/SVG with captions. Use for single codes, batch generation, or marketing campaigns with tracking parameters.

Master Business Intelligence fundamentals including KPI design, metrics frameworks, data literacy, and analytical thinking

Comprehensive guide for Amplitude MCP queries. Use when analyzing product analytics, user behavior, funnels, retention, experiments, or metrics. Reduces context overhead by documenting query patterns, event taxonomies, and RDC-specific configurations. Triggers on Amplitude, product analytics, user behavior, funnel analysis, retention, experiment analysis, or metric queries.

Apache Superset dashboard automation for Finance SSC, BIR compliance, and operational analytics. Auto-generate dashboards, datasets, and charts. Tableau/Power BI alternative saving $8,400/year in licenses.

Analytics and data analysis workflow skill

Master analytical SQL including window functions, CTEs, aggregations, and query optimization for BI workloads

Creates new projects in CCGG Business Operations with all required mechanisms automatically implemented.Ensures PARENT SYSTEM INTEGRATION, operations logging, strategic alignment, and cross-project intelligence are properly configured.Handles both simple projects (standard structure) and complex projects (with coordination hubs and dependency tracking).Use for: creating new incubator project, adding sub-project to CCGG, initializing project structure, setting up project coordination, ensuring PARENT SYSTEM INTEGRATION implemented, generating CLAUDE.md with all mechanisms, creating Active Projects Index entry.Trigger terms: create project, new project, initialize project, set up project, add sub-project, project structure, CCGG project creation.

Split audio files by detecting silence gaps. Auto-segment podcasts into chapters, remove long silences, and export individual clips.

Comprehensive SEO content strategy including keyword research, content cluster architecture, technical SEO audit, on-page optimization guidelines, 90-day content calendar, link building strategy, and success metrics for sustainable organic growth

Python and R programming for data analysis, automation, and reproducible analytics