Have questions?  phone +1 888-4-iCarol

Follow Us! iCarol helpline software iCarol helpline software iCarol helpline software     |    FREE TRIAL     |     SIGN IN

How to Read Call Report Exports


Call report exports in iCarol contain a lot of data, and it can be challenging to understand what is being shown or where to find the particular data you are looking for. This article will review how to request a call report export, the different files one receives when they complete a call report export, and what data is shown in these files.

Requesting a Call Report Export

To request a call report export, users with Admin security will click Admin Tools, in the left hand menu, then the Tools tab, then the link “Extract all of your data” in the Data Export section.


On the data export page, the right hand column will be used to request a call report export.

Data export details

The first drop-down menu, which shows “7 days ago” in the screenshot above, is a quick suggestion list you can use to denote what time frame you want to use for the resource export. If you would like to indicate a specific time frame for the export, use the two date field to denote a start and end date. Next, there are 3 check boxes to indicate what kind of export you would like to request; place a check mark next to “Call Reports”.

Under the title “Call Report export options”, you will see some information that says “Custom field columns will be ordered alphabetically. If you prefer a specific form’s fields to be first, please choose it below”. This is referring to the custom categories, groups and field that are in your call report. In the call report export, there will be one column for every custom group in your call report form, and these will be identified in this format: Category Name – Group Name. For example, Demographics – Gender. These columns will be arranged alphabetically by Category name. If your export will contain data from several different call reports, all categories from all call reports will be listed alphabetically. To say this another way, the columns, representing Categories, will not be in the order you see in the call reports, and categories from different call reports will follow each other, instead of all Categories from one call report first, then followed by the second call report, and so on. By choosing a particular call report with this option however, you can have all the categories from that call report come first, in alphabetical order, then followed by all the rest of the categories from all the rest of the call reports.

In the next section, you will choose which call reports you would like to export. By default, all call reports in your system are checked. If you would only like to export certain call reports, you will uncheck those you do not want to export. For those clients that only have one call report in their system, you will not see a list of call reports.

Finally, to run the call report export, you will click the “Start creating” button, found under the list of call reports.

Start Creating

As indicated in the note above the “Start creating” button, you will get an email when the export is ready. At that time, you will return to this page and you will find a link, on the right hand side of the screen, which you will click to download the export files. Usually, exports will be ready in an hour or two, but sometimes will take longer. Exports that contain a lot of data and cover a large period of time will take longer to generate, and if you request an export at a time when many other clients are requesting exports (for example, at the beginning of the month), your export will take longer to generate.

Call Report Export Files Received

When you return to the exports page after receiving the email that your export is ready, the export will be found on the right hand side of the screen as below.

Exports ready

Click on the download you would like to open. When it opens, you will see you have received several different files, as shown below.

Export file list

Call Report Export Files Explained


This is the most often referred to call report export file, as it contains all the data collected for every call report submitted in the time frame indicated for the call report export. This file has a column for every field in the call report, both “standard” iCarol fields, and custom categories, groups and fields. Some highlights of this export are outlined below.

call reports file detail
Click on the image above to see a larger version

Column C, LinkedToCallReportNum, will only have data in it if you are using embedded call reports. Embedded call reports are call reports that are related to each other. Many clients embed separate risk assessments to call reports, and other clients embed follow-up forms, for example. If there is an embedded call report linked to the call report shown in the row in the export, the call report number of the linked call report will be noted in this column.

Column G, CallerNum, will only show something different than -1 if a caller profile was chosen for the call report. iCarol gives a number to all caller profiles which will be noted in this column.

Column K, PhoneWorkerNum, will show the number iCarol assigned to each of your users.

call reports file detail 2
Click on the image above to see a larger version

Columns M through R refer to an old way of tracking non-transactional calls that we are not using for newer clients. Older clients may still be using this tool, which places a horizontal list of checkboxes just below the Contact Information section at the top of the call report, as shown below.

Call Report Contact Information

If you are not using this tool, you will always see Yes in column M, and No in columns N-R. If you are using this tool, No will be shown in Column M if Yes is shown in in one of the columns N through R, indicating that the call was a hangup, obscene, prank, wrong number, or silent call.

Columns U-AA indicate the caller’s location as noted in the location fields in the Contact Information section (shown in the screenshot above). Each iCarol client can determine which of these location fields appear; some clients choose to turn some or all of these location fields off. Even if these fields are turned off in all your call reports, these columns will still appear in the export, they will just be blank.

call reports file detail 3
Click on the image above to see a larger version

Columns AF-AP all refer to fields in the Contact Information section of the call report. Again, some clients choose to turn some or all of these fields off. Even if they are turned off, they will still appear in the export, but will be blank.

call reports file detail 4
Click on the image above to see a larger version

Column AQ is first default text field on the Content Tab of the call report. By default, this field is called “Call Description”, though this name can be changed.

Column AR is the “Worker’s Comments” text field on the Content tab. This field can be turned off; even if it is turned off, this column will still show on the export, but will be blank.

Column AS is the “Feedback from supervisors and staff” text field on the Content tab. This field, and therefore, the feedback function, can be turned off but again, the column will still appear in the call report export.

Column AT is the “Caller’s Feedback” text field on the Content tab. This field can be turned off but again, the column will still appear in the call report export.

Columns AU-BC are additional text fields that can be added to the Content tab. These additional text fields are added via the “Overall settings for this call report form” page when editing call reports using the call report editor. Again, even if these additional fields are not used, they will appear in the call report export.

call reports file detail 5
Click on the image above to see a larger version

Column BD will contain a number other than -1 if the worker who entered the call report is not a deleted user. iCarol assigns a Worker Number to all users in your system.

Column BH refers to the “reviewed for accuracy” function that clients can turn on via the Calls tab in Admin Tools.

Columns BI-BK refers to the feedback function in iCarol. If feedback is being given on call reports, there will be data in these columns.

Column BL will show all the referrals given to the caller, both those found in the resource database and linked to the call report, and out of database referrals, if that functionality is turned on. Please note that if more than one referral was given, the referrals will be separated by semi-colons in this column of the export.

Column BM refers specifically to instant messaging call reports where the IP address of the visitor is recorded in the call report.

call reports file detail 6
Click on the image above to see a larger version

The custom categories and groups added to the call report begin at column BN. All columns before this point were “standard” iCarol fields, some of which can be turned off in the call report. All custom categories and groups, as stated earlier, are arranged alphabetically by Category name, then Group name. In the example call report export shown in the screenshot above, you can see the first 5 custom groups in the call report listed by their Category name, then Group name. The data you find in each row for these columns will indicate what Field was selected in the Group if it is a drop-down or checkbox Group, or what text was entered if the Group is formatted as a text Group.


Call Report Custom Fields

This report shows the selections made in custom categories, groups and fields for all call reports submitted in the time frame of your export. Each block of color in the screenshot above represents one call report, as indicated by the call report number in column A. Please note that column F is labeled “SubCategoryName” which is also known as the Group, and column G is labeled “Answer”, also known as the Field. If a Group is formatted as text, the text entered into that group will be shown in column I.


Call Report Follow Ups

This file will show follow-up activities created or edited during the time frame of the call report export. Please note, a follow-up activity created outside of the time frame indicated will not be included in this file, but if that same activity was edited in the time frame, it will be shown in this file. The columns in this file refer to the fields found in the “Schedule a Follow-up activity section” on the Finish tab of call reports. Each client can control which fields appear in this section via the Calls tab of Admin Tools. However, all of the columns will appear in the export even if you have turned off a specific field, they will just be blank.

Please note columns J-L. These fields will be populated if the client has turned on, via the Calls tab in Admin Tools, the function to note follow-ups with a purpose (assistance, advocacy or survey). If this function is turned on, the follow-up purpose will be selected from a drop-down menu that will appear at the top of the “Schedule a Follow-up activity” section.


Call Report Needs Met And Unmet
Click on the image above to see a larger version
Call Report Needs Met And Unmet 2
Click on the image above to see a larger version
Call Report Needs Met And Unmet 3
Click on the image above to see a larger version
Call Report Needs Met And Unmet 4

This export only applies to those clients using the Needs by Taxonomy function, where each call report notes a need, and any referrals made are noted as meeting the need or not. This file includes:

  • the referral made (columns D and E)
  • the Need noted (columns F and G)
  • the caller’s location and phone number (columns H-N)
  • if the Need was unmet, and if so, the reason (columns O-P)
  • the breakdown of the taxonomy term chosen as the need (columns Q-Z)
  • the AIRS Need Category the need falls into (column AD)
  • the parent agency the referral belongs to (columns AF and AG)


Call Reports Linked Together

This very small export (only 2 columns of data) only applies to those clients using embedded call reports. As noted earlier, embedded call reports are a way to link two different call reports together. Two common ways this is being used is for separate risk assessment call reports, and follow-up call reports. This report will show the call report numbers of those call reports that are linked together, or related.


Call Reports Out of Database Referrals

For those clients using the Out of Database Referrals functionality, this file will contain the details of the out of database referrals made during the time frame of the export. Any details of the resource that the call taker included (Agency name, Program name, phone number, address, website, etc.) will be shown in this file.

Analysis of Export Files

The files are exported in .csv format, which can be displayed by Microsoft Excel. It is highly recommended that one have some knowledge of how to use Excel and its various functions to aid in analysing the data in the export files. There are many books, websites and courses that can teach one to use Excel.

One particularly helpful function is filtering. Using filtering, one can find very specific call reports. For example, you could use filtering to find all call reports from male callers (assuming, of course, that the gender of the caller is recorded in the call report). You can add an unlimited amount of filters to find increasingly specific call reports, such as male callers over the age of 60 who lives in Beverly Hills and discussed physical health concerns during their call.

In some cases, the particular data you might like to analyse will be contained in separate export files. For example, details on follow-ups are not contained in the same file as selections made in custom Groups. In this case, learning how to create pivot tables in Excel is very useful. In this way, you can link two files together to get a full picture of the call itself and the follow-up.

One last note – if you would like to save an export file to your hard drive, ensure you save it as an Excel file extension (.xlsx or .xls for example).

Tags: , , , , ,

Carmen Lovas

iCarol is your help line software company that is here to make your job easier as Executive Director or leader of a non-profit contact center. Whether you have a crisis, help or 211 referral line, we are here to help you help more people in your community. Read more...

Comments (2)

  • Kathy


    Hello! I am just wondering if there is a webinar available about Data Exports. thanks!


    • Dana


      Hi Kathy!
      Thanks for your comment — we actually don’t cover this information in a webinar at this time. If you’re a current user of iCarol, you’ll find several Help Articles about the export features in the Help section of your iCarol system. And you’re always welcome to submit a case to our support team if you need help or have a question, they’d be happy to assist.


Leave a comment

Follow Us On Twitter

iCarol Helplines Around the World!

Important to see a person separate from the problem & as the expert of their own lives - values for narrative documentation #KtA2016

LGBT Youth Line LGBT Youth Line

Get in touch: +1 888-4-iCarol
Copyright © 2013 iCarol