Sidekick: Build Customer Segments for Marketing

What This Sidekick Query Does

Help me create targeted customer segments for my marketing campaigns. I need segments for:


  VIP Customers: Spent over $[AMOUNT] total or placed more than [X] orders
  At-Risk Customers: Haven’t purchased in the last [90] days but were previously active
  New Customers: First purchase in the last [30] days
  High-Value Prospects: Added to cart but never purchased
  Repeat Buyers: Made 2+ purchases in the last [6 months]
  Geographic Segment: Customers from [CITY/STATE/COUNTRY]


For each segment, suggest:

  The best type of marketing campaign to run (email, SMS, ad)
  A specific offer or message angle that would resonate
  Estimated impact on revenue if we convert [X]% of the segment
  How often to target this segment without causing fatigue

Expected Output

Tips to Improve Results