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, confirming 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?
Hey, thanks for picking up. So I switched phone carriers last week and got a new number — I need to update it on my account. I also have 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 with that! Before I can make any changes, I need to verify your identity and pull up your account. Could you give me:
- Your full name
- Plus one or two identifying details on file — like your date of birth, the email or phone number currently on the account, or your address
Once I've confirmed who you are, I'll update the phone number (and the email whenever you're ready).
Sure, no problem. My name is Tanya Brooks. The email I have on file is tanya.brooks@example.com, and my address is 540 Saguaro St, Phoenix, AZ 85004.
⚙ query_db(SELECT c.cust_id, c.first_name, c.last_name, c.email, c.phone, c.status, a.li…)
{
"sql": "SELECT c.cust_id, c.first_name, c.last_name, c.email, c.phone, c.status, a.line1, a.city, a.state, a.zip FROM customers c LEFT JOIN addresses a ON c.address_id = a.address_id WHERE c.first_name = 'Tanya' AND c.last_name = 'Brooks'"
}{
"rows": [
{
"cust_id": "CUST-retention-target",
"first_name": "Tanya",
"last_name": "Brooks",
"email": "tanya.brooks@example.com",
"phone": null,
"status": "CUSTOMER",
"line1": "540 Saguaro St",
"city": "Phoenix",
"state": "AZ",
"zip": "85004"
}
],
"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 602-555-0117 on the account.
You mentioned you also have a new email — go ahead whenever you're ready and I'll update that too.
Oh actually, before we do that — quick question. Is my autopay turned on or off right now?
⚙ query_db(SELECT policy_id, line, tier_id, status, effective_date, expiration_date, fin…)
{
"sql": "SELECT policy_id, line, tier_id, status, effective_date, expiration_date, final_premium_cents, 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",
"effective_date": "2025-05-01",
"expiration_date": "2026-05-01",
"final_premium_cents": 91350,
"rating_inputs": "{\"billing\": {\"plan\": \"INSTALLMENTS\", \"autopay\": false, \"paperless\": true}, \"incidents_5yr\": 0, \"smoker\": false, \"promo_code\": null}"
}
],
"row_count": 1,
"truncated": false
}⚙ query_db(SELECT * FROM payments WHERE cust_id = 'CUST-retention-target' ORDER BY due D…)
{
"sql": "SELECT * FROM payments WHERE cust_id = 'CUST-retention-target' ORDER BY due DESC LIMIT 10"
}{
"rows": [
{
"payment_id": "PMT-POL-retention-target-p_auto-1",
"cust_id": "CUST-retention-target",
"policy_id": "POL-retention-target-p_auto",
"due": "2025-06-01",
"paid_on": null,
"amount_cents": 7612,
"status": "SCHEDULED"
},
{
"payment_id": "PMT-POL-retention-target-p_auto-0",
"cust_id": "CUST-retention-target",
"policy_id": "POL-retention-target-p_auto",
"due": "2025-05-01",
"paid_on": "2025-05-01",
"amount_cents": 7612,
"status": "PAID"
}
],
"row_count": 2,
"truncated": false
}I checked your account — you have one policy with us, your auto policy (POL-retention-target-p_auto), and autopay is currently turned off.
A few related details while I'm in there:
- You're on a monthly installment plan (~$76.12/month, annual premium $913.50)
- Your May 1 payment was made, and your next payment of $76.12 is due today, June 1 — since autopay is off, you'll want to make sure that gets paid manually.
Anything you'd like to do about that — and shall we go ahead with that email update?
Got it, thanks for checking. No, I'm good with how things are — I'll handle the payment manually, no changes needed there. And yeah, let me give you that new email now: it's t-b-r-o-o-k-s dot a-z at example dot com. So tbrooks.az@example.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"
]
}
}
]
}
}
}All set! Your email is now tbrooks.az@example.com on the account (replacing tanya.brooks@example.com).
To recap today:
- ✅ Phone updated to 602-555-0117
- ✅ Email updated to tbrooks.az@example.com
- No billing changes — you'll handle the June 1 payment manually
Is there anything else I can help you with?
No, that's everything I needed. Thanks so much for getting both of those updated for me — I really appreciate it!
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}Thanks again for contacting PEICO, Tanya — you're all set. Have a wonderful day!