EBS: How to Create a Custom Report That Calculates the Length of Time It Takes Contacts to Confirm Receipt of a Notification in Everbridge Suite

Topic:

How to create a custom report that calculates the length of time it takes contacts to confirm receipt of a notification in Everbridge Suite.

Description:

The response times for a notification can be done by:

  1. Building a custom report generating the necessary data and exporting it.
  2. Applying a formula in Excel to calculate the response time.
Follow the sections below in order for steps on how to calculate response times:

Building a Custom Report

Confirmation Time Report
  1. Log in to the Manager Portal and select the appropriate organization from the upper right-hand corner.
  2. Click on the Reports tab from the top of the page.
  3. Click on the Create Report button.
  4. From the left, drag and drop the following fields into the DATA pane:
    1. Confirmation Status.
    2. Confirmation Time.
    3. Delivery Method.
    4. Contact First Name.
    5. Contact Last Name.
    6. Contact External Id.
    7. Sent On.
  5. From the left, drag and drop the following fields into the FILTERS pane.
    1. Confirmation Status.
      1. Set the Condition to is equal to and the Value to Y.
    2. Notification ID.
      1. Set the Condition to is equal to and the Value to the notification ID of the desired notification.
  6. Preview the report by clicking on the Preview Report button. 
  7. Click on CSV to export the report as a .CSV file.

Applying a formula in Excel

Confirmation Formula in Excel
  1. Add an additional column to the .CSV file. In the example pictured, a column named Time to Confirm has been added at cell J1.
  2. In the cell beneath the new column (J2 in the example), enter the following formula and press Enter: =INT(C2-E2) & " days, " & HOUR(C2-E2) & " hours, " & MINUTE(C2-E2) & " minutes and " & SECOND(C2-E2) & " seconds"
    1. NOTE: The "C2" and "E2" entries in the above formula correlate to the Confirmation Time (column C) and Sent On (column E) positions on the CSV file. If the fields entered into the DATA pane were done a different order when building the report in the section above, the Confirmation Time and Sent On columns will be different.
  3. Expand the formula down the required amount of rows to calculate the response time by positioning the cursor over the lower right corner of the cell (the cursor icon will change to a solid black + sign) and then dragging the selection to the desired cell.
    1. NOTE: There is no value in cell J3 as there is no value in cell C3.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.