OpenParable
Skip to content
← Back to skills

Marketing Dashboard

Apps & Automation
marketing-dashboard

Marketing Dashboard is an Agent Skill for apps & automation published in the majiayu000/claude-skill-registry repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Unified marketing metrics dashboard and CLI. Use when building or running a marketing status dashboard that pulls from PostHog, Google Search Console, Stripe, and ad platforms. Covers traffic, SEO, ads, revenue, and funnel conversion reporting in terminal output.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/majiayu000/claude-skill-registry/blob/HEAD/skills/data/marketing-dashboard/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/marketing-dashboard, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

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

VariablePurpose
POSTHOG_API_KEYPostHog API key
POSTHOG_PROJECT_IDPostHog project id
GSC_SITE_URLSearch Console property URL
GOOGLE_APPLICATION_CREDENTIALSService account JSON path
STRIPE_SECRET_KEYStripe API key
ADS_METRICS_PATHJSON file for ad platform metrics
ADS_METRICS_JSONInline JSON for ad metrics
FUNNEL_STEPSComma 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.