Marketing KPIs: why 90 % of SMEs track the wrong numbers
Most SMEs follow 3 KPIs without strategic value: Instagram follower count, site page views, Facebook "engagement". These are vanity metrics — they do not directly translate into revenue.
A growing SME's dashboard should track 20 to 25 KPIs maximum, organized by funnel stage, read monthly, and correlated with revenue and margin.
TOFU / MOFU / BOFU / Retention framework
The modern marketing funnel splits into 4 stages:
| Stage | Business question | KPI type |
|---|---|---|
| TOFU (Top of Funnel — Awareness) | How many strangers discover me? | Traffic, impressions, reach |
| MOFU (Middle of Funnel — Consideration) | How many become qualified leads? | MQL, conversion rate, cost per lead |
| BOFU (Bottom of Funnel — Decision) | How many buy? | SQL, closing rate, CAC |
| Retention (post-purchase) | How many stay and re-buy? | LTV, churn, NPS, repurchase rate |
The 25 essential KPIs
TOFU (5 KPIs)
| # | KPI | Formula | SME target |
|---|---|---|---|
| 1 | Sessions / month | Raw GA4 | Sector-specific target |
| 2 | Unique visitors | GA4 | +20 %/year minimum |
| 3 | Traffic sources | % organic vs paid vs direct | 40 % organic mature target |
| 4 | Social reach | Meta/LinkedIn impressions | Steady growth |
| 5 | Brand search volume | Search Console | +30 %/year |
MOFU (7 KPIs)
| # | KPI | Formula | SME target |
|---|---|---|---|
| 6 | Landing conversion rate | conversions / sessions | > 2 % B2B, > 1 % B2C |
| 7 | Cost per lead (CPL) | spend / leads | Variable, < 8,000 FCFA |
| 8 | MQL / month | marketing qualified leads | Per annual goal |
| 9 | Email open rate | opens / delivered | > 25 % |
| 10 | Email click rate | clicks / delivered | > 3 % |
| 11 | Social engagement | likes+shares+saves / reach | Sector median |
| 12 | Newsletter sign-ups | new subscribers / month | MoM growth |
BOFU (6 KPIs)
| # | KPI | Formula | SME target |
|---|---|---|---|
| 13 | SQL / MQL | sales qualified / marketing qualified | > 30 % |
| 14 | Closing rate | customers / SQL | > 25 % B2B |
| 15 | CAC | marketing+sales spend / new customers | < LTV / 3 |
| 16 | ROAS | revenue from ads / ad spend | > 3× e-com |
| 17 | Average cart / Deal size | revenue / transactions | Trend tracking |
| 18 | Average sales cycle | days lead → close | Decrease MoM |
Retention (7 KPIs)
| # | KPI | Formula | SME target |
|---|---|---|---|
| 19 | LTV (Customer Lifetime Value) | avg cart × frequency × duration | > 3× CAC |
| 20 | LTV/CAC ratio | LTV / CAC | > 3 healthy, > 5 excellent |
| 21 | Monthly churn rate | customers lost / customers start of month | < 5 %/month SaaS, < 10 %/year services |
| 22 | NPS (Net Promoter Score) | % promoters - % detractors | > 30 good, > 50 excellent |
| 23 | 90-day repurchase rate | customers who re-bought / customers | > 25 % e-com |
| 24 | Recurring revenue (MRR/ARR) | monthly/annual subscriptions | MoM growth |
| 25 | Expansion rate | upsell / existing customers | > 15 %/year |
Recommended dashboard tools
| Tool | SME pricing | Strengths | Use case |
|---|---|---|---|
| Looker Studio | Free | Native GA4, unlimited dashboards | Early-stage SME, agency-client |
| Metabase | Free (open source) | SQL friendly, self-hosted | Tech SME, data in Postgres/MySQL |
| Power BI | ~9 € / user / month | Microsoft ecosystem, deep | Office 365 SME |
| Tableau | ~70 €/user/month | Advanced visualizations | Mid-market with dedicated analyst |
| Pirate Metrics dashboards | Notion / Coda templates | AARRR framework | Early-stage startup |
Typical SME data architecture
For a mature SME, the analytics stack consists of:
- Sources: GA4, Meta Ads Manager, Google Ads, CRM (HubSpot/Pipedrive), Shopify/WooCommerce
- Light ETL: Fivetran (paid), Airbyte (open source), n8n (open source)
- Data warehouse: BigQuery (free < 10 GB), PostgreSQL Neon, Snowflake (enterprise)
- Visualization: Looker Studio or Metabase
- Alerts: Slack via Zapier or n8n on critical thresholds (drifting CAC, dropping conversion)
SME dashboard template (to clone)
Page 1 — Executive view (CEO):
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
- Monthly revenue + MoM/YoY growth
- Global ROAS
- New customers this month
- LTV/CAC ratio
Page 2 — Acquisition (CMO):
- Traffic by source
- CPL by channel
- MQL and SQL this month
- Cost per MQL and SQL
Page 3 — Conversion (Sales lead):
- Pipeline value
- Stage conversion rates
- Average sales cycle
- Top 5 in-flight deals
Page 4 — Retention (CS lead):
- Churn rate
- Last-wave NPS
- 90-day repurchase rate
- MRR/ARR evolution
Kolonell, a strategy and execution digital agency, delivers this pre-configured dashboard to SME clients on annual retainer, plugged into GA4, Meta and their CRM.
FAQ
How many KPIs to track at the start?
Early stage (SME < 1M€ revenue): 5 to 8 critical KPIs (revenue, ROAS, CAC, LTV, churn, landing conversion, MQL, NPS). Beyond, focus is lost.
How often to check the dashboard?
Weekly KPIs (Monday morning): traffic, MQL, CPL, ROAS. Monthly KPIs (1st of the month): all 25. Quarterly KPIs: LTV, NPS, expansion rate.
How to set realistic targets?
3-source method: (1) sector benchmark (HubSpot reports, Stripe Atlas, Statista), (2) own history +20-30 % per year, (3) business goal divided by cycle. Cross-reference all three.
Looker Studio or Metabase to start?
Looker Studio if data lives in Google (GA4, Sheets, BigQuery): 1 day to a working dashboard. Metabase if data lives in Postgres/MySQL: 2-3 days but more flexible.
How to know if my LTV/CAC ratio is healthy?
< 1: non-viable model, loss per customer. 1-3: risky zone, adjust pricing or CAC. 3: healthy threshold. 5+: excellent, accelerate acquisition. > 8: under-investing in acquisition.
Let's talk about your dashboard
If you want an audit of your current KPIs and a pre-configured Looker Studio dashboard for your SME, contact us. 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.
