Cookie preferences

Choose what we may use. Strictly necessary cookies keep you signed in and can't be turned off; everything else is your call and changes nothing about how the site works. You can change your mind any time from the footer.

For Shop-Ware

A thousand-dollar ticket that was mostly parts is not a thousand-dollar ticket.

Export repair orders from Shop-Ware, upload the leads behind them, and rank channels on gross profit — shop by shop.

  • No API key
  • Nothing to install in Shop-WareNothing to install
  • No card requiredNo card

CloseRev reads a Shop-Ware export of repair orders — the customer's phone or email, the order's gross profit and the date — and matches it against the calls, ads and listings that produced the first visit. Repair groups running several shops need two things a single-shop report never gives them: an answer per location, and a ranking on what the work was worth after parts — sale less parts cost, worked out in the file — not on what it was billed at. Revenue with no traceable lead is reported as Direct / Unknown.

Page updated September 25, 2026.

The gap

Every location reports sales. The owner's real question is which channels produce profitable work at which shops.

Shop-Ware sees

What was sold, to whom, and for how much.

no shared row
Your ad account sees

The click, the keyword, the call, and what each one cost.

The file

What the export needs in it.

Three things carry the match: who, how much, and when. Anything else is optional and only changes how the report can be sliced.

  1. Needed

    Customer phone or email

    On the customer record, which is what joins every later visit back to the first one.

  2. Needed

    Gross profit per order

    Sale less parts cost, worked out in the file — one amount is read per row. That difference is what the channel actually earned the business.

  3. Needed

    Order date

    When the order was closed, used the same way on every row.

  4. Optional

    Shop

    Mapped as Location. Labor hours are not read; keep them from Shop-Ware's own reports to set beside the matched-records export.

Step by step

Getting the file out of Shop-Ware.

Written for somebody with Shop-Ware open in the next tab. Report names vary by edition, so each step says what to look for.

  1. Export closed repair orders with their margin

    One row per order with a customer contact detail, sale less parts cost, and the date.

  2. Keep the shop on every row

    A group-wide ranking describes no single location, and marketing is usually local.

  3. Export your lead sources, named by shop

    Tracked numbers and search campaigns named per location, map listings, fleet programs.

  4. Take a year

    Declined work that comes back months later needs time to arrive before it can be credited.

  5. Upload both

    The join runs on the phone and the email, normalized, with revenue cut by shop as well as reported for the group.

What comes back

The page Shop-Ware cannot show you.

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 Shop-Ware account.

Traced to a channel$203,00058% of $350,000
Sales matched406 of 695high confidence only
Average sale$492per paid sale
ChannelShareSalesRevenue
Google Ads203$101,500
Local service ads142$77,000
Meta Ads61$24,500
Direct / Unknown289$147,000

Unmatched sales stay in Direct / Unknown. They are never spread across the paid channels to make the total look better.

The argument

What changes when the repair order and the ad share a row.

A group average describes no shop

Repair groups buy marketing centrally and deliver it into several local markets, each with its own competitors and its own mix of customers.

A channel that fills bays at one location can do nothing at another a few miles away, and a group-wide figure sits between them and describes neither.

Cutting the figures by shop, and pairing each order with its channel through the matched-records export, turns one ambiguous number into local decisions, which is how a group actually allocates.

It also shows which locations are carrying a channel's group-wide result, which may be only a few of them.

Those are the shops where changing the spend changes something.

Gross profit, not sales, is what a channel earned

Two orders with the same total can be mostly labor or mostly parts, and the business keeps very different amounts from each.

Channels do not bring the same mix. A source producing heavy parts jobs can top a sales ranking and sit near the bottom of a profit one.

Where the export carries the cost of the order, upload the difference as the amount, and the report ranks on the number the owner cares about.

Where it does not, the report ranks on sales; say so when presenting it, rather than implying a precision the file does not contain.

Deferred work belongs to the channel that brought the car in

A customer declines a recommendation today and comes back for it three months later. The second order often looks like a return visit with no marketing behind it.

It was produced by the first visit — and so by whatever brought the customer in the first time.

Every order joins on the customer, so the deferred work credits the same channel as the first visit; a year of orders keeps it attached to the channel that earned it.

It is also a measure of the shop: a channel whose customers come back for deferred work is producing customers who trust the shop, which is worth more than its first-visit figure suggests.

Technician hours are the constraint

A shop can only sell the hours its technicians have. A channel bringing long, low-margin diagnostic work can fill the week and leave little behind it.

Labor hours are not read, but set beside the matched-records export — which names each order's channel — Shop-Ware's hours give gross profit per labor hour by channel, the fairest comparison for a shop at capacity.

For a shop with idle bays the ranking that matters is different, and both views are available so the owner can choose.

Neither figure is visible in an advertising platform, which sees clicks and calls and never sees the bay.

For a group, the per-shop version of this is the useful one. A location running at capacity should be bought different work from a location with empty bays, and a single group-wide channel budget cannot do that.

Fair questions

“Shop-Ware already does that.” Not quite.

They say

“Shop-Ware already reports sales by shop.”

We say

It does. It has no record of what produced each customer, because that predates the first repair order.

They say

“We only track sales.”

We say

Then the report ranks on sales. Uploading sale less parts cost instead is what turns it into a ranking on profit.

They say

“Our marketing is bought for the whole group.”

We say

Which is why the shop split matters: the same spend lands in several different local markets.

Questions

Shop-Ware, specifically.

Something else? Ask us and a person answers.

No. It reads a file you exported, so your repair orders, inspections and customer messages stay where they are.

Shop-Ware 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.

Start today

Two exports, and you will know.

Nothing to install in Shop-Ware, no API key, and no need to have been tracking anything until now. Last year works as well as this month.