Competitive Analysis Template for B2B Sales: A Free Sheet With Real Price and Renewal Lines

Competitive analysis template cover: a free five-tab Google Sheet with real price and renewal lines
AUTHOR:
REVIEWER:

Publish date: Nov 10, 2026

A competitive analysis template for B2B sales lines each rival up on four things. The price buyers actually hear, how the product is packaged, the contract terms, and how deals against that rival end. Ours is a free Google Sheet with five tabs. It opens with 31 price lines heard on Spona sales calls about 12 sales tools, and more than half of those lines auto-renew.

A list price tells you none of that. So those lines show what buyers were quoted or paid, never a list price.

Make a copy of the Sheet, then use the sections below to fill each tab and read the Summary before your next pricing review.

The Extractor
The Refiner
The Verifier
The Exporter

Get thousands of leads in 4 minutes.

Stop stitching tools together.
Start with verified sales data, delivered in minutes.

SCALE SALES NOW

No contracts · No setup · No onboarding

Competitive analysis template: what to compare in B2B

Most competitor grids compare features, websites and follower counts. A sales team needs different rows: what the rival charges, how it packages, and when its customers can leave. Forrester's Buyers' Journey Survey puts price among the top reasons buyers pick a winning vendor, nearly level with technical expertise.

Your buyer is already comparing. Gartner's survey of 645 B2B buyers found they used an average of seven information sources during a recent purchase. The template gives you eleven rows per rival, so you know what those sources told them.

Row to compareQuestion it answersTab and column
Pricing modelSeats, credits, a platform fee or per lead?Competitor grid C
Price publishedCan a buyer see a price without a call?Competitor grid D
Entry priceWhat does the cheapest paid plan show?Competitor grid E
Price as heardWhat were buyers quoted or charged, per year?Pricing log F to H
Seats and limitsHow many users and credits does it cover?Pricing log D, E; per seat in I
DiscountHow far below the vendor's baseline did the offer sit?Pricing log K
Term and auto-renewHow long, and does it roll over?Pricing log L, M
Renewal upliftHow much does year two rise?Pricing log N, O
Strength claimWhat do they say they do best, in their words?Competitor grid H
Deal outcomeWon, lost or no decision against them, and why?Win loss notes E, F
Contract endWhen can their customer next leave?Win loss notes I to L

Keep the list of rivals short. Figma's template guide says three to four competitors is usually enough. Crayon's survey found that nearly eight in ten intelligence teams track 30 competitors or fewer. Pick the rivals your ideal customer actually meets, not the biggest names in the category.

Then give each one a tier. Atlassian's Confluence template reserves tier one for major competitors, and Asana's splits them into primary, secondary and emerging. The sheet's Tier dropdown offers Primary, Secondary, Occasional and Emerging. The example rule ties the tier to how often a rival comes up on your calls, the number the Competitor grid asks for.

One row belongs to no vendor. Carnegie Mellon's guide counts any current way of solving the problem as competition. For most B2B buyers that is a spreadsheet and a free tool, so add that row to the grid. The Win loss notes tab gives "No decision" its own outcome, and the Summary shows how often the status quo wins.

The same guide explains the Strength claim column. Customers choose on price, service or quality. Write down which two each rival claims, in their words, and which two you claim. Where you both claim the same two, you will fight on price, because "at most, you can only compete on 2 out of the 3."

Competitive analysis example template: 31 price lines

The example rows in the sheet come from Spona's own sales calls. In recent months, 31 recorded calls each produced one price line, across 12 sales tools. Buyers named these prices on the calls, and each one is a negotiated offer. None is a list price.

Four caveats travel with every figure. Prices are in USD and exclude tax, and the discount sits against the baseline recorded on the call, not a public price. Credits follow each contract's own definition, so never compare credits across tools. The calls column counts distinct recorded calls that named the vendor, and one call can name several, so the column cannot be added up.

ToolCalls mentioning (n)Price linesAnnual price as heardDiscountLines that auto-renewRenewal uplift
Apollo913$4,416 to $5,5920% to 13.7%2 of 30% to 10.3%
Hunter.io873$2,460 to $4,2120% to 13.7%2 of 30% to 4.2%
ZoomInfo783$24,617 to $28,6547.3% to 9.2%1 of 30% to 11.7%
RocketReach732$6,624 to $8,76013.7% to 16.4%0 of 20% to 8.3%
Lusha682$7,080 to $8,6047.3% to 16.4%1 of 20% to 4.1%
LeadIQ633$8,592 to $14,5680% to 16.4%2 of 30% to 7%
Kaspr592$6,468 to $6,5647.3% to 13.7%2 of 20% to 2.8%
Salesloft543$22,164 to $26,7007.3% to 11.8%2 of 30% to 3.6%
Seamless.AI512$15,569 to $15,8069.2% to 13.7%1 of 20% to 3.1%
Cognism473$24,824 to $38,5287.3% to 11.8%3 of 30% to 10.9%
Demandbase393$70,926 to $83,32911.8% to 16.4%2 of 30% to 11.1%
Clearbit342$21,972 to $27,1807.3%0 of 20% to 3.7%

The annual price is the monthly price times 12, or the yearly price as heard. Twenty of the 31 lines came priced by the month, so the sheet annualizes before it compares anything. Every line runs 12 months.

The renewal columns carry the story. Eighteen of the 31 lines auto-renew. Nineteen carry a renewal uplift, and the uplifts run from 2.8% to 11.7%.

Every one of the 12 paid lines carried an uplift. Twelve of the 19 quoted lines carried none. Our reading is that a quote comes before any renewal, so it may not state a rise yet.

Discounts were common but modest. Twenty-seven of the 31 lines sat below the baseline recorded on the call. The median discount across all 31 lines was 9.2%. No line went past 16.4%.

Two by two grid sorting 31 competitor price lines by auto-renew clause and renewal uplift
Only three of the 31 lines carried neither an auto-renew clause nor a year-two price rise.

ZoomInfo: one rival, four kinds of evidence

A filled competitor block uses more than one source. ZoomInfo's pricing page shows no prices, only that each export costs one credit. The sales team will "work with you on payment frequency and options" before you see a number. That fills the Pricing model and Price published cells and nothing else.

Procurement data fills the price gap. Vendr's marketplace page reports that the median buyer pays $33,500 a year. The range runs from $7,267 to $156,000. Those figures rest on 1,581 purchases, with buyers saving 22% on average.

Vendr's FAQ adds that auto-renewal clauses are common and often carry a 5 to 10% annual escalation. That is a general range, not a measured result.

A ZoomInfo quarterly release, filed with the SEC, reports net revenue retention of 88%, so existing customers as a group spent less than a year earlier. It counts 1,851 customers paying $100,000 or more a year. That count fell 2% year over year. None of that is a price cut, but it suggests a renewal is negotiable.

Then come your own calls. ZoomInfo came up on 78 Spona calls, and three of them produced a price line.

SeatsAnnual priceQuoted or paidDiscountAuto-renewRenewal upliftCompany size
11$25,457Quoted9.2%Yes0%250+
30$28,654Paid7.3%No7.3%50 to 249
29$24,617Quoted9.2%No11.7%50 to 249

All three lines sit inside Vendr's range, below its median. Three lines are a small sample. They tell you what three buyers heard, not what ZoomInfo charges. Our ZoomInfo pricing post covers the packages and credit rules the lines sit on.

Competitor analysis template: how to fill each tab

Make a copy of the Sheet. It opens with the 12 vendors in the Competitor grid, the 31 lines in the Pricing log and six invented deals in Win loss notes. Most formulas show a result before you type. Five steps, one per tab.

  1. Instructions: set two numbers. Enter the sheet owner. Review facts every (days) starts at 90 and drives the Freshness flag on the Competitor grid. Renewal window (days) also starts at 90 and drives the Renewal flag on Win loss notes. Every dropdown list lives on this tab, in columns H to Q. Add a rival's pricing model or a reason code there once.
  2. Competitor grid: one row per rival. Fill Competitor, Tier, Pricing model, Price published, Public entry price and Packaging and contract notes from the rival's pricing page and terms. Calls mentioning (n) comes from your call recorder or CRM notes. Strength claim, in their words takes the rival's own headline. Paste the page into Source URL and type the date into Last checked. Days since checked and Freshness are formulas. Freshness turns red with "Re-check" once a row passes the review setting. The 12 example rows leave Last checked blank, so your own date goes in when you verify them.
  3. Pricing log: one row per price heard. Competitor is a dropdown from a range fed by the grid, set to warn rather than reject. Enter Plan as heard, Seats, Credits or limits a year, Price (USD, excl. tax) and Per as Month or Year. Annual price and Annual price per seat compute from those. Then Quoted or paid, Discount, Term (months), Auto-renew and Renewal uplift. Annual price after uplift computes the year-two cost. A row turns amber when Auto-renew is Yes and the uplift is above zero: the renewal that costs more without a signature. The 31 Spona lines are the example rows, with Source type set to Call note.
  4. Win loss notes: one row per deal where a rival came up. Fill Account, Size band, Competitor named, Outcome, Main reason and Price line logged. Competitor named is the same warning dropdown, so "ZoomInfo + Lusha" fits. Buyer wording holds the sentence the buyer said. Rival contract ends and Rival auto-renews hold what you learned about their current deal. Days to contract end and Renewal flag are formulas. The flag reads "In window" in green inside the renewal setting, "Later" beyond it and "Ended" once the date has passed. Next step and Next step date close the row. Our win loss analysis post has the interview questions and reason codes that feed Main reason.
  5. Summary: read it, do not type on it. One row per rival in the grid: Calls mentioning (n), Price lines (n), Price-line share, Average annual price, Average annual price per seat and Average discount. Then Lines that auto-renew, Highest renewal uplift, Deals logged, Won, Lost, No decision, Win rate and Contracts in renewal window. The totals sit on the right. Price-line share is the one number to watch. In the example rows it runs from 2.7% to 7.7%, which is how rarely a call produces a usable price.
Five tabs of the competitive analysis template in order, from Instructions to Summary, with what each holds
Three tabs take typed rows, and the Summary tab reads all of them by competitor name.

Formulas and dropdowns reach row 150 on the Pricing log and Win loss notes. The Competitor grid and Summary hold 30 rivals, the ceiling most intelligence teams stay under.

The formulas use COUNTIF, COUNTIFS, AVERAGEIFS and MAXIFS, so Excel and LibreOffice recalculate them without edits. MAXIFS needs Excel 2019 or Microsoft 365. Excel users take the file through File, Download, Microsoft Excel (.xlsx). The colored flags are conditional formats, and each one references its own tab only, so they survive the download.

Where to find competitor prices you can cite

Every line in the Pricing log carries a Source type. Here is what each one gives you, with examples from the 12 vendors.

Pricing page. The best case shows plans and prices. Hunter's page lists Starter at $49 a month, or $34 billed yearly. Its Growth plan costs $149 a month with 10,000 credits.

LeadIQ lists Pro from $20 a month for 200 credits. Annual billing takes 25% off, and its Enterprise tier is annual only. Kaspr's page shows Starter from $49 a user a month. Those go in Public entry price with Price published set to Yes or Partly.

Quote-only pages still give you packaging. Cognism's page shows no price but says 5 seats are included and that one credit equals one revealed contact. Demandbase describes a platform fee plus a flat fee per user behind a form, and Salesloft's page lists no plans at all. All three go in Pricing model and Packaging and contract notes, with Price published set to No.

Vendor terms. Credit rules decide what a seat is worth. Apollo pools credits across the team and grants them each billing cycle, and unused credits expire. Lusha charges one credit for an email and five for a phone. It rolls unused monthly credits over up to twice the limit and resets annual plans at the end of the cycle.

A status change belongs here too: Clearbit's pricing page now says it has joined HubSpot. For Apollo, Lusha, RocketReach and Seamless.AI, our pricing posts on each, linked in the table above, carry the figures.

Review site. Treat one as a flag, not a price. G2 audited its own product profiles and found that only 4% list prices explicitly. That is a share of G2 profiles, not of vendor websites.

Procurement data. Vendr's ZoomInfo page above is the pattern: a median, a range and a purchase count. Vertice's SaaS Inflation Index puts the current SaaS inflation rate at 13.2% and reports that 60% of vendors deliberately mask their rising prices. Masking is not hiding: a public price can still rise quietly at renewal, which is what the Renewal uplift column catches.

Public filing. A listed rival files quarterly, as the ZoomInfo release shows. In the UK, Companies House is free of charge and shows a company's accounts and confirmation statements. Filings rarely give a per-seat price, but they can show whether the vendor's customer base is growing or shrinking.

Call note. Crayon's survey found that knowledge the team already owns is the most-cited intelligence source at 54%, ahead of competitor websites at 48%. Win/loss insights came third at 36%, and 46% of teams now run a tool like Gong for competitive work. The Pricing log is where that knowledge stops living in one rep's head.

One rule governs the whole log. The SCIP Code of Ethics asks members to comply with all applicable laws and to disclose their identity and organization before every interview. So never pose as a buyer to pull a quote. Log what buyers choose to share on a sales call, and set the Source type to Buyer-shared quote when they send the document.

Using the competitive analysis on live deals

The renewal flag is the first thing to act on. Sort Win loss notes on Renewal flag and read the "In window" rows. Each one is a buyer whose current contract ends inside your renewal setting, usually with an auto-renew clause behind it.

One invented example row shows the problem. The buyer's contract renews on its own, so they need a reason to change before the notice date. Put the comparison in their hands before that date, and write the follow-up into Next step date.

Price objections are the second use. When a buyer says the rival is cheaper, open the Summary row. Average annual price per seat tells you what buyers actually heard, and Highest renewal uplift tells you how much year two can add.

Ask the buyer which number they were quoted and whether the contract renews on its own. Our guide to common sales objections covers the wording of that reply.

The grid's Strength claim column is the rival's own headline. Turning it into a talk track is the job of a battlecard, and our sales battlecard template does that one rival at a time. This sheet feeds it the price and renewal facts.

Review the Summary monthly. Win rate per rival moves slowly, so compare quarters. If a rival's Price-line share drops, your reps may have stopped asking about price on those calls.

Where Spona fits in a competitive analysis

Spona does not track rivals' prices, packaging or contract dates. Those come from your calls and the sources above. Competitive intelligence platforms such as Crayon and Klue monitor rival websites automatically. If you need an alert when a pricing page changes, that is their job, not ours.

What Spona does is fill in the people behind the grid. The accounts on Win loss notes are companies where a rival came up. Run that list through Spona's Data Enrichment to add company data and verified contacts, and you pay only when a result returns.

Our guide to CRM data enrichment shows which of those fields are worth keeping. Spona also integrates with HubSpot, so the enriched records land where the deal lives.

The second job is finding more accounts like the ones you win. You describe your ideal customer in a chat. The AI mines 40+ sources, verifies every lead and delivers a scored list in about 4 minutes, and every search starts with a free sample.

Leads cost from $0.008 to $2.00 each, depending on the search type and the plan, and the price per lead shows at checkout. Each new search session also has a one-time cost of 1,000 credits. That is $8 to $10, depending on the plan.

Hold Spona to the same columns as everyone else. Unused credits expire at the start of each billing period, which is the kind of term the Pricing log exists to record. Put a Spona row in your grid and compare it on Annual price per seat like any other line.

The Extractor
The Refiner
The Verifier
The Exporter

Get thousands of leads in 4 minutes.

Stop stitching tools together.
Start with verified sales data, delivered in minutes.

SCALE SALES NOW

No contracts · No setup · No onboarding

Competitive analysis template FAQ

What are the 4Ps of competitor analysis?

The 4Ps are product, price, promotion and place, the marketing mix that Jerome McCarthy set out in 1960. Product is an offering that is for sale, and price is the amount charged for it. Promotion is how the seller tells buyers about it, and place is where it is sold and delivered. The sheet splits price into the public price, the price heard and the renewal price, because those three differ most.

What are the four types of competitors?

Similarweb's guide lists direct, indirect, replacement and potential competitors, while HubSpot's version stops at the first three. Direct rivals sell the same thing to the same buyer, and indirect ones solve the problem differently. Replacements are what buyers use instead, and potential rivals could enter later. The Tier dropdown handles the first two with Primary and Secondary, and Emerging covers the potential ones.

What is the best tool for competitor analysis?

For a sales team, the best tool captures what buyers say on calls, because that is where real prices appear. Crayon's survey found that two-thirds of teams now run a dedicated competitive intelligence platform, up from roughly a third in 2022. Those platforms watch websites and reviews well. A call recorder plus this sheet covers the price and renewal facts that website tracking misses.

Can AI fill in a competitive analysis template?

It can draft the grid. Crayon reports that 80% of teams use AI to generate sales-facing competitive content, up from 61% a year earlier. Gartner's buyer survey found that 45% of buyers used generative AI to gather information on vendors, and 51% expect more misleading information from it. So let AI draft the Competitor grid, then make every price keep its Source URL or its call note before it enters the Pricing log.

How often should you update a competitive analysis?

Canva's guide names the triggers: a new product, a new rival or lost share, a pricing change or a rebrand. Prices also move on their own within a year, given Vertice's 13.2% inflation figure above. The sheet's Freshness flag asks for a re-check every 90 days by default, and you can change that number on the Instructions tab. Add price lines after every call where a rival came up, and read the Summary once a month.

Share this article

GET FREE LEADSSparkle

Similar Topics For You

see all texts