01 · countlift-locations-template.csv
Locations
One row per location: ID, name, market (metro or DMA) and an open date for newer locations.
- Location ID · required
- Location name
- Market / metro · required
- State
- Open date
- Postal code (for weather & local data)
- Latitude
- Longitude
Example rows for countlift-locations-template.csv| location_id | name | market | state | open_date | postal_code | lat | lng |
|---|
| SSK-001 | Galleria | Houston | TX | — | 77056 | 29.7390 | -95.4631 |
| SSK-002 | Wesley Chapel | Tampa | FL | 2026-08-24 | 33544 | 28.1869 | -82.3540 |
Download countlift-locations-template.csv02 · countlift-sales-template.csv
Sales by location
Date, location ID, one outcome count and optional revenue. About 16 weeks gives a solid read; a year is better.
- Date or week · required
- Location ID · required
- Outcome count · required
- Revenue
Example rows for countlift-sales-template.csv| date | location_id | guests | revenue |
|---|
| 2026-07-27 | SSK-001 | 1042 | 25108 |
| 2026-07-27 | SSK-002 | 880 | 21120 |
Download countlift-sales-template.csv03 · countlift-spend-template.csv
Ad spend by market
Date, market, channel and spend. Add a location ID for opening media aimed at one location.
- Date or week · required
- Market / metro · required
- Channel
- Spend · required
- Location ID (launch media)
Example rows for countlift-spend-template.csv| date | market | channel | spend | location_id |
|---|
| 2026-07-27 | Houston | Paid social | 900 | — |
| 2026-07-27 | Tampa | CTV | 640 | — |
| 2026-08-03 | Tampa | CTV | 1500 | SSK-002 |
Download countlift-spend-template.csvCall the outcome column whatever your system does: covers, joins, new patients, jobs, bookings, visits, tickets or transactions.