Mailer match-back worksheet for auto shops
To check a postcard or mailer campaign, get the exact list of households mailed, export visits from your POS at every store, and match the two by phone, plate, or name and address inside a window you set before the mail dropped. Count unique households, sort them into new, lapsed and regular, and divide the campaign cost by new plus lapsed. That's your cost per customer gained.
This worksheet is for quick lube, tire and auto repair owners, and for the marketing agencies that run their mail. It's neutral on purpose: the same steps work for any vendor and any POS. The reasoning behind each step, with a worked example, is in our mailer match-back audit guide.
Updated November 16, 2026.
Quick answer
To check a postcard campaign, get the exact mailed list, export POS visits from every store, and match the two by phone, plate, or name and address inside a window you fixed before the drop. Count unique households, split them into new, lapsed (12+ months) and regular, then divide the campaign cost by new plus lapsed. Run it the same way at every store.
Before you sign anything, you’ll speak with businesses we already work with. No pitch deck, no pressure. If it’s not a fit, we’ll tell you.
Before the mail drops
Fill these in first, and don't change them afterwards.
| Field | Your answer |
|---|---|
| Campaign name and offer | |
| Drop date | |
| Stores covered | |
| Pieces mailed, per store | |
| Total cost (print, postage, list, design, discount cost) | |
| Match window (days after drop) | 30 / 45 / 60 |
| Lapsed cutoff (months since last visit) | 12 (or your own) |
| Holdout: share of list not mailed | 10% suggested |
| Current customers removed from the list? | Yes / No / Last 12 months only |
Step 1: collect the two files
- Mailed list from the vendor: one row per household, with name, street address, postal or ZIP code, and phone if they have it. Mark the holdout households.
- POS export from every store: ticket date, store, customer name, phone, address, plate or VIN, ticket total, account type (retail, fleet, warranty). Include at least 12 months before the drop and the full match window after it.
Step 2: clean the match keys
- Phone numbers: digits only, 10 digits, drop blanks and placeholders (000-000-0000, the store's own number).
- Plates: uppercase, no spaces or dashes.
- Addresses: same abbreviations everywhere (St, Ave, Rd), unit numbers in one column.
- Remove fleet, warranty, no-charge and employee tickets from the POS file.
Step 3: match, strongest key first
| Order | Key | Strength | Count separately? |
|---|---|---|---|
| 1 | Phone | Strong | No |
| 2 | Plate or VIN | Strong | No |
| 3 | Name + street address | Medium | No |
| 4 | Street address only | Weak | Yes, report as its own line |
Keep only visits inside the window. One household with two visits is one match.
Step 4: sort every matched household
Look at that household's visits before the drop date, at any of your stores.
| Group | Rule | Count |
|---|---|---|
| New | No visit ever, at any store | |
| Lapsed | Last visit more than [cutoff] months before the drop | |
| Regular | Visited within [cutoff] months before the drop | |
| Address-only match | Matched on address alone |
Step 5: the numbers, per store and in total
| Line | Formula | Store 1 | Store 2 | Store 3 | Total |
|---|---|---|---|---|---|
| A. Pieces mailed | |||||
| B. Cost | |||||
| C. Matched households | |||||
| D. New | |||||
| E. Lapsed | |||||
| F. Regular | |||||
| G. Response rate | C ÷ A | ||||
| H. Share that were regulars | F ÷ C | ||||
| I. Cost per matched household | B ÷ C | ||||
| J. Cost per new + lapsed | B ÷ (D + E) | ||||
| K. Cost per new only | B ÷ D |
Line J is the one to compare across campaigns and stores. Line I is usually what a vendor report shows.
Step 6: the holdout (if you held one back)
| Line | Mailed group | Holdout group |
|---|---|---|
| Households | ||
| Households that visited in the window | ||
| Visit rate | ||
| Lift = mailed rate − holdout rate | ||
| Extra households = lift × households mailed |
The holdout is the only way to know how many would have come in without the postcard.
Example, filled in
(Made-up numbers, not real store data.) 15,000 pieces across three stores, $7,500 total, 30-day window, 12-month lapsed cutoff:
| Line | North | South | East | Total |
|---|---|---|---|---|
| Matched households | 260 | 190 | 150 | 600 |
| New | 60 | 25 | 45 | 130 |
| Lapsed | 45 | 20 | 30 | 95 |
| Regular | 155 | 145 | 75 | 375 |
| Cost per matched household | $9.62 | $13.16 | $16.67 | $12.50 |
| Cost per new + lapsed | $23.81 | $55.56 | $33.33 | $33.33 |
South mailed mostly its own regulars. North won the most new customers per dollar.
Run it the same way at every store
The point of a worksheet is that every store, every campaign and every vendor gets measured the same way. Keep the window, the lapsed cutoff and the match keys fixed for a year, so this spring's mailer can be compared with this fall's. After a campaign, check how many of the new customers came back for a second visit; our second-visit rate guide shows how.
How Trilix fits
We build the matching so it runs on its own. The mailed list and POS history from every store go in, and new, lapsed and regular counts by store land on the same owner dashboard as car count and ticket average. More on the quick lube side on our quick lube page.
Frequently asked questions
Something else on your mind? Ask us directly or call 416-262-2723.
What is a match-back in direct mail?
It's matching the households you mailed against your own sales records to see who came in during a set window after the drop. It counts customers whether or not they brought the postcard.
Why separate new, lapsed and regular customers?
Because a regular who was due anyway didn't need the postcard. Counting them as responders makes a campaign look cheaper than it was.
What match window should I use?
Pick one before the mail drops and keep it for every campaign. 30 days is common for oil change offers; 60 for seasonal or tire mailers.
Do I need the vendor to do this?
Only for the mailed list. Once you have it, the match can be done in a spreadsheet against your POS export.
What is a holdout group?
A random slice of the same list, usually around 10%, that isn't mailed. Comparing its visit rate with the mailed group's shows how many visits the mail actually added.
Want this run on every campaign, by store?
Tell us your POS and how your mail is sent, and we'll show you the new, lapsed and regular split for your last campaign.
Before you sign anything, you’ll speak with businesses we already work with. No pitch deck, no pressure. If it’s not a fit, we’ll tell you.