marketing-status - Claude MCP Skill

# /marketing-status

Marketing metrics dashboard. Shows what's working.

## Philosophy

If you can't measure it, you can't iterate. Three metrics that matter:
1. Traffic source - where people came from
2. Activation - did they do the core thing once?
3. Conversion - paid or email signup

## Output Format

Show a dashboard like:

```
MARKETING STATUS
================

Traffic (last 7 days)
├─ Direct: XXX
├─ Twitter: XXX
├─ Reddit: XXX
├─ HN: XXX
└─ Other: XXX

Activation
├─ Signups: XXX
├─ Activated: XXX (XX%)
└─ Core action: XXX

Revenue (Stripe)
├─ MRR: $XXX
├─ New this week: $XXX
└─ Churn: $XXX
```

## Data Sources

### PostHog MCP (if configured)
- Traffic by source
- Signup events
- Activation events (custom)
- Core action events (custom)

### Stripe MCP (if configured)
- MRR calculation
- New revenue
- Churn

### Postiz MCP (if configured)
- Post performance
- Engagement metrics
- Scheduled posts

## CLI Script Examples

### PostHog via MCP (Preferred)

When PostHog MCP is configured, Claude can query directly:
- "What are my top traffic sources this week?"
- "Show signup conversion rate by source"
- "Which features have the highest engagement?"

### PostHog via CLI

```bash
# Get pageviews for last 7 days
curl -s "https://app.posthog.com/api/projects/${POSTHOG_PROJECT_ID}/insights/trend/" \
  -H "Authorization: Bearer $POSTHOG_API_KEY" \
  -d '{"events": [{"id": "$pageview"}], "date_from": "-7d"}' | jq '.result[0].data | add'

# Get signups by referrer
curl -s "https://app.posthog.com/api/projects/${POSTHOG_PROJECT_ID}/insights/trend/" \
  -H "Authorization: Bearer $POSTHOG_API_KEY" \
  -d '{"events": [{"id": "signup"}], "breakdown": "$referrer", "date_from": "-7d"}' | jq

# Get feature flag evaluations
curl -s "https://app.posthog.com/api/projects/${POSTHOG_PROJECT_ID}/feature_flags/" \
  -H "Authorization: Bearer $POSTHOG_API_KEY" | jq '.[].key'
```

### Stripe via CLI

```bash
# MRR calculation (active subscriptions)
stripe subscriptions list --status=active --limit=100 | jq '[.data[].plan.amount] | add / 100'

# New revenue this week
stripe balance_transactions list --created[gte]=$(date -v-7d +%s) --limit=100 | jq '[.data[].amount] | add / 100'

# Churn (canceled subscriptions)
stripe subscriptions list --status=canceled --created[gte]=$(date -v-7d +%s) | jq '[.data[].plan.amount] | add / 100'
```

## Fallback (No MCPs)

If MCPs not configured, show:
1. Instructions for setting up PostHog
2. Links to dashboards (PostHog, Stripe, etc.)
3. Recommend running /check-observability

## Process

1. Check which MCPs are available
2. Pull metrics from available sources
3. Format into dashboard view
4. Highlight anomalies or opportunities
5. Suggest next actions based on data

## MCP Configuration

Add to your Claude config for full MCP integration:

```json
{
  "mcpServers": {
    "posthog": {
      "command": "npx",
      "args": ["-y", "@posthog/mcp-server"],
      "env": {
        "POSTHOG_API_KEY": "your-api-key",
        "POSTHOG_PROJECT_ID": "your-project-id"
      }
    },
    "stripe": {
      "command": "npx",
      "args": ["-y", "@stripe/mcp", "--tools=all"],
      "env": {
        "STRIPE_SECRET_KEY": "your-stripe-key"
      }
    }
  }
}
```

## Related Skills

- /check-observability - Audit analytics setup
- /growth-sprint - Weekly marketing ritual
- /check-stripe - Stripe integration audit