Analyze refund patterns and affected products
Refunds are logged as single events with no link back to the order or the reason, so trends cannot be read. In this case, the immediate task is to analyze refund patterns and affected products. The workflow should produce a breakdown separating refund counts from refunded value and matching each refund to its order date to surface recurring clusters.