Guides › Research & News
Compare competitor prices in one tidy table
A spreadsheet of competitors' products, prices, offers and delivery terms, with a summary of where you sit in the market.
When to use it
Once a quarter or before a pricing review
Step by step
Choose what to compare
List 4 to 6 competitors and the matching products to compare. In Google Sheets, set up columns for competitor, product, price, pack size, offers, delivery cost and date checked.
Collect the facts
Visit each competitor's website, or ask an AI assistant with web browsing to gather current prices, then paste the details into your sheet. Note the link for each.
Check anything the AI found
Open the links and confirm each price yourself, because web results can be out of date.
Ask for the market picture
Copy the finished table into your AI assistant with this prompt.
Prompt to copyHere is a price comparison of [our product] against competitors, collected on [date]. 1) Work out the price per unit for each so they're comparable. 2) Place each competitor as budget, mid-market or premium. 3) Say where we sit and how big the gap is to the nearest rival on each side. 4) Note any offers, bundles or delivery terms that change the real price. 5) Give 3 questions this raises for our pricing or positioning. Use only the data provided. [paste table]Save the snapshot
Paste the summary into a new tab named with the date, so you can compare quarter by quarter.
What you get
Per 100g: Us 1.20, Brand A 0.95, Brand B 1.35, Brand C 1.80. Position: we're upper mid-market, 26% above A. Note: B offers free delivery over 20, which makes it cheaper than us for most baskets. Question: is our premium clear on the pack?
Tips
- Always record the date and source of each price, since prices change often.