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.

FieldYour 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 mailed10% 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

  1. Phone numbers: digits only, 10 digits, drop blanks and placeholders (000-000-0000, the store's own number).
  2. Plates: uppercase, no spaces or dashes.
  3. Addresses: same abbreviations everywhere (St, Ave, Rd), unit numbers in one column.
  4. Remove fleet, warranty, no-charge and employee tickets from the POS file.

Step 3: match, strongest key first

OrderKeyStrengthCount separately?
1PhoneStrongNo
2Plate or VINStrongNo
3Name + street addressMediumNo
4Street address onlyWeakYes, 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.

GroupRuleCount
NewNo visit ever, at any store
LapsedLast visit more than [cutoff] months before the drop
RegularVisited within [cutoff] months before the drop
Address-only matchMatched on address alone

Step 5: the numbers, per store and in total

LineFormulaStore 1Store 2Store 3Total
A. Pieces mailed
B. Cost
C. Matched households
D. New
E. Lapsed
F. Regular
G. Response rateC ÷ A
H. Share that were regularsF ÷ C
I. Cost per matched householdB ÷ C
J. Cost per new + lapsedB ÷ (D + E)
K. Cost per new onlyB ÷ 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)

LineMailed groupHoldout 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:

LineNorthSouthEastTotal
Matched households260190150600
New602545130
Lapsed45203095
Regular15514575375
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.