Skip to content
Sprint

eBay Store Sprint: Live KPIs in 14 Days

Retail / eCommerce — Centralized eBay data, tracked profit margins, and clear category-level trends.

14,000 listings. 4,300 sales. One dashboard that finally made sense.

14,000+
Active listings at engagement start
4,300
Items sold in the prior 12 months
12 months
Clean year of history to baseline margins

The Challenge

With 14k active listings and a fresh 12-month track record, the seller needed more than sales totals — they needed truth on profit. Exports lived in separate places (eBay, PayPal, shipping) and reconciling fees, item costs, and postage was eating hours every week.

  • ⚙️ Multiple CSVs (eBay, PayPal, USPS/PirateShip) without a unified model
  • 🕒 Time sink reconciling fees, COGS, and shipping deductions
  • 📉 No live SKU/category view of margin or trend velocity

The Ironhide Approach

We built a refreshable reporting hub: clean the exports with Power Query, model in Power BI, and automate updates via a shared file hub. We also layered public category benchmarks to contextualize performance.

Power BI Excel Power Query OneDrive Power Automate Marketplace Benchmarks

The Solution

In two weeks, we delivered live KPIs — profitability, sales velocity, category ROI, and week-over-week patterns — all updating automatically. The seller stopped counting rows and started seeing patterns.

  • ✅ Net profit per SKU (COGS, fees, shipping all-in)
  • ✅ Top categories by ROI and contribution margin
  • ✅ 30- / 90-day trend analysis with seasonality cues
  • ✅ Sales vs COGS with fee impact attribution

Built from the Ground Up

Every clean dashboard sits on top of a modeled, governed dataset. Here’s the reality behind the scenes.

Raw data table with orders, items, buyers, and shipping fields in Power BI
Raw data reality — consolidated orders, items, buyers, and shipping fields.
Power BI model view showing related tables and connectors
Structured model — relationships that drive reliable KPIs and drilldowns.

Visual Showcase

Representative frames from the report. To protect sensitive details, we favor visuals and totals over personally identifiable table rows.

Dashboard navigation page with report sections
Custom navigation — one click from chaos to clarity.
Slide 1 of 4

The Impact

  • ⏱️ ~90% reduction in manual reporting time
  • 📊 SKU-level truth on profit and category ROI
  • 🔁 Automated refresh via shared hub
  • 💡 Clear reinvest decisions based on margin velocity

Tools

Power BI Excel Power Query OneDrive Power Automate Public Marketplace Data

Ready to see your numbers the Ironhide way?

Start Your Data Clarity Sprint →