Exporting Call History Data

1: About Call History Data Exports

The CATI Supervisor allows call history data to be exported. This data includes a number of call properties - see the list below. This data can include calls made in the course of a single or a number of surveys.

The exported data is limited to a maximum of 1000000 call attempts and 100000 interviewer breaks.

Call history data is exported in the tab delimited format as a plain text file. This file is saved under the CallHistoryData.txt name and exported as an archive in ZIP format.

The resulting file can be encrypted to restrict access to any PII data it may contain (go to Security Settings for more information).

The format of the tab-delimited file is as follows:

• Date time – UTC timestamp for the time the call was finished.
• Survey ID – The Survey ID (Pxxxxx) for the survey, or "BREAK-Survey ID" survey-specific breaks, or "BREAK" for non-survey-specific breaks, or "LOGIN" and "LOGOUT" for session events.
• Survey Name - The name of the survey.
• Interview ID – The interview ID (respondent ID) for the call attempt made.
• Interviewer ID – The numeric ID of the CATI interviewer who made the call (blank for interviewer breaks).0
• Interviewer Name - The name of the CATI interviewer that made the call
• Telephone Number – The telephone number of the respondent.
• Extended Status – The numeric value of the extended status for the call outcome.
• Duration – The duration of the call made in seconds.
• Waiting time - The time spent (in seconds) waiting for the call to be delivered.
• Call Center - The name of the Call Center the exported data pertains to (this is the current Call Center indicated in the header frame (go to Default and Current Call Centers for more information).

Data in the file is sorted first by SurveyID and then by date/time timestamp.

2: Exporting Call History Data

1. Go to the Navigation menu > Survey tab and select one or a number of surveys.
2. Either right-click on a selected survey and choose Call History Export from the context menu that appears, or click the Call History Export icon on the frame toolbar.

The Export Call History Data page opens.



• You can export call history data for all selected surveys - check the Include Data From All Surveys option. Note that this option is only available for supervisors who have been granted the appropriate permission by the system administrator.
• You can export data for all calls that have been made for all the selected surveys - check the No Date Time Filter option, or you can select the desired time range using the Start Time and End Time controls.

If you opt to select a time range, note that these dates and times are based on the local time (in the timezone which has been set as "local" in the Active Timezone List) (go to Setting the Selected Active Timezone as Local for more information). You must then select the start/end date and time.

• You can choose whether you want the call history to include data regarding all interviewer breaks that were taken during the selected period - check the appropriate box.
• You can include all log in/log out events for the selected survey(s) - check the Include interviewer login and logout events for the selected time period option. The resulting file will include the start and end time for each type of event, and the ID of the relevant interviewer. This data is separated into groups - each survey included in the report will be followed by the selected data.
• You can include additional information on some variables. This information will be added as extra columns to the generated report. Note that you can include only variables that are marked as "Available as CATI filter" in Forsta Professional Authoring, refer to the Professional Authoring documentation for details. To include variables, check the Include Variables box and then enter the variable names in the field separated by a semicolon. If a variable you have included here is absent, the corresponding column will be created in the report but it will remain empty.

The lower part of the dialog lists and describes the contents of the file.

3. Click Export to start, or Cancel to terminate the procedure.

The Call history data is exported as a single archive file containing two files; an XML description file, and a tab-delimited file in plain text format that contains the data. A standard Windows dialog appears asking whether you want to open or save the file. If you choose Save you must select a path to the location where the file is to be saved. If you choose to open the file, it is opened in the archive utility (one should be installed on your machine, or the default Windows archive utility must be present). Choose the file with the TXT extension to read the call history data.