Retail and E-commerce

E-commerce & Retail Analytics

Shopify-vs-Stripe-vs-GA4 reconciliation, refund-aware revenue, RFM segmentation, repeat-purchase cohorts — the SQL DTC and retail analysts actually write.

• “What financial statuses exist?”
• “Top 10 products by units sold”
• “Repeat-purchase cohort retention”

• Shopify-Shaped Schema — Customers, products, orders, line items, with the financial_status / fulfillment_status fields you’ll see on day one of any DTC shop. Familiar to anyone who’s opened a Shopify export.
• Three-System Reconciliation — GA4 sessions and Stripe charges sit alongside Shopify orders with planted mismatches — partial refunds, currency conversion fees, failed captures, GA4 conversion-value drift. The signature mission ties all three together.
• Refund + Cohort + RFM SQL — Refund-aware revenue, repeat-purchase cohorts, RFM segmentation, abandoned-cart funnels, source/medium attribution. The full DTC analyst toolkit.