By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 15, 2026
To set a KPI target, start from a baseline you measured, pick the one number that moves your goal, decide what kind of target it is, attach a date, and review it on a fixed schedule. A target is simply the level of performance you want a KPI to reach by a given date. Without a baseline and a date, it is a wish. Everything below works in Excel or Google Sheets, and if you would rather have the targets, dashboard and review rhythm built into your own spreadsheets, our KPI Dashboard Build does exactly that.
TL;DR
- A KPI is the measure, the target is the level you want it to reach, and the goal is the outcome the business is after.
- Start with a baseline from your own recent data, then add a realistic improvement and a date.
- Use a driver tree to split one big number (profit, revenue) into the few inputs you can actually influence.
- Set a range with green, yellow and red zones instead of one fragile number.
- Review monthly, change targets deliberately, and treat a miss as a question to solve, not a verdict.
Table of Contents
- KPI, target, goal: what is the difference?
- Step 1: Pick three to five goals, then the KPIs behind them
- Step 2: Build a KPI driver tree
- Step 3: Measure your baseline
- Step 4: Choose the type of target
- Step 5: Set the number: realistic, challenging, dated
- Step 6: Agree on targets with the people who own them
- KPI target examples for small businesses
- Step 7: Review, adjust and handle misses
- Where we can help
- Our view: targets belong in a sheet you understand
- FAQ
- Sources
KPI, target, goal: what is the difference?
These words get mixed up, and mixing them up is where bad targets start.
- Goal: the outcome you want. “Be profitable enough to hire a second employee.”
- KPI: the metric that tells you whether you are getting there. “Gross margin.”
- Target: the number and date you attach to the KPI. “Gross margin of 45% by the end of Q2.”
A KPI differs from an ordinary metric because it ties to a strategic objective and measures performance against a goal, as TDWI explains. Website visits are a metric. Visits that turn into paid orders, measured against what you need to reach your revenue goal, are a KPI.
KPI.org adds one more piece: a target is the desired performance level for a specific reporting period, and thresholds are the upper and lower limits around it that create green, yellow and red zones. We will use that below.
Step 1: Pick three to five goals, then the KPIs behind them
The most common mistake is tracking everything. Santa Clara University’s KPI workbook for small businesses starts with writing down three to five top goals, then choosing KPIs that are relevant, measurable, actionable and time-bound. It also asks you to label each KPI as leading or lagging.
- A lagging KPI reports a result: monthly revenue, net profit, cash balance.
- A leading KPI moves before the result does: qualified leads, quotes sent, repeat-order rate, weeks of cash runway.
You want a mix. Lagging KPIs tell you if you won. Leading KPIs tell you early enough to change something.
If you want a ready list of candidates, our guides to KPIs for small business and e-commerce KPIs show how each one is calculated.
Step 2: Build a KPI driver tree
A KPI driver tree (also called a KPI tree) starts with one top-level number and splits it into the inputs that multiply or add up to it. You keep splitting until you reach a number that a person on your team can change this week.
Here is a simple tree for a service business:
- Monthly profit
- Revenue = number of billable hours x average hourly rate
- Billable hours = available hours x utilization rate
- Costs = fixed costs + variable costs
- Revenue = number of billable hours x average hourly rate
And one for an online store:
- Monthly profit
- Revenue = sessions x conversion rate x average order value
- Cost of goods sold = units x unit cost
- Marketing spend = ad spend + agency or tool fees
The reason this matters for targets: you cannot sensibly set a target for “profit” alone, because nobody can act on it directly. You can set a target for conversion rate, utilization or unit cost, and those are the numbers that add up to the profit target. KPI.org recommends cause-and-effect analysis or a logic model for the same reason: to find the measurable components before you pick measures.
Building the tree in a spreadsheet
A driver tree is easy to build in Excel or Google Sheets:
- Put the top-level KPI in the first row, with its formula (for example,
=Sessions*ConvRate*AOV). - List each input in its own row, with the current value in one column and the target in the next.
- Let the top-level number calculate from the inputs, so changing a target at the bottom shows the effect at the top.
- Add a column for the owner of each input.
That live link is the point. When you set a conversion target of 3.0% instead of 2.4%, the sheet shows how much profit that is worth, and you can judge whether the target is worth chasing.
Step 3: Measure your baseline
A KPI without a baseline and a target is just a number. The University of Maryland’s project management center gives a clean example: baseline employee confidence at 3.2 out of 5, target 4.0 out of 5 three months after launch. It also tells you to specify the data source, owner, frequency, reporting format and tools for each KPI.
For a small business, a usable baseline is:
- The last 6 to 12 months of the KPI, so seasonality does not fool you.
- The average and the best and worst month, not only the average.
- A note on how the number was calculated, so next quarter’s figure is comparable.
Pull it from your bank exports, invoices or store reports into one sheet. If the data is messy, say so in the sheet and fix the source before you set a target on it. Maryland’s guidance warns that a good KPI loses its power if data collection is manual, inconsistent or too hard, and recommends automating collection where you can.
Step 4: Choose the type of target
Not every KPI should be “go up.” TDWI classifies targets into five types, and picking the right one avoids silly goals:
| Target type | What it means | Example |
|---|---|---|
| Achievement | Reach or exceed a level | Monthly revenue of $85,000 |
| Reduction | Get lower | Overtime hours down 20% |
| Absolute | Hit a fixed standard | 98% of orders shipped on time |
| Min/max range | Stay inside a band | Inventory between 6 and 9 weeks of sales |
| Zero | None allowed | Zero stockouts on top 10 products |
The dollar figures above are illustrations, not benchmarks. Your own baseline decides the number.
Step 5: Set the number: realistic, challenging, dated
The KPI Institute says targets should be SMART: specific, measurable, achievable, relevant and timed. It also makes two points that matter in practice. Ambitious targets should motivate, but a bar set too high deflates people. And you should only ask for improvement in areas the person responsible can influence.
Where the number comes from
The Wisconsin Local Government Center’s performance measurement manual lists several sources for a target: your previous performance plus a reasonable improvement, the best or average performer, other parts of your own organization, or similar organizations. It also notes that comparisons should use similar periods, such as month to month or quarter to quarter.

For a small business, the first option is usually the most useful. Compare this March with last March, not with February.
A worked example
An online store has a 2.4% conversion rate, averaging the last 12 months. The best month was 2.9%, the worst 1.9%.
- Baseline: 2.4%.
- Target: 2.8% by the end of Q2. That is below the best month, so it has already been achieved once, but it asks for a sustained lift.
- Range: green at 2.8% or more, yellow from 2.4% to 2.79%, red below 2.4%.
- Owner: the person who runs the site and the ads.
- Check the tree: at 3,000 monthly sessions and a $60 average order, moving from 2.4% to 2.8% adds roughly 12 orders, or about $720 a month in revenue. Is the work worth that? If not, pick a different lever.
The last step is where a spreadsheet earns its keep: it tests whether the target is worth setting before you commit anyone to it.
Use a range, not a single point
The Wisconsin manual says a target does not have to be a single value, and that a range is fully acceptable where there is uncertainty. This suits small businesses, where one big customer can swing a month. A green, yellow and red band, the thresholds KPI.org describes, tells you when to act and when to leave things alone.
Step 6: Agree on targets with the people who own them
TDWI’s view is that targets are best set collectively by executives, managers and workers, during planning or budget talks, because it builds buy-in and makes targets more accurate. In a five-person company that is a 30-minute conversation. Show the driver tree, show the baseline and ask the owner what they think is achievable. People know things the data does not, like a supplier delay or a seasonal lull.
KPI target examples for small businesses
Use these as patterns for the format, not as numbers to copy. Fill in your own baseline.
| Business | KPI | Target format |
|---|---|---|
| Service company | Utilization rate | Raise from your 12-month average to a set percentage by end of quarter |
| Service company | Days to collect invoices | Reduce from current average to a set number of days by end of next quarter |
| E-commerce | Conversion rate | Range with green, yellow, red thresholds, reviewed monthly |
| E-commerce | Gross margin | Hold above a minimum percentage after shipping and fees |
| Retail | Gross margin by product category | Minimum per category, reviewed monthly |
| Startup | Cash runway | Never below a set number of months |
| Startup | Monthly burn | Stay within a max/min band tied to the forecast |
Some industries publish their own ratios. The American Institute of Architects, for example, reports that the historical average operating profit rate for U.S. architecture firms is around 10% of net revenue, with payroll and related expenses making up 70% to 75% of operating expenses. That is the kind of industry reference worth looking for in your own trade association, as a sanity check on your internal numbers. It does not apply outside that profession.
Step 7: Review, adjust and handle misses
Set a review schedule on day one. The Santa Clara workbook ends with exactly that: track results over time, record next actions, and schedule reviews with time to reflect.
A simple monthly routine:
- Update actuals in the sheet.
- Look at the colors: which KPIs are red or yellow?
- Walk down the driver tree to find which input moved.
- Write one next action per red KPI, with an owner and a date.
- Change a target only if the conditions behind it have really changed (a new product, a lost customer, a seasonal pattern you had not seen), and note the date and reason.
When a target is missed, ask why. The KPI Institute warns that a stick-based approach undermines the main benefit of KPIs, which is opening up communication and solving problems together. If people fear the number, they will stop reporting it honestly.
Where we can help
The steps above are simple to describe and fiddly to maintain. The driver tree, the baselines, the thresholds and the monthly update all live in linked formulas, and one broken reference can quietly make a dashboard wrong. Our KPI Dashboard Build sets this up in Excel or Google Sheets, the tools you already use, so your targets and actuals sit in one place you control.
If you want a ready-made layout to start from, the Performance Scorecard Excel Template is in our template shop. If you want ongoing help setting and revisiting targets as you grow, our fractional CFO plans start at $600 per month or $7,200 per year, and include hands-on onboarding and email support. For more dashboard layouts, see our financial dashboard examples.
Our view: targets belong in a sheet you understand
Most small businesses we talk to do not have a target problem. They have a visibility problem. The numbers sit in a bank portal, a store admin and three half-finished files, so nobody can say what last quarter’s baseline was, let alone what next quarter’s target should be.
We believe the fix is not new software. It is one spreadsheet where the driver tree, the baseline, the target and the actual sit side by side, with formulas you can read and change yourself. That is why we build only in Excel and Google Sheets: you keep full control and understanding of your financial data, with tools you already use.
A good target should make the next decision easier. If a KPI target does not tell you what to do on Monday, it is the wrong KPI or the wrong target, and a clear dashboard makes that obvious within a month.
frac
FAQ
How do you set KPI targets when you have no historical data?
Start with the best estimate you have: your forecast, a quote, or a trade-association figure for your industry. Label it as provisional and use a wide range. After one to three months of real data, replace it with a baseline-driven target.
How many KPIs should a small business track?
Fewer than you think. The Santa Clara workbook starts from three to five top goals, and a handful of KPIs per goal is plenty. If nobody looks at a KPI in the monthly review, remove it.
What is the difference between a KPI target and a threshold?
The target is the performance level you want in a given period. Thresholds are the upper and lower limits around it that define green, yellow and red zones, according to KPI.org. The target says where you are aiming; thresholds say when to worry.
Can I build a KPI tree in Excel?
Yes. Put the top-level KPI in the first row, list its inputs below with current and target values, and write the formulas so the top number calculates from the inputs. Add an owner column and conditional formatting for the color zones.
About the author
Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.
Sources
- Performance Management Strategies: Understanding KPIs, TDWI
- KPI 101: Working with targets, The KPI Institute
- How to Develop KPIs / Performance Measures, KPI.org
- How to Choose the Right KPIs for Your Project, University of Maryland
- Performance Measurement, Benchmarking & Outcome-Based Budgeting, Wisconsin Local Government Center
- AIA Best Practices: Budgeting basics
- MOBI KPI Workbook, Santa Clara University


