Skip to main content
How to Audit Alerts on Birdie Analytics

Learn how to audit all unqualified alerts through Birdie Analytics

Amy Grant avatar
Written by Amy Grant
Updated over 2 months ago

Please note: If you do not have access to these features and you are interested in learning more about Birdie Analytics, Please get in touch to talk to a member of our team!

Why do I need to audit my alerts?

Qualifying or solving a raised alert is not only a key category we look at when calculating your Q-Score (which gets you one step closer to an 'Outstanding' rating with the CQC), but also helps you to be more responsive in your care.

How to find the report

Start with selecting the Care Management Trends report from your Birdie Analytics home screen, under the Weekly Updates reports

Within the Care Management Trends report, you will be able to see an overview of alert responsiveness. This includes a chart on the number of alerts raised, the type of alerts raised, the average number of hours to qualify the alerts and the percentage of alerts resolved.

This can be a useful snapshot of how your agency is managing the alerts and can highlight areas for improvement.


How to audit the alerts

In the report, there are two measures of alert responsiveness. These are: 

  1. Hours to Qualify - This measures the time it takes for an alert to be assigned a severity in the Agency Hub (some alerts like those arising for a Care Professional raising a concern are assigned a severity at the time they are raised).

  2. Hours to Resolve - This measures the time from raising the alert to the time it is marked as resolved in the AH.

We recommend that all alerts should be actioned within 24 hours, which means that the alert status should be changed to ‘in progress’ within the Agency Hub and resolved as quickly as possible in order to keep the hours to resolve measurement low. 

This helps to demonstrate to the CQC that your care is safe and well-led.

Using the Alerts Raised report, you can download your alert data for a specific time period, and carry out your auditing!

To do this you can click on the bar for the week you’re interested in and click on ‘show all’.

This will bring up all of the alerts you received in that week in a list view. From here, you can download the data as a CSV to be opened on your computer as an Excel or Google Sheets file.

When downloading, we recommend adjusting the advanced data options to 'as displayed in the data table' for best results. Also, be sure to adjust the number of rows you want to include.

When viewing or downloading a report on Looker, it defaults to showing 500 rows, even if more rows of data are available.

You can change this by going to the data dropdown, and adding in a custom number e.g. 10000, then clicking run. This will update and show over 500 rows of data.

When you download the report from Looker, you can select All Results or a custom number of rows e.g. 10000, so that it downloads all the data for you.

Please note: Looker collects a vast amount of data to create concise report updates every 24 hours. Therefore, if you make a change in the morning then these will only appear tomorrow within the Looker report.


I've downloaded my data, now what?

Once you've downloaded the CSV file, you can then upload it to your computer's spreadsheet software (Google Sheets, Excel, Numbers, etc.).

From here, you will want to filter the data to show alerts that are blank under the 'Hours to Resolve' column. This will highlight which alerts have not been qualified and require action. This will provide you with your hit list of alerts to action for the week.



Birdie Academy Video


Too many alerts? Take a look at the articles below to reduce your numbers!

Did this answer your question?