Reporting
Compare forecast and actuals, spot the biggest levers, and open details only when needed.
1. Select forecast period
Set the scope and target baseline. Then review forecast risk, required action, and short-term drivers.
Forecast vs Target
No valid forecast for Month yet. Run the forecast before reviewing the decision.
Scenario Controls
Test short-term drivers for conversion, average order value, and units per transaction.
Commercial Signals Summary
Use the strongest product, category, availability, and margin signals as context for the forecast decision.
Run the forecast to unlock product, category, and availability drilldowns.
Start Forecast
No historical campaign data available. Load sample data or valid campaign data before running the forecast.
2025 Demand Summary
2025 Delivered
Orders 2025
Conversion Rate 2025
AOV 2025
Open Rate 2025
Clickrate 2025
Delivered 2025
Unsub 2025
Spam 2025
2025 Summary
| Metric | 2025 | 2024 | Var % |
|---|---|---|---|
| Campaigns | 0 | 0 | - |
| Delivered | 0 | 0 | - |
| Orders | 0 | 0 | - |
| Demand | 0,00 € | 0,00 € | - |
| CNV | 0,00% | 0,00% | - |
| Open Rate | 0,00% | 0,00% | - |
| Clickrate | 0,00% | 0,00% | - |
| Unsub | 0 | 0 | - |
| Spam | 0 | 0 | - |
| AOV | 0,00 € | 0,00 € | - |
Year
| Year | Demand | Demand LY | Var % |
|---|
Quarter
| Quarter | 2025 | 2024 | Var % |
|---|
Month
| Month | 2025 | 2024 | Var % |
|---|
Week
| Week | 2025 | 2024 | Var % |
|---|
| Date | Quarter | Month | Week | Campaigns | Delivered | Orders | Demand | Demand LY | Var % |
|---|---|---|---|---|---|---|---|---|---|
| No detail data for the selected quarter/month/week filters. | |||||||||
Promotion Performance Across All Years
Then review the performance view: how promotions perform overall and how demand, CNV, and engagement develop.
Total Promotion Demand (all years)
Last Year Demand
Open Rate (last year)
CNV (last year)
Promotion Demand Trend (all years)
Promotion Conversion Trend (all years)
Promotion x Weekday Matrix
Example demand index by promotion type and weekday. Higher cells indicate stronger historical response windows.
| Promotion | Seasonality | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | Trend |
|---|---|---|---|---|---|---|---|---|---|
| Fullprice + Bookvoucher | Winter / gift peak | 690.000 € | 654.000 € | 618.000 € | 584.000 € | 548.000 € | 515.000 € | 489.000 € | -29,10% |
| 40% Jackets & Coats | Autumn / winter | 520.000 € | 498.000 € | 461.000 € | 424.000 € | 391.000 € | 365.000 € | 338.000 € | -35,00% |
| 30% Sale | Mid-season | 480.000 € | 455.000 € | 431.000 € | 409.000 € | 384.000 € | 361.000 € | 339.000 € | -29,40% |
| Book Cover Sneak Peak + FS | Catalogue launch | 410.000 € | 389.000 € | 367.000 € | 344.000 € | 326.000 € | 302.000 € | 286.000 € | -30,20% |
| Kids Outerwear | Back-to-school | 285.000 € | 272.000 € | 254.000 € | 238.000 € | 219.000 € | 207.000 € | 194.000 € | -31,90% |
| 50% Pullovers & Cardigans | Cold weather | 365.000 € | 342.000 € | 322.000 € | 298.000 € | 276.000 € | 251.000 € | 232.000 € | -36,40% |
| Free Shipping | Activation booster | 310.000 € | 294.000 € | 276.000 € | 259.000 € | 241.000 € | 229.000 € | 214.000 € | -31,00% |
| Clearance Reminder | End of season | 240.000 € | 228.000 € | 214.000 € | 202.000 € | 187.000 € | 176.000 € | 162.000 € | -32,50% |
Monthly Comparison and Promotion Types
Drill into which promotion type currently drives demand or CNV, and how the selected month develops across years.
| Promotion Type | Current Demand | Previous Demand | Demand Var % | Current CNV | Previous CNV | CNV Var % | Campaigns |
|---|---|---|---|---|---|---|---|
| No promotion type trends available. | |||||||
| Year | Campaigns | Demand | Demand vs LY | Delivered | Opened | Open Rate | Clicked | Clickrate | Orders | CNV | AOV | UPT | Unsub | Unsubrate | EUR/Mail |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No monthly data for this promotion or filter selection. | |||||||||||||||
Promotion Demand Trend (June)
Demand vs Last Year (June)
Top 10 Promotion Types by Demand (current year)
Weekly Metrics
Forecast and actuals for the reporting week at a glance: largest levers first, followed by the complete summary row for demand, engagement, and commerce.
Weekly Metrics - Summary
| Metric | Demand | Delivered | Open Rate | CTR | Purch.Rate | AOV | EUR/mail | UPT | AUR | FP-Share |
|---|---|---|---|---|---|---|---|---|---|---|
| Forecast | 125.516 € | 1,7m | 15,60% | 11,51% | 0,07% | 95,96 € | 0,07 € | 3,28 | 29,22 € | 71,01% |
| Actuals | 144.680 € | 1,6m | 11,89% | 14,97% | 0,09% | 100,96 € | 0,09 € | 3,58 | 28,23 € | 78,01% |
| Variance % | +15,27% | -6,21% | -23,81% | +30,06% | +16,81% | +5,21% | +22,90% | +8,89% | -3,38% | +9,86% |
Conversions
Opens & Clicks Unique
Demand Momentum
Top Product Performance
Product Revenue & Quantity
Trigger Email Performance
Sample flow diagnostics inspired by automated lifecycle email reporting: performance first, message detail second.
Delivered
Opens & Clicks Unique
Conversions
Flow Performance
| # | Name | Delivered | Open Rate | CTR | CNV | AOV | Revenue Euro |
|---|---|---|---|---|---|---|---|
| 1. | Valentinespromo - New Subscribers | 16,3k | 74,22% | 28,63% | 38,28% | 77,25 € | 482.576 € |
| 2. | Welcome eMail | 19,5k | 72,46% | 16,70% | 23,36% | 80,47 € | 366.219 € |
| 3. | Blackfriday 2024 | 4,5k | 79,81% | 28,20% | 56,59% | 78,83 € | 199.985 € |
| 4. | Winter-Special 2024 | 4,1k | 82,13% | 32,51% | 51,62% | 70,25 € | 148.568 € |
| 5. | Valentinespromo - Existing Subscribers | 40,9k | 44,33% | 5,39% | 0,55% | 78,56 € | 17.676 € |
| 6. | Extend Blackfriday 2024 | 2,2k | 52,01% | 9,04% | 3,71% | 87,08 € | 7.140 € |
| 7. | Checkout Subscriber | 3,1k | 54,95% | 4,31% | 0,54% | 30,05 € | 511 € |
| 8. | Singles Day 2024 | 1,5k | 82,14% | 30,30% | 0,00% | null | 0 € |
Message Performance
| # | Name | Delivered | Open Rate | CTR | CNV | AOV | Revenue Euro |
|---|---|---|---|---|---|---|---|
| 1. | Email #1 | 10,2k | 81,41% | 24,97% | 42,29% | 79,76 € | 342.582 € |
| 2. | 1# eMail Valentin 25 - New Subscribers | 6,6k | 79,90% | 34,45% | 50,20% | 74,32 € | 244.436 € |
| 3. | eMail Valentin 25 - New Subscribers | 5,9k | 77,74% | 32,16% | 47,05% | 81,78 € | 225.379 € |
| 4. | eMail Blackfriday 2024 | 6,2k | 72,02% | 22,71% | 41,55% | 78,81 € | 204.596 € |
| 5. | eMail Winter Special 24 | 4,1k | 82,13% | 32,51% | 51,62% | 70,25 € | 148.568 € |
| 6. | 1# eMail Valentin 25 - Existing Subscribers | 40,9k | 44,33% | 5,39% | 0,55% | 78,56 € | 17.676 € |
| 7. | 2# eMail Valentin 25 - New Subscribers | 3,9k | 59,42% | 13,60% | 5,16% | 63,17 € | 12.761 € |
| 8. | Email #2 | 4k | 61,74% | 7,20% | 2,14% | 99,87 € | 8.588 € |
| 9. | B - Email #2 | 2,4k | 68,76% | 8,07% | 3,68% | 92,19 € | 8.205 € |
| 10. | A - Email #2 | 2,9k | 60,71% | 8,07% | 2,79% | 84,48 € | 6.843 € |
| 11. | eMail Blackfriday 2024 Extended | 448 | 51,12% | 10,04% | 5,13% | 110,00 € | 2.530 € |
| 12. | Checkout - Opt Out eMail | 2k | 54,97% | 4,53% | 0,71% | 25,32 € | 355 € |
| 13. | Opt-Out Email | 1,1k | 54,89% | 3,94% | 0,28% | 52,12 € | 150 € |
| 14. | eMail Singles Day 24 | 1,5k | 82,14% | 30,30% | 0,00% | null | 0 € |
Tests & Insights
Project cards for automation, migrations, forecasting, AI, and CRM-adjacent data products.
Inhouse Trigger Solution
Replacement of an expensive external trigger solution with a flexible inhouse setup across four touchpoints.
Oracle to Yesmail and Back
Two full platform migrations including data mapping, template migration, and workflow transfer.
Unified Customer Profile
SQL-based customer profile across several systems as a single customer view.
Python-Based Forecasting Method
Custom analytics and forecasting logic for email performance instead of shallow standard reporting.
Google Annotations
Visible promotion information directly in the Gmail inbox before the email is opened.
Responsive Templates & Freemarker
Modular and fully responsive email templates for marketing and transactional communication.
Flash Sales & Dynamic Promotions
Automated flash-sale mechanics with triggers, promotion logic, and inventory checks.
Excel Macros for Sigma Workflows
VBA-based data transformation for promotion management instead of manual preparation.
AI Optimization for Subject Lines
AI logic already used in production for subject lines and preheaders in Germany and the UK.
DE/UK - Enhanced Customer Profile Analysis
Tailor marketing campaigns to specific interests, increasing engagement and conversion rates.
Example: target customers with top category "WM SWIMWEAR" through dedicated swimwear emails.
| E-Mail Use | Revenue | Orders | Units | Avg. Value | Top Category | Second Category | Third Category | Last Order | Avg Days | Customer Value (3Y) | CLV (5Y) |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 38,5k | 371 € | 12 | 23 | 41,18 € | 3 - WM KNIT TOPS | 34 - WM KNIT TOPS | 12 - MN BOTTOMS | 12.02.2024 | 35 | 123 € | 615 € |
| 46k | 1.121 € | 18 | 20 | 62,27 € | 24 - WM BOTTOMS | 23 - WM WOVEN TOPS | 9 - WM KNIT TOPS | 11.03.2024 | 17 | 180 € | 929 € |
| 45,6k | 180 € | 4 | 5 | 45,12 € | 21 - WM SWEATERS | 34 - MN KNIT TOPS | 33 - WM KNIT TOPS | 07.02.2024 | 66 | 135 € | 673 € |
| 54,4k | 163 € | 4 | 5 | 40,84 € | 15 - MN CASUAL SHIRTS | 23 - WM WOVEN TOPS | 14 - MN SLEEPWEAR | 24.09.2023 | 56 | 122 € | 610 € |
| 65,1k | 198 € | 3 | 3 | 66,11 € | 33 - WM KNIT TOPS | 56 - WM FOOTWEAR | 9 - WM OUTERWEAR | 10.03.2024 | 161 | 197 € | 987 € |
| 69,2k | 207 € | 5 | 6 | 41,34 € | 12 - MN BOTTOMS | 14 - MN SLEEPWEAR | 15 - MN WOVEN SHIRTS | 16.03.2024 | 61 | 125 € | 617 € |
| 76,9k | 140 € | 3 | 6 | 46,78 € | 15 - MN CASUAL SHIRTS | 34 - MN KNIT TOPS | 22 - MN SWEATERS | 20.08.2023 | 20 | 140 € | 698 € |
| 89,6k | 197 € | 4 | 4 | 49,26 € | 56 - WM FOOTWEAR | 24 - WM BOTTOMS | 33 - WM KNIT TOPS | 13.11.2023 | 50 | 147 € | 735 € |
| 101,3k | 248 € | 6 | 8 | 41,51 € | 33 - WM KNIT TOPS | 12 - MN BOTTOMS | 19 - WM FOOTWEAR | 07.10.2023 | 6 | 185 € | 824 € |
| 116k | 150 € | 4 | 6 | 37,61 € | 36 - WM KNIT TOPS | 12 - MN BOTTOMS | 17 - MN DRESSSHIRTS | 03.06.2023 | 0 | 112 € | 561 € |
Sales Forecasting
Order frequency and average days between purchases support more precise inventory planning and forecasting.
Customer Segmentation
Revenue and order counts enable clear segmentation of high-value and occasional buyers.
Product Cross-Selling
Secondary and tertiary category insights reveal relevant cross-sell options such as "WM FOOTWEAR" or "MN SLEEPWEAR".
Enhanced Customer Retention
Last-order data identifies at-risk customers early enough to trigger re-engagement before potential churn.
CRM Intelligence Roadmap
Planned extensions that turn customer behavior, campaign signals, product patterns, and data quality into guided CRM decisions.
Unify profile, behavior, lifecycle, campaign, and product context into one decision layer.
Retention, content AI, decisioning, commerce, monitoring, governance, and data quality.
Move from reporting what happened to recommending the next best action before performance changes.
360 Customer Intelligence
A unified customer intelligence layer connecting behavior, purchase rhythm, channel affinity, and lifecycle context.
Churn Signals Before Cancellation
Detect early behavioral patterns that indicate churn risk before customers actively unsubscribe or disengage.
Channel Preference Learning System
Learn whether each customer responds best to email, CRM, promotion-heavy content, product inspiration, or mixed journeys.
Automated Reputation Monitor
Monitor deliverability and sender reputation signals to protect inbox placement before campaign performance drops.
Cross-Sell Timing Detection
Identify when a customer is most likely to accept a complementary product offer based on recent purchase behavior.
Dynamic Subject Line Variants
Generate and test subject-line variants based on campaign goal, customer segment, product category, and lifecycle stage.
Lifecycle Stage Detector
Classify customers into lifecycle stages automatically and adapt CRM messaging to their current journey state.
Reactivation Timing Optimization
Recommend the best timing window for reactivation messages based on prior purchase cadence and inactivity depth.
Predictive Next-Best-Action in CRM
Recommend the next best action per customer or segment, including offer, channel, cadence, and content direction.
Automated Unsubscribe Reason Analyzer
Cluster unsubscribe reasons and behavioral context to reveal preventable friction in cadence, content, or relevance.
Content Performance Feedback Loop
Feed campaign outcomes back into planning so successful products, hooks, and creative angles influence future sends.
Purchase Rhythm Deviation Detection
Detect when customers deviate from their normal buying rhythm and trigger retention or inspiration actions.
RFM Drift Monitor
Track Recency, Frequency, and Monetary drift over time to identify customers moving into higher or lower value bands.
Product Combination Patterns
Discover frequently connected product combinations that can improve recommendations, bundles, and cross-sell logic.
Segment Overlap Analysis
Expose overlapping segments, conflicting targeting rules, and cannibalization risk across audiences.
Seasonal Individual Behavior
Learn customer-specific seasonal patterns instead of relying only on generic campaign-calendar assumptions.
Silent-Before-the-Storm Detector
Identify quiet behavioral phases that often precede a buying spike, churn event, or major engagement shift.
Campaign Cannibalization Analysis
Detect when campaigns compete for the same demand instead of creating incremental revenue.
KPI Anomaly Detection
Flag unusual movements in demand, open rate, CTR, conversion, margin, and unsubscribe metrics automatically.
Cross-Channel Attribution Patterns
Reveal recurring attribution patterns across channels to understand which touchpoints support conversion.
Customer Profile Data Gap Detection
Identify missing, stale, or inconsistent customer-profile fields before they weaken segmentation and personalization.
Week 9 Performance Briefing
What to do this week: frame the forecast, set the promotion focus, and prioritize the strongest category levers.
Both clusters show the strongest mix of forecast, historical demand, and category signal.
Then switch to bundle and free shipping mechanics to protect margin and basket value.
This keeps the week plannable and separates newsletter production cleanly.
AI Category Recommendations
Focused product clusters with short rationale and visual previews instead of long raw tables.
Highest CLV correlation in the customer profile analysis. 35% of top customers have this as their primary category.
Top seller in week 7 with high repeat-purchase rate
Strong flash-sale performance (+19% CNV)
Seasonal spring-transition trend. Historical demand is +8.5% in week 9 vs week 8.
Below-average Q4 performance (-6.01%). Reactivation potential among existing customers.
Click rate +0.64% vs LY in Promotion Insights. Good engagement despite lower demand.
Promotions This Week
Active offers for this week, separated from the core briefing flow.
| Name | Type | Value | Start | End | Segment | Code |
|---|---|---|---|---|---|---|
| Spring Preview 20% | percentage | 20% | Monday | Wednesday | Active Buyers (90d) | SPRING20 |
| Free Shipping Weekend | freeShipping | from 49 EUR | Friday | Sunday | All Subscribers | FREEWEEK |
| Outerwear Bundle Deal | bundle | 2 for 199 EUR | Thursday | Saturday | MN Category Buyers | BUNDLE199 |