Advertising Sales Metrics to Track Each Week

Sales metrics are useful when they answer a specific question. Activity shows what work occurred. Pipeline describes opportunities still in progress. Decisions show what buyers chose. Booked sales and collected payments describe different financial events and should remain separate.

Download the sales planning workbook. The Weekly Metrics sheet calculates a decision win rate from wins and losses entered for the same week. Blank inputs remain unreported until completed.

Track activity without treating it as a result

Relevant activity may include completed discovery conversations, proposal reviews, and promised follow-ups completed. Define what counts before comparing people or periods. An attempted call and a substantive buyer conversation should not share one label.

Use activity to identify a process question. For example, many introductions and few conversations may justify reviewing contact accuracy or audience fit. It does not automatically mean the representative needs a more aggressive script.

Define pipeline value

Pipeline value is the amount attached to opportunities still being considered under a stated definition. The supplied workbook’s open total includes Contacted, Discovery, Proposal, and Decision stages. It excludes Research, Won, Lost, and Deferred.

This is unweighted proposed value. It is not a forecast of what will close. Opportunities without an amount are shown as missing values so an incomplete total is easier to recognize.

Calculate a decision win rate

For a defined period, use:

Decision win rate = won opportunities ÷ (won opportunities + lost opportunities).

The numerator and denominator must describe the same set of decisions. If three opportunities were won and two were lost during a week, the illustrative decision win rate is 3 ÷ 5, or 60%. That calculation says nothing about the percentage of proposals first sent that week that will eventually close.

When no opportunities were decided, the rate is not applicable. A zero-percent rate means decisions occurred and none were wins; it is different from a week with no decisions.

Separate booked value from revenue and cash

Booked value records the agreed value of sales under your team’s definition. Revenue recognition and payment collection follow different rules and timing. Use the organization’s accounting records for financial reporting rather than treating a sales worksheet as the accounting system.

Compare amounts on a consistent basis. A twelve-month agreement and a one-month agreement should not be described as equivalent monthly revenue simply because both are single opportunities.

Review renewals with a defined eligible group

A renewal rate needs a clear population and cutoff. Decide which accounts were eligible to renew during the period and how undecided accounts are handled. State whether the measure is by account count or value.

Do not divide renewed accounts by every customer in the database. Many may not have reached a renewal decision in the period.

Keep a compact weekly review

Use patterns to choose the next improvement

Look across enough time to understand the sales cycle and the number of decisions involved. Small samples can swing sharply. Discuss the underlying opportunities before attributing a change to a script, campaign, or individual habit.

The pipeline template and account review agenda provide the records that make these conversations more useful.