Your question is Investigate Checkout Conversion Spike. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
ShopWave is an e-commerce marketplace for home goods. Yesterday, the executive dashboard showed a sudden spike in checkout conversion rate, and the VP of Growth wants to know whether this reflects real performance improvement, a mix shift, or a tracking issue.
For the prior 4 weeks, checkout conversion rate was stable at 3.8% to 4.1% of sessions. On Tuesday, it jumped to 6.2%. At the same time, daily sessions fell from 1.25M to 910K, orders increased only slightly from 49K to 56K, paid traffic share dropped from 42% to 25%, and iOS app traffic rose from 28% to 44% of sessions. A new checkout UI launched to 15% of users on Monday evening, and the data engineering team also migrated part of the sessionization logic that same night. Leadership needs a same-day diagnosis before reporting results externally.
web_sessions: session_id, user_id, session_start, platform, device_type, traffic_source, landing_pagecheckout_events: session_id, cart_view, checkout_start, payment_submit, order_complete, timestamporders: order_id, user_id, session_id, order_value, discount_amount, payment_method, timestampexperiment_assignments: user_id, experiment_name, variant, assignment_timeevent_quality_logs: event_name, platform, error_rate, duplicate_rate, missing_event_rate, deploy_version