“Shopmonkey already reports customer revenue.”
It does, and it has no record of what produced the customer, because that happened before the first order existed.
For Shopmonkey
Export repair orders from Shopmonkey, upload the leads behind them, and rank marketing on the customer rather than the ticket.
CloseRev reads a Shopmonkey export of repair orders — the customer's phone or email, the total and the date — and matches it against the calls, ads and forms that produced the first visit. A repair shop's economics are built on customers returning, so a channel's value is the relationship it created rather than the ticket it opened. Orders with no traceable lead are reported as Direct / Unknown.
Page updated September 24, 2026.
The gap
Your cheapest ad brings oil changes. Your most expensive one brings people who come back. Nothing you run tells the two apart.
What was sold, to whom, and for how much.
The click, the keyword, the call, and what each one cost.
The file
Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.
On the customer record rather than the order. Phone is the reliable key in this trade.
Parts and labor together, on closed orders. Open estimates are not revenue.
When the order was closed. Use it consistently across every row.
Make or vehicle class, or whether the visit was maintenance or a major repair — one of them in the Product / service slot. Both predict whether the customer returns.
Step by step
Written for somebody with Shopmonkey open in the next tab. Report names vary by edition, so each step says what to look for.
One row per order with a customer contact detail, the total and a date.
A first visit measures the coupon. A year measures the customer, which is what a channel actually produced.
Call tracking first — this trade converts on the phone — plus search ads, map listings, the website form and any coupon or marketplace listing, combined into one lead file with the source on each row.
A regular customer produces four or five orders a year, and each counts as a sale. Marketing decisions are made per customer, so read revenue rather than the count — or sum per customer before uploading.
The join runs on the phone and the email, normalized; return visits carry the same contact and credit the channel behind the first.
What comes back
Revenue by channel, the count of sales behind each figure, and an honest bucket for the ones nobody could trace. Sample figures, from the worked example on the Auto Repair Shops page — not from a Shopmonkey account.
| Channel | Share | Sales | Revenue |
|---|---|---|---|
| Google Ads | 203 | $101,500 | |
| Local service ads | 142 | $77,000 | |
| Meta Ads | 61 | $24,500 | |
| Direct / Unknown | 289 | $147,000 |
Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.
The argument
A cheap oil change or a brake special fills bays quickly, and the cost per new customer looks unbeatable in the month it runs.
The customers it brings are, by construction, price-led. A meaningful share of them return only when there is another coupon.
Matching a year of repair orders back to the source is the test, and discount channels can fail it by a wide margin against sources that produced fewer, stickier customers.
This is not an argument against offers. It is an argument for knowing what a channel's customers are worth before deciding how much of the budget it should have.
An oil change is a small ticket. A transmission or an engine job is the kind of work that makes a shop's month, and the two arrive through different routes.
Emergency repairs come from map results and searches made from the roadside; maintenance comes from reminders, habit and coupons.
Where the export carries a service type, mapped as Product / service, the report cuts revenue by it, and the matched-records export pairs type and channel — which stops one channel being ranked as though it produced the other's work.
It also tells you which channel to buy when the bays are empty, which is not the same as the channel with the best annual number.
A small fleet account is worth many retail customers and behaves nothing like one: it is won once, it is invoiced monthly and it is lost to a single bad experience.
Averaged into the same file, one fleet win can make whichever channel produced it look extraordinary, and the conclusion will not repeat.
Filtering fleet out gives an honest retail ranking, and a customer-type column mapped as Product / service shows how much of the revenue each side brought; the matched-records export pairs type and channel for the commercial one.
Where the export flags a customer type, the split is automatic; where it does not, the order pattern usually identifies the accounts within a few minutes.
A driver with a warning light calls. So does the one who saw the sign, the map result and the coupon, and none of them fill in a form.
Without tracked numbers, the lead file covers the small minority of web inquiries and the rest lands in Direct / Unknown.
Distinct numbers on the website, the map listing, any print or coupon and the sign itself produce a lead file with a source on every row, which is what makes the whole exercise work.
Until that exists, the report states the size of the untracked bucket rather than spreading it across the channels that happen to be measurable.
Fair questions
It does, and it has no record of what produced the customer, because that happened before the first order existed.
They fill bays. Whether they produce customers worth keeping is a different question and the file answers it.
Then most of this trade's inquiries have no source, and tracked numbers are the first fix rather than a different report.
No. It reads a file you exported, so your orders, inventory and customer records are not reachable from here.
Closed repair orders with a customer contact detail, the total and a date.
A year at minimum, because the value of a repair customer is measured in visits, not in one ticket.
Yes. Return visits carry the same contact, so they credit the channel behind the first.
Yes, where the export carries a service type, mapped as Product / service.
Filter them out for a retail ranking, or map a customer type as Product / service to see their share. One fleet win otherwise makes a channel look extraordinary on a result that will not repeat.
Every order carries the same customer and credits the same channel, whatever the vehicle. The relationship is the unit.
Yes, on a year of revenue, once coupon redemptions are in the lead file under the coupon's name — which is where discount channels can lose their advantage.
Anything with no traceable lead — mostly untracked calls and passing trade, and its size is worth knowing.
Yes. Two exports is the whole exercise.
A contact detail, an amount and a date, plus a service type or vehicle class if you include them. No VINs required, no notes, no card data. Encrypted in transit and at rest and deleted with the import.
A year of revenue by source, return visits credited to the channel behind the first, fleet filtered or shown as its own cut, and everything unmatched kept visible.
By trade
What the report looks like once the export is in, written for each one.
Other systems
Running more than one system, or comparing? The method is the same and the columns are not.
Shopmonkey and the other product names and logos on this page belong to their owners and are shown to identify the software a file comes from. CloseRev is not affiliated with or endorsed by them, and connects to none of them: it reads a file you export.
From the blog
Multi-crew home and field services businesses run on phone calls and job management software, not on web forms. Which means the standard marketing dashboard is measuring the smallest part of the business and missing where the money actually is.
Read the articleCall tracking answers one question well: which campaign produced the ring. It has no view of what happened after the call ended, which is where the money is decided. This is what the gap costs, and how to close it without replacing the call tracker you already have.
Read the articleA channel judged on its first invoice is judged on the wrong customer. For a business that sees the same households again, the channel that sends loyal customers can look expensive and the one that sends deal hunters can look brilliant. Here is how to compute revenue per customer by acquisition channel at 12 and 24 months from a sales export, read cohorts honestly, switch to margin, and set what you can afford to pay for a customer.
Read the articleStart today
Nothing to install in Shopmonkey, no API key, and no need to have been tracking anything until now. Last year works as well as this month.