• PERFORMANCE
  • ENGAGEMENT
  • TRENDS
  • HUMAN

How to analyze newsletter engagement metrics with your AI

Connect Substack to your AI client to turn raw newsletter data into instant insights. You stop digging through dashboards and start asking questions.

Ask AI about this page

Short answer

How can I analyze my Substack metrics using AI?

Your AI pulls specific post stats and leaderboard data directly from your Substack account. You get a clear view of what's working and what isn't without manual exports. Here is how the data flows.

Data outcomes

Where your insights land.

What you get from your Substack connection.

PERFORMANCE

Identify top posts

The AI identifies which posts drive the most interest. You see exactly which topics resonate with your readers.

ENGAGEMENT

Track click rates

Get specific click metrics for individual posts. This helps you understand how much your audience actually interacts with your links.

TRENDS

Monitor open rates

Compare open rates across different issues. You'll see if your subject lines or sending times are improving over time.

HUMAN

Refine your strategy

The AI provides the numbers, but you decide the next move. Use the data to plan your upcoming editorial calendar.

The workflow

What your AI does when the data arrives.

The AI acts as a bridge between your Substack dashboard and your chat interface.

  1. Fetch post list

    The AI scans your Substack account to find all published content.

    list_posts

  2. Pull specific stats

    Once it finds a post, the AI pulls the exact open and click numbers.

    get_post_stats

  3. Find top performers

    The AI compares all posts to find your most successful content.

    get_leaderboard

  4. Summarize findings

    The AI presents the requested metrics in a plain, readable format.

    list_postsget_post_stats

Try it

Copy these to start.

Use these prompts to begin your analysis.

Starting points

Replace the specific post names or timeframes with your own details.

Substack Connector

You're all set. Choose your MCP client and follow the setup instructions.

Connector linkhttps://edge.vinkius.com/vk_preview_YpBi8hRnrhTPJHoHKTYYVNARu6MIIFCBfFP8XLRm/mcp

Claude Desktop

Follow the steps below to connect in seconds.

  1. 1In Claude Desktop, open Settings → Connectors.
  2. 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
  3. 3Click Add and start a new chat — Substack capabilities are ready to use.
Configuration · claude_desktop_config.jsonCopy
{
  "mcpServers": {
    "substack-mcp": {
      "url": "https://edge.vinkius.com/vk_preview_YpBi8hRnrhTPJHoHKTYYVNARu6MIIFCBfFP8XLRm/mcp"
    }
  }
}
Copy into chat04

  • Show me the stats for my 'Summer Update' post.

  • Which of my posts has the highest open rate?

  • List my top 5 posts based on engagement.

  • Compare the click metrics for my last three newsletters.

  • Claude
  • ChatGPT
  • Cursor
  • VS Code
  • Windsurf
  • Claude Code
  • JetBrains
  • Cline

Start here

Connect Substack once, then ask.

Follow the link to connect your account. Your login stays encrypted on our side, and you can start chatting immediately.

Connect Substack to your AI

FAQ

How the Substack analysis works

  • 01

    Can the AI post new newsletters for me?

    No. The AI can only read and analyze existing data from your Substack account.

  • 02

    Can I use this to change my subscriber list?

    No. The tools only allow for reading post stats and leaderboards; they cannot modify subscribers or settings.

  • 03

    Does the AI see my private drafts?

    The AI only accesses the data provided by the tools, which focuses on published post statistics.

  • 04

    How does it know which post is which?

    It uses the post list to identify specific titles or IDs you mention in your chat.

  • 05

    Can I export this data to a spreadsheet?

    The AI can format the data into a table for you to copy, but it doesn't create files directly.

  • More questions about Substack? The Connector page answers them. See everything the Substack Connector can do

Connect Substack to Claude, Cursor, ChatGPT & more