Changes between Version 3 and Version 4 of RSVPConversion

Timestamp:

05/28/26 00:10:18 (5 hours ago)

Author:

193284

Comment:

--

RSVPConversion

@@ -500 +500 @@
     3
 );
+
+INSERT INTO guest (
+    first_name,
+    last_name,
+    email,
+    wedding_id
+)
+VALUES
+(
+    'Ana',
+    'Petrovska',
+    'ana@email.com',
+    3
+),
+(
+    'David',
+    'Stefanovski',
+    'david@email.com',
+    3
+),
+(
+    'Elena',
+    'Trajkovska',
+    'elena@email.com',
+    3
+);
+
+INSERT INTO event_rsvp (
+    response_date,
+    status,
+    guest_id,
+    event_id
+)
+VALUES
+(
+    '2024-08-01',
+    'CONFIRMED',
+    1,
+    1
+),
+(
+    '2024-08-02',
+    'CONFIRMED',
+    2,
+    1
+),
+(
+    '2024-08-03',
+    'DECLINED',
+    3,
+    1
+);
+
+INSERT INTO attendance (
+    status,
+    table_number,
+    role,
+    guest_id,
+    event_id
+)
+VALUES
+(
+    'ATTENDED',
+    1,
+    'Guest',
+    1,
+    1
+),
+(
+    'ATTENDED',
+    1,
+    'Guest',
+    2,
+    1
+);
 }}}
 
@@ -505 +580 @@
 
 {{{
- wedding_id | organizer_name | event_type | invitations
-------------+----------------+------------+-------------
- 3          | Марко Николов  | Ceremony   | 15
+ wedding_id | organizer_name | wedding_date | event_id | event_type | total_invitations | rsvp_responses | confirmed_rsvps | declined_rsvps | attendance_records | actual_attendees | rsvp_response_rate_percent | confirmation_rate_percent | attendance_conversion_percent
+------------+----------------+--------------+----------+-------------+-------------------+----------------+------------------+-----------------+--------------------+------------------+-----------------------------+----------------------------+--------------------------------
+ 3          | Марко Николов  | 2024-08-10   | 1        | Ceremony    | 3                 | 3              | 2                | 1               | 2                  | 2                | 100.00                      | 66.67                      | 100.00
 }}}
 
@@ -513 +588 @@
 
 * Total Invitations:
-  * total invited guests
+  * 3 invited guests
 
 * RSVP Responses:
-  * guests who submitted RSVP responses
+  * all invited guests submitted RSVP responses
 
 * Confirmed RSVPs:
-  * responses with CONFIRMED status
-
-* Attendance Conversion:
-  * actual attendees compared to confirmed RSVPs
-
-* Response Rate:
-  * RSVP responses relative to invitations
+  * 2 guests confirmed attendance
+
+* Declined RSVPs:
+  * 1 guest declined the invitation
+
+* Attendance Records:
+  * 2 attendance records created
+
+* Actual Attendees:
+  * 2 guests attended the event
+
+* RSVP Response Rate:
+  * (3 / 3) × 100 = 100.00%
+
+* Confirmation Rate:
+  * (2 / 3) × 100 = 66.67%
+
+* Attendance Conversion Rate:
+  * (2 / 2) × 100 = 100.00%
+
+* Operational Insight:
+  * all confirmed guests successfully attended the event, indicating strong RSVP reliability
 
 == Summary ==