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 do I audit my alerts?
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’ll 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
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. 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 and then 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