SLA Reporting - Example Reports

Hold reps accountable using SLA based performance reports

Last published at: August 1st, 2024

The records that hold SLA information are regular Salesforce records which means we can produce reports using standard Salesforce Reports and Dashboards. Create the reports you need and combine them with your other performance metrics in dashboards that help the business optimise productivity and sales.

Information In the MatchLogSLA Records

When a record is assigned through a MatchGroup that has an SLA defined for it, a MatchLog is created as usual but in addition a MatchLogSLA record is also created. This MatchLogSLA record holds key SLA information about this record; see the image below for an example MatchLog record and its MatchLogSLA record. Note the fields highlighted green - the MatchGroup and the User - useful for segmenting reports, and the metrics highlighted in red, notably the SLA Outcome and the Minutes to SLA Met field. These are the fields most commonly used in our reporting of SLA metrics.

Example Report 1: Average Time To Meet SLA

A metric that is commonly required is the average time it takes for a rep to meet the SLA. Here we look at a report that shows the average time it takes for the SLA to be met, grouped by rep:

To create this report:

  1. Select the MatchLogs with MatchLogSLAs objects
  2. Under Group Rows, select User
  3. Under Columns select Minutes to SLA Met
  4. Then in the table, set the Minutes To SLA Met metric to be summarized (Average) - see image below
  5. Toggle the chart on if necessary and save the report

This is what the report editor looks like with the finished report:

Instead of seeing the data grouped by User, you could group by the Time Assigned field in order to see how agent response time is changing over time. This example below is first grouped by the Time Assigned field, and then grouped by the MatchGroup (East and West Coast teams):

Example Report 2: SLA Missed and Met

This report breaks down the number of records by their SLA Outcome field; the possible options being either MET or MISSED. Most useful is to see this by rep:

To create this report:

  1. Select the MatchLogs with MatchLogSLAs objects
  2. Under Group Rows select User
  3. Under Group Columns select SLA Outcome
  4. Toggle the chart on and save the report

Additionally, set any filters that you might need like date ranges etc and then once the report is saved you can add them to a Dashboard so you can see all the information on one screen.