Can I vibe code Conversific?

Build a full-stack e-commerce business intelligence dashboard that aggregates store performance metrics by syncing data directly from Shopify REST/GraphQL APIs and Google Analytics 4 Data API. The application consists of a Node.js/TypeScript backend API, a PostgreSQL database managed with Prisma ORM, and a Next.js frontend powered by Tremor charts.

1. Data Pipelines & Ingestion:
Implement webhook handlers for Shopify events: orders/create, orders/updated, and customers/create. Build background jobs using BullMQ to handle initial backfill historical data syncs (orders, line items, product costs, customer records with full pagination and rate-limit backoff handling) and a nightly sync job for Google Analytics 4 data (sessions, users, traffic source/medium). Store parsed records in normalized database tables: Stores, Orders, OrderItems, Customers, Products, and TrafficMetrics.

2. Core Metrics & Calculation Logic:
- Revenue Analytics: Calculate net revenue, gross margin (subtracting item cost of goods sold), average order value (AOV), refund rates, and total order volume bucketed by day, week, and month.
- Customer Analytics: Build logic for RFM (Recency, Frequency, Monetary) segmentation grid scoring (1-5 scale). Calculate Customer Lifetime Value (LTV) cohort retention matrices grouped by acquisition month.
- Product Velocity: Calculate top-selling SKUs, inventory turnover rate, and individual product gross margin percentages.
- Traffic Attribution: Aggregate GA4 traffic channels (Organic, Paid, Direct, Referral) and compute blended CAC and store conversion rates.

3. Front-End UI Components:
Build a responsive dashboard using Next.js App Router and Tremor charts. Create metric summary cards with time-period comparison indicators, an interactive RFM grid visualizer, monthly cohort heatmap tables, multi-axis line charts for revenue vs traffic, and export functions to CSV.

4. Robustness & Failure Modes:
Ensure idempotent processing on webhooks using event ID deduping to prevent double-counting revenue. Convert multi-currency order amounts to store base currency using historical exchange rates. Account for partial refunds and null traffic attribution gracefully. Out of scope: benchmark comparison network data, ad account management, and multi-tenant billing.

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