How do I create an automated reminder report?

With the (Automated) Reminder report you can receive insights into the efficiency and compliance of your (automated) reminders. This article explains how to run the report and provides information as to which type of information is available.

Before you start

This report will display results for manual and automated reminders.

Step-by-step instructions

  1. Browse to  > Reports > Automated Reminder Report
  2. At the top, you will have the ability to filter on the following:
    1. Reminder due date: select the date range of which the reminder needs to be active.
    2. Location: select the specific location where the subsequent reminder was created for.
    3. Species: select the species of the animal.
    4. Reminder group: select the reminder group where the product was added to.
    5. Include reminders without group: filter on reminders that don’t have a reminder group. We strongly advise to always use reminder groups! If you are interested to know why, click here.

  3. Select the filters you need.
  4. Click Show Results.
  5. Your results will be displayed at the bottom:

  6.  If needed, this information can also be exported by clicking on the   below the table for further analysis.

More about this

Getting deeper insights

If you are familiar with Microsoft Excel, you can perform extra calculations with this report that will help you answer some important questions such as:

  • How many notifications were sent in the selected period?
    SUM the numbers in the “Times Reminded” column.
  • How many notifications were required on average before a sale occurred?
    To calculate this average, filter out all “no purchase” rows, then calculate the AVERAGE of the “Times Reminded” column.
  • How many notifications were required on average before a sale occurred per reminder group?
    To calculate this average, filter out all “no purchase” rows, and filter by “Reminder Group” then calculate the AVERAGE of the “Times Reminded” column. You can also do this by working with pivot tables.
  • What was the purchase rate per product or reminder group?
    Calculate the number of purchases made per reminder group or product and divided by the total number of patients that were attached to that reminders for the selected period.

Microsoft Excel Tip

When viewing the report in Excel, you may find that the “Times Reminded” and the “Total Number Reminders” columns are incorrectly imported as text (if this happens you will see a green triangle in the top-left of the cell). To correct this, select the cells with the green triangle, then from the pop-up button, select “convert to number”.


All the columns of these report explained

NameExplanation
Due DateDisplays the due date of the reminder.
SpeciesIndicates the species of the animal that the reminder was for.
ProductMentions the product that is being reminded.
Times RemindedThe amount of reminders sent.
Max. RemindersWhat the total amount of reminders are that can be sent.
Reminder(s) SentWhat type of reminders have been sent. Such as Text Messages and/or Letters.
Reminder GroupTo which Reminder Group this reminder belongs.
Date Last RemindedWhen the last reminder was sent to the client.
New Product Purchased OnWhen they purchased a product from the same reminder group.
ClientClient in question.
PatientPatient in question.

Why the need for reminder groups is essential for reporting

The reminder groups are essential in many ways. Firstly, a reminder group determines which product reminders overrule other product reminders. As it is possible in Animana to schedule reminders to be sent automatically to clients based on reminder settings, the reminder group settings determine which reminders can be deleted when a new product of the same reminder group is added. Thus making it a time saver and a large step towards more efficiency.

As an added bonus, they are also important for reporting because a correct set up can give you valuable information about the effectiveness of a reminder for treatments and/or products.  More information about setting up reminder groups can be found in the “Related articles” section.

Some of the fields in the product column are empty, why?

There might be instances where the fields in the product column are empty, this is an indicator that the reminder has been added manually and has not been added with a product attached to it.

Related articles

 

Was this article helpful?


If you wish to provide more detailed feedback regarding this article, please send us an email at: idexx-animana-support-uk@idexx.com