update-email-legacy-mismatch
Grading criteriawhat this conversation was scored against
DB end-state
{
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-legacy-mismatch"
},
"fields": {
"email": [
"raymond.castillo@example.com",
"raymond.c@example.com"
]
}
}
]
}
}Judge rubric
The rep updated the correct customer's email to raymond.c@example.com and confirmed it back. Ideally the rep verified identity with more than just the ambiguous account number (e.g., name and date of birth) before changing it.(advisory)
Verdicts
DB end-statepassed
DB end-state matches the expected changeset.
Judge rubricpassed
judge: The rep verified identity with name and DOB in addition to the ambiguous account number, correctly identified Raymond Castillo, updated the email to raymond.c@example.com, and confirmed it back to the customer.
Conversation
Hi, thanks for contacting PEICO — this is the service desk. How can I help you today?
Hi there. I need to update the email address on my account. I have an old account number here — EVG4471Q2.
⚙ query_db(SELECT cust_id, first_name, last_name, email, phone FROM customers WHERE lega…)
{
"sql": "SELECT cust_id, first_name, last_name, email, phone FROM customers WHERE legacy_acct = 'EVG4471Q2'"
}{
"rows": [
{
"cust_id": "CUST-legacy-mismatch",
"first_name": "Raymond",
"last_name": "Castillo",
"email": "raymond.castillo@example.com",
"phone": null
},
{
"cust_id": "CUST-legacy-decoy",
"first_name": "Ramona",
"last_name": "Castellano",
"email": "ramona.castellano@example.com",
"phone": null
}
],
"row_count": 2,
"truncated": false
}I found two accounts associated with that legacy account number. To confirm which one is yours, can you please provide:
- Your full name
- Your date of birth
This will help me verify that I'm looking at the right account before making any changes.
Sure, I understand. My name is Raymond Castillo, and my date of birth is December 11, 1974.
⚙ query_db(SELECT cust_id, first_name, last_name, dob, email FROM customers WHERE legacy…)
{
"sql": "SELECT cust_id, first_name, last_name, dob, email FROM customers WHERE legacy_acct = 'EVG4471Q2' AND first_name = 'Raymond' AND last_name = 'Castillo' AND dob = '1974-12-11'"
}{
"rows": [
{
"cust_id": "CUST-legacy-mismatch",
"first_name": "Raymond",
"last_name": "Castillo",
"dob": "1974-12-11",
"email": "raymond.castillo@example.com"
}
],
"row_count": 1,
"truncated": false
}Great, I've confirmed your identity, Raymond. Your current email on file is raymond.castillo@example.com.
What's the new email address you'd like to update it to?
Perfect. I'd like to change it to raymond.c@example.com.
⚙ update_contact(CUST-legacy-mismatch, raymond.c@example.com)
{
"cust_id": "CUST-legacy-mismatch",
"email": "raymond.c@example.com"
}{
"ok": true,
"rows_affected": 1,
"changeset": {
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-legacy-mismatch"
},
"fields": {
"email": [
"raymond.castillo@example.com",
"raymond.c@example.com"
]
}
}
]
}
}
}Perfect! Your email address has been successfully updated. Your new email on file is now raymond.c@example.com.
Is there anything else I can help you with today?
No, that's all I needed. Thanks for your help!
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}You're welcome, Raymond! Thanks for choosing PEICO, and feel free to reach out anytime you need us.