marketing-dashboard

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Marketing Dashboard

营销仪表盘

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

用于营销指标的统一CLI工具，专为快速状态检查和深度分析而构建。

Quick Start

快速开始

bash

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

bash

./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

```
mktg status
```
- 流量（7天）、收入（30天）、主要错误
```
mktg seo --period [7d|30d|90d]
```
- GSC点击量、展示量、平均排名、热门搜索词
```
mktg ads --period [7d|30d]
```
- 各平台的广告花费、展示量、点击量、单次获取成本（CPA）
```
mktg revenue --period [30d|90d]
```
- 月度经常性收入（MRR）、客户流失率、新订阅数、按产品划分的收入
```
mktg funnel
```
- 转化漏斗：访问 → 注册 → 试用 → 付费

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` )

环境变量	用途
`POSTHOG_API_KEY`	PostHog API密钥
`POSTHOG_PROJECT_ID`	PostHog项目ID
`GSC_SITE_URL`	Search Console属性URL
`GOOGLE_APPLICATION_CREDENTIALS`	服务账号JSON文件路径
`STRIPE_SECRET_KEY`	Stripe API密钥
`ADS_METRICS_PATH`	广告平台指标JSON文件路径
`ADS_METRICS_JSON`	内嵌式广告指标JSON数据
`FUNNEL_STEPS`	PostHog事件逗号分隔列表（默认值： `$pageview,signup,trial,paid` ）

Ads JSON Shape

广告数据JSON格式

json

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

json

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

```
dashboard.py
```
- Click CLI入口（
```
mktg
```
命令）
```
src/posthog_client.py
```
- 基于
```
httpx
```
的PostHog API封装

src/gsc_client.py

- 基于

google-auth

googleapiclient

的Search Console封装

```
src/stripe_client.py
```
- Stripe指标封装工具
```
src/display.py
```
- 基于Rich库的表格与格式化工具

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.

优先使用PostHog获取流量和漏斗数据，调用
```
insights/trend
```
和
```
insights/funnel
```
接口。
GSC仅支持读取操作，需为服务账号配置Search Console访问权限。
Stripe指标基于订阅和发票计算，请保持产品命名的一致性。