Quarterly Business Review for Sales use with your customer.
Jump to Overview | Samples | CRM Process Review | Report Functionality | Variables | SSRS Report
Overview
Overview
This is a report for reps to use to do account reviews with their customers. We try to highlight points we think the rep should be discussing, whether it's problem equipment, contracts using too much toner, people who need additional training, or problems getting meter readings.
Provides the average response time, machine availability % for period as well as BW/Color/Total click volume by location of equipment at the time of billing. Also includes lease detail by machine and service details with response times, number of service calls by machine, and more!
Type of Output: Email via CRM and On Demand SSRS Report
Watch a recorded webinar below
* * *
Sample
Sample
* * *
Process Review
CRM Process Review
1. The QBR will be sent to the email associated to the CRM user requesting. Anyone listed on the TO/CC/BCC of your ID258 subscription will be included in the email.
2. The QBR is pulling data together based on Contract Invoices in eAuto. So if there is no Contract Record in eAuto, there will be no QBR. Most meter information is based on clicks billed via Contract Invoices, so if data is missing, check with your contract department to ensure the contract is billing clicks for all devices during the period you are requesting the QBR for.
3. The process looks for the Customer Number listed as the Main Customer on the Contract Record in eAuto (see highlighted field in screenshot below), regardless of any parent/location relationships in place.
**SO be sure your CRM has the same ERP/Customer Number listed as your eAuto Contract Record. CEO Juice assumes Best Practice of Parent Customer being listed as Main Customer of eAuto Contract Record aligned with your CRM Customer Number assignment.
4. The max number of months of data we will send is equal to the value in your VariableW of your ID258 subscription. See your company's CEO Juice administrator if you want to change.
**Please note, the dates on your QBR will reflect the number of months you requested, not the value in your Variable1 (as shown above).
LINKS
LINKS to Worksheet Explanations:
Use these links for detailed explanations and formulas used for each of the worksheets provided:
Customer Review (Worksheet1) | Equipment Excessive Calls (Worksheet2) | Current Equipment Details (Worksheet3)
Detail Stats Chart (Worksheet4) | Detail Stats (Worksheet5) | Equip Details (Worksheet6)
Lease Details (Worksheet7) | Service Details (Worksheet8) | Survey Responses (Worksheet9)
CRM Connection
CRM Connection Requirements
Click here for how to set up the Compass interface and how the rep requests the report.
Click here for how to set up the Sales Chain interface and how the rep requests the report.
Click here for how to set up the Salesforce interface and how the rep requests the report.
Use ID577 to see who is requesting QBRs.
* * *
Report Functionality
Report Functionality
1. We highly recommend exporting to excel for printing/formatting/resizing - formatted for 11x17 paper size for printing
The Excel rendering extension infers the print settings based on page size when exporting, as opposed to letting us specify them anywhere in the SSRS settings for the report. We are defining page breaks within the SSRS report which makes the report segment into tabs when exported. We can't force specific print settings for each tab of the report when it is exported to Excel. This is a limitation of the SSRS reporting and unfortunately, not something that we can change.
3. For the date filters, it is best to use filters that match the billing cycle of the contract when you can, or else to run 5/01-4/30 or similar because there is still some data that is presented based on the calendar month the activity happened in. Note that if you are requesting the report through a CRM that it will send you the timeframe for the most recently completed months. If you need exact timeframes, use SSRS report.
4. When requesting the QBR from your CRM, it will break if you have any special characters in your Customer Name, such as asterisks (*), brackets of any kind ({ }, [ ]). Commas and periods are acceptable.
* * *
Variables
Variables
The variables for this alert/report do greatly affect the information provided, so please be sure to review THIS LINK for those details.
* * *
SSRS Report
SSRS Report
Report security is tied to eAautomate security, click here if your error message says: Query execution failed for dataset 'ReportSecurity'.
Click here for where to find your SSRS reports.
(1) The variables in your subscription also effect your SSRS Report. The months of history filter on the SSRS Report will NOT override your Variable1 setting. Please see this link for details
(2) Report is formatted for 11x17 paper size. We highly recommend exporting to excel for printing/formatting/resizing as we can't customize for each client on formatting or type of information included.
(3) Click here for data that may be missing if not set up!
(4) Filter Options (right click on image to enlarge):Filter Explanations (SSRS Version) from Left to Right:
Customer Name Contains: Enter as much of Customer Name (per e-automate Customer Record Name) as possible
Select Main Customer Location (Parent): Will auto populate with e-automate Customer Numbers matching Customer Name Contains field, be sure to review to ensure you are selecting correct customer
Report From / To Date: Defaults to number of months per your Variable1 on your ID258 subscription
Parent Customer Number: Indicates Parent Customer Number selected from Customer Name filters
Select Bill Codes for Managed IT Equipment/Contracts: Indicate Contract Type(s) for Managed IT Service: Select specified Managed IT Contract Types to segregate from metrics on QBR.
**Please note: by default in SSRS Reports, there is (Select All) option in drop down, we highly suggest NOT using this filter option. Instead, please specify actual Contract Types (or Include all though hopefully that doesn't apply) OR None Applicable.
Report Selected Contract(s): Can elect to run QBR for just selected ACTIVE contracts under customer selected. **Please note this select contract(s) drop down will only show options if less than 50 contracts; otherwise, no choice and will run for all (due to SSRS limitation). In addition, if standard major/minor (i.e. Contract # 1101-01, 1101-02) usage is in place, then the report will look back to previous iterations of the contract (even if those previous iterations are inactive) to report on needed date filter settings selected.
Isolate Equipment having # of CM Calls exceeding (X) for Period: indicate how many Corrective Maintenance calls to consider for identifying equipment to the purpose of this filter is to flag this equipment separately on the report (defaults to Variable X on your ID258 subscription)
Red GM % / Green GM %: Indicate what color highlight to use at designated Gross Margin % for contract profit in Current Eqp Details worksheet (Worksheet3)
Top X Machines Volume: Indicate how many machines to show in top list of machines by volume listed on in Customer Review Worksheet (Worksheet1)
Show all non-zero AR Invoices: Allows for you to select ALL AR Invoices to see such activity as Sales Invoices
Run in Single Customer Mode: Allows you to run for a specific customer as opposed to a parent and all its locations.
0 Comments