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
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
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions