MRSware Sales Commissions
  • Home
    • About
    • FAQs
  • Sales & Commissions
  • CRM
  • Blog
  • Pricing
  • Try It
  • 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
  • Support
    • Documentation
    • Integrations
    • Admins
    • Live Service Status
  • Login
    • MRSweb Login
    • MRSware Sync
    • Webmail
    • Spam Filter Portal

Sales Rep Activity Reporting

7/19/2012

0 Comments

 
As business grows, it's harder to keep track of sales activities.  Managers often ask - Is there any way to search by sales rep to see a summary of journal activity and non-activity for that sales rep's customers?

For example: Let's say Sales Rep George has 25 customers.  I would like to get a "snapshot" of his customers with his call frequency. I.e., he went to ABC Supply twice but went to XYZ Industries no times.


In MRSWARE there are 4 ways to find reports on sales rep/user activity: 

1) Search Journals by User
To see a list of activities entered by a particular user, select "Search" → "Journals" from the menu and select the user from the "Opened By" selector.  You will probably also want to use the date range selectors to narrow down the results to a range you are interested in.  The search results are all journals matching your criteria.  You can look through the list, open any journals to read the details, sort, filter, and save the list out to a spreadsheet ("File" → "Save As"). 


2) Run the Journal Activity by User or Journal Sales Activity by User reports
There are two reports that print the journals in a more reading-friendly way.  The Journal Activity by User is meant as a summary of time spent and where it is being spent.  The Journal Sales Activity by User includes the notes of each journal and is used as the more detailed report of the activity. Go to Report Explorer, run either of the reports, selecting the desired User and Date range.  You can run reports in Excel or PDF formats.

3) Search Customers by Sales Rep
What you can't really do is search for non-activity -- the system records what he does, not what he hasn't done.  This is where the Search Customers by Sales Rep comes in...  You can certainly get a list of his assigned Customers and compare that to the list of Journals he has entered.  You may want to sort and filter the customer list to get just active customers for the last year and compare this list.  The comparison is probably best done in Excel, where you can copy from one list and paste it into the other, then sort to see them side by side.

4) Journal Activity Analysis
There is also a Data Analysis cube, Journal Activity Analysis, that aggregates Journal information for the company.  It is a pretty simple cube that allows for various sorting, filtering, and grouping of Users, Journal Types, Descriptions, and Dates. The metric shown is hours, so users can break down the time being spent on various activities as compared to other users and activities. 
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
    Analytics
    Apple Mac
    Calendar
    Conferences
    Customers
    Data Analysis
    Data Import
    Email
    File Share
    Invoices
    IOS
    ISSA
    Marketing
    Mobile Computing
    MRSware Desktop
    MRSweb
    New Features
    Outlook
    Passwords
    Payments
    Permissions
    Projects
    Reports
    Sales
    Sales Force Automation
    Scheduling
    Security
    Sync
    Tips & Tricks
    Tools
    Updates
    Web Client

    Archives

    April 2022
    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
    November 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
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    April 2016
    March 2016
    January 2016
    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 | Try It | Training | Support | Log In
sales@MRSware.com     (866)795-8386 x1
Copyright (c) 2002-2022 EYOND, Inc
.
MRSware is an EYOND, Inc. Integrated Solution
made in Austin, TX  USA