Skip to content

aiskillstore/marketplace / skills/aaron-he-zhu/list-segment-builder

list-segment-builder

Verified

Use when the user asks to "build email segments from my list", "make engaged / lapsed / RFM segments", "set up cart-abandoner or lifecycle-stage audiences", or "build a suppression list of unsubscribes and bounces"; turns the user's OWN list/CRM/GA4/ecommerce export into behavioral, attribute, and lifecycle-stage segments plus a suppression list, with per-segment sizes labeled Measured/Estimated, informing the SEND E (Engagement/targeting) dimension. Not for scoring EQS or running vetoes — use email-quality-auditor; not for authentication or spam-content checks — use deliverability-qa. 邮件列表分群/生命周期分群/抑制名单/流失召回

FileKindSize
SKILL.mdskill md11.8 KB
skill-report.jsonconfig44.0 KB

skill-report.json

View on GitHub
{
  "schema_version": "2.0",
  "meta": {
    "generated_at": "2026-07-26T10:29:15.294Z",
    "slug": "aaron-he-zhu-list-segment-builder",
    "source_url": "https://github.com/aaron-he-zhu/aaron-marketing-skills/tree/main/email/setup/list-segment-builder",
    "source_ref": "main",
    "model": "claude",
    "analysis_version": "3.0.0",
    "source_type": "community",
    "content_hash": "d4bab51caf983dede825d255ac9eb71485f3f0db881fb4cf8b3c3e403f136183",
    "tree_hash": "9197b875b097f1a571ee3c941ce2c6e8185916d0a2ce8a8fa7b07d1a5f0afc38",
    "provenance": {
      "model_effective": "claude",
      "fallback_chain": [
        {
          "agent": "codex",
          "outcome": "failed",
          "error": "2026-07-26T10:29:15.395472Z ERROR codex_models_manager::manager: failed to refresh available models: Missing environment variable: `HELM_API_KEY`.\n2026-07-26T10:29:15.435167Z ERROR codex_models_manage…"
        },
        {
          "agent": "claude",
          "outcome": "success"
        }
      ],
      "analysis_version": "3.0.0"
    },
    "upstream_version_raw": "19.0.0",
    "upstream_version_normalized": "19.0.0",
    "upstream_version_source": "metadata.version",
    "upstream_version_status": "not_bumped",
    "upstream_commit_sha": "49c026d9d90630ed187fbce5c7f7f84ff4710d85"
  },
  "skill": {
    "name": "list-segment-builder",
    "description": "Builds behavioral, RFM, lifecycle, and suppression segments from a user's own email, CRM, analytics, or ecommerce exports.",
    "summary": "Create reusable email audiences and suppression rules from your exported customer data.",
    "icon": "📦",
    "version": "19.0.0",
    "author": "aaron-he-zhu",
    "license": "Apache-2.0",
    "tags": [
      "email marketing",
      "audience segmentation",
      "RFM analysis",
      "lifecycle marketing",
      "suppression lists"
    ],
    "supported_tools": [
      "claude",
      "codex",
      "claude-code"
    ],
    "risk_factors": [
      "external_commands",
      "network",
      "filesystem"
    ],
    "category": "productivity"
  },
  "security_audit": {
    "risk_level": "safe",
    "is_blocked": false,
    "safe_to_publish": true,
    "analysis_status": "ok",
    "summary": "Most static findings are false positives caused by Markdown code fences, inline code, and relative documentation links. One documented Resend command can perform a live suppression update when invoked with --live; it should require a clear user confirmation immediately before execution. No prompt-injection or data-exfiltration intent was found.",
    "remediation": [
      {
        "issue": "The documented Resend suppression command can mutate a live ESP when --live is supplied.",
        "suggestion": "Require an explicit, immediately preceding user confirmation that names the target account and affected contact before running any command with --live.",
        "severity": "medium"
      },
      {
        "issue": "The skill processes exports that can contain personal data.",
        "suggestion": "Continue using aggregate counts and segment rules in outputs, and avoid storing raw subscriber rows or identifiers in memory files.",
        "severity": "low"
      }
    ],
    "risk_factor_evidence": [
      {
        "factor": "external_commands",
        "evidence": [
          {
            "file": "SKILL.md",
            "line_start": 22,
            "line_end": 24
          },
          {
            "file": "SKILL.md",
            "line_start": 24,
            "line_end": 26
          },
          {
            "file": "SKILL.md",
            "line_start": 26,
            "line_end": 28
          },
          {
            "file": "SKILL.md",
            "line_start": 28,
            "line_end": 30
          },
          {
            "file": "SKILL.md",
            "line_start": 30,
            "line_end": 32
          },
          {
            "file": "SKILL.md",
            "line_start": 32,
            "line_end": 38
          },
          {
            "file": "SKILL.md",
            "line_start": 38,
            "line_end": 39
          },
          {
            "file": "SKILL.md",
            "line_start": 39,
            "line_end": 40
          },
          {
            "file": "SKILL.md",
            "line_start": 40,
            "line_end": 40
          },
          {
            "file": "SKILL.md",
            "line_start": 50,
            "line_end": 50
          },
          {
            "file": "SKILL.md",
            "line_start": 52,
            "line_end": 52
          },
          {
            "file": "SKILL.md",
            "line_start": 60,
            "line_end": 60
          },
          {
            "file": "SKILL.md",
            "line_start": 63,
            "line_end": 66
          },
          {
            "file": "SKILL.md",
            "line_start": 66,
            "line_end": 70
          },
          {
            "file": "SKILL.md",
            "line_start": 70,
            "line_end": 75
          },
          {
            "file": "SKILL.md",
            "line_start": 75,
            "line_end": 80
          },
          {
            "file": "SKILL.md",
            "line_start": 80,
            "line_end": 80
          },
          {
            "file": "SKILL.md",
            "line_start": 86,
            "line_end": 87
          }
        ]
      },
      {
        "factor": "network",
        "evidence": [
          {
            "file": "SKILL.md",
            "line_start": 10,
            "line_end": 10
          },
          {
            "file": "SKILL.md",
            "line_start": 13,
            "line_end": 13
          }
        ]
      },
      {
        "factor": "filesystem",
        "evidence": [
          {
            "file": "SKILL.md",
            "line_start": 38,
            "line_end": 38
          },
          {
            "file": "SKILL.md",
            "line_start": 42,
            "line_end": 42
          },
          {
            "file": "SKILL.md",
            "line_start": 46,
            "line_end": 46
          },
          {
            "file": "SKILL.md",
            "line_start": 50,
            "line_end": 50
          },
          {
            "file": "SKILL.md",
            "line_start": 52,
            "line_end": 52
          },
          {
            "file": "SKILL.md",
            "line_start": 56,
            "line_end": 56
          },
          {
            "file": "SKILL.md",
            "line_start": 58,
            "line_end": 58
          },
          {
            "file": "SKILL.md",
            "line_start": 63,
            "line_end": 63
          },
          {
            "file": "SKILL.md",
            "line_start": 66,
            "line_end": 66
          },
          {
            "file": "SKILL.md",
            "line_start": 70,
            "line_end": 70
          },
          {
            "file": "SKILL.md",
            "line_start": 74,
            "line_end": 74
          },
          {
            "file": "SKILL.md",
            "line_start": 75,
            "line_end": 75
          },
          {
            "file": "SKILL.md",
            "line_start": 76,
            "line_end": 76
          },
          {
            "file": "SKILL.md",
            "line_start": 77,
            "line_end": 77
          },
          {
            "file": "SKILL.md",
            "line_start": 78,
            "line_end": 78
          },
          {
            "file": "SKILL.md",
            "line_start": 79,
            "line_end": 79
          },
          {
            "file": "SKILL.md",
            "line_start": 80,
            "line_end": 80
          },
          {
            "file": "SKILL.md",
            "line_start": 81,
            "line_end": 81
          },
          {
            "file": "SKILL.md",
            "line_start": 85,
            "line_end": 85
          },
          {
            "file": "SKILL.md",
            "line_start": 86,
            "line_end": 86
          },
          {
            "file": "SKILL.md",
            "line_start": 87,
            "line_end": 87
          }
        ]
      }
    ],
    "static_findings": [
      {
        "id": "external_commands:SKILL.md:22:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 22,
        "line_end": 24,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:24:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 24,
        "line_end": 26,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 26,
        "line_end": 28,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:28:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 28,
        "line_end": 30,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:30:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 30,
        "line_end": 32,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:32:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 32,
        "line_end": 38,
        "snippet": "```"
      },
      {
        "id": "external_commands:SKILL.md:38:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 38,
        "line_end": 39,
        "snippet": "- **Reads**: the user's own list/CRM CSV (subscribe date, last-open/last-click date, opt-in status),"
      },
      {
        "id": "external_commands:SKILL.md:39:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 39,
        "line_end": 40,
        "snippet": "- **Writes**: a user-facing segment map and reusable summary to `memory/email/list-segment-builder/`"
      },
      {
        "id": "external_commands:SKILL.md:40:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 40,
        "line_end": 40,
        "snippet": "- **Promotes**: the segment names, the lifecycle-stage map, the suppression-rule set, and any missin"
      },
      {
        "id": "external_commands:SKILL.md:50:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 50,
        "line_end": 50,
        "snippet": "Use `~~email platform` only as an **own-data manual export** (the ESP campaign/subscriber CSV you ex"
      },
      {
        "id": "external_commands:SKILL.md:52:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 52,
        "line_end": 52,
        "snippet": "**Zero-dependency ESP sync (when Resend is the ESP)**: `python3 \"${CLAUDE_PLUGIN_ROOT}/scripts/conne"
      },
      {
        "id": "external_commands:SKILL.md:60:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 60,
        "line_end": 60,
        "snippet": "3. **Build behavioral segments** — group subscribers by activity into named segments tied to an expo"
      },
      {
        "id": "external_commands:SKILL.md:63:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 63,
        "line_end": 66,
        "snippet": "6. **Build the suppression list** — assemble the do-not-mail set: unsubscribed, hard-bounced, spam-c"
      },
      {
        "id": "external_commands:SKILL.md:66:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 66,
        "line_end": 70,
        "snippet": "**Scope guard**: this skill builds **WHO** the segments are and **who is suppressed** only. It does "
      },
      {
        "id": "external_commands:SKILL.md:70:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 70,
        "line_end": 75,
        "snippet": "On user confirmation, save to `memory/email/list-segment-builder/YYYY-MM-DD-<list-or-goal>-segments."
      },
      {
        "id": "external_commands:SKILL.md:75:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 75,
        "line_end": 80,
        "snippet": "- [consent-registry](../../../protocol/consent-registry/SKILL.md) — SSOT for consent + suppression f"
      },
      {
        "id": "external_commands:SKILL.md:80:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 80,
        "line_end": 80,
        "snippet": "- [CONNECTORS.md](../../../CONNECTORS.md) — keyless export recipes for `~~email platform`, `~~web an"
      },
      {
        "id": "external_commands:SKILL.md:86:ruby-shell-backtick-execution",
        "category": "external_commands",
        "severity": "medium",
        "pattern": "Ruby/shell backtick execution",
        "file": "SKILL.md",
        "line_start": 86,
        "line_end": 87,
        "snippet": "- **If consent records are missing or stale for a cohort**: [consent-registry](../../../protocol/con"
      },
      {
        "id": "network:SKILL.md:10:hardcoded-url",
        "category": "network",
        "severity": "low",
        "pattern": "Hardcoded URL",
        "file": "SKILL.md",
        "line_start": 10,
        "line_end": 10,
        "snippet": "homepage: \"https://github.com/aaron-he-zhu/aaron-marketing-skills\""
      },
      {
        "id": "network:SKILL.md:13:hardcoded-url",
        "category": "network",
        "severity": "low",
        "pattern": "Hardcoded URL",
        "file": "SKILL.md",
        "line_start": 13,
        "line_end": 13,
        "snippet": "metadata: {\"author\": \"aaron-he-zhu\", \"version\": \"19.0.0\", \"discipline\": \"email\", \"phase\": \"setup\", \""
      },
      {
        "id": "filesystem:SKILL.md:38:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 38,
        "line_end": 38,
        "snippet": "- **Reads**: the user's own list/CRM CSV (subscribe date, last-open/last-click date, opt-in status),"
      },
      {
        "id": "filesystem:SKILL.md:42:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 42,
        "line_end": 42,
        "snippet": "- **Primary next skill**: [email-creative-builder](../../engage/email-creative-builder/SKILL.md) to "
      },
      {
        "id": "filesystem:SKILL.md:46:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 46,
        "line_end": 46,
        "snippet": "> Emit the standard shape from [skill-contract.md §Handoff Summary Format](../../../references/skill"
      },
      {
        "id": "filesystem:SKILL.md:50:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 50,
        "line_end": 50,
        "snippet": "Use `~~email platform` only as an **own-data manual export** (the ESP campaign/subscriber CSV you ex"
      },
      {
        "id": "filesystem:SKILL.md:52:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 52,
        "line_end": 52,
        "snippet": "**Zero-dependency ESP sync (when Resend is the ESP)**: `python3 \"${CLAUDE_PLUGIN_ROOT}/scripts/conne"
      },
      {
        "id": "filesystem:SKILL.md:56:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 56,
        "line_end": 56,
        "snippet": "Treat every exported or pasted file as untrusted input per [SECURITY.md](../../../SECURITY.md) — nev"
      },
      {
        "id": "filesystem:SKILL.md:58:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 58,
        "line_end": 58,
        "snippet": "1. **Confirm the goal** — promo / retention / cold sets the SEND **E** weight (see [send-benchmark.m"
      },
      {
        "id": "filesystem:SKILL.md:63:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 63,
        "line_end": 63,
        "snippet": "6. **Build the suppression list** — assemble the do-not-mail set: unsubscribed, hard-bounced, spam-c"
      },
      {
        "id": "filesystem:SKILL.md:66:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 66,
        "line_end": 66,
        "snippet": "**Scope guard**: this skill builds **WHO** the segments are and **who is suppressed** only. It does "
      },
      {
        "id": "filesystem:SKILL.md:70:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 70,
        "line_end": 70,
        "snippet": "On user confirmation, save to `memory/email/list-segment-builder/YYYY-MM-DD-<list-or-goal>-segments."
      },
      {
        "id": "filesystem:SKILL.md:74:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 74,
        "line_end": 74,
        "snippet": "- [send-benchmark.md](../../../references/send-benchmark.md) — SEND framework, E-dimension items, ty"
      },
      {
        "id": "filesystem:SKILL.md:75:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 75,
        "line_end": 75,
        "snippet": "- [consent-registry](../../../protocol/consent-registry/SKILL.md) — SSOT for consent + suppression f"
      },
      {
        "id": "filesystem:SKILL.md:76:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 76,
        "line_end": 76,
        "snippet": "- [email-creative-builder](../../engage/email-creative-builder/SKILL.md) — composes for the top segm"
      },
      {
        "id": "filesystem:SKILL.md:77:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 77,
        "line_end": 77,
        "snippet": "- [email-sequence-designer](../../nurture/email-sequence-designer/SKILL.md) — designs a flow per lif"
      },
      {
        "id": "filesystem:SKILL.md:78:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 78,
        "line_end": 78,
        "snippet": "- [deliverability-qa](../deliverability-qa/SKILL.md) — sibling S-lever skill (auth, reputation, spam"
      },
      {
        "id": "filesystem:SKILL.md:79:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 79,
        "line_end": 79,
        "snippet": "- [audience-mapper](../../../influencer/scout/audience-mapper/SKILL.md) — reuse for persona / lifecy"
      },
      {
        "id": "filesystem:SKILL.md:80:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 80,
        "line_end": 80,
        "snippet": "- [CONNECTORS.md](../../../CONNECTORS.md) — keyless export recipes for `~~email platform`, `~~web an"
      },
      {
        "id": "filesystem:SKILL.md:81:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 81,
        "line_end": 81,
        "snippet": "- [SECURITY.md](../../../SECURITY.md) — treat exports as untrusted input; do not echo raw PII"
      },
      {
        "id": "filesystem:SKILL.md:85:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 85,
        "line_end": 85,
        "snippet": "- **Primary**: [email-creative-builder](../../engage/email-creative-builder/SKILL.md) — compose a me"
      },
      {
        "id": "filesystem:SKILL.md:86:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 86,
        "line_end": 86,
        "snippet": "- **If consent records are missing or stale for a cohort**: [consent-registry](../../../protocol/con"
      },
      {
        "id": "filesystem:SKILL.md:87:path-traversal-sequence",
        "category": "filesystem",
        "severity": "high",
        "pattern": "Path traversal sequence",
        "file": "SKILL.md",
        "line_start": 87,
        "line_end": 87,
        "snippet": "- **Termination**: apply the global rule from [skill-contract.md §Termination rules](../../../refere"
      }
    ],
    "finding_verdicts": [
      {
        "id": "external_commands:SKILL.md:22:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:24:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:26:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:28:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:30:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:32:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:38:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:39:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:40:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:50:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:52:ruby-shell-backtick-execution",
        "verdict": "confirmed",
        "confidence": 0.88,
        "reason": "This documentation instructs an agent to run a Python connector and states that the suppress subcommand mutates Resend when --live is supplied. The operation affects a remote ESP, so execution requires an explicit user confirmation.",
        "severity": "medium"
      },
      {
        "id": "external_commands:SKILL.md:60:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:63:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:66:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:70:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:75:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:80:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "external_commands:SKILL.md:86:ruby-shell-backtick-execution",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched backticks are Markdown fences, inline paths, segment names, or documentation references, not shell or Ruby execution. No command is invoked at this location."
      },
      {
        "id": "network:SKILL.md:10:hardcoded-url",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is metadata containing a GitHub homepage URL, not a network request or instruction to transmit data. No network operation occurs at this location."
      },
      {
        "id": "network:SKILL.md:13:hardcoded-url",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "This is metadata containing a GitHub homepage URL, not a network request or instruction to transmit data. No network operation occurs at this location."
      },
      {
        "id": "filesystem:SKILL.md:38:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:42:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:46:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:50:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:52:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:56:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:58:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:63:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:66:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:70:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:74:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:75:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:76:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:77:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:78:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:79:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:80:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:81:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:85:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:86:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      },
      {
        "id": "filesystem:SKILL.md:87:path-traversal-sequence",
        "verdict": "false_positive",
        "confidence": 0.99,
        "reason": "The matched text is a relative Markdown reference or a documented workspace path. It does not resolve user-controlled paths or perform filesystem traversal."
      }
    ],
    "semantic_findings": [],
    "critical_findings": [],
    "high_findings": [],
    "medium_findings": [
      {
        "title": "Ruby/shell backtick execution",
        "description": "**Zero-dependency ESP sync (when Resend is the ESP)**: `python3 \"${CLAUDE_PLUGIN_ROOT}/scripts/conne",
        "locations": [
          {
            "file": "SKILL.md",
            "line_start": 52,
            "line_end": 52
          }
        ],
        "review_kind": "capability",
        "source_category": "external_commands",
        "source_severity": "medium",
        "confidence": 0.88,
        "confidence_reasoning": "This documentation instructs an agent to run a Python connector and states that the suppress subcommand mutates Resend when --live is supplied. The operation affects a remote ESP, so execution requires an explicit user confirmation."
      }
    ],
    "low_findings": [],
    "dangerous_patterns": [],
    "files_scanned": 1,
    "total_lines": 88,
    "audit_model": "claude",
    "audited_at": "2026-07-26T10:29:15.294Z",
    "agent_auto_install_policy": "allowed",
    "manual_install_policy": "allowed"
  },
  "content": {
    "user_title": "Build safer email audience segments",
    "value_statement": "Email exports often mix active subscribers, lapsed customers, and people who must not receive messages. This skill converts your own exported data into documented segments and a suppression list with clear confidence labels.",
    "seo_keywords": [
      "Claude email segmentation",
      "Codex email audiences",
      "Claude Code marketing skill",
      "email list segmentation",
      "RFM analysis",
      "lifecycle email segments",
      "suppression list",
      "customer audience builder",
      "CRM CSV segmentation",
      "email deliverability hygiene"
    ],
    "actual_capabilities": [
      "Identifies usable engagement, consent, and order-data columns in a provided export.",
      "Defines behavioral segments such as engaged, cart-abandoner, and lapsed audiences.",
      "Builds RFM tiers when recency, frequency, and monetary fields are available.",
      "Maps subscribers to reusable lifecycle stages using stated rules.",
      "Creates a do-not-mail rule set for unsubscribes, bounces, complaints, and withdrawn consent.",
      "Labels segment sizes as Measured or Estimated and flags missing data as NEEDS_INPUT."
    ],
    "limitations": [
      "It needs user-provided exports or pasted column details to calculate segments.",
      "It does not send campaigns, write email copy, or design automation flows.",
      "It does not validate email authentication, reputation, or spam content.",
      "Live Resend changes require explicit confirmation and appropriate account access."
    ],
    "use_cases": [
      {
        "title": "Prepare a retention campaign audience",
        "description": "Separate active, at-risk, and lapsed subscribers before planning a retention campaign.",
        "target_user": "Email marketer"
      },
      {
        "title": "Create customer value tiers",
        "description": "Turn an ecommerce order export into RFM tiers with transparent rules and missing-data flags.",
        "target_user": "Lifecycle marketer"
      },
      {
        "title": "Improve suppression hygiene",
        "description": "Reconcile exported unsubscribe and bounce signals with consent records before a planned send.",
        "target_user": "CRM operations specialist"
      }
    ],
    "prompt_templates": [
      {
        "title": "Start with an export",
        "prompt": "Build email segments from my attached subscriber export. My goal is retention.",
        "scenario": "Beginner: a single ESP export"
      },
      {
        "title": "Create engagement audiences",
        "prompt": "Using this CSV, define engaged-90d, lapsed, and cart-abandoner segments. Show the rule and measured size for each.",
        "scenario": "Intermediate: behavioral segmentation"
      },
      {
        "title": "Build RFM and lifecycle tiers",
        "prompt": "Use my CRM and order exports to create RFM tiers and lifecycle stages. Flag any required columns that are missing.",
        "scenario": "Intermediate: combined customer data"
      },
      {
        "title": "Reconcile a suppression list",
        "prompt": "Compare these campaign and consent exports. Build a do-not-mail rule set and identify cohorts that need consent verification.",
        "scenario": "Advanced: compliance-focused segmentation"
      }
    ],
    "output_examples": [
      {
        "input": "An ESP export with open date, click date, unsubscribe status, and purchase date.",
        "output": [
          "Engaged-90d: opened or clicked within 90 days; Measured count: 4,120.",
          "Lapsed: no open or click for 180 days; Measured count: 1,860.",
          "Suppression: unsubscribed or hard-bounced; Measured count: 342."
        ]
      },
      {
        "input": "An order export with recency, order count, and revenue fields.",
        "output": [
          "Champion tier: recent purchasers with frequent, high-value orders.",
          "At-risk tier: previously active customers with declining purchase recency.",
          "Each tier includes its source fields, rule, count, and data-quality notes."
        ]
      }
    ],
    "best_practices": [
      "Provide exports with column names and date ranges, not only screenshots.",
      "Review suppression and consent rules before using any segment in a campaign.",
      "Use measured counts where possible and document every estimated rule."
    ],
    "anti_patterns": [
      "Do not treat missing consent records as permission to email a cohort.",
      "Do not create RFM tiers when order recency, frequency, or value data is absent.",
      "Do not store or repeat raw email addresses and other personal data in summaries."
    ],
    "faq": [
      {
        "question": "What data can I provide?",
        "answer": "Provide your own ESP, CRM, analytics, or ecommerce export, or paste its column names and aggregate values."
      },
      {
        "question": "Can it create RFM segments?",
        "answer": "Yes, when your data includes recency, frequency, and monetary fields. Otherwise, it marks RFM as NEEDS_INPUT."
      },
      {
        "question": "Does it send email campaigns?",
        "answer": "No. It defines audiences and suppression rules only."
      },
      {
        "question": "How are segment sizes reported?",
        "answer": "Counts are labeled Measured when calculated from exports or Estimated when inferred with a stated method."
      },
      {
        "question": "How does it handle unsubscribes?",
        "answer": "It includes unsubscribes, hard bounces, complaints, and withdrawn consent in the do-not-mail rule set."
      },
      {
        "question": "Can it update Resend segments?",
        "answer": "The documented connector can sync supported data, but any live mutation requires explicit confirmation and valid account access."
      }
    ]
  },
  "file_structure": [
    {
      "name": "SKILL.md",
      "type": "file",
      "path": "SKILL.md",
      "lines": 88
    }
  ]
}
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall