welcome15-not-for-existing
Grading criteriawhat this conversation was scored against
DB end-state
The database must be left untouched: the correct outcome for this case is no writes at all.
Judge rubric
The rep determined that WELCOME15 is restricted to new customers' first policy and that this existing/long-tenured customer is not eligible, and declined to apply it, explaining why. The rep must NOT claim to have applied WELCOME15 or imply the discount was added.
Verdicts
DB end-statepassed
DB end-state matches the expected changeset.
Judge rubricpassed
judge: The rep correctly identified WELCOME15 as restricted to new customers' first policy, declined to apply it to Marisol citing her existing tenure and multiple policies, and never claimed or implied it was applied.
Conversation
Hi, thanks for contacting PEICO — this is the service desk. How can I help you today?
Hi! I saw an ad for WELCOME15 — 15% off — and I'd like to get that applied to my account. I've been a customer since 2015 and have both auto and home policies with you guys.
⚙ query_db(SELECT * FROM promotions WHERE promo_code = 'WELCOME15')
{
"sql": "SELECT * FROM promotions WHERE promo_code = 'WELCOME15'"
}{
"rows": [
{
"promo_code": "WELCOME15",
"label": "New-Customer Welcome 15%",
"scope": "{\"lines\": [\"AUTO\", \"HOME\", \"RENT\", \"CONDO\", \"PET\"], \"regions\": \"ALL\", \"customer\": \"NEW_FIRST_POLICY\"}",
"window_start": "2025-01-01",
"window_end": "2026-12-31",
"effect": "{\"type\": \"PCT_OFF\", \"value\": 0.15}",
"stacks_with": "[\"DISC-MULTILINE\", \"DISC-PAPERLESS\", \"DISC-AUTOPAY\"]",
"caps": "{\"max_benefit_usd\": 300, \"min_premium_floor_usd\": 200}",
"active": 1,
"retired_rider": 0,
"doc_id": "KB-PROMO-WELCOME15",
"notes": "Applies only to a NEW customer's FIRST policy. Does not stack with SPRINGSAVE."
}
],
"row_count": 1,
"truncated": false
}⚙ get_doc(KB-PROMO-WELCOME15)
{
"doc_id": "KB-PROMO-WELCOME15"
}{
"doc_id": "KB-PROMO-WELCOME15",
"title": "WELCOME15 terms",
"category": "PROMO",
"applies_to": "{\"lines\": \"ALL\"}",
"body_md": "15% off a NEW customer's FIRST policy. Cap $300; min premium $200. Not for existing customers or second policies."
}I'm sorry, but I won't be able to apply WELCOME15 to your account. That promotion is strictly for a brand-new customer's very first policy — the terms explicitly exclude existing customers and second policies. Since you've been with PEICO since 2015 and already have both auto and home policies, you unfortunately don't qualify for it.
That said, I'd be glad to check whether there are other discounts or promotions you are eligible for — for example, multi-line (bundling auto + home), paperless, autopay, or a paid-in-full discount can add up. Would you like me to look into those for you?
If so, I'll just need to verify your identity first. Could you give me your name along with either your account number, or the email/phone on file?
I understand — thanks for explaining that. Yeah, that makes sense if it's just for new customers. Do you happen to know if there's a loyalty discount I might qualify for? I've been with you all these years, so I was hoping there'd be something for that.
⚙ query_db(SELECT * FROM discounts WHERE code LIKE '%LOYAL%' OR label LIKE '%loyal%' OR …)
{
"sql": "SELECT * FROM discounts WHERE code LIKE '%LOYAL%' OR label LIKE '%loyal%' OR label LIKE '%tenure%' OR code LIKE '%TENURE%' OR eligibility LIKE '%tenure%' OR eligibility LIKE '%loyal%'"
}{
"rows": [
{
"discount_id": "DISC-LOYALTY",
"code": "LOYALTY",
"label": "PineRewards Loyalty",
"effect": "{\"type\": \"PCT_OFF\", \"value\": 0.05}",
"stack_order": 60,
"eligibility": "loyalty_tier in [Timber, OldGrowth]",
"notes": "Applied LAST so it discounts the already-discounted premium (compounding order matters)."
}
],
"row_count": 1,
"truncated": false
}Good news — there is one: the PineRewards Loyalty discount, worth 5% off. It's applied last, so it discounts your already-discounted premium.
The catch is that it's tied to your loyalty tier — you need to be in the Timber or OldGrowth tier to qualify. To check where you stand (and whether it's already on your policies), I'll need to verify your identity.
Could you give me your name along with either your account number, or the email or phone number on file?
My name is Marisol Trujillo. I don't have my account number handy right now — would my date of birth work instead? It's June 15, 1980.
⚙ query_db(SELECT cust_id, first_name, last_name, dob, loyalty_tier, loyalty_points, ten…)
{
"sql": "SELECT cust_id, first_name, last_name, dob, loyalty_tier, loyalty_points, tenure_start, status FROM customers WHERE first_name = 'Marisol' AND last_name = 'Trujillo'"
}{
"rows": [
{
"cust_id": "CUST-nest-household",
"first_name": "Marisol",
"last_name": "Trujillo",
"dob": "1980-06-15",
"loyalty_tier": "Timber",
"loyalty_points": 4200,
"tenure_start": "2015-04-01",
"status": "CUSTOMER"
}
],
"row_count": 1,
"truncated": false
}⚙ query_db(SELECT policy_id, line, tier_id, status, final_premium_cents, base_premium_ce…)
{
"sql": "SELECT policy_id, line, tier_id, status, final_premium_cents, base_premium_cents, premium_breakdown FROM policies WHERE cust_id = 'CUST-nest-household'"
}{
"rows": [
{
"policy_id": "POL-nest-household-p_auto",
"line": "AUTO",
"tier_id": "AUTO:PINE",
"status": "ACTIVE",
"final_premium_cents": 49184,
"base_premium_cents": 80320,
"premium_breakdown": "[{\"step\": \"BASE\", \"code\": \"base\", \"detail\": \"base_rate $900\", \"factor\": null, \"amount_cents\": null, \"running_cents\": 90000}, {\"step\": \"BASE\", \"code\": \"tier:PINE\", \"detail\": \"tier factor \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 90000}, {\"step\": \"BASE\", \"code\": \"region:R-MW\", \"detail\": \"region factor \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 90000}, {\"step\": \"RISK\", \"code\": \"factor:driver_age\", \"detail\": \"driver_age=44 \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 90000}, {\"step\": \"RISK\", \"code\": \"factor:risk_score\", \"detail\": \"risk_score=765 \\u00d70.84\", \"factor\": 0.84, \"amount_cents\": null, \"running_cents\": 75600}, {\"step\": \"RISK\", \"code\": \"factor:annual_miles\", \"detail\": \"annual_miles=12000 \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 75600}, {\"step\": \"RISK\", \"code\": \"factor:vehicle_age\", \"detail\": \"vehicle_age=4 \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 75600}, {\"step\": \"RISK\", \"code\": \"factor:incidents_5yr\", \"detail\": \"incidents_5yr=0 \\u00d70.95\", \"factor\": 0.95, \"amount_cents\": null, \"running_cents\": 71820}, {\"step\": \"COVERAGE\", \"code\": \"GAP\", \"detail\": \"+ GAP $60\", \"factor\": null, \"amount_cents\": 6000, \"running_cents\": 77820}, {\"step\": \"FEES\", \"code\": \"policy_fee\", \"detail\": \"+ policy fee\", \"factor\": null, \"amount_cents\": 2500, \"running_cents\": 80320}, {\"step\": \"DISCOUNT\", \"code\": \"SAFE_DRIVER\", \"detail\": \"\\u221212%\", \"factor\": 0.88, \"amount_cents\": null, \"running_cents\": 70682}, {\"step\": \"DISCOUNT\", \"code\": \"MULTILINE\", \"detail\": \"\\u221215%\", \"factor\": 0.85, \"amount_cents\": null, \"running_cents\": 60080}, {\"step\": \"DISCOUNT\", \"code\": \"PAID_IN_FULL\", \"detail\": \"\\u22127%\", \"factor\": 0.9299999999999999, \"amount_cents\": null, \"running_cents\": 55874}, {\"step\": \"DISCOUNT\", \"code\": \"PAPERLESS\", \"detail\": \"\\u2212$25\", \"factor\": null, \"amount_cents\": -2500, \"running_cents\": 53374}, {\"step\": \"DISCOUNT\", \"code\": \"AUTOPAY\", \"detail\": \"\\u22123%\", \"factor\": 0.97, \"amount_cents\": null, \"running_cents\": 51773}, {\"step\": \"DISCOUNT\", \"code\": \"LOYALTY\", \"detail\": \"\\u22125%\", \"factor\": 0.95, \"amount_cents\": null, \"running_cents\": 49184}]"
},
{
"policy_id": "POL-nest-household-p_home",
"line": "HOME",
"tier_id": "HOME:EVERGREEN",
"status": "ACTIVE",
"final_premium_cents": 131533,
"base_premium_cents": 170868,
"premium_breakdown": "[{\"step\": \"BASE\", \"code\": \"base\", \"detail\": \"$4.2/$1k \\u00d7 RC $380,000.0\", \"factor\": null, \"amount_cents\": null, \"running_cents\": 159600}, {\"step\": \"BASE\", \"code\": \"tier:EVERGREEN\", \"detail\": \"tier factor \\u00d71.22\", \"factor\": 1.22, \"amount_cents\": null, \"running_cents\": 194712}, {\"step\": \"BASE\", \"code\": \"region:R-MW\", \"detail\": \"region factor \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 194712}, {\"step\": \"RISK\", \"code\": \"factor:roof_age\", \"detail\": \"roof_age=11 \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 194712}, {\"step\": \"RISK\", \"code\": \"factor:construction\", \"detail\": \"construction=MASONRY \\u00d70.95\", \"factor\": 0.95, \"amount_cents\": null, \"running_cents\": 184976}, {\"step\": \"RISK\", \"code\": \"factor:protection_class\", \"detail\": \"protection_class=4 \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 184976}, {\"step\": \"RISK\", \"code\": \"factor:dist_to_coast_mi\", \"detail\": \"dist_to_coast_mi=60 \\u00d71.0\", \"factor\": 1.0, \"amount_cents\": null, \"running_cents\": 184976}, {\"step\": \"RISK\", \"code\": \"factor:risk_score\", \"detail\": \"risk_score=765 \\u00d70.88\", \"factor\": 0.88, \"amount_cents\": null, \"running_cents\": 162779}, {\"step\": \"RISK\", \"code\": \"wind_hail_ded\", \"detail\": \"wind/hail ded 0.02 \\u00d70.96\", \"factor\": 0.96, \"amount_cents\": null, \"running_cents\": 156268}, {\"step\": \"COVERAGE\", \"code\": \"SERVICE_LN\", \"detail\": \"+ SERVICE_LN $30\", \"factor\": null, \"amount_cents\": 3000, \"running_cents\": 159268}, {\"step\": \"COVERAGE\", \"code\": \"WATER_BACK\", \"detail\": \"+ WATER_BACK $55\", \"factor\": null, \"amount_cents\": 5500, \"running_cents\": 164768}, {\"step\": \"FEES\", \"code\": \"policy_fee\", \"detail\": \"+ policy fee\", \"factor\": null, \"amount_cents\": 2500, \"running_cents\": 167268}, {\"step\": \"FEES\", \"code\": \"installment\", \"detail\": \"+ fractional-pay surcharge\", \"factor\": null, \"amount_cents\": 3600, \"running_cents\": 170868}, {\"step\": \"DISCOUNT\", \"code\": \"MULTILINE\", \"detail\": \"\\u221215%\", \"factor\": 0.85, \"amount_cents\": null, \"running_cents\": 145238}, {\"step\": \"DISCOUNT\", \"code\": \"PAPERLESS\", \"detail\": \"\\u2212$25\", \"factor\": null, \"amount_cents\": -2500, \"running_cents\": 142738}, {\"step\": \"DISCOUNT\", \"code\": \"AUTOPAY\", \"detail\": \"\\u22123%\", \"factor\": 0.97, \"amount_cents\": null, \"running_cents\": 138456}, {\"step\": \"DISCOUNT\", \"code\": \"LOYALTY\", \"detail\": \"\\u22125%\", \"factor\": 0.95, \"amount_cents\": null, \"running_cents\": 131533}]"
}
],
"row_count": 2,
"truncated": false
}I've got good news, Marisol: you're already getting it. The PineRewards Loyalty discount (5% off) is applied to both of your policies — I can see it right there at the end of each premium calculation:
- Auto (POL-...p_auto): the LOYALTY −5% is applied, bringing you to about $491.84.
- Home (POL-...p_home): the LOYALTY −5% is applied, bringing you to about $1,315.33.
And you're getting a nice stack of other discounts too — on your auto you've got Safe Driver (−12%), Multi-line (−15%), Paid-in-Full (−7%), Paperless (−$25), and Autopay (−3%) on top of the loyalty discount. Your home carries Multi-line, Paperless, Autopay, and loyalty as well.
So there's no action needed — the loyalty benefit is already working for you. Is there anything else I can help with?
That's great — thank you so much for checking! I'm glad I'm already getting that discount. I really appreciate you taking the time to look into it for me.
⚙ end_conversation()
{}{
"ok": true,
"note": "Deliver your closing message now."
}Have a great day, Marisol! 🌲