Business Intelligence · Profitability

From sales reporting to margin-led decisions

A monthly operating view that turned scattered data into decisions about what to scale, defend or correct.

Period
July 1–October 27, 2025.
Baseline
July: $96,842.56 in sales and $15,624.09 in estimated net profit.
Final outcome
October 1–27: $312,480 in sales and $62,314.45 in estimated net profit.

01

Client and context

An ecommerce portfolio anonymized for confidentiality, observed from July through October 27, 2025 in Sellerboard. The objective was not another dashboard—it was understanding what explained the economic outcome.

Evidence note

Brand anonymized for confidentiality. Results observed in Sellerboard; the October cutoff covers 27 days and is not a complete calendar month.

02

Problem and diagnosis

Sales growth could look healthy even when products depended too heavily on advertising, discounts or insufficient margin. Without a combined view, volume risked being confused with profitability.

Diagnosis

I organized the reading by month and connected sales, media spend, costs, refunds and estimated net profit. I then separated traffic, conversion, media-efficiency and economic constraints.

03

My role

I built the monthly view, defined diagnostic criteria and prioritized actions by product. Final inventory and operational decisions were coordinated with the account team.

04

Decisions and interventions

01

One economic counterweight

I used estimated net profit alongside sales to avoid rewarding growth without margin.

02

Cause-led diagnosis

I separated demand, conversion, media and cost problems instead of applying the same fix to the full portfolio.

03

Prioritization

I classified products by opportunity, risk and real capture capacity—not revenue alone.

04

Monthly cadence

I documented consistent cutoffs and flagged that October contained 27 days to avoid a misleading comparison.

EVIDENCE

Visual evidence

Monthly sales and estimated net-profit evolution
Monthly sales and estimated net-profit evolution

05

Results

$96,842.56→ $312,480 in sales
$15,624.09→ $62,314.45 estimated net profit
Period:July–October 27, 2025

The portfolio moved from $96,842.56 in sales and $15,624.09 in estimated net profit in July to $312,480 and $62,314.45 at the October 27 cutoff. The system's value was making commercial and economic growth visible together.

Source: Sellerboard — Caso2.jpeg

06

What I learned

A dashboard is useful when it changes decision order. The relevant question is not only what a product sold, but how much of that outcome remains defensible after media, costs and operational constraints.

Next step

Need to understand which part of your growth is profitable?

I can build a view that connects sales, investment and margin to prioritize the portfolio with explicit criteria.

Software used or related

  • Excel
  • Sellerboard

Topics

  • Business Intelligence
  • Ecommerce profitability
  • Profit and loss analysis
  • Sales analysis
  • Portfolio prioritization
  • Ecommerce analytics

Related work

Next step

Want to apply this approach to your brand or team?

Book a 30-minute call, review my CV or email me.