VoltEdge E-commerce Analysis

Table of Contents

• Background
• Key Analyses
• Dataset Entity Relationship Diagram (ERD)
• Overall Trend in Sales 2019-2022
• Month-over-Month Order Volume Growth Rates
• Loyalty Program
• Refund Rates – Apple Products
• Key Takeaways
• Recommendations by Team

Background

VoltEdge began in 2018 as a small online electronics retailer and has since grown into a global e-commerce brand with nearly 88,000 customers. Through its website and mobile app, the company connects customers to top tech products from brands like Apple and Samsung. With more than 108,000 orders, the company has generated over $28 million in sales.

A little over a year after its founding, VoltEdge experienced a significant surge in sales during the COVID-19 pandemic, as global demand for remote work and home technology solutions increased sharply. However, as the pandemic-driven demand subsided, the company began to see a notable decline in sales through 2021 and 2022.

In response, VoltEdge’s marketing, operations, and product teams sought to better understand the key factors driving these changes in performance. The following analysis examines company data from 2019 through 2022 to identify trends, assess the effectiveness of marketing and product initiatives, and provide actionable insights to guide future growth strategies. The stakeholders want to focus on the following:

Key Analyses

• Overall sales trends
• Month-over-month seasonal growth rates in sales
• Loyalty program performance
• Apple products – refunds rates, total number of refunds, and average order values (AOV)

Dataset Entity Relationship Diagram (ERD)

VoltEdge's dataset is structured as shown in this diagram.

Overall Trend in Sales 2019-2022

• Sales surged in 2020, primarily due to pandemic-related shifts in consumer behavior.
• Beginning in 2021, sales declined as pandemic-driven purchasing slowed.

Total Sales	Total Order Volume	AOV
$28M	108K	$260

Month-over-Month Order Volume Growth Rates

• Varied significantly over the analysis period, reflecting external market conditions and shifts in consumer behavior.
• Highest growth rate 46.2% in March 2020
• Lowest growth rate -46.9% in October 2022
• Seasonality patterns:
  • Positive growth in November and December
  • Negative growth in February and October

Loyalty Program

• Initially, members had less sales volume over non-members, indicating limited early adoption and engagement.
• Beginning in March 2021, the program gained traction
• By the end of 2022, however, member sales again declined, signaling waning engagement and the need for renewed incentives.

Refund Rates – Apple Products

• Notable differences in refund rates, average order value (AOV), and number of refunds.
• MacBook had the highest AOV of $1,588, but it also exhibited the highest refund rate of 11.4%.
  • Suggests potential issues that may be affecting customer satisfaction.

Key Takeaways

• 2020 growth surge unsustainable post-pandemic.
• Seasonality patterns should be anticipated and leveraged.
• Loyalty program shows promise but needs re-engagement strategies.
• The MacBook requires a deeper quality and satisfaction analysis.
• Data-driven adjustments in marketing, product, and sales will be critical to long-term recovery and growth.

Recommendations by Team

Marketing Team Goal: Reignite demand, strengthen customer loyalty, and stabilize sales throughout the year. Re-engage loyalty program members through personalized email and in-app campaigns. Exclusive discounts, early access to new products, tier-based rewards, targeted marketing campaigns, personalized offers Target seasonal demand spikes (November–December). Increase ad spending and promotional campaigns before these months. Offer bundled discounts or limited-time offers to boost AOV. Mitigate seasonal slumps (February and October). Flash sales, referral bonuses, or “upgrade events” Gather customer feedback from refund-related surveys to identify product experience issues that could inform both product and customer communication strategies.

Product Team Goal: Improve customer satisfaction, reduce refund rates, and align products with evolving market needs. Investigate high refund rates for MacBooks. Analyze return reasons (defects, performance issues, unmet expectations, etc.) Partner with customer support to identify recurring complaints. Enhance product quality checks and pre-purchase information. Provide clearer product specs, comparison guides, or compatibility information online Use post-purchase surveys to gauge satisfaction and identify early indicators of dissatisfaction. Introduce extended warranties or support plans to increase buyer confidence, particularly for high-priced items like MacBooks.

Sales Team Goal: Increase sales and capitalize on existing customer base. Leverage the loyalty program as a retention and upselling tool. Offer bonus points for multi-product purchases or referrals. Use historical sales data. Forecast demand for seasonal peaks and adjust inventory accordingly. Identify high-value customers and offer them exclusive upgrade offers. Collaborate with Marketing to cross-sell and upsell during known high-growth months (e.g., bundle accessories with popular items). Train the sales team to proactively communicate post-purchase support options and reduce potential refund triggers. Monitor performance metrics (sales, order volume, AOV) regularly to track the impact of incentive programs.