Weekly summary of survey responses received.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts |
Overview
Overview
This is a weekly summary of all survey responses, emailed as an Excel spreadsheet on Sunday evening for the previous week. There is also an on-demand SSRS report that can be run directly from the SSRS reports folder. It allows you to filter by branch, specific survey, and number of days to look back for results.
Run Schedule: Weekly, Sunday evening
Type of Output: Email / On Demand SSRS Report
* * *
Sample
Sample
Sample of Excel attachment in email:
* * *
Variables
Variables
Variable X: Enter 'Yes' to send the summary to the recipients specified on each survey. Setting this variable to 'No' will send the summary to those set on ID394 as the recipients.
**Please note, if you enter Yes in Variable X, the To/CC/BCC on ID394 will not work.
Variable Y: Days Back: The number of days back to send the export of surveys, the default is 7.
* * *
Alert Functionality
Alert Functionality
This alert sends an Excel spreadsheet listing all survey responses. If you are subscribed to multiple surveys, each survey will have a separate spreadsheet. If Variable X is set to 'Yes', each spreadsheet will be emailed to the specific recipients for that survey. If Variable X is set to 'No', each spreadsheet will be emailed to the recipients listed on ID394.
* * *
OnDemand Report Filters
OnDemand Report Filters
You can run this report in the SSRS console:
Report filters:
1. Days to look back.
2. The branches to use on the report.
3. The specific survey to report on (if you have multiple running.)
4. Click on View Report to see the results.
* * *
Best Practices & Tips
Best Practices & Tips
None at this time.
* * *
Related Alerts
Related Alerts
ID109 - Service Call Survey
ID220 - Supply Order Survey
ID271 - Employee Survey
ID312 - Equipment Install Survey
ID373 - Executive Contact Survey
ID379 - Site Survey
ID557 - Monthly Summary of Survey Results
ID695 - Survey Results e-view
* * *
0 Comments