Sales & Customer Insights Dashboard for a Skincare eCommerce Brand

• Analyze monthly sales and average order value (AOV)

• Identify top-performing products and categories

• Understand customer segments and geographic distribution

• Present findings in an executive-friendly visual format

• Google Looker Studio (dashboard creation & visualization)

• Google Sheets / CSVs (data prep)

• Dummy datasets: Orders, Products, Customers

• Total Revenue: $911.98

• Total Orders: 10

• AOV: $91.20

• Main Market: United States

Top Products by Revenue

• Hair Dryer - $200.00

• Essential Oils Pack - $130.00

• Anti-Aging Cream - $120.50

These 3 products alone account for over 50% of total revenue. The Hair Dryer generated the highest revenue from a single transaction, highlighting its potential as a high-ticket item.

Most Sold Product by Quantity

• Lip Balm – 2 units sold (the only product with >1 quantity in a single order)

Skincare Category Performance

• Skincare products such as Vitamin C Serum, Green Tea Cleanser, Night Cream, and Moisturizer were all purchased once.

• While no single skincare item stands out, the category shows broad interest, indicating a potential for bundling or upselling.

• Buyer segments include a mix of new, returning, and loyal customers.

• Female shoppers dominate the customer base, aligning with beauty and wellness industry benchmarks.

• The presence of returning and loyal customers suggests early signs of customer retention.

• Main market: The United States is the top-performing region in both order count and revenue.

• Secondary markets: Canada, United Kingdom, Germany, and France, each with one recorded order.

1. Highlight High-Value Products: Focus marketing on bestselling high-ticket items like the Hair Dryer and Essential Oils Pack.

2. Create value bundles for Skincare: Group together popular items and sell together in order to raise Average Order Value.

3. Reach out and retain Loyal Customers: Create automated marketing email flows to engage returning and loyal segments with reorder reminders, loyalty perks or discount codes.

4. US-Centric Strategy: Continue targeting the U.S. as the core market while testing ads in Canada.

5. Launch Retargeting Campaigns: Especially for visitors who bounced but didn’t purchase high-ticket items.

6. Monitor Product Reviews: Since many products only sold once, gather feedback or incentivize reviews to discover what could scale.