skills/phrazzld/claude-config/marketing-dashboard

marketing-dashboard

SKILL.md

Marketing Dashboard

Unified CLI for marketing metrics. Built for quick status checks and deeper dives.

Quick Start

./dashboard.py status
./dashboard.py seo --period 30d
./dashboard.py ads --period 7d
./dashboard.py revenue --period 90d
./dashboard.py funnel

Commands

  • mktg status - Traffic (7d), revenue (30d), top errors
  • mktg seo --period [7d|30d|90d] - GSC clicks, impressions, avg position, top queries
  • mktg ads --period [7d|30d] - Spend, impressions, clicks, CPA by platform
  • mktg revenue --period [30d|90d] - MRR, churn, new subs, revenue by product
  • mktg funnel - Funnel: visit → signup → trial → paid

Environment

Variable Purpose
POSTHOG_API_KEY PostHog API key
POSTHOG_PROJECT_ID PostHog project id
GSC_SITE_URL Search Console property URL
GOOGLE_APPLICATION_CREDENTIALS Service account JSON path
STRIPE_SECRET_KEY Stripe API key
ADS_METRICS_PATH JSON file for ad platform metrics
ADS_METRICS_JSON Inline JSON for ad metrics
FUNNEL_STEPS Comma list of PostHog events (default: $pageview,signup,trial,paid)

Ads JSON Shape

{
  "google": {"spend": 123.45, "impressions": 10000, "clicks": 321, "cpa": 12.34},
  "meta": {"spend": 98.76, "impressions": 9000, "clicks": 210, "cpa": 15.67}
}

Files

  • dashboard.py - Click CLI entrypoint (mktg)
  • src/posthog_client.py - PostHog API wrapper via httpx
  • src/gsc_client.py - Search Console wrapper via google-auth + googleapiclient
  • src/stripe_client.py - Stripe metrics wrapper
  • src/display.py - Rich tables and formatting

Notes

  • Prefer PostHog for traffic and funnel. Uses insights/trend and insights/funnel.
  • GSC reads only. Requires Search Console access for the service account.
  • Stripe metrics are computed from subscriptions and invoices; keep product naming consistent.
Weekly Installs
21
GitHub Stars
5
First Seen
Jan 29, 2026
Installed on
cline21
github-copilot21
codex21
gemini-cli21
cursor21
opencode21