CJA - Isolating Cart IDs with Only Item
Hello,
I'm currently working on an analysis on Cart Abandonment rates and I'm trying to isolate Cart IDs which match the following conditions:
- The cart (represented by the Cart ID) is comprised of only a single item, and
- the item = a specific value (in this case, Product SKU = Professional Membership)
The goal is to see compare abandonment rates of carts with multiple items versus those with a just a single item, Professional Membership.
The following screenshot shows Cart ID broken down by Product SKU. I'm trying to capture ONLY instances of where the Cart ID returns a single row. Any ideas on how I can achieve this?
