Build a basic spreadsheet tracking script to log local competitor rate shifts and align your services.

Pricing decisions made without competitive data are pricing decisions made in the dark. Most small businesses check their competitors' rates occasionally — when they feel pressure on price, when a prospect mentions a lower quote, or when business slows enough to prompt a review. By then, the competitor may have been running a different rate structure for months. For $1, this article gives you a simple, automated system that monitors competitor pricing on a fixed schedule — every Thursday — so that you always know where your rates sit relative to the market, without spending an hour a week manually checking websites.

The system works for any service category where competitors publish their rates publicly: accountants, web designers, personal trainers, marketing agencies, cleaning companies, tradespeople, and any professional service that lists pricing on a website or booking platform. It uses a spreadsheet, a web scraping tool, and a weekly automated trigger. The setup takes two hours. The ongoing time commitment is approximately five minutes a week.

List your five to ten closest competitors. For each one, find the specific URL where they publish their pricing — the pricing page, the services page, or the booking platform listing. Record the URL in a spreadsheet alongside the competitor's name and the last date you manually verified their prices.

Add columns for each pricing tier they offer. If they charge by hour, record the hourly rates. If they charge by package, record the package names and prices. Leave one column for notes — this is where you record when a price changed and by how much.

This master spreadsheet is your competitive pricing record. It takes about 30 minutes to build from scratch. Once built, the automated system keeps it current.

Use a free web monitoring tool to track your competitors' pricing pages. Visualping, ChangeTower, and Distill Web Monitor all offer free tiers that monitor up to a set number of pages for changes. When a page changes, you receive an email alert.

Set the monitoring frequency to weekly and the check day to Thursday. Thursday is a deliberate choice — it gives you Friday to review the data, the weekend to decide if a response is warranted, and Monday to implement any changes before the next working week begins.

Some competitors publish pricing in PDF format or use dynamic booking systems where prices are not in the page HTML. For these, you will need to check manually. Add them to your spreadsheet with a reminder to review on Thursday alongside your automated alerts.

Every Thursday morning, check your monitoring alerts. For each page that has changed, visit the page and record the new pricing in your spreadsheet. Note the direction of the change (up or down), the percentage change, and any context — did they add a new tier, remove a service, or restructure their entire pricing model?

Once a month, look at the spreadsheet as a whole. Are rates in your market trending up or down? Are your rates above, below, or in line with the median? Are there specific service types where competitors have created a gap — charging significantly more or less than the market — that you could exploit?

This monthly review is where the value of the system accumulates. A single data point tells you nothing. Four months of Thursday logs tell you whether your market is inflating, deflating, or stable — and whether your current rates are likely to become a competitive liability.

The goal of this system is not to automatically match your competitors. It is to make pricing decisions from a position of knowledge rather than instinct. Some pricing gaps are opportunities — if you consistently find that you are the most expensive option and your conversion rate is falling, that is data worth responding to. If you find that you are the cheapest option in a market that is raising rates, you are leaving money on the table.

Set yourself a rule about when competitive data triggers a pricing review: for example, if two or more direct competitors change their rates in the same direction within a 60-day window, schedule a pricing review meeting. Not a decision — a review. The data informs the decision; it does not make it.

Monitoring competitor rates is only useful if it informs decisions. Build a simple decision rule into your quarterly pricing review: if three or more competitors in your primary market have raised rates in the same direction within 60 days, treat that as a market signal warranting a pricing review. If you are the lowest-priced option in a market where all comparable providers are raising rates, you are accumulating an opportunity cost.

Equally, if a competitor drops their rates significantly, do not automatically follow. Price drops are frequently a sign of difficulty, not strategy — a competitor who is cutting rates to fill capacity is not one whose pricing should set your floor. Understand the context before you respond.

Pricing in the dark is one of the most expensive habits in any service business. The Thursday monitor costs five minutes a week. The pricing insight it produces is worth considerably more than that.

—