update-contact-both-fields
Grading criteriawhat this conversation was scored against
DB end-state
{
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-retention-target"
},
"fields": {
"phone": [
null,
"602-555-0117"
],
"email": [
"tanya.brooks@example.com",
"tbrooks.az@example.com"
]
}
}
]
}
}Judge rubric
The rep applied BOTH contact updates the customer requested — new phone 602-555-0117 and new email tbrooks.az@example.com — and confirmed both values back to her before ending the call. Updating only one of the two (e.g., saving the phone and wrapping up without the email she said she'd provide) is a fail.(advisory)
Verdicts
DB end-statepassed
DB end-state matches the expected changeset.
Judge rubricpassed
judge: The rep updated both the phone number and email, and explicitly confirmed both values back to the customer before ending the call.
Conversation
Hi, thanks for contacting PEICO — this is the service desk. How can I help you today?
Hi! Thanks for picking up. So I switched phone carriers last week and I need to update my number on my account. I've also got a new email I'll give you in a second, but let me start with the phone number — it's 602-555-0117.
Happy to help update your contact info! First, I need to verify your identity. Could you give me your name and either your date of birth or the ZIP code on file (and your customer or policy ID if you have it handy)?
Sure! My name is Tanya Brooks. My ZIP code is 85004 — that's Phoenix, Arizona.
⚙ query_db(SELECT c.cust_id, c.first_name, c.last_name, c.dob, c.email, c.phone, a.zip, …)
{
"sql": "SELECT c.cust_id, c.first_name, c.last_name, c.dob, c.email, c.phone, a.zip, a.city, a.state FROM customers c JOIN addresses a ON c.address_id = a.address_id WHERE c.first_name LIKE 'Tanya' AND c.last_name LIKE 'Brooks'"
}{
"rows": [
{
"cust_id": "CUST-retention-target",
"first_name": "Tanya",
"last_name": "Brooks",
"dob": "1990-09-14",
"email": "tanya.brooks@example.com",
"phone": null,
"zip": "85004",
"city": "Phoenix",
"state": "AZ"
}
],
"row_count": 1,
"truncated": false
}⚙ update_contact(CUST-retention-target, 602-555-0117)
{
"cust_id": "CUST-retention-target",
"phone": "602-555-0117"
}{
"ok": true,
"rows_affected": 1,
"changeset": {
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-retention-target"
},
"fields": {
"phone": [
null,
"602-555-0117"
]
}
}
]
}
}
}Done! Your phone number is now set to 602-555-0117. Ready for the new email whenever you are.
Great, thanks! Oh, quick question though — is my autopay turned on or off right now?
⚙ query_db(SELECT policy_id, line, tier_id, status, rating_inputs FROM policies WHERE cu…)
{
"sql": "SELECT policy_id, line, tier_id, status, rating_inputs FROM policies WHERE cust_id = 'CUST-retention-target'"
}{
"rows": [
{
"policy_id": "POL-retention-target-p_auto",
"line": "AUTO",
"tier_id": "AUTO:PINE",
"status": "ACTIVE",
"rating_inputs": "{\"billing\": {\"plan\": \"INSTALLMENTS\", \"autopay\": false, \"paperless\": true}, \"incidents_5yr\": 0, \"smoker\": false, \"promo_code\": null}"
}
],
"row_count": 1,
"truncated": false
}I checked your auto policy (POL-...p_auto), and autopay is currently OFF. You're on the installments plan with paperless billing on, but payments aren't set to draft automatically.
Would you like me to help with anything on that? (Just a heads up — I can update your billing plan, but toggling the autopay flag itself isn't something I can change from here.) And whenever you're ready, I can take that new email too.
No, that's fine — I was just curious. Okay, so for the email, it's tbrooks.az@example.com. Let me spell that out for you: t, b, r, o, o, k, s, dot, a, z, at example dot com.
⚙ update_contact(CUST-retention-target, tbrooks.az@example.com)
{
"cust_id": "CUST-retention-target",
"email": "tbrooks.az@example.com"
}{
"ok": true,
"rows_affected": 1,
"changeset": {
"customers": {
"changed": [
{
"pk": {
"cust_id": "CUST-retention-target"
},
"fields": {
"email": [
"tanya.brooks@example.com",
"tbrooks.az@example.com"
]
}
}
]
}
}
}Done! Your email is now tbrooks.az@example.com. Anything else I can help with?
Perfect! So just to confirm — you've got both my new phone number 602-555-0117 and my new email tbrooks.az@example.com on file now, right?
Yes, both are saved and confirmed:
- Phone: 602-555-0117
- Email: tbrooks.az@example.com
Anything else I can help you with?
Nope, that's all I needed! Thanks so much for your help.
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}Have a great day! 👋