Page background
Support item image

Salesmatrix Basics

 

Salesmatrix performs three main functions:

  • Marketing performance assessment.
  • Sales Opportunity Analysis in your market.
  • Dynamic data-mining of Sales data.

Salesmatrix is based on a simple premise:

The components for every business transaction can be summarised in a simple formula:

Customer A buys X units
of Product B
from Salesperson
(or Sales Channel) C
in Period D for Y Dollars
creating Z Margin

Salesmatrix takes a collection of business transactions and creates a four dimension "matrix" from them. This matrix is literally A x B x C x D.

Even though this is a seemingly simple equation, Salesmatrix turns this into literally thousands of potential reports, all with the potential to give important information regarding sales and business trends.

Salesmatrix creates transaction cross-sections, allowing the data to be viewed, compared and sorted. Some examples include:

  • A x B - Customers by Product
  • A x D - Customers by Period
  • B x C - Product by Salesperson
  • C x D - Salesperson by Period
  • A(i) x A(ii) - Customer Region by Customer Type
  • B(i) x D - Supplier by Period

Each view can show a variety of values including units (X), dollars (Y) or margin (Z), as well as other important factors like:

  • Cost of Sales (Y-Z)
  • Sales price per unit (Y/X) and
  • Margin percentage (Z/Y x 100)

This formula can be modified to incorporate different business models, shuch as Professional Services, where the transaction may be defined as "Client A received X units of Employee B's time who performed Worktype C in Period D for which we charged Y Dollars and expect to make Z margin".