Something went wrong!
Hang in there while we get back on track
Year-over-Year Decline Analysis
Year-over-year comparison showing declining performance across revenue, orders, and conversion rate. Demonstrates how the skill handles negative growth scenarios with concern flagging, root cause analysis, and critical recommendations for turnaround.
Input
What you provide to the skill
YoY comparison 2024 vs 2023: date,revenue,orders,conversion_rate
2023-01-01,245000,3100,0.042
2024-01-01,218000,2750,0.038
Output
What the skill generates for you
YEAR-OVER-YEAR COMPARISON REPORT
2024 vs 2023
KEY PERFORMANCE INDICATORS
Metric 2024 2023 Change % Change Trend
Revenue $218,000 $245,000 -27,000 -11.0% 📉📉
Orders 2,750 3,100 -350 -11.3% 📉📉
Conversion Rate 3.8% 4.2% -0.4pp -9.5% 📉
BIGGEST CHANGES
📉 Order Volume: DOWN 11.3% (-350 orders)
Orders dropped from 3,100 to 2,750, a decline of 350 orders.
Analysis:
- Significant order volume decline of 11.3% YoY
- Combined with conversion rate drop suggests funnel issues
Recommendation:
- Audit marketing channels and acquisition funnel
- Review pricing changes or competitive dynamics
- Analyze customer feedback for product/service issues
📉 Revenue: DOWN 11.0% (-27,000)
Revenue declined from $245K to $218K, a loss of $27K.
Contributing factors:
- Order volume: -350 orders (-11.3%) - declining demand
- Average order value: $79.27 (2024) vs $79.03 (2023)
- AOV impact: +0.3%
Assessment: CONCERNING - Double-digit decline in both revenue and orders
signals weakening demand or competitive pressures.
📉 Conversion Rate: DOWN 9.5% (-0.4 percentage points)
Conversion rate fell from 4.2% to 3.8%.
Analysis:
- Conversion efficiency declined despite smaller absolute change
- This compounds the order volume problem
Recommendation:
- Conduct user experience audit
- Test checkout flow improvements
- Review site performance and load times
EXECUTIVE SUMMARY
2024 Performance: WEAK YEAR
2024 underperformed 2023 across all key metrics. Revenue declined 11.0% YoY
to $218K, driven by an 11.3% drop in order volume and a 9.5% decline in
conversion rate.
Key Concerns:
- Revenue down $27K year-over-year (-11.0%)
- Order volume decreased by 350 orders (-11.3%)
- Conversion rate dropped from 4.2% to 3.8% (-9.5%)
- All metrics trending negatively indicates systemic issues
Critical Recommendations:
- Immediate deep-dive analysis into customer acquisition and retention
- Competitive analysis to identify market share losses
- Customer surveys to understand declining conversion
- Review pricing strategy and value proposition
- Audit marketing spend efficiency and channel performance
[Visualization saved: comparison_chart.png]
About This Skill
Generate executive-ready MoM/QoQ/YoY period comparison reports with automated growth rate calculations, variance analysis, formatted tables, and visualizations to identify key business metric changes.
View Skill DetailsMore Examples
E-commerce Monthly Revenue Comparison
Month-over-month comparison for an online retailer tracking revenue, orders, and customers. Demonstrates standard MoM analysis with growth calculations, contributing factor breakdown, and actionable recommendations for a positive growth scenario.
SaaS Quarterly Metrics Board Report
Quarter-over-quarter analysis for a SaaS company tracking MRR, new MRR, churned MRR, and customer count. Shows board-ready formatting with net new MRR calculations, churn analysis, and strategic recommendations for Q4 planning.