Skip to content

PranavNagrecha/AwesomeSalesforceSkills / skills/admin/analytics-requirements-gathering

analytics-requirements-gathering

Verified

Use this skill to elicit, document, and validate CRM Analytics requirements — covering data source mapping (Salesforce object sync vs external connector vs Data Cloud), transformation needs, audience-specific lens or dashboard views, and drill-down path specifications — before any dataset or dashboard is built. Trigger keywords: CRM Analytics requirements, analytics data source mapping, CRM Analytics audience requirements, analytics visualization requirements. NOT for the formula and target behind each KPI — use admin/analytics-kpi-definition. NOT for building the dashboard once requirements are agreed — use admin/analytics-dashboard-design.

scripts/check_analytics_requirements_gathering.py

View on GitHub
#!/usr/bin/env python3
"""Checker script for Analytics Requirements Gathering skill.

Checks org metadata or configuration relevant to Analytics Requirements Gathering.
Uses stdlib only — no pip dependencies.

Usage:
    python3 check_analytics_requirements_gathering.py [--help]
    python3 check_analytics_requirements_gathering.py --manifest-dir path/to/metadata
"""

from __future__ import annotations

import argparse
import sys
from pathlib import Path


def parse_args() -> argparse.Namespace:
    parser = argparse.ArgumentParser(
        description="Check Analytics Requirements Gathering configuration and metadata for common issues.",
    )
    parser.add_argument(
        "--manifest-dir",
        default=".",
        help="Root directory of the Salesforce metadata (default: current directory).",
    )
    return parser.parse_args()


def check_requirements_doc(file_path: Path) -> list[str]:
    """Check a CRM Analytics requirements document for completeness."""
    issues: list[str] = []

    if not file_path.exists():
        return issues

    content = file_path.read_text(encoding="utf-8")
    lower = content.lower()

    # Check for CRM Analytics vs Reports decision
    if "crm analytics" not in lower and "wave" not in lower and "einstein analytics" not in lower:
        issues.append(
            f"{file_path.name}: Document does not mention CRM Analytics. "
            "Confirm whether CRM Analytics is required or standard Reports are sufficient."
        )

    # Check for data source type specification
    source_types = ["salesforce object", "external connector", "data cloud", "csv", "snowflake", "bigquery"]
    if not any(t in lower for t in source_types):
        issues.append(
            f"{file_path.name}: Data source types are not specified. "
            "Requirements must identify data source type for each source "
            "(Salesforce object sync / external connector / Data Cloud / CSV)."
        )

    # Check for audience/RLS requirements
    if "audience" not in lower and "row-level" not in lower and "row level" not in lower and "predicate" not in lower:
        issues.append(
            f"{file_path.name}: No audience or row-level security requirements documented. "
            "Audience matrix with RLS mechanism must be specified before dataset design."
        )

    # Check for transformation requirements
    if "transformation" not in lower and "join" not in lower and "computed" not in lower:
        issues.append(
            f"{file_path.name}: No transformation requirements documented. "
            "Specify joins, computed fields, and field renames needed before recipe design."
        )

    return issues


def check_analytics_requirements_gathering(manifest_dir: Path) -> list[str]:
    """Check a documentation directory for CRM Analytics requirements completeness."""
    issues: list[str] = []

    if not manifest_dir.exists():
        issues.append(f"Directory not found: {manifest_dir}")
        return issues

    # Look for requirements document files
    req_files = (
        list(manifest_dir.rglob("*analytics*requirement*"))
        + list(manifest_dir.rglob("*crm*analytics*req*"))
        + list(manifest_dir.rglob("*wave*requirement*"))
    )
    for rf in req_files:
        if rf.suffix in (".md", ".txt"):
            issues.extend(check_requirements_doc(rf))

    return issues


def main() -> int:
    args = parse_args()
    manifest_dir = Path(args.manifest_dir)
    issues = check_analytics_requirements_gathering(manifest_dir)

    if not issues:
        print("No issues found.")
        return 0

    for issue in issues:
        print(f"WARN: {issue}", file=sys.stderr)

    return 1 if issues else 0


if __name__ == "__main__":
    sys.exit(main())
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall