How to Download ECM Reports using Looker

In this video we will walk through step by step how you can filter and download the electronic call monitoring report for audited times.

Scarlett Aichroth avatar
Written by Scarlett Aichroth
Updated over a week 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!

Start by logging in to Looker and open the Full Electronic Call Monitoring - Audited Times report. If you would like to download an ECM report based on reported times (also known as 'actual' times), you can use the Looker report called Full Electronic Call Monitoring - Reported Times and follow the same process.

Use the filters to select the care recipient and date range you would like. Click the blue Run button to update the data table.

Once you're happy with the data, you can download it by clicking the cog symbol in the top right-hand corner and then selecting Download.

Download the file as a CSV, and tick All Results. 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.

When you are done with your formatting choices you can also rename the file before clicking Download.


Did this answer your question?