Calculate customer acquisition cost for eligible new customers
Ad spend is known, but it is divided by every order in the period rather than by the customers actually acquired. 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, listing exclusions and grounding the count in the merchant's records.