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 recognized the ambiguous account number, requested additional verification (name and DOB), received both, and then confirmed the email update to raymond.c@example.com.
Conversation
Hi, thanks for contacting PEICO — this is the service desk. How can I help you today?
Hi, thanks for picking up. I need to update the email address on my account. My account number is EVG4471Q2.
⚙ query_db(SELECT cust_id, first_name, last_name, email, phone, legacy_acct FROM custome…)
{
"sql": "SELECT cust_id, first_name, last_name, email, phone, legacy_acct 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,
"legacy_acct": "EVG4471Q2"
},
{
"cust_id": "CUST-legacy-decoy",
"first_name": "Ramona",
"last_name": "Castellano",
"email": "ramona.castellano@example.com",
"phone": null,
"legacy_acct": "EVG4471Q2"
}
],
"row_count": 2,
"truncated": false
}I found two records tied to that legacy account number, so I need one more detail to make sure I update the right person.
Please reply with either:
- the full name on the account, or
- the date of birth, or
- the current email address on file
And please include the new email address you want me to save.
Got it. My name is Raymond Castillo, and my date of birth is December 11, 1974. I want to change my email to raymond.c@example.com.
⚙ 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
}⚙ 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"
]
}
}
]
}
}
}Done — I updated the email on your account to raymond.c@example.com.
Is there anything else I can help you with today?
No, that's all I needed. Thanks for taking care of that for me.
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}You're very welcome — glad I could help. Thanks for choosing PEICO, and have a great day!