The one Cowork prompt every Substack writer needs

Drop one file into a Cowork project. Run one prompt. Get a complete Substack analytics dashboard -- with data your admin page buries.

No CSV export Free download Requires Claude Pro+
See what it surfaces

Two steps

1
Download and drop
Download the file and save it to a new folder. Open Claude Desktop, go to Cowork, and point it to that folder.
2
Paste and press enter
Sign in to substack.com in Chrome. Then paste this into Cowork and press enter:
Run the Substack analytics workflow

The Claude for Chrome extension must be connected in Claude Desktop Settings. The analysis takes 4-6 minutes and builds itself.

What it surfaces

Not in your dashboard

Recommendations ROI

Which publications send you subscribers -- and whether each relationship is worth keeping. Every recommendation gets a ratio: subscribers received vs sent.

Not in your dashboard

Audience overlap

Which other Substack publications your subscribers also read. The warmest targets for cross-promotions -- their audiences already know your kind of content.

Not in your dashboard

Click anomalies

Posts that dramatically outperformed your average, flagged automatically. Includes a note on whether a recommendations spike likely caused it.

Live data

Health score

An engagement, growth, and revenue score out of 75 points, benchmarked and colour-coded. Built from the same formula as Substack CSV Analytics.

Live data

Open rate trend

Your 10 most recent posts vs your 10 oldest. Flags declining engagement automatically with a plain-language explanation.

Live data

Action list

Three specific things to do this week, generated from your actual data. Every number in the list comes from your dashboard.

Want the full picture?

This workflow reads what is visible in your Substack admin. For per-subscriber analysis -- individual engagement scores, at-risk identification, cohort retention, and churn -- you need your CSV exports.

Substack CSV Analytics parses your exports entirely in the browser. No data leaves your device.

  • Engagement score per subscriber
  • At-risk subscriber identification
  • Cohort retention analysis
  • Free-to-paid conversion funnel
  • Full health score 0-100
  • Historical growth charts
  • Superfan and ghost segments
  • Churn rate and lifetime value
Try Substack CSV Analytics free

Common questions

Do I need a paid Claude plan?
Yes -- Claude Cowork and the Chrome extension require Pro, Max, Team, or Enterprise. The file itself is free.
Does it work for any Substack publication?
Yes, for free and paid publications, as long as you are signed in to your admin in Chrome when you run it.
Is my data private?
Claude reads your admin pages locally through the Chrome extension. Nothing passes through any third-party server.
How is this different from Substack CSV Analytics?
The Cowork prompt gives you live data from your admin -- no export needed, plus three data points unavailable in any CSV (recommendations ROI, audience overlap, click anomalies). Substack CSV Analytics goes deeper on per-subscriber data: engagement scoring, cohort retention, at-risk identification. They are complementary.
Can I schedule it to refresh automatically?
Yes. After the first run, ask Cowork to create a weekly task that refreshes every Monday. The dashboard updates in place and saves a version each time.