Skip to main content

Frac CFO

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.

Fraccfo
fraccfo.org
Turn KPI Targets Into Clearer Decisions
Frac CFO builds KPI dashboards into your existing spreadsheets, helping your team track targets and make more informed financial decisions.

Visit

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?

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

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:

  1. Put the top-level KPI in the first row, with its formula (for example, =Sessions*ConvRate*AOV).
  2. List each input in its own row, with the current value in one column and the target in the next.
  3. Let the top-level number calculate from the inputs, so changing a target at the bottom shows the effect at the top.
  4. 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.

Four evidence sources for setting KPI targets

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%.

  1. Baseline: 2.4%.
  2. 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.
  3. Range: green at 2.8% or more, yellow from 2.4% to 2.79%, red below 2.4%.
  4. Owner: the person who runs the site and the ads.
  5. 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.

KPI Dashboard Build

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:

  1. Update actuals in the sheet.
  2. Look at the colors: which KPIs are red or yellow?
  3. Walk down the driver tree to find which input moved.
  4. Write one next action per red KPI, with an owner and a date.
  5. 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.

KPI Dashboard Build

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

Leave a Reply