Multi-Month Active Customers

Meta's retention team defines a multi-month active user as one who's shown up in at least 2 different calendar months — the minimum threshold for counting as 'retained' in their internal MAU reports. For each such customer, show name, membership, distinct_months (count of unique YYYY-MM values in their orders), and total_orders. Sort by distinct_months descending, then total_orders descending. COUNT(DISTINCT ...) over a date-formatted expression is the pattern every Meta growth team runs weekly — you'll see this exact query in Meta Data Analyst interviews dressed up in a dozen different business contexts (multi-month active users, multi-week engagers, multi-session shoppers).