Attract and measure
Acquisition and Sales Metrics Template
CSV template to record cost, leads, and sales by month and channel, and to calculate cost per lead, cost per sale, and close rate. Includes an explanation of each calculation and does not contain executable formulas.
In this guide
Instructions
- One row per month and channel.
- Write in “Included costs” what you summed, and keep it the same each month.
- CPL = cost ÷ leads. CPV = cost ÷ sales. Close rate = sales ÷ leads.
- Calculate manually or with your spreadsheet; the CSV does not include formulas.
Bring it to your business
Download resource| Month | Channel or campaign | Included costs | Total cost (COP) | Leads | Sales | CPL (calculate) | CPV (calculate) | Close rate (calculate) | Method (cohort or period) | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-01 | Synthetic example: search | Only media | 2000000 | 50 | 4 | 40000 | 500000 | 8 % | Period | Made-up figures |
Keep exploring
Attract and measure
Cost per lead and cost per sale: how to interpret them
Cost per lead and cost per sale look easy to calculate, but they vary a lot depending on what you count as a lead, which period you use and which costs you include. This guide explains the formulas, time windows and how to read results without comparing yourself to external benchmarks.