Monitoring survey exports

Survey export statistics are recorded in survey records whose Survey type value is 6 (SURVEY_EXPORT_STATS). There is one record for every export (scheduled or manually by Administrator), and every record has these A-fields that record specific information about the event.

These example reports demonstrate how to use some of the fields to monitor exports:

Tip: It is useful to copy the client and an internal contact on the Failed Emails Reports property as a warning when issues arise in the Export process.

Also, ensure that these emails are not filtered out of the inbox as many people filter out Success emails.

Export-specific A-Fields

These A-fields record the details of an export.

a_survey_export_elapsed_seconds
Survey export elapsed seconds — How long (seconds) the currently running export process has been running.
a_survey_export_end_date
Survey export end date — Timestamp when the survey export finished.
a_survey_export_exported_kbytes
Survey export exported kbytes — Size (kilobytes) of the export file.
a_survey_export_exported_records
Survey export exported records — Count of records exported.
a_survey_export_exported_via
Survey export exported via — Delivery method the export used (such as SFTP). Values include: 
  • FTP
  • EMAIL
  • SFTP_PASSWORD
  • SFTP_PUBLIC_KEY
  • FTPS_EXPLICIT
  • RESPONSES_FILTER
  • INVITATIONS_FILTER
  • ASK_NOW
a_survey_export_namea_survey_export_name
The survey export name – The  export specification name.
a_survey_export_requester
Survey export requester — Action that initiated the export.
  • MANUALLY_TRIGGERED — Triggered by the Export survey now button on the Export specifications screen.
  • SCHEDULE — A regularly scheduled export.
  • FEED_ACCOUNT — Not used by export monitoring.
a_survey_export_requester_details
Survey export requester details — Detailed information about the requester who initiated the survey export. For
  • SCHEDULE  this is the name of the Schedule that triggered the export.
  • MANUALLY_TRIGGERED this is the User Username.
a_survey_export_retry_seq_number
Survey export retry seq number — If a scheduled export fails, the system automatically retires the process. This is the sequence number of attempts for a scheduled export. 1 for first try and null for manually triggered exports. 
a_survey_export_start_date
Survey export start date — Timestamp date the export process started.
a_survey_export_status
Survey export status — The current status of the export. Values include:
  • RUNNING
  • SUCCESSFUL
  • FAILED

Example: Listing of exports

Uses several export A-Fields to report the details of recent export events.

Screen capture showing listing of exports

This Advanced Analytics codes reports the individual export listing

<analytics-report> 
<axis axis="x"> 
<optionbox-filter plugins="timeperiod,custom_filter,search" time-field="e_creationdate"/>  
<survey-type types="SURVEY_EXPORT_STATS"/>  
<record-field-split columns="a_survey_export_start_date,a_survey_export_end_date,a_survey_export_name,a_survey_export_exported_kbytes,a_survey_export_exported_records,a_survey_export_requester,a_survey_export_requester_details,a_survey_export_exported_via,a_survey_export_status,a_survey_export_retry_seq_number"/> 
</axis>  
<axis axis="y"> 
<!-- Commented out is an example of how to split on a feed account -->  
<!--<split field="a_feed_file_processing_report_feed_account" filter="true" values="Stay file pull"/>-->  
<record-split disable-survey-link="true"> 
<record-sort sort-field="a_survey_export_end_date" order="DESCENDING" row-limit="50"/> 
</record-split> 
</axis> 
</analytics-report>

Example: Status over time

Uses the a_survey_export_status field.

Screen capture of graph of export files over time

This Advanced Analytics codes graphs the successes and failures over time:

<analytics-report> 
<chart type="LINE"/>  
<axis axis="Time"> 
<optionbox-filter plugins="timeperiod" time-field="a_survey_export_start_date"/>  
<survey-type types="SURVEY_EXPORT_STATS"/>  
<timeperiod-dropdown-split/> 
</axis>  
<axis axis="# of Exports Files"> 
<aggregate operation="num_samples"/>  
<split field="a_survey_export_status"/> 
</axis> 
</analytics-report>

Example: Requestor over time

Uses the a_survey_export_requester field to report the actions that initiated the exports.

Screen capture of chart of exports of files over time

This Advanced Analytics codes graphs the export types over time:

<analytics-report> 
<chart type="COLUMN"/>  
<axis axis="Time"> 
<optionbox-filter plugins="timeperiod" time-field="a_survey_export_start_date"/>  
<survey-type types="SURVEY_EXPORT_STATS"/>  
<timeperiod-dropdown-split/> 
</axis>  
<axis axis="# of Exports Files"> 
<aggregate operation="num_samples"/>  
<split field="a_survey_export_requester"/> 
</axis> 
</analytics-report>