Competitor price tracking template
See the report before you sign up. Download the template with the six columns we deliver, and a worked example row.
You fill the first two columns: your SKU and the price you sell at. The other four are what a run fills in, which is the lowest matched competitor, their price, the gap, and what changed since the last run.
The template, with one row already worked out
Row 1 is a worked example. The rows under it are yours: type your SKU and the price you sell at, and leave the last four columns for the run to fill. Download it as a CSV and open it in Excel, Numbers or Sheets.
| Your SKU | Your price | Lowest matched competitor | Their price | Gap | Changed since last run |
|---|---|---|---|---|---|
| SNK-AM90-42 | EUR 110.00 | retailer-b.com | EUR 104.90 | you are 4.9% higher | dropped from EUR 124.90 |
| your SKU | your price | ||||
What each column means
Six columns, and every one of them earns its place. Open a column to see what goes in it and who puts it there.
The code you already use for the product in your own system. Everything else in the row hangs off it, so it has to be your code, not ours. One row per SKU.
If you build the view yourself
You can take the CSV export or the REST API into your own sheet or BI tool. These are the three sums behind the four columns a run fills.
Take your price, subtract their price, divide the result by their price, and multiply by 100. A positive number means you are dearer; a negative one means you are cheaper. Dividing by their price, not yours, is what makes two rows comparable. If the two prices cover different pack sizes, divide each price by its pack size before you subtract, so you compare like with like: work out the price per kg, litre or piece.
See the same six columns with real rows in them
The use case page shows this report filled in, with the same Download CSV button beside it.