# 80. Sales Mix to Oil Change Report

[Sales Mix to Oil Change Report](https://autosoftware.company/service_sales_percent_to_oil_change_report.php) is the full picture of what your oil change business turns into. It opens with a summary of the period, breaks your oil changes down by the kind of oil that went in, and then runs through around twenty add-on services, showing for each one how many you sold, how often that happened per oil change, and what it earned. Use it to see your whole service mix on one line, to find which add-ons are being missed, and to compare oil types as customers move from conventional to synthetic.

## How do I run the Sales Mix to Oil Change Report?

1. From the Home Screen, click Reports → Marketing & Business Analysis Reports → Sales Mix to Oil Change Report.
2. Click the From : … To : … date box and pick the period. The report reloads by itself when you apply the dates — there is no Search button.
3. Click SHOW ALL to reload the report on the dates you have set.
4. Click [DOWNLOAD](https://autosoftware.company/export_service_sales_percent_to_oil_change_report.php) to take the figures into a spreadsheet. There is no printed version of this report.

![Sales Mix to Oil Change Report date range and filters](/images/s227_cc8e625e.png)
*Sales Mix to Oil Change Report date range and filters*

![Sales Mix to Oil Change Report oil changes by oil type](/images/s227_e13a5537.png)
*Sales Mix to Oil Change Report oil changes by oil type*

## How do I find the add-ons my team is missing?

1. From the Home Screen, click Reports → Marketing & Business Analysis Reports → Sales Mix to Oil Change Report, and set a period of a quarter or more.
2. Note Oil Changes from the summary — every attachment rate is measured against it. Example: 9,918.
3. Scroll right through the service blocks and read the % to Oil Change on each.
4. Pick out the rates that look low against what you would expect to sell. Example: Brake Flush 1.39%, Driver Belt 0.33%, Battery 0.52% and Transfer Case Service 0.07%, against Trans Flush 5.26% and Cool Flush 4.43%.
5. Read the Sales beside a low rate to see what it is currently worth, then work out what lifting it would bring. Example: brake flushes earned $11,037.63 at 1.39%, so each further percentage point is worth roughly $8,000 over the same period.
6. Check the oil-type mix too. Example: synthetic oil is 46.84% of oil changes against conventional at 15.85% — useful for stocking, and for knowing which customers are already buying the premium product.
7. Watch for a count of 0 with a rate of 0%: that is a service you sold none of in the period, not a reporting gap.

![Sales Mix to Oil Change Report store summary with ticket average](/images/s227_aa13b64a.png)
*Sales Mix to Oil Change Report store summary with ticket average*

![Sales Mix to Oil Change Report brake and flush services](/images/s227_b33bb315.png)
*Sales Mix to Oil Change Report brake and flush services*

![Sales Mix to Oil Change Report wiper blade and battery services](/images/s227_818e10a8.png)
*Sales Mix to Oil Change Report wiper blade and battery services*

## About this screen

This is a very wide report — around ninety columns — and it gives one row per Store, so on a single site it is a single very long line. Use a period of a quarter or a year: attachment rates over a week mean nothing.

The report opens with the summary. Total Sales and Total Customers are the whole period, Ticket Avg is one divided by the other, Oil Changes and Oil Changes Sales are the oil change business inside that, Avg Oil Change is a per-customer figure, and % Car Count is the share of your customers who had an oil change.

Take care with Avg Oil Change. It is not the average value of an oil change — it divides oil change sales by every customer in the period, including those who never had one. In the example, $924,771.70 of oil change sales across 11,021 customers gives the $83.91 shown, while the same sales across the 9,918 actual oil changes come to $93.24. If you want what an oil change is really worth, divide Oil Changes Sales by Oil Changes yourself.

Next comes the oil type breakdown — Conv Oil, High Mileage, Synthetic Blend, Synthetic Oil, Premium Synthetic Oil, Mobil 1 Synthetic Oil and Diesel Oil. These come as pairs, a count and a % to Oil Change, with no money column, and because every oil change uses exactly one kind of oil the seven counts add up to your Oil Changes total and the seven percentages come to 100%.

After that, every remaining service comes as a set of three — how many were sold, the % to Oil Change, and the Sales. The pattern repeats for around twenty services, from brakes and flushes through filters, tyres, inspections and batteries.

% to Oil Change is an attachment rate — that service's count divided by your oil changes. The add-on percentages are not shares of anything and are not meant to total 100%; each one answers "how often did an oil change also get this?" A service can also show a count with no sales, as a free brake inspection does.

Wiper Blade is counted differently, and its headings say so. The count is headed Wiper Blade (Part QTY) and gives blades sold, while the percentage is headed % to Oil Change (Service Count) and is worked out from jobs. Blades sell in pairs, so 361 blades in the example sits against a 1.91% rate — about 189 jobs out of 9,918 oil changes. Every other service on the report counts the same thing in both columns.

A word on the two similar reports. Sales Mix to Oil Change Mag 7 covers just seven headline add-ons on a much narrower table; this one covers the full service list, the oil types and the store summary as well. Use the Mag 7 report when you want the short version and this one when you want everything.