Independent product · Commerce + applied AI
Aeyora
A Shopify-native analytics product that connects first-party customer journeys to plain-English, merchant-scoped analysis.
The operating problem
Merchants can see conflicting attribution across ad platforms and storefront analytics, but answering a focused business question still demands manual reporting or data expertise. Aeyora turns collected storefront and purchase signals into governed analysis without exposing raw query access to the merchant or the model.
What I owned
- Product architecture across the embedded Shopify app, tracking pipeline, data layer, AI orchestration, billing controls, and production deployment.
- Shopify OAuth, App Store distribution, web pixels, purchase webhooks, GDPR handlers, and tenant provisioning.
- Agent-tool contracts, query safeguards, response shaping, regression tests, and the cost model behind plan quotas.
System map
Architecture simplified for clarity- 01ShopifyPixel, OAuth, orders, billing
- 02App layerRemix BFF + tenant binding
- 03BigQueryMerchant-scoped event tables
- 04AI agentFastAPI + governed tools
- 05ValidateCost, SQL, quota, response checks
- 06AnswerMerchant-facing insight blocks
Tenant isolation outside the model
The authoritative tenant is resolved by the trusted application layer and bound server-side. It is not exposed as a tool argument the model can rewrite.
Constrained execution
Template-first, parameterized BigQuery queries apply date windows, dry-run byte estimates, row caps, timeouts, retention limits, and SELECT-only rules for eligible custom analysis.
Budget-aware AI
Plan allowances, analysis counts, planning budgets, execution budgets, and query cost ceilings are enforced before work reaches the expensive part of the pipeline.
Test the boundaries
The test suite pins tenant validation, SQL placeholders, authentication failures, sandbox import restrictions, curated runtime modules, and API error behavior.