Can I vibe code RetentionX?

Build an e-commerce customer cohort and retention analytics web app using Next.js (App Router), PostgreSQL (with Drizzle ORM), and Tremor UI components.

1. DATA MODEL:
- Create tables for `customers` (id, shopify_id, email, created_at, total_spent, orders_count), `orders` (id, customer_id, shopify_order_id, total_price, subtotal_price, taxes, discounts, financial_status, processed_at), and `order_line_items` (id, order_id, product_id, variant_id, price, quantity, title).
- Create tables for `cohort_cache` and `rfm_segments` to cache analytical query results.

2. INGESTION & WEBHOOKS:
- Implement HTTP POST webhook handlers for Shopify events: `orders/create`, `orders/updated`, `orders/fulfilled`, and `refunds/create`.
- Ensure idempotent processing by storing processed webhook IDs in a dedicated table.
- Deduct refunds and adjust total net revenue accordingly.

3. ANALYTICS ENGINE (SQL/DB Queries):
- Build a Cohort Analysis engine: Group customers by acquisition month (Month 0). Calculate percentage of customers who placed a secondary purchase in Month +1, Month +2, ..., Month +12.
- Build an RFM Engine: Assign scores (1-5) for Recency (days since last order), Frequency (total orders), and Monetary Value (total net spend). Segment into buckets: 'Champions', 'Loyal', 'At Risk', 'Lost'.
- Build LTV Trajectory: Calculate cumulative average revenue per user (ARPU) at day 30, 60, 90, 180, and 365.

4. USER INTERFACE:
- Build a cohort triangle heatmap displaying order retention over 12 months using Tailwind styling.
- Build an RFM matrix grid showing customer count per segment with drill-down tables to view individual customer lists.
- Display key executive metrics: Average Order Value (AOV), Repeat Purchase Rate (RPR), and Churn Rate.

5. FAILURE HANDLING & CONCURRENCY:
- Handle multi-currency transactions by converting to store base currency using historical exchange rates.
- Implement backoff retry logic for API endpoints reading bulk historical order data.

OUT OF SCOPE: Live ad network reverse-ETL audience syncing, push notification triggers, and multi-tenant billing management.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs