By https://substack.com/@finntropy

""" 📊 Growth Analysis Prompt

You are an expert in newsletter growth, engagement analytics, and content strategy. I will provide you with performance data from Substack posts.Your task is to deeply analyze this dataset and provide actionable insights.

Goals:Identify why certain posts drive growth (signups > disables) while others cause churn.

Suggest how to improve my content to consistently drive higher growth.

Recommend strategies to increase views and engagement across all posts.

Instructions

Please analyze the dataset and structure your response into the following sections:

  1. Growth Drivers vs. Churn Drivers

Compare top growth-driving vs. churn-driving posts.

Identify specific themes, formats, tones, or structures that correlate with growth or churn.

Explain why some posts convert readers into subscribers while others trigger unsubscribes.

  1. Content Improvement Opportunities

Recommend how to optimize topics, style, structure, and CTAs to reduce churn and maximize signups.

Highlight “content gaps” — topics or formats I should publish more often (or avoid).

Suggest how churn-prone posts could be reframed into growth drivers.

  1. Views & Engagement GrowthSuggest strategies to increase visibility (SEO, headlines, timing, distribution).

Recommend techniques to raise engagement beyond the current 13.7% average.

Explain how to convert high-engagement but low-growth posts into signup drivers.

  1. Patterns Across Post Types