Many e-commerce entrepreneurs in Senegal steer by instinct. They vaguely know that "it is working" or that "it is sluggish," but they do not know why, nor what to fix. The result: they spend in the wrong place, keep products that lose money, and miss growth levers. A well-built KPI dashboard changes everything: it turns fog into decisions. Here is how to build it, simply, with the indicators that really matter in Senegal.
Why steer by the figures
Without figures, you react to the emotions of the moment: a good month elates you, a bad one panics you. With KPIs, you see trends, you isolate causes and you decide coolly. The goal is not to have 50 indicators, but the 7 or 8 that really drive your business. A good dashboard fits on one page and updates every week.
KPI 1: revenue and its breakdown
Gross revenue says little on its own. Break it down: by product, by acquisition channel, by delivery zone, by new versus returning customer. It is this breakdown that reveals where growth is and where loss hides. A stable revenue can hide a collapsing product offset by an exploding one: without breakdown, you do not see it.
KPI 2: average order value
Average order value = total revenue / number of orders. It is one of the fastest levers to act on. Increasing the average order value from 15,000 to 18,000 FCFA is 20 percent more revenue without a single extra customer. Levers: upsells, bundles, free delivery threshold, suggested complementary products. Track it every week and test actions to push it up.
KPI 3: conversion rate
Conversion rate = number of orders / number of visitors, as a percentage. If 2,000 people visit and 40 buy, your rate is 2 percent. In Senegal, a good rate varies by channel, but watching its trend is more useful than aiming for an absolute figure. A drop in the rate signals a problem: price, trust, buying journey, payment. It is your leak detector.
KPI 4: the CAC
CAC = total marketing spend / number of new customers acquired. It is the cost to win a customer. Track it by channel: if WhatsApp and referral give you a CAC of 1,500 FCFA and ads a CAC of 8,000 FCFA, you know where to put the energy. A CAC that rises without a margin increase is a warning signal.
KPI 5: LTV (customer lifetime value)
Customer lifetime value measures what a customer brings in margin over their entire relationship with you. Simple approximation: average margin per order times the average number of orders a customer makes over their lifetime. If a customer places on average 3 orders at 6,000 FCFA of margin, their LTV is 18,000 FCFA. The reigning rule of e-commerce: LTV must be worth at least 3 times the CAC. Below that, you are buying customers at a loss.
KPI 6: margin
Revenue flatters the ego, margin pays the bills. Track gross margin (after product cost) and ideally net margin (after marketing, delivery, payment fees, overheads). Many Senegalese stores show a nice revenue and lose money because delivery and payment fees eat everything. Calculate margin per product: you will often discover that your best-sellers by volume are not your best-sellers by profit.
KPI 7: cancellation rate and the cash-on-delivery trap
This is the specifically African KPI never to forget. Cash on delivery remains common, and it generates cancellations: the customer is not there, changes their mind, or stops answering. Cancellation rate = cancelled or refused orders / orders placed. A rate of 25 percent on cash on delivery destroys profitability, because you pay the courier for nothing and the product comes back.
Reduction levers:
- Systematic WhatsApp confirmation before dispatch.
- Encouraging Wave or Orange Money prepayment with a small benefit.
- Filtering zones and customers with a high failure rate.
Track this rate closely: it is often the difference between a profitable store and a store that exhausts itself.
Building the dashboard, simply
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
No need for an expensive tool. A structured spreadsheet is enough at launch:
- One row per week, one column per KPI.
- Updated every Monday with the figures of the past week.
- A "decisions" area: for each KPI in the red, a decided action.
Your store's back office provides most of the data (revenue, orders, conversion). Your Wave and Orange Money statements complete it. What matters is not sophistication, but consistency and turning figures into actions.
Mini case study: Ndeye's fashion store
Ndeye showed a monthly revenue of 4,200,000 FCFA and thought she was performing well. When building her dashboard, three truths appeared. First, her cancellation rate on cash on delivery reached 28 percent: she paid for lost deliveries every week. Then, her average order value stagnated at 14,000 FCFA with no upsell at all. Finally, two flagship references by volume had near-zero net margin once delivery was deducted.
Actions decided on the figures: WhatsApp confirmation before dispatch and a prepayment incentive (cancellations brought down to 11 percent), bundles and free-delivery threshold (average order value up to 17,500 FCFA), and repositioning of the two low-margin products. In two months, revenue rose only 9 percent, but net margin jumped 41 percent. The lesson: it is not revenue that you steer, it is margin, and only KPIs make it visible.
Summary: the decision rules
- Track 7 to 8 KPIs, not 50: broken-down revenue, average order value, conversion, CAC, LTV, margin, cancellation rate.
- LTV must be worth at least 3 times the CAC, otherwise review acquisition.
- Watch margin per product, not just overall revenue.
- The cash cancellation rate is the silent killer: reduce it with confirmation and prepayment.
- Update every week and link each red KPI to a concrete action.
FAQ
How many KPIs should I track?
Seven to eight is more than enough: broken-down revenue, average order value, conversion rate, CAC, LTV, margin and cancellation rate. More than that scatters attention.
What is the most neglected KPI in Senegal?
The cancellation rate on cash on delivery. It can reach 25 to 30 percent and destroys profitability silently.
Do I need paid software for my dashboard?
No. A spreadsheet updated every week with back-office data and mobile money statements is enough at launch.
How do I know if my acquisition is profitable?
Compare LTV to CAC: a customer's lifetime value must be worth at least three times the cost to acquire them.
Why track margin rather than revenue?
Because a nice revenue can hide losses: delivery, payment fees and low-margin products can absorb all the profit. Only margin tells the truth.
Let's talk about your project. To build a dashboard that turns your figures into decisions, message us on WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
