Module 04 · Pricing Intelligence
Building a Competitor Price Tracker With Sheets and AI
Open lesson + course map
On this lesson
Course outline
Module 1 · Ecommerce Foundations for the AI Era
Module 2 · Product Research
Module 3 · Listing Automation
Module 4 · Pricing Intelligence
Module 5 · Operations and Growth
A price tracker should explain comparable offers over time, not encourage automatic undercutting. Prices differ because bundles, variants, delivery, warranty, seller reputation and campaign terms differ. Normalize those facts before asking AI for a pattern.
// concept
Capture Comparable Observations
Use one row per dated observation:
capture_date | listing_id | url | seller | sku_equivalent | quantity
variant | displayed_price | shipping | voucher_condition | normalized_unit_price
placement | stock_note | warranty | notes | checked_byKeep formulas transparent. normalized_unit_price = (displayed price + unavoidable shipping - universally applicable discount) / quantity. Conditional vouchers stay in their own field; do not subtract a discount most buyers cannot use.
Google Sheets can flag changes and create pivot views. AI can summarize supplied rows, but require listing IDs and dates for every observation. Never ask it to scrape accounts or bypass platform controls.
// worked_example
Worked Example
Three sellers appear to price storage jars at PKR 1,399, 1,599 and 1,850. Normalization shows the first is a four-pack, the second a six-pack with shipping, and the third a six-pack with thicker material and warranty language. The cheapest displayed price is not the cheapest equivalent unit.
After four weekly captures, the tracker shows campaign discounts that reverse afterward. The business decides not to chase each change. It sets a sustainable floor, monitors position, and tests whether clearer quantity and material information supports its price.
// concept
Turn the Tracker Into a Decision Log
Add decision, reason, approved_by, effective_date and review_date. Most observations should produce “no change.” If you do change price, write the hypothesis first—for example, clearer bundle value at the current price versus a lower price—and keep a baseline. The tracker then explains why a decision happened instead of becoming a colorful archive.
// failure_cases
Failure Cases to Diagnose
5 cases to diagnose
Tracking screenshots without dates or URLs.
Comparing different quantities or specifications.
Treating conditional vouchers as universal prices.
Auto-lowering price whenever a competitor changes.
Storing competitor or platform credentials in a script or sheet.
// pakistan_angle
Pakistan Angle
Separate imported-input price changes, currency effects, campaign subsidies and city-specific delivery. A sustainable Pakistani seller may need a higher price than an informal competitor who has omitted packaging, tax, returns or warranty costs.
// hands_on
Hands-On Exercise
5 steps
Select five genuinely comparable listings.
Capture them on three dates.
Normalize bundle and unavoidable shipping differences.
Ask AI for row-cited patterns and verify each.
Set a pricing review rule that does not auto-undercut.
// completion_rubric
Completion Rubric
5 checks — tick as you verify
// sources