Should KPIs use completion or remaining?

Completion for morale and external updates; remaining for internal pacing near deadlines. Many teams show both in small type.

Can one KPI use dollars and another use units?

Yes, on separate rows. Never divide dollars by units in one fraction.

How often should KPIs update?

Weekly is common for revenue and leads. Daily for operations with short cycles.

What about year-to-date targets?

Use YTD actual and YTD target as P and G. Same formulas.

Where do spreadsheets fit?

See Percent to Goal in Excel for row templates.

KPI Goal Tracking Formulas for Sales & Marketing

KPI goal tracking formulas turn actuals and targets into percent to goal for sales, revenue, marketing, and employee performance. The math stays simple; the discipline is in definitions and cadence.

Open the calculator

Quick answer

KPI % to goal = (Actual ÷ Target) × 100 for the period. One target per KPI. Note target changes in the report footer.

Formula

Sales: Revenue actual / Quota
Marketing: Leads actual / Lead goal
Remaining % = gap / target

Introduction

Executives want one screen that says how the quarter is going. Percent to goal is the readable layer on top of raw actuals.

Sales target percentages, revenue goal tracking, conversion goals, and individual quotas all map to progress and goal.

This article focuses on formulas and reporting habits, not advanced analytics. Get the progress fraction right first.

Pair with Goal Completion Percentage and Remaining Percentage to Goal for narrative choice.

Business and marketing use cases

Sales target percentages compare closed revenue to quota for the period.

Revenue goal tracking does the same at company or division level with finance-owned targets.

Conversion rate goals can use percent to goal when the goal is a count (sign-ups, demos) rather than a rate; define carefully.

Employee performance goals often stack multiple KPIs; each KPI gets its own percent, not one blended number without weights.

Marketing KPI tracking (leads, MQLs, spend efficiency targets with fixed caps) uses identical division when the target is numeric and fixed.

Reporting habit

Publish target at period start
Pull actuals on weekly rhythm
Completion % = Actual / Target
Remaining % = (Target - Actual) / Target
Footnote any target change

CRM and finance exports should feed the actual column automatically to reduce typos.

Do not compare this week’s percent to last week if the target changed mid-period.

KPI setup and reporting

Lock the target per KPI. Document in the KPI dictionary: name, owner, unit, period, target value.
Wire actuals from source systems. Revenue from CRM, leads from marketing automation, support tickets from help desk.
Calculate completion and remaining. Sheet or BI tool; same formulas as everywhere on this site.
Choose headline percent for audience. Sales kickoff: completion. Two weeks left: remaining.
Review outliers. Tiny targets make percents swing; huge targets hide small misses. Read amount left too.
Archive weekly snapshots. Trend lines need history; do not overwrite last week’s row without a log.

Marketing and sales snapshots

Marketing: 420 leads on a 600 goal → 70% completion, 30% remaining, 180 leads left.

Sales: $410k on $500k quota → 82% completion, 18% remaining, $90k left.

Combined executive slide can show both KPIs side by side with different units; do not average 70% and 82% into “76%” without weights.

Action items come from amount left and time left, not from blending percents.

Frequently asked questions

Should KPIs use completion or remaining?: Completion for morale and external updates; remaining for internal pacing near deadlines. Many teams show both in small type.
Can one KPI use dollars and another use units?: Yes, on separate rows. Never divide dollars by units in one fraction.
How often should KPIs update?: Weekly is common for revenue and leads. Daily for operations with short cycles.
What about year-to-date targets?: Use YTD actual and YTD target as P and G. Same formulas.
Where do spreadsheets fit?: See Percent to Goal in Excel for row templates.

Conclusion

KPI goal tracking formulas are percent to goal with business ownership and reporting cadence wrapped around them.

Invest in clear targets and clean actuals; the division is the easy part.

Show completion, remaining, and amount left when decisions depend on accurate gaps.