KPI Dashboard Builder
When to Use This Skill
- Business metrics are scattered across multiple tools and spreadsheets
- Want a single view of business health updated weekly or monthly
- Setting quarterly OKRs and need to track progress
- Onboarding a team member who needs visibility into performance
- Preparing for a board meeting or investor update
Core Principle
A DASHBOARD THAT TRACKS EVERYTHING TRACKS NOTHING. Limit to 5-8 KPIs that directly reflect business health.
Workflow
Step 1: Identify Key Metrics
Ask the user:
- What type of business? (e-commerce, SaaS, service, content creator)
- What are you trying to improve right now? (revenue, growth, efficiency, retention)
- How often will you review this? (weekly, monthly, quarterly)
- Who else will see this dashboard? (just you, team, investors)
Minimum needed: question 1.
Step 2: Select KPIs by Business Type
E-commerce:
| KPI |
Formula |
Target Example |
Frequency |
| Revenue |
Total sales |
$25,000/mo |
Weekly |
| Average Order Value |
Revenue / Orders |
$58 |
Weekly |
| Conversion Rate |
Orders / Visitors |
2.5% |
Weekly |
| Customer Acquisition Cost |
Ad Spend / New Customers |
< $25 |
Monthly |
| Return Rate |
Returns / Orders |
< 5% |
Monthly |
SaaS / Subscription:
| KPI |
Formula |
Target Example |
Frequency |
| MRR |
Sum of active subscriptions |
$15,000 |
Weekly |
| Churn Rate |
Lost customers / Total customers |
< 5%/mo |
Monthly |
| LTV |
Avg revenue per customer × avg lifespan |
> $500 |
Quarterly |
| CAC |
Sales + Marketing spend / New customers |
< $100 |
Monthly |
| LTV:CAC Ratio |
LTV / CAC |
> 3:1 |
Quarterly |
Service Business / Freelance:
| KPI |
Formula |
Target Example |
Frequency |
| Revenue |
Invoiced amount |
$12,000/mo |
Monthly |
| Utilization Rate |
Billable hours / Available hours |
> 70% |
Weekly |
| Pipeline Value |
Sum of proposal values |
$50,000 |
Weekly |
| Close Rate |
Won proposals / Total proposals |
> 40% |
Monthly |
| Client Retention |
Returning clients / Total clients |
> 80% |
Quarterly |
Content Creator:
| KPI |
Formula |
Target Example |
Frequency |
| Revenue |
Sponsorships + Products + Affiliate |
$8,000/mo |
Monthly |
| Email List Size |
Total subscribers |
10,000 |
Weekly |
| Email Open Rate |
Opens / Delivered |
> 40% |
Weekly |
| Engagement Rate |
(Likes + Comments) / Followers |
> 3% |
Weekly |
| Content Published |
Posts/videos/episodes produced |
12/mo |
Weekly |
Step 3: Build the Notion Dashboard
Create a Notion database with these properties:
- KPI Name (Title)
- Current Value (Number)
- Target (Number)
- Status (Select: On Track / At Risk / Off Track)
- Trend (Select: Up / Flat / Down)
- Period (Select: This Week / This Month / This Quarter)
- Category (Select: Revenue / Growth / Efficiency / Retention)
- Last Updated (Date)
- Notes (Rich text — for context on changes)
Add a formula property for % of Target: (Current Value / Target) × 100
Set status rules:
- On Track: ≥ 90% of target
- At Risk: 70-89% of target
- Off Track: < 70% of target
Step 4: Create Dashboard Views
- Summary View — Gallery view showing all KPIs with status color-coding
- Weekly Review — Table filtered to weekly KPIs, sorted by status
- Trend View — Board view grouped by trend (Up / Flat / Down)
- Category View — Board view grouped by category
Step 5: Set Up Review Rhythm
Provide a review checklist:
- Weekly (15 min): Update all weekly KPIs, flag anything Off Track
- Monthly (30 min): Update all KPIs, compare to previous month, adjust targets if needed
- Quarterly (60 min): Full review, set new targets, add/remove KPIs
Examples
Example 1: E-commerce Store Dashboard
Notion Database Setup:
| KPI |
Current |
Target |
Status |
Trend |
| Monthly Revenue |
$22,400 |
$25,000 |
At Risk |
Up |
| Average Order Value |
$62 |
$58 |
On Track |
Up |
| Conversion Rate |
1.8% |
2.5% |
Off Track |
Flat |
| New Customers |
180 |
200 |
At Risk |
Up |
| Return Rate |
3.2% |
< 5% |
On Track |
Down |
| Email List Growth |
+340 |
+500 |
At Risk |
Flat |
| Ad ROAS |
3.2x |
3.0x |
On Track |
Up |
Weekly Review Notes:
Revenue trending up but still below target — conversion rate is the bottleneck. AOV is strong (above target), so traffic quality may be the issue. Action: Review ad targeting this week, check landing page bounce rate.
Example 2: Freelance Consultant Dashboard
| KPI |
Current |
Target |
Status |
Trend |
| Monthly Revenue |
$9,800 |
$12,000 |
At Risk |
Flat |
| Utilization Rate |
58% |
70% |
Off Track |
Down |
| Pipeline Value |
$42,000 |
$50,000 |
At Risk |
Up |
| Active Clients |
3 |
4 |
At Risk |
Flat |
| Close Rate |
45% |
40% |
On Track |
Up |
| Avg Project Value |
$4,200 |
$4,000 |
On Track |
Up |
Insight: Close rate is strong but pipeline is light. The constraint isn't converting leads — it's generating them. Recommendation: Increase outreach or referral activity before optimizing anything else.
Recovery & Fallbacks
- User doesn't know what to track: Start with revenue + one growth metric + one efficiency metric. Three KPIs beats zero KPIs. Expand after the first month of tracking.
- User wants to track 20+ metrics: Push back. A dashboard with 20 metrics is a spreadsheet, not a dashboard. Force-rank and pick the top 5-8.
- User doesn't use Notion: Adapt the dashboard to a Google Sheet or Airtable. The structure is the same — only the tool changes.
- Metrics aren't improving: Dashboards show problems; they don't fix them. When a KPI is Off Track for 3+ periods, it needs an action plan, not more tracking.
Constraints
- NEVER include more than 8 KPIs on the primary dashboard — create a secondary "detail" view for nice-to-haves
- Every KPI must have a defined target — a metric without a target is just a number
- Include status indicators (On Track / At Risk / Off Track) for at-a-glance reading
- Always include a "Last Updated" field to prevent stale data from looking current
- Provide the review rhythm — a dashboard nobody looks at is useless
1---2name: kpi-dashboard3description: "Sets up KPI tracking dashboards in Notion with metrics, targets, status indicators, and trend tracking for any business type. Use when a user wants to track business performance, needs a visual dashboard for key metrics, or wants to replace scattered spreadsheets with a centralized KPI view."4metadata:5 source: https://skillmd.com/skills/reaperinvest/kpi-dashboard6---78# KPI Dashboard Builder910## When to Use This Skill1112- Business metrics are scattered across multiple tools and spreadsheets13- Want a single view of business health updated weekly or monthly14- Setting quarterly OKRs and need to track progress15- Onboarding a team member who needs visibility into performance16- Preparing for a board meeting or investor update1718## Core Principle1920**A DASHBOARD THAT TRACKS EVERYTHING TRACKS NOTHING. Limit to 5-8 KPIs that directly reflect business health.**2122## Workflow2324### Step 1: Identify Key Metrics2526Ask the user:271. What type of business? (e-commerce, SaaS, service, content creator)282. What are you trying to improve right now? (revenue, growth, efficiency, retention)293. How often will you review this? (weekly, monthly, quarterly)304. Who else will see this dashboard? (just you, team, investors)3132**Minimum needed: question 1.**3334### Step 2: Select KPIs by Business Type3536**E-commerce:**37| KPI | Formula | Target Example | Frequency |38|-----|---------|---------------|-----------|39| Revenue | Total sales | $25,000/mo | Weekly |40| Average Order Value | Revenue / Orders | $58 | Weekly |41| Conversion Rate | Orders / Visitors | 2.5% | Weekly |42| Customer Acquisition Cost | Ad Spend / New Customers | < $25 | Monthly |43| Return Rate | Returns / Orders | < 5% | Monthly |4445**SaaS / Subscription:**46| KPI | Formula | Target Example | Frequency |47|-----|---------|---------------|-----------|48| MRR | Sum of active subscriptions | $15,000 | Weekly |49| Churn Rate | Lost customers / Total customers | < 5%/mo | Monthly |50| LTV | Avg revenue per customer × avg lifespan | > $500 | Quarterly |51| CAC | Sales + Marketing spend / New customers | < $100 | Monthly |52| LTV:CAC Ratio | LTV / CAC | > 3:1 | Quarterly |5354**Service Business / Freelance:**55| KPI | Formula | Target Example | Frequency |56|-----|---------|---------------|-----------|57| Revenue | Invoiced amount | $12,000/mo | Monthly |58| Utilization Rate | Billable hours / Available hours | > 70% | Weekly |59| Pipeline Value | Sum of proposal values | $50,000 | Weekly |60| Close Rate | Won proposals / Total proposals | > 40% | Monthly |61| Client Retention | Returning clients / Total clients | > 80% | Quarterly |6263**Content Creator:**64| KPI | Formula | Target Example | Frequency |65|-----|---------|---------------|-----------|66| Revenue | Sponsorships + Products + Affiliate | $8,000/mo | Monthly |67| Email List Size | Total subscribers | 10,000 | Weekly |68| Email Open Rate | Opens / Delivered | > 40% | Weekly |69| Engagement Rate | (Likes + Comments) / Followers | > 3% | Weekly |70| Content Published | Posts/videos/episodes produced | 12/mo | Weekly |7172### Step 3: Build the Notion Dashboard7374Create a Notion database with these properties:7576- **KPI Name** (Title)77- **Current Value** (Number)78- **Target** (Number)79- **Status** (Select: On Track / At Risk / Off Track)80- **Trend** (Select: Up / Flat / Down)81- **Period** (Select: This Week / This Month / This Quarter)82- **Category** (Select: Revenue / Growth / Efficiency / Retention)83- **Last Updated** (Date)84- **Notes** (Rich text — for context on changes)8586Add a **formula property** for % of Target: `(Current Value / Target) × 100`8788Set status rules:89- **On Track:** ≥ 90% of target90- **At Risk:** 70-89% of target91- **Off Track:** < 70% of target9293### Step 4: Create Dashboard Views94951. **Summary View** — Gallery view showing all KPIs with status color-coding962. **Weekly Review** — Table filtered to weekly KPIs, sorted by status973. **Trend View** — Board view grouped by trend (Up / Flat / Down)984. **Category View** — Board view grouped by category99100### Step 5: Set Up Review Rhythm101102Provide a review checklist:103- **Weekly (15 min):** Update all weekly KPIs, flag anything Off Track104- **Monthly (30 min):** Update all KPIs, compare to previous month, adjust targets if needed105- **Quarterly (60 min):** Full review, set new targets, add/remove KPIs106107## Examples108109### Example 1: E-commerce Store Dashboard110111**Notion Database Setup:**112113| KPI | Current | Target | Status | Trend |114|-----|---------|--------|--------|-------|115| Monthly Revenue | $22,400 | $25,000 | At Risk | Up |116| Average Order Value | $62 | $58 | On Track | Up |117| Conversion Rate | 1.8% | 2.5% | Off Track | Flat |118| New Customers | 180 | 200 | At Risk | Up |119| Return Rate | 3.2% | < 5% | On Track | Down |120| Email List Growth | +340 | +500 | At Risk | Flat |121| Ad ROAS | 3.2x | 3.0x | On Track | Up |122123**Weekly Review Notes:**124> Revenue trending up but still below target — conversion rate is the bottleneck. AOV is strong (above target), so traffic quality may be the issue. Action: Review ad targeting this week, check landing page bounce rate.125126### Example 2: Freelance Consultant Dashboard127128| KPI | Current | Target | Status | Trend |129|-----|---------|--------|--------|-------|130| Monthly Revenue | $9,800 | $12,000 | At Risk | Flat |131| Utilization Rate | 58% | 70% | Off Track | Down |132| Pipeline Value | $42,000 | $50,000 | At Risk | Up |133| Active Clients | 3 | 4 | At Risk | Flat |134| Close Rate | 45% | 40% | On Track | Up |135| Avg Project Value | $4,200 | $4,000 | On Track | Up |136137**Insight:** Close rate is strong but pipeline is light. The constraint isn't converting leads — it's generating them. Recommendation: Increase outreach or referral activity before optimizing anything else.138139## Recovery & Fallbacks140141- **User doesn't know what to track:** Start with revenue + one growth metric + one efficiency metric. Three KPIs beats zero KPIs. Expand after the first month of tracking.142- **User wants to track 20+ metrics:** Push back. A dashboard with 20 metrics is a spreadsheet, not a dashboard. Force-rank and pick the top 5-8.143- **User doesn't use Notion:** Adapt the dashboard to a Google Sheet or Airtable. The structure is the same — only the tool changes.144- **Metrics aren't improving:** Dashboards show problems; they don't fix them. When a KPI is Off Track for 3+ periods, it needs an action plan, not more tracking.145146## Constraints147148- **NEVER include more than 8 KPIs** on the primary dashboard — create a secondary "detail" view for nice-to-haves149- Every KPI must have a defined target — a metric without a target is just a number150- Include status indicators (On Track / At Risk / Off Track) for at-a-glance reading151- Always include a "Last Updated" field to prevent stale data from looking current152- Provide the review rhythm — a dashboard nobody looks at is useless