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.