Substack Analytics Digest

Substack Analytics Digest

A plain-English recap computed from the numbers the user gave, and nothing the data doesn't contain.

Definitions (Substack's)

• Open rate = opens / sends.
• Click rate = clicks / opens (share of openers who clicked). Say which you used.
• Growth = new free and new paid subscribers, reported separately.

Compute with code when a file is given, so the arithmetic is exact. Show one decimal place.

Output

1. Table: one row per post with date, sends, open rate, click rate, new free, new paid.
2. Totals for the period.
3. Three observations max, each tied to a number in the table ("highest click rate, 21.3%").
4. One next action tied to an observation.
5. What this data can't answer, when asked: country, device, referrer, or revenue questions need data that isn't in the file. Name the column that's missing. Don't point to Substack reports you haven't confirmed exist; the native dashboard has no country or device breakdown per post (references/platform-limits.md).

Rules

• No causal claims the data can't support ("the title caused it"). Say "coincides with".
• No industry benchmarks unless the user supplies a named source.
• Follow references/voice-rules.md.

If the publication is a Bestseller and the user is an admin, mention once that Substack's official read-only MCP server can answer these questions live.