Follow

ID258 - QBR - Variables

This report can be run like our normal SSRS reports from a browser, it can also be requested by the sales reps within the CRM. We will we email the user requesting the report from CRM within 15 minutes of request an Excel attachment (assuming they have security). The browser version can be exported to Excel and will then look exactly the same as the version the rep gets.

Click here for where to find your SSRS reports.

As sales have no control over report parameters we allow you to adjust these via variables in the alert (details below).

Click here for how to set up the Compass interface and how the rep requests the report in Compass.

**Please note the variables in your subscription also effect your SSRS Report. The months of history filter on the SSRS Report will NOT override your Variable 1 setting**

Anyone listed in to:/cc: of your ID258 alert subscription will also receive the QBR requested from Compass. (bcc: will not send to anyone as it is intentionally not connected)

VariableW | VariableZ | Variable1 | Variable3 | Variable4

***********

Meter Collection - VariableW and VariableZ

Ideally we want all our meter collection automated and as part of the account review sales should focus on where we are still having to collect meters manually. To do this we need to identify meters collected manually versus those automated.

Web Meter Sources (VariableZ)

VarZ.PNG

The meter sources in eAuto that indicate meter reading comes from eInfo or any other web portal customers use to enter meters (i.e. Web is default Meter Source in eInfo), separated by comma. Please note: since this report pulls historical data, be sure to include inactive Meter Source(s) used in the past.

Automated Meter Sources (VariableW)

VarW.PNG

The Meter Sources in eAuto that indicate meter reading came from a meter capture tool (i.e. FMAudit, PrintAudit), separated by comma. Please note: since this report pulls historical data, be sure to include inactive MeterSource(s) used in the past

************

Max Months to Report to Rep - Variable1

You decide how much data your reps need to have 

Max Months of History Allowed (Variable1)

Var1.PNG

The maximum # of months of history to this report is restricted to. This is primarily intended to keep your server from being overloaded by a large request. We don't recommend setting this for more than 12 months as there is maximum about of info SSRS Reports is capable of reporting and it is really intended to be a Quarterly (not annual) Business Review.

 

*************

Call Types for Service Metrics - Variable3 and Variable4

A helpdesk agent who closes a call over the phone in minutes is a very different metric to a tech who must go onsite to close a call and mixing these metrics can give confusing results. As dealers do more IT related calls this becomes a bigger issue.

Response Time Service Metrics (Variable3)

Var3.PNG

Response time has morphed into a lot of different translations, and we aren't going to tell clients it's only 1 way. So this variable allows you control using the Call Type Category from eAuto:

CM for Corrective Maintenance
PF for Phone Fix
PM for Preventative Maintenance
SH for Shop
IR for install/delivery
CC for Courtesy Call

You can see the Call Type code/category assigned to each Call Type via Tools/ Lists & Codes / Call Types:

CallTypeCode.PNG

Suppress Call Details? (Variable4)

Variable4: Enter 'Yes' to suppress Call Details on the report, else 'No' to append them. Note that this setting affects both the automation and the direct running of the report on the SSRS server.

Var4.PNG

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk