--- title: "Rig for D2C and e-commerce: know what you made on every order" description: "Rig brings Shopify, your ad accounts, Klaviyo, your 3PL and your accounting into one place, works out true margin after shipping and returns, and answers revenue and spend questions in plain English. Suri centralised 95% of its sources in under two months with a solo data function." canonical: "https://rig.so/solutions/ecommerce" format: markdown --- [Home](https://rig.so/) For D2C and e-commerce # Know what you actually made on every order Rig brings Shopify, your ad accounts, Klaviyo, your 3PL and your accounting into one place, works out true margin after shipping and returns, and answers questions about revenue, spend and repeat rate in plain English. No data team needed. [Book a demo](https://rig.so/book-demo)[Try Rig](https://app.rig.so/signup) Suri, sustainable oral care 40+ sources centralised, about 95% of the company's \<2 months from first connector to a solo data function running it 1 meeting to sign off the metrics, down from a quarter of back-and-forth In plain terms Rig is AI-native data infrastructure. Think Stripe or Vercel, but for data. We connect all your sources, build a brain that sits on top of them, and let your team and your AI tools reach that data safely. For a consumer brand that means every order, the ad spend that won it, the parcel that shipped it and the refund that came back all read as one story, so margin is a number you can trust rather than a number you rebuild. What you'd build ## What a consumer brand builds first These are projects, not features. Each one is a thing brands already try to do in a spreadsheet, and each one names the systems it reads, so you can tell whether we have actually thought about your stack. ### True contribution margin Margin after cost of goods, shipping, 3PL pick-and-pack, payment fees and returns, at SKU and order level. The number most brands see once a quarter, because assembling it by hand means five exports and a reconciliation nobody has time for. Shopify · ShipBob · Stord · Xero · Stripe ### Blended CAC and channel mix What a first-time customer actually cost this week, measured against orders in Shopify rather than against each platform's own reported conversions. Summed up, the platforms will always claim more orders than you sold. Meta Ads · Google Ads · TikTok Ads · Amazon Ads · Shopify ### Subscription cohorts and repeat rate Subscription state joined to order history, so you can see who lapses after box two, which flow held them, and what a retained subscriber is worth against one who churns at the first renewal. Skio · Klaviyo · Postscript · Shopify ### Returns and refund leakage Return rate by SKU, size and stated reason, netted off revenue so margin includes what came back. It is usually one size in one product line, and it is usually invisible in the storefront dashboard. Frate Returns · parcelLab · Shopify ### Stock cover and sell-through Units on hand across every 3PL and marketplace against current run rate, so a stockout on the best seller arrives as a warning rather than as a post-mortem. Unleashed · ShipBob · ShipHero · Mintsoft · Amazon Seller Central ### Marketplace P&L Amazon and Walmart revenue with referral fees, fulfilment charges, ad spend and returns netted off, sitting next to your own DTC margin on the same SKU. Marketplace usually looks worse than the seller dashboard says. Amazon Seller Central · Walmart Marketplace · Amazon Ads · Sellerboard ### Creator and affiliate reconciliation Attributed orders from your creator and affiliate platforms against what was actually invoiced, so payouts match performance instead of matching whatever the platform reported. ShopMy · Skimlinks · GoAffPro · Archive ### The month-to-date tracker The one finance view the whole business runs on, rebuilt from source every morning rather than assembled at month end once the accounts close. Suri runs theirs this way, and calls it a single source of truth across the business. Shopify · Xero · Stripe · Klaviyo [See every connector](https://rig.so/integrations) In production > "In just shy of two months we've flipped how these projects normally go: a solo data function is outputting what would usually take a 10+ person team." Tal, AI and Data Strategy Manager at Suri [Read the Suri story](https://rig.so/case-studies/suri-metrics) Partner SuriSustainable oral care · Series A · UK Challenge Almost any question ended in a hand-edited spreadsheet export. Northbeam and Triple Whale were both in place, and neither could answer a question it had not been built for, while iOS checkouts had severed the attribution source chain underneath them. Contribution margin was only true once a quarter, after a round of back-and-forth between finance and whoever owned the data. Solution Rig centralised the company's sources into one governed warehouse, then rebuilt each metric against the monthly finance tracker Suri already trusted, used as an eval set: only definitions that scored inside the error boundary went to a human for sign-off. Net and gross revenue, contribution margin, AOV and LTV were certified once. The team then built their own cross-channel attribution model with a geo-split MMM on top of it. - 40+ sources centralised, roughly 95% of the company's, in just shy of two months - Metric sign-off went from a quarter of back-and-forth to a single 50-minute meeting - Running the tracker as an eval set caught errors in the tracker itself, including SKUs carrying no cost of goods and costs booked into revenue that did not belong there - A solo data function now outputs what would usually take a 10+ person team ## Your stack, connected and modelled Rig Ingest syncs each of these into your warehouse on a schedule, and the context layer models how they join, so an order in Shopify, the spend that won it, the subscription it started and the parcel that shipped it are one story rather than four exports. Storefront and marketplace - [Shopify](https://rig.so/integrations/shopify) - [Amazon Seller Central](https://rig.so/integrations/amazon-seller-central) - [TikTok Shop](https://rig.so/integrations/tiktok-shop) - [Walmart Marketplace](https://rig.so/integrations/walmart-marketplace) - [Skio](https://rig.so/integrations/skio) Paid and attribution - [Meta Ads](https://rig.so/integrations/meta-ads) - [Google Ads](https://rig.so/integrations/google-ads) - [TikTok Ads](https://rig.so/integrations/tiktok-ads) - [Triple Whale](https://rig.so/integrations/triple-whale) - [Northbeam](https://rig.so/integrations/northbeam) - [Fairing](https://rig.so/integrations/fairing) Retention and messaging - [Klaviyo](https://rig.so/integrations/klaviyo) - [Postscript](https://rig.so/integrations/postscript) - [Gorgias](https://rig.so/integrations/gorgias) - [Okendo](https://rig.so/integrations/okendo) Fulfilment and finance - [ShipBob](https://rig.so/integrations/shipbob) - [Stord](https://rig.so/integrations/stord) - [parcelLab](https://rig.so/integrations/parcellab) - [Unleashed](https://rig.so/integrations/unleashed) - [Xero](https://rig.so/integrations/xero) - [Stripe](https://rig.so/integrations/stripe) Plus 300+ SaaS tools via our integrator and webhooks. [See the full library](https://rig.so/integrations) Proof ## Consumer brands on Rig, and the companies alongside them Suri and Hunter & Gather are the consumer brands. Every tile says what that company actually does, because a logo wall that implies ten D2C customers when we have two is worth nothing. [![Suri](https://rig.so/logos/customers/suri.png)Sustainable oral care](https://rig.so/case-studies/suri-metrics) ![Hunter & Gather](https://img.logo.dev/hunterandgatherfoods.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=120&format=png)Food and supplements [![Cleo](https://rig.so/logos/customers/cleo.png)Consumer fintech](https://rig.so/case-studies/cleo)[![Birdie](https://rig.so/logos/customers/birdie.png)Homecare software](https://rig.so/case-studies/birdie)[![Novakid](https://rig.so/logos/customers/novakid.png)Online education](https://rig.so/case-studies/novakid) ![deskbird](https://img.logo.dev/deskbird.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=120&format=png)Workplace management ![Vita Mojo](https://img.logo.dev/vitamojo.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=120&format=png)Hospitality tech ![Frontline Education](https://img.logo.dev/frontlineed.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=120&format=png)K-12 school software Built on Rig ## What consumer brands build on Rig Real examples assembled from Rig's building blocks. Each one starts from data you already have in Shopify, your ad accounts and your finance tools. [Board pack · JuneARR£4.1mNet burn£180kRunway16mJanFebMarAprMayJun“ARR up 12% MoM, net burn down 8%, runway extended to 16 months.”ReportInvestor & board reportingAuto-assemble the board pack from source dataGenerate the monthly board and investor update straight from finance, product and CRM data, with the numbers and commentary built in minutes, not days.![Stripe logo](https://img.logo.dev/stripe.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)![Xero logo](https://img.logo.dev/xero.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)![HubSpot logo](https://img.logo.dev/hubspot.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)minutes, not daysHow to build](https://rig.so/apps/board-reporting)[dbt model“Build a daily revenue model”✓ 6 tests passed · materialisedData modeldbt modelling with ClaudeBuild and document dbt models without a data hireDescribe the model you need in plain English and Rig drafts the dbt SQL, tests and docs against your real schema, then materialises it into your warehouse.![Snowflake logo](https://img.logo.dev/snowflake.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)![BigQuery logo](https://img.logo.dev/cloud.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)![dbt logo](https://img.logo.dev/getdbt.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)How to build](https://rig.so/apps/dbt-modelling)[Ask for a dashboardMRR by plan, last 12 monthsBuildMRR£342kChurn2.1%EnterpriseGrowthStarterJulSepNovJanMarMayDashboardSelf-serve dashboardsLet anyone build a custom dashboard in plain EnglishBusiness teams ask for the report they need and Rig builds a governed, custom dashboard on your modelled data, so the data team stops being a ticket queue.![Snowflake logo](https://img.logo.dev/snowflake.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)![BigQuery logo](https://img.logo.dev/cloud.google.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=36&format=png&retina=true)CleoHow to build](https://rig.so/apps/self-serve-dashboards) [See all apps](https://rig.so/apps) ## Common questions We already run Triple Whale and Northbeam, why add Rig Those are attribution dashboards with a fixed view of your data. Suri ran both and still ended up hand-editing spreadsheet exports, because a dashboard cannot answer a question it was not built for. Rig puts Shopify, Klaviyo, the ad platforms, your 3PL and your finance data in one governed warehouse, then lets anyone ask across all of it and build their own model on top. Suri built a cross-channel attribution model with a geo-split MMM that way. Does Rig replace our warehouse Only if you want it to. Rig can provision and run one for you, which is the usual choice for a brand with no data team, or it can sit on top of the Snowflake, BigQuery or Postgres you already have. The context layer and the governance work the same either way. How long does it take to get a consumer brand connected Suri centralised roughly 95% of the company's sources in just shy of two months, across more than 40 connectors covering storefront, retail, 3PL, freight, ads and finance. A brand with a smaller stack is faster. Rig manages the syncs, so there is no pipeline for your team to babysit. iOS changes broke our attribution, can Rig fix that Rig does not restore the tracking that privacy changes removed, and any vendor who says otherwise is selling you something. What it does is give you the raw order, spend, subscription and survey data in one place, so you can build and test your own model rather than trusting a black box. Suri's team ran their existing finance tracker as an eval set and scored each rebuilt metric against it. Who uses this day to day, we do not have a data team That is the normal case for a consumer brand. Suri runs a solo data function. The point of the context layer is that finance, growth and ops ask questions in plain English, in Claude or ChatGPT or a hosted dashboard, and get the same answer each time because the definitions live in one place. Can we keep our agency in the loop Yes. Access is role based, so an agency user can be scoped to campaign and spend data without ever seeing customer records or finance. Every query is logged. ## Get one number your whole team believes Bring your Shopify, ad and finance data. We'll show you what a governed layer over it looks like on a call. [Book a demo](https://rig.so/book-demo)[Try Rig](https://app.rig.so/signup) --- - [This page as HTML](https://rig.so/solutions/ecommerce) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)