# 108. Sales Mix MAG Custom Report

[Sales Mix MAG Custom Report](https://autosoftware.company/service_sales_percent_to_oil_change_mag_custom_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-seven add-on services, showing for each one how many you sold, how often that happened per oil change, and what it earned. It is the widest report in this section — roughly a hundred columns on a single line per store. Use it to see your whole service mix at once, to find the add-ons your team is missing, and to see which oil types your customers are moving to.

## How do I run the Sales Mix MAG Custom Report?

1. From the Home Screen, click Reports → Marketing & Business Analysis Reports → Sales Mix MAG Custom Report. It sits under Revenue & Performance Analytics, below Sales Mix to Oil Change Report.
2. Click the From : … To : … date box and pick your period. The report reloads by itself when you apply the dates — there is no Search button.
3. Click SHOW ALL to reload on the dates you have set.
4. Click DOWNLOAD to take the figures into a spreadsheet. There is no printed version of this report.

![Sales Mix MAG Custom Report date range and buttons](/images/s253_322bcfaf.png)
*Sales Mix MAG Custom Report date range and buttons*

![Sales Mix MAG Custom Report oil changes by oil type](/images/s253_a8b3c17f.png)
*Sales Mix MAG Custom 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 MAG Custom Report, and set a period of a quarter or more.
2. Note Oil Changes in the summary — every attachment rate is measured against it. Example: 9,920.
3. Scroll right through the service blocks, reading the % Oil to Change on each one.
4. Pick out the rates that look low against what you would expect to sell. Example: Battery 0.52%, Light Bulbs 0.89% and Driver Belt 0.33%, against Trans Flush 5.26% and Cool Flush 4.43%.
5. Read the Sales beside a low rate to see what it is worth now, then work out what lifting it would bring. Example: batteries earned $9,844.30 from 52 sales at 0.52%, so each further half-point is worth roughly another $9,800 over the same period.
6. Check the oil-type mix as well. Example: Synthetic Oil is 46.84% of oil changes against High Mileage at 11.8% — useful for stocking, and for knowing which customers already buy the premium product.
7. Work out any figure you want to quote yourself rather than trusting a rate in isolation. Example: Air Filter 1,057 ÷ 9,920 = 10.66%, matching the column, so the rates can be relied on once you know what they are measured against.
8. Remember the oil types are incomplete. Example: the six types shown total 8,347 of 9,920 oil changes, so any conclusion about the oil mix is a conclusion about 84% of it.

![Sales Mix MAG Custom Report store summary and first oil types](/images/s253_e32cd93b.png)
*Sales Mix MAG Custom Report store summary and first oil types*

![Sales Mix MAG Custom Report state inspection and filters](/images/s253_50f421bc.png)
*Sales Mix MAG Custom Report state inspection and filters*

![Sales Mix MAG Custom Report wipers lights tires and batteries](/images/s253_c3118b38.png)
*Sales Mix MAG Custom Report wipers lights tires and batteries*

![Sales Mix MAG Custom Report low volume services](/images/s253_008b3e23.png)
*Sales Mix MAG Custom Report low volume services*

![Sales Mix MAG Custom Report flushes and differential services](/images/s253_ccc07d0b.png)
*Sales Mix MAG Custom Report flushes and differential services*

![Sales Mix MAG Custom Report brake services and belts](/images/s253_22b2ad74.png)
*Sales Mix MAG Custom Report brake services and belts*

## About this screen

Use a long period. Attachment rates over a week mean nothing; a quarter or a year is the right length. And because the table runs to about a hundred columns on one row, DOWNLOAD is usually the easier way to read it — open the spreadsheet and read the row down the page instead of scrolling sideways.

The report opens with the summary: Store, Total Sales, Total Customers, Ticket Avg, Oil Changes, Oil Changes Sales, Avg Oil Change and % Car Count. Total Sales and Total Customers cover 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 what an oil change is worth; and % Car Count is the share of your customers who had one.

In the example, $1,385,777.00 of sales across 11,022 customers gives a Ticket Avg of $125.73, and 9,920 of those customers had an oil change — a % Car Count of 90%. Those 9,920 oil changes earned $924,928.68, so Avg Oil Change is $93.24.

Avg Oil Change on this report is the true figure. It divides Oil Changes Sales by Oil Changes. The older Sales Mix to Oil Change Report divides the same sales by Total Customers instead, which understates it — on the same data that report shows $83.92 where this one correctly shows $93.24. If the two reports disagree on this column, this is the one to believe.

Next comes the oil type breakdown — Synthetic Blend, Synthetic Oil, High Mileage, Mobil 1 Synthetic Oil, Diesel Oil and Premium Synthetic Oil. Each comes as a set of three: a count, a % Oil to Change, and Sales.

The oil types will not add up to your oil change total. There is no column for conventional oil, so every oil change that used it is missing from this block. In the example the six types come to 8,347 against 9,920 oil changes — 1,573 oil changes, about one in six, appear in no oil type column at all. Treat the block as a comparison between the oil types it does show, not as a breakdown of all your oil changes. The older Sales Mix to Oil Change Report has a Conv Oil column and its oil types do total correctly.

After the oil types, every remaining service comes as the same set of three — the count, the % Oil to Change, and the Sales. The pattern repeats for around twenty-seven services, beginning with State Inspection, Air Filter and Cabin Filter.

% Oil to Change is an attachment rate — that service's count divided by your oil changes. It answers "how often did an oil change also get this?" The add-on percentages are not shares of anything and are not meant to total 100%. In the example Air Filter is 1,057 out of 9,920, which is 10.66%; Trans Flush is 522, which is 5.26%; Transfer Case Service is 8, which is 0.08%.

Wiper Blade is counted differently, and its headings say so. The count is headed Wiper Blade (Part QTY) and gives blades sold — 361.00 in the example — while the percentage is headed % Oil to Change (Service Count) and is worked out from jobs, giving 1.91%, or about 189 jobs out of 9,920. Blades sell in pairs, so the two will never line up. Every other service on the report counts the same thing in both columns.

A service you sold none of shows as three zeros — count, percentage and sales all reading 0. Premium Synthetic Oil, State Inspection, Oil System Cleaning, Engine Flush, Fuel Tank Additive, Battery Cleaning, Engine Treatment, Head Lamp Restoration and Tune-up all do this in the example. That is a genuine nil, not a gap in the report.

The column set is fixed. Despite the name, there is no control on this page for choosing which services appear — the date range, SHOW ALL and DOWNLOAD are the only things on the filter bar.

A word on the similar reports. Sales Mix to Oil Change Report covers much the same ground with a Conv Oil column this report lacks, but it works Avg Oil Change out incorrectly and gives no sales figures for the oil types. Sales Mix to Oil Change Mag 7 is the short version — seven headline add-ons on a much narrower table. Use this one when you want the full service list with money against every oil type.