{ "success": true, "summary": { "total_abandoned": "8", "payment_failures": "0", "form_abandonments": "0", "total_lost_revenue": "727.89", "not_contacted": "0", "last_hour": "0" }, "recent_records": [ { "id": "221", "final_amount": "119.98", "payment_status": null, "payment_method": "Google Pay", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "59.103.125.5", "reminder_count": "3", "status": "LINK_GENERATED", "created_at": "2025-10-04 17:08:09", "updated_at": "2026-04-28 11:29:51", "minutes_since_created": "296310", "minutes_since_updated": "9", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "Sh************@gmail.com" }, { "id": "167", "final_amount": "119.98", "payment_status": null, "payment_method": "Google Pay", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "3.233.121.62", "reminder_count": "3", "status": "COMPLETED", "created_at": "2025-09-03 18:52:28", "updated_at": "2026-04-28 03:54:18", "minutes_since_created": "340846", "minutes_since_updated": "464", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "fi*****@gmail.com" }, { "id": "3358", "final_amount": "59.99", "payment_status": "PENDING", "payment_method": "Stripe Recovery Link", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "216.26.111.18", "reminder_count": "1", "status": "LINK_GENERATED", "created_at": "2026-04-28 00:56:22", "updated_at": "2026-04-28 01:20:03", "minutes_since_created": "642", "minutes_since_updated": "618", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "nb********@gmail.com" }, { "id": "3350", "final_amount": "179.97", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "71.13.17.108", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-27 21:06:04", "updated_at": "2026-04-27 21:09:48", "minutes_since_created": "872", "minutes_since_updated": "869", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "kf********@outlook.com" }, { "id": "3310", "final_amount": "119.99", "payment_status": "PENDING", "payment_method": "Stripe Recovery Link", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "172.117.104.97", "reminder_count": "3", "status": "cancelled", "created_at": "2026-04-25 20:28:30", "updated_at": "2026-04-27 20:30:02", "minutes_since_created": "3790", "minutes_since_updated": "908", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "dm**********@gmail.com" }, { "id": "3347", "final_amount": "599.90", "payment_status": "PENDING", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "192.103.118.1", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-27 14:47:53", "updated_at": "2026-04-27 14:49:08", "minutes_since_created": "1251", "minutes_since_updated": "1249", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "rh***********@nutrien.com" }, { "id": "3342", "final_amount": "59.99", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "71.52.23.200", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-27 14:11:22", "updated_at": "2026-04-27 14:14:39", "minutes_since_created": "1287", "minutes_since_updated": "1284", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "do*****@gmail.com" }, { "id": "3304", "final_amount": "119.99", "payment_status": "PENDING", "payment_method": "Stripe Recovery Link", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "142.197.224.125", "reminder_count": "3", "status": "cancelled", "created_at": "2026-04-25 12:43:57", "updated_at": "2026-04-27 12:50:02", "minutes_since_created": "4255", "minutes_since_updated": "1368", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "no*********@gmail.com" }, { "id": "3289", "final_amount": "59.99", "payment_status": "PENDING", "payment_method": "Stripe Recovery Link", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "67.84.128.30", "reminder_count": "3", "status": "cancelled", "created_at": "2026-04-25 12:00:39", "updated_at": "2026-04-27 12:10:02", "minutes_since_created": "4298", "minutes_since_updated": "1408", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "sk*************@gnail.com" }, { "id": "3284", "final_amount": "59.99", "payment_status": "PENDING", "payment_method": "Stripe Recovery Link", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "172.59.201.80", "reminder_count": "3", "status": "cancelled", "created_at": "2026-04-24 23:37:18", "updated_at": "2026-04-26 23:40:02", "minutes_since_created": "5041", "minutes_since_updated": "2158", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "md****@live.com" }, { "id": "3332", "final_amount": "59.99", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "172.59.136.54", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-26 22:12:47", "updated_at": "2026-04-26 22:19:39", "minutes_since_created": "2246", "minutes_since_updated": "2239", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "mo*******@yahoo.com" }, { "id": "3324", "final_amount": "59.99", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "166.196.54.68", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-26 13:30:34", "updated_at": "2026-04-26 13:33:01", "minutes_since_created": "2768", "minutes_since_updated": "2766", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "wa******@gmail.com" }, { "id": "3316", "final_amount": "119.99", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "172.117.104.97", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-25 20:31:57", "updated_at": "2026-04-25 20:33:12", "minutes_since_created": "3787", "minutes_since_updated": "3785", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "ca*******@aol.com" }, { "id": "3215", "final_amount": "119.98", "payment_status": "PENDING", "payment_method": "Stripe Recovery Link", "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "139.68.243.173", "reminder_count": "3", "status": "cancelled", "created_at": "2026-04-23 19:48:29", "updated_at": "2026-04-25 19:50:02", "minutes_since_created": "6710", "minutes_since_updated": "3828", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "cp******@gmail.com" }, { "id": "3294", "final_amount": "59.99", "payment_status": "PENDING", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "23.235.30.251", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-25 12:05:50", "updated_at": "2026-04-25 12:09:52", "minutes_since_created": "4293", "minutes_since_updated": "4289", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "si******@nep.net" }, { "id": "3285", "final_amount": "239.98", "payment_status": "PENDING", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "136.175.73.64", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-25 00:48:15", "updated_at": "2026-04-25 00:54:05", "minutes_since_created": "4970", "minutes_since_updated": "4964", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "me********@yahoo.com" }, { "id": "3276", "final_amount": "59.99", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "207.212.33.134", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-24 21:18:11", "updated_at": "2026-04-24 21:20:03", "minutes_since_created": "5180", "minutes_since_updated": "5178", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "ws********@gmail.com" }, { "id": "3265", "final_amount": "119.98", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "47.218.4.84", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-24 20:56:55", "updated_at": "2026-04-24 21:03:41", "minutes_since_created": "5202", "minutes_since_updated": "5195", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "su*******@gmail.com" }, { "id": "3251", "final_amount": "127.98", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "201.103.103.128", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-24 20:37:01", "updated_at": "2026-04-24 20:55:08", "minutes_since_created": "5222", "minutes_since_updated": "5203", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "ar**************@gmail.com" }, { "id": "3243", "final_amount": "119.98", "payment_status": "PAID", "payment_method": null, "payment_error": null, "gateway_reference_id": null, "payment_decline_reason": null, "user_ip": "72.223.21.231", "reminder_count": "0", "status": "COMPLETED", "created_at": "2026-04-24 20:25:05", "updated_at": "2026-04-24 20:28:11", "minutes_since_created": "5233", "minutes_since_updated": "5230", "all_gateway_reference_ids": [], "attempt_count": 0, "all_errors": [], "user_email_masked": "wa**********@gmail.com" } ], "record_count": 20, "timestamp": "2026-04-28 11:39:01", "note": "Gateway reference IDs from retry attempts are tracked in comma-separated format" }