Bruin Academy
Guide
Shopify Data Pipeline
Build an analytics stack for your Shopify store - pick your warehouse, payment processor, marketing platform, and more, then follow a step-by-step guide to build a full pipeline with an AI analyst.
Skip ahead
The whole project is one command. Run it, point your coding agent at the Bruin MCP, and it can configure and run everything itself.
$ bruin init ecommerceThree ways to go from here:
- Self-service it. Let the agent configure and run the whole thing, and ask it questions as you go.
- Follow this tutorial. Slower, and it explains why each setting matters - the part an agent will not guess for you.
- Hand the tutorial to the agent. Point it at this page and have it work through the steps with you.
The template README is the short reference for everything it ships.
What
Build an analytics pipeline for your Shopify store. Pull data from Shopify and the tools around it, transform it into business reports, and set up an AI data analyst - all customized to your stack.
- Data ingestion from Shopify, payment processors, marketing platforms, and ad tools
- Staging layer that cleans and joins data across sources
- Business reports (revenue, cohorts, product performance, marketing ROI) and an AI data analyst
How
- Pick your warehouse, payment processor, marketing platform, and ads tool below
- Bruin CLI handles extraction, transformation, and orchestration
- Claude Code with Bruin MCP helps build and test the pipeline; Bruin Cloud handles deployment
Pick your stack, customize the guide
Before you start
- Git installed
- Bruin CLI installed
- A data warehouse account (ClickHouse, BigQuery, or Snowflake)
- A Shopify store with API credentials
- API credentials for your selected payment, marketing, ads, and analytics tools
- Claude Code installed (this guide uses Claude Code throughout, but you can adapt the prompts for Cursor or Codex)
Guide overview
- 1Set Up Your Project & WarehouseInstall Bruin CLI, initialize an ecommerce project, connect your data warehouse, and set up AI-assisted development with Claude Code and the Bruin MCP.
- 2Ingest Your Ecommerce DataConnect your Shopify store and surrounding tools to Bruin, and create ingestor assets that pull data into your warehouse automatically.
- 3Clean & Join Your DataBuild a staging layer that cleans, deduplicates, and joins data across Shopify, Stripe, and your marketing, ads, and analytics sources into consistent, analysis-ready tables.
- 4Build Ecommerce ReportsCreate report tables for daily revenue, customer cohorts, product performance, marketing ROI, and a unified KPI dashboard.
- 5Set Up Your AI Data AnalystEnhance your pipeline with AI-generated metadata, create an ecommerce-specific AGENTS.md, and deploy an AI analyst your team can use locally or in Slack.
- 6Build Ecommerce DashboardsUse the Bruin Cloud AI agent to generate interactive ecommerce dashboards - revenue trends, customer cohorts, marketing ROI, and product performance - from natural language.
Resources
Get help & contribute