Quavren Electronics
DTC electronics brand, heavy returns/refunds modeling
About Quavren Electronics
Industry
DTC electronics e-commerce
Company size
Growth-stage DTC brand
Commercial focus
Gross-to-net, returns, refunds
Selling footprint
U.S. online; selective Canada
Assortment
Electronics, accessories, open-box
Data scope
14 tables, 1.17M rows
Quavren Electronics is a fictional DTC electronics brand built for BI demos that need orders, fulfillment, returns, refunds, inventory, campaign quality, and customer cohorts in one model. The company sells personal electronics, charging accessories, audio gear, smart-home add-ons, and certified open-box units through owned digital channels, giving buyers a practical story for gross-to-net leakage, product-quality drilldowns, refund-cycle pressure, and inventory availability.
Operating Profile
- Commerce model: DTC order lifecycle from acquisition channel to order, shipment, return authorization, refund transaction, and inventory restock outcome
- Product posture: fast-moving assortment varying by category, price band, defect exposure, and open-box eligibility
- Returns posture: returns are common enough to move margin and workload, with the heaviest weeks following holiday peaks and launches
- Fulfillment posture: regional fulfillment centers create delivery-time, split-shipment, carrier, and stockout differences that should show up in analysis
- Buyer use case: dashboards and drillthroughs across gross sales, net revenue, product quality, refunds, and cohorts
Recent Business Events
- 1Holiday promotions raised order volume but created a new-year return spike across audio and smart-home categories.
- 2The open-box program improved recovery value for lightly used returns but complicated refund and restock reporting.
- 3New bundle campaigns increased average order value, while compatibility-related returns exposed weak product-detail content in several accessory families.
- 4Daily inventory review grew in importance as stockouts and inspection backlogs changed which SKUs could be promoted safely.
These are the operating questions this kit is optimized to answer first.
Gross sales, discounts, refunds, net revenue, shipping revenue, and gross-to-net leakage
Order volume, average order value, items per order, repeat purchase rate, and cohort retention
Return rate, refund rate, exchange rate, restock rate, and return cycle time
Product category return exposure, defect reason mix, compatibility returns, and open-box recovery
Fulfillment latency, split-shipment rate, delivery exception rate, and warehouse service level
Inventory availability, stockout days, sell-through, and returned-unit restock outcomes
Embedded Analytical Stories
Gross-to-net revenue bridge
Move from gross orders to discounts, refunds, shipping fees, and net revenue by cohort.
Returns root-cause drillthrough
Drill from return-rate spikes into product, return reason, disposition, and recovery.
Marketing quality check
Compare campaigns by acquisition volume, repeat behavior, refund exposure, and net contribution.
Fulfillment friction review
Connect stockouts, split shipments, and delivery delays to returns and refund cycle time.