MRSware Sales and Commissions
  • New MRSware.com
  • About EYOND
  • Free Trial / Download
  • New Blogs / Docs / Training
  • Blog
  • Support
    • Training >
      • Sales Training
      • Data Entry Training
      • Training Classes - MRSweb
      • Training Classes - MRSware >
        • Lesson 1 - MRSware Home Page
        • Lesson 2 - CRM - Companies/Contacts
        • Lesson 3 - CRM - Calendar
        • Lesson 4 - CRM - Journals
        • Lesson 5 - CRM - Tasks
        • Lesson 6 - CRM - Projects
        • Lesson 7 - MREPS - Customers
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Web Login
  • Sales Tracking Software for Manufacturers Reps
  • Commission Tracking Software
  • Manufacturers Sales Rep Commission Rates
  • Commission Management Software for Manufacturers Reps

What's this database all about, and why is it better than a spreadsheet?

5/11/2023

0 Comments

 
This is a repost from our Newsletter that goes out via email.  If you wish to subscribe, fill out any of our forms found here on MRSware.com or send an email to [email protected].
​    We touched upon the subject of databases versus spreadsheets in a fairly recent blog post, "Databases take your spreadsheet headaches away", and I wanted to expand upon that with some practical examples: Let's take a look at some product sales. In this situation, we have a great new line with some cross-selling opportunity with a particular product we've carried for years. I would like to:
  1. Know who has been buying this product, when was their last purchase, and in what quantities have they bought it?
  2. Let's zero-in on our top 3 customers by quantity, and take a look at what other products they are buying already.
  3. Now that we have some top prospects for our cross-sell, let's approach them with the offer to see how receptive they are, and refine our technique before we go wide with a marketing campaign for the other buyers.

A Product's Customers
We have all these beautiful spreadsheets from our manufacturers, listing all sorts of details from last month.  Maybe someone bought our product of interest last month?  Maybe they bought it in the spreadsheet for the month before that?  There is a lot of work in answering a question that is potentially spread across many spreadsheets, even if you only want to go back one year for your answer.  You could potentially go back to the manufacturer and ask them to do the legwork to find your answer, but what is the risk here?  I wouldn't even want them getting into the thought-cycle of "you don't know who is buying this?".

However, we've been loading all that great detail into our sales system on a regular basis, and now it's time to shine.  We click over to the Product Catalog, scroll / filter / or search for our item, and click on it.  Metrics light up our screen: quantities Ordered and Shipped, total dollars spent, high/avg/low prices and the average discount given.  Click over to the Customers tab, and there it is, the list of Customers who have purchased this item.

I can take a look at the full list, or sort by recent orders; in this case, I am interested in a top-down look at the Quantity column to see who are my top buyers.

A Customer's Products
Let's look into the purchasing habits of our top three customers.  Right from this same screen, we can click the underlined Customer Name to pop up that Customer's entry in our Customers list.  Boom, once again we are presented with some great metrics for our customer -- year-to-date numbers, last year numbers, growth percentage, and 12-month variations of those.  Click over to the Products tab and visit a similar view to what we had in the Product Catalog, this time covering all the items being purchased.  Do we have some synergy?  This answer doesn't come from the metrics, but from some salesperson knowledge (with a side of our sales call notes in the Activities section).

The Approach
Now we make some decisions on next steps.  Do we set up a Project for our marketing campaign, linking Opportunities that we pursue or responses we get from our broader emails or touches during visits?  Projects helps us group our various entries from around the system to track what is going on, especially between multiple sales people executing on our marketing.  Opportunities allows us to track Close Reasons and Win/Loss -- if we get a lot of losses like "price" or "missing feature", then we have some avenues to report back to the manufacturer and perhaps follow back up on those.


Trending over time, aggregating data at different levels, isolating opportunities, and surfacing details in a digestible format.  These are some of the things that databases, and products like MRSware, do for us.  Take a look at MRSware for your Sales and Commissions, and Customer Relationship Management needs.

For a visual look at what is described in this article, login to our Demo installation, complete with sample data that highlights these use cases.  Would you like to see the same with your own data?  Sign-up for the MRSware Free Trial (no credit card required, no time limit to your evaluation).
 
    In addition to the Free Trial, which is always available, we have been offering a promotion for existing MRSware Users that would like to pay yearly.  Pre-pay a year and get 1 month free. 

This offer is also open to new members; however, we thought we might offer an alternative to help agencies make a quicker decision to move on to new software, by lowering the barrier to entry significantly:

New MRSware Subscribers: Pay 1 Year Upfront, get 1 Year Data Imported for Free

This offer is for those of you coming from an existing system, and worried about not having access to data from your old system, or just concerned about the cost of getting that data into a new system.  We want you to feel comfortable in MRSware, and part of that is seeing your customers, sales rep assignments, lines you represent, and some sales history leading up to today.  We will import a spreadsheet that your existing system exports for you, to make sure you are up and running quickly -- and now, at no additional cost!
 
    Creating one company-wide, "master" database of contact and companies  One of the typical challenges/projects we see when a new customer comes on board with MRSware is the creation of one company-wide company and ...
 
The Power of the "R" in CRM  ...maximizing your CRM application? Most companies using CRM have created a master list (database ...

Activities or Results - Which Are You Tracking?  ..., campaigns, and e-mails.  Building and sharing a Relationship Database is part of what makes a CRM ...
 
MRSware is software for Manufacturer Reps, Independent Reps, and Brokers.  We serve many industries, each performing the Rep function for their manufacturers in very similar ways.  Our system works equally well on Desktop, Tablet, and Phone, making it ideal for office staff and field rep alike.  Take a look at our website for a Free Trial, to schedule a Web Conference Demo, or just to find out more about our offering.
 
www.MRSware.com   [email protected]    (866)795-8386
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    MRSware Blog

    contains updates for shows and conferences we will be attending, product releases and enhancements (the changelog), and general market engagement articles

    Categories

    All
    Account Numbers
    AI (artificial Intelligence)
    AIM/R
    Analytics
    Apple Mac
    Calendar
    ChangeLog
    Conferences
    CRM
    Customers
    Data Analysis
    Database Features
    Data Import
    Email
    Expenses
    File Share
    Free Community
    Invoices
    IOS
    ISSA
    Maps
    Marketing
    Mobile Computing
    MRA
    MRSware Desktop
    MRSweb
    New Features
    Newsletter Archive
    Opportunities
    Outlook
    Passwords
    Payments
    Permissions
    Projects
    PTRA
    Reports
    Sales
    Sales Force Automation
    Sales Reps
    Scheduling
    Security
    STAFDA
    Sync
    Timely Commissions
    Tips & Tricks
    Tools
    Updates
    Web Client

    Archives

    December 2023
    November 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    February 2023
    January 2023
    November 2022
    October 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    December 2021
    October 2021
    September 2021
    May 2021
    February 2021
    July 2020
    June 2020
    May 2020
    April 2020
    October 2019
    September 2019
    June 2019
    April 2019
    August 2018
    March 2018
    January 2018
    December 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    October 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    February 2016
    January 2016
    December 2015
    November 2015
    October 2015
    September 2015
    August 2015
    June 2015
    May 2015
    March 2015
    February 2015
    January 2015
    December 2014
    November 2014
    October 2014
    September 2014
    August 2014
    July 2014
    June 2014
    May 2014
    April 2014
    January 2014
    December 2013
    September 2013
    July 2013
    June 2013
    April 2013
    March 2013
    February 2013
    December 2012
    August 2012
    July 2012
    June 2012
    May 2012
    April 2012
    March 2012
    January 2012
    December 2011
    February 2011
    January 2011
    December 2010
    April 2009
    May 2008

    RSS Feed

Home | Sales and Commissions | CRM | Blog |​ Pricing | Training | Support | Log In | Free Trial 
[email protected]    
​(866)795-8386
Copyright (c) 2004 -2025 EYOND
Picture
Live Services Status

​MRSware is an EYOND Integrated Solution
made in Austin, TX  USA