/marketing-status

Marketing metrics dashboard. Shows what's working.

Philosophy

If you can't measure it, you can't iterate. Three metrics that matter:

• Traffic source - where people came from

• Activation - did they do the core thing once?

• 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

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

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:

• Instructions for setting up PostHog

• Links to dashboards (PostHog, Stripe, etc.)

• Recommend running /check-observability

Process

• Check which MCPs are available

• Pull metrics from available sources

• Format into dashboard view

• Highlight anomalies or opportunities

• Suggest next actions based on data

MCP Configuration

Add to your Claude config for full MCP integration:

{ "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