Competitor Price Tracking: Systematic 500-Meter Radius Analysis

Every Monday at 9:00 AM, a cafe owner on Atlihan Street in Eskisehir spends 25 minutes pulling cappuccino, americano, latte, drip coffee, breakfast spread, and simit prices from the online menus of 12 cafes within a 500-meter radius. The data goes into a Google Sheet tracker. Eight months in, the discipline has transformed his pricing strategy.

Why these six items

They appear on virtually every menu and they are the items customers mentally check when asking "how much is coffee here?". Cappuccino anchors price perception; americano signals the simple-drinker benchmark; latte the sweet-drinker; drip coffee positions you in the specialty market; breakfast spread captures total check; simit is the entry price point. Together they explain about 78% of weekly average check.

The 12 competitors split into three tiers: premium (cappuccino 95-110 TL), mid-segment (75-90 TL), and economy (55-70 TL). His own price sits at the upper edge of mid-segment, 88 TL. The strategy is not to chase premium but to defend perceived value inside the mid tier.

Google Sheet tracker structure

The sheet is intentionally simple: competitor name and Google Maps link in the left column, weekly dates across the top, prices in cells, conditional formatting in red, yellow, and green. An 8-week trailing window is visible at a glance, so drift is impossible to miss.

• Monday 9:00-9:25: pulled from Instagram menu stories and Google Maps photos
• Monthly "customer visit" rotation to 3 competitors for physical price verification
• Auto-calculated mean, median, and standard deviation per item

Turning data into decisions

Raw price data alone is useless. He watches three signals: (1) average drift — when the mid-tier average climbs 3%+ for two consecutive weeks, he repositions on percentile, not absolute TL; (2) outlier reactions — if a competitor cuts price 15%+, he plans a counter-campaign for the month; (3) menu expansion — new items added across multiple competitors signal a trend worth testing (matcha latte appeared in four menus the same month).

Result after 8 months: gross margin up 4.2%, customer count up 11%. Prices went up, but the "expensive" perception faded because his position relative to the mid-tier average tightened.

FAQ

Why a 500-meter radius? It is the maximum distance most customers walk. Beyond 500m, the decision shifts from "which cafe" to "transportation", and the price comparison psychology changes.

Should I track daily instead of weekly? No. Restaurant prices change roughly every 4-8 weeks. Daily tracking introduces noise that distorts the signal.

Is automated scraping legal? Public menus sit in a gray zone, but manual price observation is standard industry practice and entirely safe.

Found this helpful? Share it.