Updated Prepare a repeat-order customer cohort
Define the qualifying orders and customer scope before analyzing repeat purchases.
The context
The operator needs a precise customer cohort for loyalty activity or customer research: people who placed more than two orders in a specified month. The output must be usable as a list, with consistent dates, order statuses and customer matching.
The Bustly workflow
Bustly counts qualifying orders by customer, applies the requested threshold and returns the relevant customer and purchase fields. It checks date boundaries, order eligibility and deduplication so repeat buyers are not confused with duplicate records or non-qualifying orders.
A prompt to adapt
Find customers who placed more than two qualifying orders in the specified month. Return their order count, purchased products and spend. Explain the date boundaries, included order statuses and customer deduplication rules.
Adapted from real operating tasks. Customer identifiers and sensitive business details are omitted. The workflows are examples, not promises of business results.