Calculate customer acquisition cost for eligible new customers
A merchant wants to understand acquisition efficiency but mixes new-customer costs with repeat orders. In this case, the immediate task is to calculate customer acquisition cost for eligible new customers. The workflow should produce a CAC calculation and segment comparison, using the merchant's actual records and constraints.