Email Marketing 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick email-marketing analytics

Email Performance Analytics Dashboard

Build a live ShopifyQL report pulling actual revenue-per-email and campaign performance data, plus a framework for tracking and benchmarking.

đź“‹ Prompt
Run in Sidekick
Create an email performance analytics framework:

Brand name: [YOUR BRAND NAME]
Email platform: [KLAVIYO/MAILCHIMP/SHOPIFY EMAIL/OMNISEND/OTHER]
Monthly email sends: [APPROXIMATE NUMBER OF CAMPAIGNS AND FLOWS]
Current tracking: [WHAT METRICS YOU CURRENTLY MONITOR]
Biggest question: [WHAT YOU MOST WANT TO UNDERSTAND ABOUT EMAIL PERFORMANCE]
Industry: [YOUR PRODUCT CATEGORY FOR BENCHMARK COMPARISON]

First, pull the live data: run a ShopifyQL query against this store’s actual orders and email/marketing-attribution data to calculate current revenue per email, campaign-level conversion, and list growth for the stated monthly send volume. Use these real numbers as the baseline throughout the framework below, rather than placeholder figures.

Build a complete analytics framework:


  Core Metrics to Track:
    
      Open rate (and limitations after Apple MPP)
      Click-through rate and click-to-open rate
      Conversion rate (clicks to purchases)
      Revenue per email and revenue per recipient
      Unsubscribe rate and spam complaint rate
      List growth rate (net new subscribers)
      Bounce rate (hard vs. soft)
    
  
  Industry Benchmarks:
    
      Provide typical ranges for e-commerce in the specified category
      Define what “good,” “average,” and “needs improvement” looks like for each metric
      Explain which benchmarks matter most for the business stage
    
  
  Weekly Reporting Template:
    
      Table format with last week vs. previous week vs. 4-week average
      Campaign-level breakdown
      Flow performance summary
      Top performing email by revenue
      Worst performing email for review
      List health snapshot (growth, churn, engagement ratio)
    
  
  Monthly Deep Dive:
    
      Revenue attribution analysis (email vs. other channels)
      Segment performance comparison
      Flow conversion funnel analysis
      Content type performance (what topics and formats drive results)
      Send time and day performance patterns
    
  
  Action Framework:
    
      If open rate drops below [X], do [specific action]
      If click rate drops below [X], do [specific action]
      If unsubscribe rate exceeds [X], do [specific action]
      If list growth stalls, do [specific action]
    
  


Include formulas for calculating each metric manually if needed.
Suggest free and paid tools for deeper analytics beyond the email platform.
Provide a quarterly review checklist for strategic adjustments.

How to Use

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions