COD Product Research & Test Planner (Excel + Google Sheets): Scorecard, Break-even CPL & Kill/Scale Rules

Stop guessing which product to test next, and stop burning ad money on losers for too long.

This planner gives every product idea a score out of 100, calculates the most you can pay per lead and still break even, and tells you after each test whether to KILL, WAIT, ITERATE or SCALE. Built for Cash-on-Delivery sellers, with your real delivery fees, return fees and confirmation rates.

What's inside

• Product Scorecard for 100 ideas: landed cost, price, markup check, price sweet-spot check, five 1-5 criteria (wow in 3 seconds, solves a real problem, light and hard to break, easy to film, low return risk), competition and ad-longevity scores from what you see in ad libraries, a total score and a TEST / MAYBE / SKIP verdict.
• Break-even cost per lead for every product, using your confirmation rate, delivery rate, courier fee, return fee and confirmation cost.
• Test Tracker for 100 tests: spend, leads, confirmed, delivered, returned, CPL vs break-even, confirmation and delivery rates, cost per delivered order, profit so far, budget used, and an automatic decision.
• Settings you control: currency, fees, usual rates, minimum markup, price range, test budget, kill and scale thresholds.
• Start Here tab explaining every formula and rule, with the sources behind the defaults.

Default rules (change them to yours)

At least 3x markup, retail price in the 99-399 MAD range, a test budget of about 2,500 MAD per product, kill when cost per delivered order passes 40% of the price, scale when CPL is at or below 70% of break-even. Sources for the defaults are listed in the file.

Format

One .xlsx file for Excel and Google Sheets. Works in any currency (MAD by default). Example rows included so you can see how it works before adding your own products.

Pairs well with the COD Profit & RTO Calculator and 120 COD Ad Hooks in this store.