A production-grade embedded Shopify analytics app, built with React Router v7, TypeScript, and Prisma. Pulls live data via Shopify Admin GraphQL + ShopifyQL and the Google Ads API to solve a problem neither platform solves alone: blended ROAS, CAC, and ad-spend-per-order on one timeline.

Includes: Five dashboard sections (Overview, Marketing, Products, Ad Spend, ROAS) with a global date-range picker, period-over-period deltas, and sparklines. Real GraphQL queries against Shopify Admin + Analytics APIs, Google Ads OAuth integration, Polaris web components + Recharts, working test suite.

Important: this is a deployable codebase, not a one-click app. You’ll need to swap SQLite for Postgres, register your own Shopify Partner app, and get your own Google Ads API access approved before going live. Built for developers and agencies who want a real starting point, not a plug-and-play SaaS.