Something went wrong!
Hang in there while we get back on track
Regional Sales Trends with MoM and YoY Growth
Comprehensive regional performance analysis showing month-over-month changes, year-over-year growth rates, seasonal patterns, and specific recommendations for underperforming regions.
Input
What you provide to the skill
I have a CSV file at /tmp/regional_sales.csv with columns: date, region, product_category, revenue, units_sold, customer_count. How have regional sales trends changed month-over-month with year-over-year growth rates?
Output
What the skill generates for you
==========================================================================================
REGIONAL SALES TRENDS: MONTH-OVER-MONTH & YEAR-OVER-YEAR ANALYSIS
REGIONAL PERFORMANCE SUMMARY (Last 6 Months)
Region Avg Monthly Avg MoM Avg YoY Trend
Revenue Change Growth
West $ 2,237,270 2.4% 15.3% Growth
Northeast $ 2,105,760 2.6% 14.9% Growth
Midwest $ 1,544,809 1.3% 14.8% Growth
Southwest $ 1,466,399 2.2% 17.4% Growth
Southeast $ 1,370,607 2.5% 14.1% Growth
DETAILED MONTHLY TRENDS BY REGION (2024)
Northeast:
Month Revenue MoM Change Units Sold Customers
Jan 2024 $ 2,911,135 +32.1% 25,420 12,034
Feb 2024 $ 3,145,786 +8.1% 29,580 13,049
Mar 2024 $ 3,478,684 +10.6% 31,474 14,534
Apr 2024 $ 3,053,444 -12.2% 28,710 13,521
May 2024 $ 3,069,870 +0.5% 27,827 13,019
Jun 2024 $ 2,386,197 -22.3% 22,794 10,464
Jul 2024 $ 2,296,864 -3.7% 21,201 10,030
Aug 2024 $ 1,943,149 -15.4% 19,102 8,689
Sep 2024 $ 1,741,843 -10.4% 15,374 7,047
Oct 2024 $ 1,876,088 +7.7% 18,010 8,571
Nov 2024 $ 2,135,860 +13.8% 19,371 8,633
Dec 2024 $ 2,640,755 +23.6% 24,134 10,937
==========================================================================================
KEY INSIGHTS & RECOMMENDATIONS
-
REGIONAL PERFORMANCE RANKINGS:
- WEST leads with $2.2M avg monthly revenue (H2 2024) and 15.3% YoY growth
- NORTHEAST second at $2.1M monthly with 14.9% YoY growth
- SOUTHEAST trailing at $1.4M monthly with 14.1% YoY growth (39% below West)
-
YEAR-OVER-YEAR GROWTH PATTERNS:
- All regions showing positive YoY growth (14-17% range)
- SOUTHWEST highest YoY growth at 17.4% - emerging growth market
- Consistent growth suggests strong market conditions across all territories
- West and Northeast maintaining leadership positions year-over-year
-
MONTH-OVER-MONTH VOLATILITY:
- Strong seasonal patterns: Q1/Q4 peaks, Q3 summer decline across all regions
- January shows strongest MoM jumps (+28-40%) recovering from December baseline
- Summer months (Jun-Sep) experience consistent declines of 10-20% MoM
- Q4 recovery evident with October showing 6-10% MoM gains accelerating through December
-
CRITICAL OPPORTUNITIES:
- SOUTHEAST & SOUTHWEST underperforming by $700K-900K monthly vs top regions
- Southeast showing most concerning pattern: sustained Q3 decline without full Q4 recovery
- Bringing underperformers to median would add $43M annually
- Focus sales resources on product mix and customer acquisition in weak regions
-
ACTIONABLE RECOMMENDATIONS:
- Conduct sales audit in Southeast/Southwest to identify root causes of performance gap
- Replicate West region strategies (product mix, sales tactics) in lagging areas
- Address Southeast’s structural weakness: customer count 40% below West in peak months
- Increase marketing investment pre-Q1 to maximize seasonal peak performance
- Monitor MoM trends closely for early detection of regional declines
==========================================================================================
About This Skill
Upload business data and ask questions in plain English to get instant insights, visualizations, and trend analysis without BI tools or SQL knowledge.
View Skill DetailsMore Examples
Customer Segment Profitability Analysis
Identifies most profitable customer segments with margin analysis, profit-per-customer calculations, regional breakdowns, and specific acquisition budget allocation recommendations with expected ROI.
Top Products by Revenue Analysis
Analyzes quarterly product performance showing revenue rankings, market share percentages, YoY trends, and momentum indicators with actionable recommendations for portfolio optimization.