AMSOIL Dealer Insights Vault: My “Dealer Brain” in One Place

If you’ve ever downloaded the same AMSOIL reports over and over and thought, “There has to be a better way,” this is that better way.

My AMSOIL Dealer Insights Vault is a private tool I built with my brother Mark Holdridge to help manage a large downline and a lot of customers without drowning in spreadsheets. It’s built around one simple idea:

Take the raw CSV data from AMSOIL, turn it into real insights, and make the next best action obvious.

This post explains what the Vault is, why it exists, how it works, and what every dashboard and list is designed to do—so you can understand the “system” behind it (and borrow ideas for your own workflow).

The 11 Specialized Email Lists (The Real Engine of the Vault)

This is where the Vault turns into an outreach machine.

Instead of “one big list,” it produces multiple lists that each represent a different action:

1) Email All Dealers

Use this when you need to communicate something across the downline:

  • updates
  • deadlines
  • promotions
  • training links
  • reminders

2) Email All PCs (Preferred Customers)

Use this for:

  • seasonal oil change reminders
  • “what to order next” guides
  • product education
  • loyalty reminders

3) Email All Commercial Accounts

Use this for:

  • fleet-friendly maintenance reminders
  • uptime messaging
  • cost-per-mile value education
  • reorder cadence

4) Email All Retail Accounts

Use this for:

  • general product updates
  • cross-sell education (filters, grease, gear oil)
  • seasonal maintenance plans

5) Email All CRs

If you track customer types that fall into this category, this list keeps them organized and easy to reach.

6) Convert To PCs

This is one of the highest-value lists because it’s goal-driven.

It’s built to help you identify people who should convert to Preferred Customer status and then contact them with the right message.

7) Convert To Auto Renew

This list is about stability.

Auto renew / recurring patterns reduce churn and help customers stay consistent, especially for:

  • oil change intervals
  • seasonal equipment
  • fleet maintenance cycles

8) Expiring PCs

This list is your “save it before it slips away” list.

It helps you catch:

  • fading activity
  • expiring status concerns
  • customers who need a reminder or quick help

9) Expiring Dealers

Same concept, bigger impact.

If a dealer drifts away, it’s not just a customer lost—it’s leadership momentum lost.

10) Email All Dealers (Structured Sections)

The Vault formats lists in sections that stay readable even when the dataset grows.

11) Loyalty / Awards Outreach Lists

These are “value-based” lists. They work well because the outreach is helpful, not pushy