Customer satisfaction score aggregation and trends

**Purpose**

1. Aggregate customer satisfaction scores from digital surveys, email feedback, kiosk terminals, and social media, then identify trends for acrobatic diving pools.
2. Enable management to evaluate guest experiences, monitor facility performance, and make swift operational adjustments by visualizing up-to-date satisfaction data.
3. Ensure timely reporting to stakeholders, facilitate comparisons across seasons and events, and pinpoint service improvement areas.

**Trigger Conditions**

1. New survey submitted via online, mobile, or kiosk platforms.
2. Satisfaction data received through email or social comments.
3. Scheduling-based data collection (e.g., nightly at 3:00 AM).
4. Manual trigger for ad-hoc aggregation by management staff.

**Platform Variants**

3.1. SurveyMonkey
- Feature/Setting: Webhook to send response data upon survey submit.
- Sample: Configure webhook URL in Survey Options → Integrations.

3.2. Google Forms
- Feature/Setting: Google Apps Script Trigger on form submit.
- Sample: Script Editor → “onFormSubmit” function.

3.3. Typeform
- Feature/Setting: Webhook integration for each new response.
- Sample: Connect → Webhooks → Add endpoint, enable real-time push.

3.4. Zendesk
- Feature/Setting: API endpoint for ticket satisfaction rating.
- Sample: GET /api/v2/satisfaction_ratings.json

3.5. Salesforce
- Feature/Setting: Salesforce Flow for survey data capture.
- Sample: Flow Builder → “Survey Response Created” trigger.

3.6. Microsoft Forms
- Feature/Setting: Power Automate “When a new response is submitted”.
- Sample: Select trigger → link to aggregation workflow.

3.7. Qualtrics
- Feature/Setting: Outbound Webhook on survey completion.
- Sample: Actions → Webhook → configure endpoint.

3.8. Freshdesk
- Feature/Setting: API GET for customer feedback ratings.
- Sample: GET /api/v2/surveys/responses

3.9. Facebook Graph API
- Feature/Setting: Webhook for public comments and ratings.
- Sample: Set app webhook, listen for "feed" field events.

3.10. Twitter API (X)
- Feature/Setting: Stream hashtags or mentions for feedback.
- Sample: GET /2/tweets/search/stream, filter diving pool terms.

3.11. Google Sheets
- Feature/Setting: Script on row add or change.
- Sample: Trigger → “onEdit” or “onChange” handler.

3.12. Slack
- Feature/Setting: Incoming Webhooks or API Bot to post feedback.
- Sample: Post to a channel → listen to new messages.

3.13. Intercom
- Feature/Setting: API for survey conversation ratings.
- Sample: GET /conversations, parse “rating” fields.

3.14. Medallia
- Feature/Setting: Real-time API push for survey data.
- Sample: API integration point → define POST schema.

3.15. Email (Outlook/IMAP)
- Feature/Setting: Poll for new survey feedback.
- Sample: Connect via IMAP, parse feedback emails.

3.16. Zoho Survey
- Feature/Setting: Webhook for survey completion.
- Sample: Survey Settings → Webhook URL.

3.17. Ticketing Kiosk (Custom IoT)
- Feature/Setting: REST API POST on satisfaction screen.
- Sample: Device sends JSON to endpoint after user submit.

3.18. Power BI
- Feature/Setting: Dataset API push row.
- Sample: POST to /v1.0/reports/datasets/rows

3.19. Tableau
- Feature/Setting: Data Extract API for syncing new records.
- Sample: Use Tableau Hyper API to import scores.

3.20. SAP SuccessFactors
- Feature/Setting: OData API for survey and feedback forms.
- Sample: GET /odata/v2/SurveyResponses

**Benefits**

1. Real-time satisfaction aggregation streamlines decision-making.
2. Granular trend analysis for timely, targeted improvements.
3. Centralizes multichannel feedback, reducing manual effort.
4. Provides accessible, visual analytics for non-technical staff.