KPI Registry

Critical Data Quality Issues

Records carrying a Critical-severity data quality defect. These block event operations and must be cleared first.

High Severity Data Quality Issues

Records carrying a High-severity defect — serious, but not immediately blocking.

Issues Awaiting Triage

Detected issues not yet assigned, started or closed.

Resolved Data Quality Issues

Issues closed by a person, or automatically once a later scan stopped detecting them.

Data Quality Resolution Rate

Share of all detected issues that have been closed.

Records Affected by Data Quality Issues

Distinct records carrying at least one detected issue — the true remediation workload.

Data Completeness Issues

Missing mandatory information — the largest driver of the Completeness score.

Data Integrity Issues

Broken relationships and references — records pointing at things that do not exist.

Data Consistency Issues

The same fact stored two different ways, including duplicated identity documents.

Data Validity Issues

Values present but outside the accepted range, format or allowed set.

Data Compliance Issues

Records missing the documentation or consent the event is required to hold.

Guest Data Quality Issues

Every detected defect on a Guest record, across all five dimensions.

Duplicate Passport Defects

Contacts sharing an identification number — the most serious consistency failure, because it silently merges two people.

Overall Data Quality Score

Weighted overall score across the five data quality dimensions, for the selected event.

Data Completeness Score

Share of mandatory fields that are actually populated.

Data Integrity Score

How intact the relationships between records are.

Data Consistency Score

How free the data is of contradictions and duplicate identities.

Data Validity Score

Share of values that fall inside their accepted range, format or allowed set.

Data Compliance Score

Share of required documentation and consent actually held.

Contact Duplicate Rate

Percentage of CRM contacts sitting in a suspected-duplicate group.

Event Data Readiness

How ready the data behind the selected event is to run it — the readiness areas rolled into one score.

Survey Invitations Sent

Recipients the post-event survey was dispatched to (SurveyTracking.sent). Stage 1 of the delivery funnel.

Survey Invitations Delivered

Invitations that actually reached an inbox or handset (SurveyTracking.delivered). Distinct from sent: a message can be dispatched and then bounce. Stage 2 of the delivery funnel.

Survey Invitations Failed

Invitations that failed outright (hard bounce on email, undelivered on SMS). A failed recipient is never opened, started or completed, so this is a strict subset of sent-not-delivered.

Survey Links Opened

Recipients who opened the survey link (SurveyTracking.opened). Stage 3 of the delivery funnel.

Survey Responses Started

Recipients who began answering questions (SurveyTracking.started). Stage 4 of the delivery funnel.

Survey Responses Completed

Recipients who completed and submitted the survey (SurveyTracking.completed). Final stage of the delivery funnel; equals the count of completed SurveyResponse rows.

Survey Delivery Rate

Delivered of sent. Denominator = invitations dispatched, not guests invited, so a failed send counts against this rate.

Survey Open Rate

Opened of delivered. A failed delivery is excluded from the denominator — the recipient never had the chance to open.

Survey Start Rate

Started of opened. Measures how many recipients who opened the link actually began answering — a low rate points at the invitation or the first page, not at the questions.

Survey Completion Rate of Started

Completed of started. A partial (in_progress) response is never counted as completed, so this measures true drop-off inside the questionnaire.

Survey Overall Completion of Sent

Completed of sent — the end-to-end yield of the survey campaign. NOT the same figure as KPI-021 (Response Rate), which measures respondents as a share of attendees. This one is measured against invitations dispatched.

NPS Promoter Rate

Share of completed respondents who scored 9 or 10 on the recommendation question. Denominator = completed responses that answered the score (partial responses excluded).

NPS Passive Rate

Share of completed respondents who scored 7 or 8 on the recommendation question. Denominator = completed responses that answered the score (partial responses excluded).

NPS Detractor Rate

Share of completed respondents who scored 0 to 6 on the recommendation question. Denominator = completed responses that answered the score (partial responses excluded).

Net Promoter Score

Promoter rate minus detractor rate, in percentage points — the classic NPS. NOT the same figure as KPI-022 (Average Recommendation Score), which is the mean of the 0-10 answers themselves. Uses NET_PERCENTAGE, whose result is already in points, so its format is Score: a value of 9.1 reads as 9.1, never 9.1%.

Would Attend Again Rate

Completed respondents answering Yes to 'Would you attend WSS again?' (G1), as a share of those who answered it. Skipped answers are excluded from the denominator, never counted as No.

Badge Support Contact Rate

Completed respondents answering Yes to 'Did you need to contact the support team about your badge or access?' (B4), as a share of those who answered it. Lower is better.

Concierge Use Rate

Completed respondents answering Yes to 'Did you use the concierge service?' (C5), as a share of those who answered it. Skipped answers are excluded.

Mobile App Use Rate

Completed respondents answering Yes to 'Did you use the WSS mobile app?' (F1), as a share of those who answered it. Skipped answers are excluded.

Average Registration Ease

Mean rating (1-5) of 'How easy was the registration process?' (B1) across completed responses that answered it. Skipped answers are excluded from the mean, never treated as zero.

Average Flight Arrangements

Mean rating (1-5) of 'How would you rate your flight arrangements?' (C1) across completed responses that answered it. Skipped answers are excluded from the mean, never treated as zero — so guests who had no flight do not drag the average down.

Average Hotel Accommodation

Mean rating (1-5) of 'How would you rate your hotel accommodation?' (C2) across completed responses that answered it. Skipped answers are excluded from the mean, never treated as zero.

Average Ground Transportation

Mean rating (1-5) of 'How would you rate ground transportation (rides and transfers)?' (C4) across completed responses that answered it. Skipped answers are excluded from the mean, never treated as zero.

Average Session Relevance

Mean rating (1-5) of 'How relevant were the sessions to your interests?' (D1) across completed responses that answered it. Skipped answers are excluded from the mean, never treated as zero.

Average Speaker Quality

Mean rating (1-5) of 'How would you rate the quality of speakers?' (D4) across completed responses that answered it. Skipped answers are excluded from the mean, never treated as zero.

Average Catering Rating

Mean rating (1-5) of 'How would you rate catering and refreshments?' (E2) across completed responses that answered it. Skipped answers are excluded from the mean, never treated as zero.

Average Mobile App Rating

Mean rating (1-5) of 'How would you rate the mobile app?' (F2) across completed responses that answered it. Only guests who used the app reach this question, so the denominator is app users — not all respondents.

Expectation Met Agreement

Share of completed respondents answering Agree or Strongly Agree to 'The event met my expectations.' (A3), of those who answered it. Arabic-language responses use the Arabic scale labels and are counted on the same scale.

Badge Collection Ease Agreement

Share of completed respondents answering Agree or Strongly Agree to 'Badge collection or reprint was quick and easy.' (B3), of those who answered it. Arabic-language responses use the Arabic scale labels and are counted on the same scale.

Signage Clarity Agreement

Share of completed respondents answering Agree or Strongly Agree to 'Signage and wayfinding at the venue were clear.' (E1), of those who answered it. Arabic-language responses use the Arabic scale labels and are counted on the same scale.

Vehicles Deployed

Distinct fleet vehicles assigned to at least one ride for the event (COUNT_DISTINCT over TransportBooking.vehicle_id). Rides with no vehicle assigned do not count. Cross-checked against raw assignments: WSS 2026 = 8 of the 10-vehicle fleet deployed across 31 rides, WSS 2025 = 8 across 21 rides.

Pending Security Clearance

Security-clearance approvals still pending.

Badge Queue

Badges not yet printed (generated or not generated).

Stages Over Target

Approvals decided after their SLA deadline (breaches).

Active Alerts

Approvals pending or escalated.

Open Concierge Requests

Count of ConciergeRequest records with status = Open.

Open Alerts

Count of Alert records with status = Open (operational alerts, distinct from KPI-035 which counts active approval workflows).

Travel Request to Confirmation Duration

Mean elapsed time (days) between FlightBooking creation and confirmation. Target: 7 days.

Average Accreditation Review Duration

Mean elapsed time (days) from approval creation to decision. Proxy: uses Approval.created_date as start (approximates document submission completion) and Approval.decision_at as end.

Non-Responsive Guest Count (All Time)

Count of guests in invite_sent status without a Confirmed or Declined response. PROXY: the dictionary's 72-hour elapsed-time threshold is not supported by the resolver (no dynamic NOW() comparison). This metric counts ALL invite_sent guests regardless of elapsed time — use as a worklist total, not a time-thresholded count.

Badge Scan Error Rate

Percentage of check-in scans denied vs total attempts.

Document Rejection Rate

Percentage of submitted documents marked Rejected vs total submitted (Uploaded + Rejected).

RSVP Response Time

Average elapsed time (days) between campaign invitation sent and guest response. Only definitive responses (Accepted) included in current data.

Decline Rate

Percentage of guests who have declined. Declines are final.

Cancellation Rate

Share of ground-transport rides cancelled: status = cancelled ÷ ALL transport bookings for the event. A lower number is better, so the target band is expressed as an upper bound. Cross-checked against raw counts: WSS 2026 = 5 of 31 = 16.1%, WSS 2025 = 6 of 21 = 28.6%. Cancellations are a real, populated status in both events, so this is a genuine operational ratio — not a placeholder.

RSVP Acceptance Rate

Share of invited guests who confirmed attendance. Numerator: rsvp_status = confirmed; denominator: rsvp_status IN [invite_sent, confirmed, declined] (dictionary 'invited' maps to live 'invite_sent').

Badge Print Completion Rate

Share of authorised badges that have been printed. Numerator: status = Printed; denominator: status IN [Generated, Printed] (authorised badges).

Hotel Confirmation Rate

Hotel occupancy = rooms actually stayed / rooms confirmed. SUM-based RATIO using rooms_required. Numerator: SUM(rooms_required) where status IN [checked_in, checked_out] (stayed); denominator: SUM(rooms_required) where status IN [confirmed, checked_in, checked_out] (all non-cancelled bookings). NOTE: only 2 live rows (thin sample).

Badge Generation Rate

Share of badge issuances that have been authorised (beyond NotGenerated). Numerator: status IN [Generated, Printed, Reissued]; denominator: all BadgeIssuance records. (Approval status=Approved join not used — BadgeIssuance has no link field to Approval.)

Check-In Rate

Share of expected guests who checked in at the venue.

Accreditation Completion Rate

Share of approval workflow records that reached Approved. Numerator: Approval.status = Approved; denominator: all Approval records (no filter).

Flight Ticketing Rate

Share of flight bookings that are confirmed (reached ticketing). Numerator: status IN [ticketed, tickets_shared, landed, completed] — the dictionary's literal 'confirmed'/'ticketed' has 0 exact matches, but confirmed = ticketed-or-beyond; both live bookings are post-ticketing. Denominator: all FlightBooking records. NOTE: only 2 live rows (thin sample).

Hotel Check-In Rate

Share of VIP-tier room allocations (suite/presidential) successfully confirmed. Scope: room_type IN [suite, presidential]; numerator: status IN [confirmed, checked_in]; denominator: all scoped VIP-tier bookings.

VIP Acceptance Rate

RSVP acceptance rate scoped to VIP-category guests. scope_filter: category = vip (applied to both numerator and denominator); numerator: rsvp_status = confirmed; denominator: rsvp_status IN [invite_sent, confirmed, declined]. NOTE: live Guest.category is near-empty — only 1 record has category='vip' (the dictionary's 'VIP A' does not exist as a stored value), so this KPI is live-ready but produces a degenerate 1-record denominator until VIP categorisation is populated.

Invitation Success Rate

Share of invitations successfully delivered. Numerator: status = delivered; denominator: status IN [sent, delivered, failed]. (Real CommunicationLog values: delivered/opened/clicked/failed — no 'sent' or 'bounced' in live data; opened/clicked are post-delivery engagement, excluded from the delivery denominator.)

Registration Completion Rate

Share of confirmed guests who completed registration. Numerator: registration_status = complete (dictionary 'submitted' does not exist as a live value — the real completion value is 'complete'); denominator: rsvp_status = confirmed.

Team SLA Adherence

Team SLA Adherence — percentage of approval decisions made within the SLA deadline (decision_at <= sla_deadline). Baseline corrected on 2026-09-16 — original sla_deadline values predated created_date (SLA deadlines before the record was even created) and produced a false 70.0%/57.1% reading from two independently corrupted fields canceling out. Corrected sla_deadline to created_date + 5 days (realistic target). Corrected value reflects genuine ~45% SLA adherence against a realistic 5-day target.

Visa Approval Rate

Share of required visas that were approved.

VIP Journey Completion Rate

Share of VIP guests whose full journey stages are complete.

Government Officials Confirmed

Count of UAE-government guests with RSVP confirmed.

WhatsApp Read Rate

Opened ÷ delivered+opened+failed among WhatsApp messages.

Hotels Allocated

Distinct hotels with room bookings.

NPS

Average Net Promoter Score from post-event survey responses (0-10 scale).

Concierge Adoption Rate

Percentage of VIP guests who have used the concierge service at least once.

Post-Event Survey Response Rate

Percentage of attended guests (Granted check-in) who completed the post-event survey.

Document Submission Rate

Percentage of submitted documents that are in Uploaded status (vs Missing/Rejected).

Concierge SLA Response Compliance

Percentage of concierge requests responded to within the 30-minute SLA deadline.

Average Satisfaction

Average overall satisfaction rating from post-event survey responses (1-5 scale).

Speaker AV Confirmation Rate

Percentage of speakers with confirmed AV requirements (av_requirements_status = confirmed).

Confirmed Guests

Count of guests with rsvp_status = confirmed.

Speaker Bio Approval Rate

Percentage of speakers with approved biography (bio_status = approved).

Resolved Concierge Requests

Count of ConciergeRequest records with status = Resolved.

Speaker Travel Confirmed Rate

Percentage of speakers with confirmed travel (speaker_travel_confirmed = true).

Speaker Photo Approval Rate

Percentage of speakers with approved photo (photo_status = approved).

Onsite Guests

Count of distinct guests who have checked in (CheckInLog.access_status = Granted).

Total Invited Guests

Total count of guest records for the event.

Agenda Readiness Rate

Percentage of sessions with status=Published (ready for public agenda display). 0 sessions = 0% (agenda not yet built).

Invitation Delivery Rate

Percentage of communications marked Delivered. Per-channel breakdown (email/whatsapp) is a dashboard segmentation concern.

Active Registration Cases (Total)

Total count of pending registration submissions. Per-officer breakdown is a dashboard segmentation on assigned_officer_id.

Booking Conversion Rate

Percentage of experience bookings that converted from Pending. Confirmed-then-cancelled still counts as converted. Target: >85%.

Visa Approval Rate

Percentage of visa-required guests with approved visa status. Excludes not_required. Per-nationality breakdown is a dashboard segmentation.

Communication Response Rate

Percentage of delivered communications that received an RSVP response (accepted or declined). Denominator includes all delivery-implying statuses (delivered, opened, clicked) — a response without delivery is logically impossible, so responded records with opened/clicked status are correctly included in the denominator.

Speaker Travel Confirmed Rate

Percentage of speakers with confirmed travel. One component of the Speaker Readiness Checklist (full checklist requires all four: bio_status, photo_status, av_requirements_status, speaker_travel_confirmed).

Badge Production Rate

Percentage of generated badges that have been printed. Per-category breakdown is a dashboard segmentation.

Speaker Readiness Score

Composite of the four speaker readiness sub-KPIs (Bio Approval, Photo Approval, AV Confirmation, Travel Confirmed) — each weighted equally. Measures overall speaker readiness across the bio/photo/AV/travel dimensions that exist as live KPIs today. Excludes presentation/briefing/green-room stages (no fields or KPIs for those yet).

Event Readiness Score

Weighted composite of 9 readiness sub-scores: Registration (KPI-004), Accreditation (KPI-006), Flights (KPI-008), Hotels (KPI-010), Badges (KPI-007 — Badge Generation Rate chosen over KPI-014 Badge Print Completion Rate because it measures the full pipeline including not-generated badges, not just the print step of already-generated ones), Speaker Readiness (KPI-049, itself a composite), Communications (MET-002 Invitation Delivery Rate), Transportation (KPI-052 Transportation Confirmation Rate — added once TransportBooking gained real event-linked, guest-linked rows), Operations (KPI-025 Team SLA Adherence). Excluded sub-scores: Venues (no existing KPI — Session/AccessZone live-occupancy confirmed absent). MET-023-style transport on-time/utilization remains deferred: TransportBooking has no vehicle_id, driver_id, sub_event_id or flight_booking_id assignment, every row carries passengers=1, and only pickup_date/pickup_time exist — no scheduled-vs-actual timestamps, so no on-time or utilization rate is computable. Each sub-score weighted equally (weight 1).

Confirmed & Registered Guests

Guests who are BOTH RSVP-confirmed and registration-complete (registration_status=complete AND rsvp_status=confirmed). This is the strictly-nested registration milestone: its row set is a true subset of KPI-042 (Confirmed = 109) and of KPI-046 (Total Invited = 150). It exists because KPI-004 (Registration Completion Rate) counts every registration_status=complete guest regardless of RSVP status, which at WSS 2026 includes 10 guests who completed registration without ever being confirmed. Use KPI-004 for the rate-as-reported and KPI-051 where a stage must nest inside Confirmed.

Rides In Progress

Live operational count of transport bookings currently underway (status = in_progress) for the event. Unlike KPI-052 this is a point-in-time operational figure, not a rate — it is deliberately NOT a KPI-050 sub-score (the composite averages percentage-format rates only). Cross-checked against raw counts: WSS 2026 = 6, WSS 2025 = 0 (the 2025 backfill has no in_progress rows).

Transportation Confirmation Rate

Share of ground-transport bookings that are confirmed/executed: rides completed or in progress ÷ ALL transport bookings (cancelled included, so cancellations lower the rate). TransportBooking has no 'confirmed' status value, so the dictionary's confirmed-or-completed maps onto the real enum as status IN [completed, in_progress]; 'scheduled' counts as not-yet-confirmed. Denominator = every TransportBooking row for the event. Cross-checked against raw counts: WSS 2026 = 16/31 = 51.6%, WSS 2025 = 15/21 = 71.4%.

Flights Landed

Live operational count of flight bookings whose guest has arrived at the destination (status = landed) for the event — the flights equivalent of KPI-053 Rides In Progress, and the live counterpart to the Pre-Event readiness rate KPI-008 Flight Ticketing Rate. Deliberately a point-in-time operational count, not a rate: it is NOT a KPI-050 readiness sub-score (the composite averages percentage-format rates only). 'landed' is set by a manual agent/handler trigger — there is no live flight-tracking API yet (honest-mock mode). Cross-checked against raw counts: WSS 2026 = 7 of 33 flight bookings, WSS 2025 = 4 of 22.

Guests Checked In

Live operational count of room bookings whose guest is currently checked in to their hotel (status = checked_in) for the event — the hotel equivalent of KPI-053 Rides In Progress and KPI-054 Flights Landed, and the live counterpart to the Pre-Event readiness rate KPI-010 Hotel Confirmation Rate. Distinct from KPI-011 Hotel Check-In Rate, which is a RATIO readiness percentage; this is a point-in-time operational count of guests currently in-house (guests who finish their stay move to checked_out and drop out of the count). NOT a KPI-050 readiness sub-score (the composite averages percentage-format rates only). Cross-checked against raw counts: WSS 2026 = 13 of 38 room bookings, WSS 2025 = 7 of 28.

Total Rides

Total ground-transport rides booked for the event — a straight COUNT of every TransportBooking row, with no status filter (cancelled rides included, so this is total demand booked, not rides delivered). Cross-checked against raw counts: WSS 2026 = 31 rides, WSS 2025 = 21 rides.