How do I verify that the survey response rate displayed on the Community page is correct?

The Survey Response Rate is the number of members with an activity status of Completed, Disqualified, or Over Quota who were invited to complete a survey within the last 30 days. It is expressed as a percentage of total members invited in the last 30 days.

To calculate the Survey Response Rate, the application uses the following formula:

(# Completes + # Disqualified + # Overquota in the last 30 days) / # Invitations in the last 30 days

If you are unsure whether the Survey Response Rate is correct, you can export member participation data and manually check the calculation in Excel. Follow the steps below to do so.

Detailed Steps

1. In the Community app, click Community > Metrics.
2. Click Export Member Participation Data.
3. Select start and end dates based on the Updated date stamp displayed in the Survey Response Rate widget.
   • Choose a start date 30 days prior to the Updated date stamp.
   • Choose an end date to match the Updated date stamp.
   
4. Click Export. 
5. Open the CSV file in Excel.
6. If necessary, filter the CSV file so that it only displays rows with an ActivityType value of Survey, and an InvitedDate within the last 30 days.

   In the survey event columns, there is a 1 in the cell if an event occurred.

7. Add all the 1s for SurveyDisqualified, SurveyCompleted, and SurveyOverQuota.
8. Add all the 1s from SurveyInvited.
   
9. Divide the step 7 total by the step 8 total, and then multiply the answer by 100.

More Information

Please click the WebHelp links below for more information:

• The Community page
• Export member participation data