Back to Homepage

<aside>

Table of Contents

</aside>

Project Background

Company Context

N&N is a US-based authorized electronics retailer specializing in popular gadgets and accessories across global markets. Following a period of rapid expansion, the company is shifting focus toward profitability optimization and operational efficiency by analyzing the performance across 2024-2025 period.

Key Analysis Areas & Project Objectives

Insights and recommendations are provided on the following key areas:

1. Revenue Trends and Profit Drivers
   • Stakeholder: Finance Team
   • Objectives: Understand revenue and profit drivers and identify high-performing product categories to drive Portfolio Rationalization, allowing the team to prioritize high-margin assets and phase out low-contribution products.
   • Metrics: Gross Sales, Net Sales, Final Realized Sales, Gross Profit, Profit Margin %
   • Dimensions: Order Date, Product Category, Product Name
2. Marketing Channel Evaluation
   • Stakeholder: Marketing Team
   • Objectives: Evaluate channel efficiency to optimize budget allocation, shifting focus from high-volume acquisition to high-value customer retention.
   • Metrics: Net Sales, Acquisition Volume, High-Value Customer Count (based on Net Sales)
   • Dimensions: Order Date, Marketing Channel
3. Regional Performance
   • Stakeholders: Marketing Team
   • Objectives: Surface regional trends to move away from "one-size-fits-all" campaigns toward localized marketing strategies tailored to specific geographic demands.
   • Metrics: Net Sales
   • Dimensions: Order Date, Product Category, Region, Marketing Channel
4. Product Quality & Return Analysis
   • Stakeholders: Product Team
   • Objectives: Identify quality-related friction that affects customer experience by analyzing category-specific return rates. This enables the Product Team to further investigate root causes.
   • Metrics: Return Rate, Orders, Revenue Leakage ($)
   • Dimensions: Product Category, Products

<aside>

Executive Summary

Based on the 2024–2025 performance analysis across revenue trends, marketing channels, regional performance, and product returns, the following key findings and recommendations were identified.

Key Findings:

• Revenue grew 16% YoY with two predictable seasonal peaks driving the majority of annual sales. However, Q4 growth is volume-led — AOV declines 8–16% as customers shift toward lower-ticket items and concentrated promotional activity, compressing margins during the highest-revenue period.
• Smartphones and Headphones are the two Core Driver categories, contributing ~$36M combined. Laptops and Tablets underperform on both margin and revenue, flagging them as candidates for portfolio rationalization. Smartwatches represent an underleveraged asset with a 33% margin, the lowest return rate in the portfolio (~7.8%), yet having low contribution to revenue at ~$5M.
• Paid Search dominates acquisition at ~4,000 customers but converts only 9% into High-Value customers. Email, by contrast, converts 65% of its 1,000 acquisitions — revealing a clear quality and quantity comparison across channels.
• Direct channel delivers strong customer quality at 54% High-Value conversion rate, representing high-value revenue that requires no paid acquisition spend.
• APAC contributes 51% of global revenue, anchored by China and India. LATAM shows zero Smartphone sales across the full 24-month period.
• A consistent 8.6% return-driven revenue leakage persists across all categories with no single outlier category, indicating systemic friction that erodes Final Realized Sales company-wide.

Key Recommendations:

• Initiate portfolio rationalization by phasing out the lowest-contributing Laptop and Tablet SKUs, redirecting investment toward Smartphones, Headphones, and Smartwatches.
• Reallocate a portion of Paid Search budget toward Email retention campaigns to improve High-Value Customer conversion and long-term marketing efficiency.
• Introduce a Q4 bundle strategy pairing high-ticket items with lower-ticket accessories to defend AOV during the Year-End volume surge.
• Develop region-specific campaign strategies aligned with local demand patterns, prioritizing Smartphone growth in LATAM after investigation of its absence.
• Launch a cross-functional investigation into systemic return friction, with priority return reduction targeting Samsung Galaxy S24 Ultra and iPhone 15 Pro — the two highest leakage products at $620K and $597K respectively. </aside>

Insights Deep Dive

1. Revenue Trends and Profit Drivers

1.1 Overall Revenue Growth

• Throughout 2024-2025, N&N demonstrated an upward trend, with baseline monthly revenue (outside of peak season) growing from a median of $1.9M in 2024 to $2.2M in 2025
• Revenue follows a predictable seasonal pattern, with two major sales peaks: Back-to-School (Aug–Sep) and Year-End holidays (Nov–Dec).