Substack Themes Chart Generator: See your blog’s themes change over time

This prompt generates a bar chart showing how the themes you write about on Substack have evolved over time.

Paste your Substack URL in place of the placeholder in the prompt Change color settings to match your design style Run the prompt in your favourite AI tool (I used Perplexity). The AI will automatically: Extract your blog archive Analyze content themes Generate appropriate theme categories Count posts by month and theme Create the visualization Review and refine theme names if needed Download the resulting chart ## Blog to Chart Prompt Analyze this Substack blog: [PASTE YOUR SUBSTACK URL HERE] Step 1: AUTOMATED DATA COLLECTION & THEME ANALYSIS - Scrape all posts from the blog archive - Analyze post titles and content to identify recurring themes - Auto-categorize posts into 3-5 dominant themes based on content analysis - Generate theme names that reflect the blog's unique focus areas - Count posts per theme by month for the last 6-8 months Step 2: CREATE VISUALIZATION   Create a stacked bar chart with these specifications: TITLE & STYLING: - Title: "Themes We Explore" (or customize based on blog name) - Background: White - Chart type: Stacked bar chart DATA STRUCTURE: - X-axis: Last 1-24 months with posts - Y-axis: Number of posts - Data series: Use the auto-identified themes with these color options:   * Primary theme: #2B5722 (dark forest green)   * Secondary theme: #3D3B3B (dark gray)   * Tertiary theme: #FF5900 (bright orange)   * Additional themes: Generate complementary colors as needed AUTOMATED REQUIREMENTS: - Automatically classify each post into identified themes using AI content analysis - Generate monthly counts for each theme - Include legend with theme names and colors - Label axes appropriately - Ensure colors are accessible and distinct THEME CLASSIFICATION PROMPT: "Based on this blog's content, identify the 3-5 main themes by analyzing: - Post titles and content keywords - Recurring topics and subjects - Author's expertise areas - Content focus patterns For each post, determine which theme(s) it belongs to based on: - Primary subject matter - Target audience - Content type and purpose - Keywords and terminology used" OUTPUT FORMAT: 1. List of identified themes with definitions 2. Monthly post counts per theme 3. Interactive stacked bar chart 4. Summary of content strategy insights