Which products and channels make money after discounts, returns, fees and ad spend?
Revenue is easy to read. Profit is where stores guess: the discounts sit on the order, the refunds arrive weeks later, the fees and shipping are buried in other reports, and ad spend lives in a different tool. Quiriz is an AI business analyst that reads your Shopify store and ad accounts read-only, defines contribution margin, break-even ROAS and MER once, and gives you the same number in the spreadsheet, the deck and Slack.
Most store owners can tell you their top seller by revenue and cannot tell you whether it is profitable, or whether last month's ad spend was above or below break-even. The gap is not effort. Sales, costs, fees and ad spend live in four places at different grains, and stitching them together by hand produces a different answer each time.
What you get
- A margin number you can defend. Contribution margin before ads is built from Shopify net sales, cost of goods at the unit cost in force on the order date, shipping and payment fees. Every ingredient is on the connector page, and an admin can edit any of them.
- Break-even ROAS and MER without a side spreadsheet. Break-even MER is calculated for you, and Blended MER, nCAC and aMER are added automatically when Shopify and your ad accounts are both connected.
- The same number in the deck, the cell and Slack. Definitions live in Company Context, and every surface reads them. The daily refresh never overwrites a definition an admin has edited.
- Next month's profit review is a refresh. Formulas re-ask, and Refresh all updates every figure and chart in the deck.
- Read-only, and your whole team on one subscription. Quiriz never writes to your store or ad accounts. Your VA checking margin on a SKU costs nothing extra: no per-seat fee.
The metrics come pre-defined
Every formula, so you can check it against how you already measure. Names are exactly as they appear in Quiriz.
| Metric | Definition | What it is for |
|---|---|---|
| Net sales | gross sales + discounts + returns (discounts and returns are negative, as in Shopify) | Matches Shopify's sales report, with returns counted on the refund date. |
| Cost of goods sold | Unit cost of goods sold, at the cost in force on the order date | A return reverses the cost it carried. Variants with no unit cost count as 0, which Net sales without a unit cost shows you. |
| Contribution margin before ads | net sales − cost of goods sold − shipping and fulfillment − payment fees | What is left to pay for advertising and overhead. Shipping (8% of net sales) and payment fees (3% of total sales) are editable assumptions; the (actual fees) version uses real Shopify Payments fees. |
| Contribution margin rate before ads | contribution margin before ads / net sales | The percentage that sets your break-even. |
| Break-even MER | net sales / contribution margin before ads | Net sales per ad dollar at which ads use up the whole margin. Above it ads add profit, below it they lose money. Same as break-even ROAS if you measure on net sales. |
| Blended MER | net sales / (Meta Ads spend + Google Ads spend) | What you actually got per ad dollar, from Shopify's figure and not the platforms'. Compare it with Break-even MER. |
| Meta Ads nCAC, Google Ads nCAC, Blended nCAC | ad spend / new customers | What a new customer cost. Guest checkouts count in neither number. |
| Meta Ads aMER, Google Ads aMER, Blended aMER | new customer net sales / ad spend | First-order sales per ad dollar. Below 1 means first orders alone do not repay the ad, and repeat purchases have to. |
| Google Ads ROAS, Meta Ads ROAS | platform conversion value / platform spend | The platform's own count, useful inside that platform. Microsoft Ads has nCAC and aMER too. |
The full list, including refund rate, repeat purchase rate and the Shopify Payments versions, is on the Shopify, Google Ads, Meta Ads and Microsoft Ads connector pages, and the cross-source list is on the connectors hub.
Contribution margin is not net profit. It excludes overhead and fixed costs. Quiriz's version is before ads; subtract ad spend for the after-ads figure. Cross-source metrics (nCAC, aMER, MER, break-even MER with actual fees) answer for a period or a trend by month, not by product, channel or campaign.
A worked example (illustrative numbers)
These figures are made up to show the arithmetic. They are not a customer result.
| Line | Amount |
|---|---|
| Net sales | $100,000 |
| Cost of goods sold | −$38,000 |
| Shipping and fulfillment (8% of net sales) | −$8,000 |
| Payment fees | −$3,000 |
| Contribution margin before ads | $51,000 (51%) |
| Break-even MER: 100,000 / 51,000 | 1.96 |
| Ad spend | $40,000 |
| MER: 100,000 / 40,000 | 2.50, above break-even, so ads add profit |
| Contribution margin after ads: 51,000 − 40,000 | $11,000 |
| New customers: 400, so nCAC = 40,000 / 400 | $100 |
| New customer net sales $36,000, so aMER = 36,000 / 40,000 | 0.90 |
Read it like this: the month made money after ads, with a margin of safety between a 2.50 MER and a 1.96 break-even. But a new customer costs $100 and their first order returns only 90 cents per ad dollar, so growth is being paid for by repeat buyers. Quiriz's repeat purchase rate and the customer acquisition cost guide cover that side. For break-even by product, see the break-even ROAS calculator guide and the free tool.
MER vs ROAS, and target ROAS
Each ad platform reports its own ROAS using its own attribution, so Meta and Google can both claim the same sale. MER ignores attribution: your store's net sales divided by everything you spent. Set a target ROAS from your break-even, not from a benchmark: a store with a 51 percent contribution margin before ads breaks even at about 1.96 and needs a target above that to make anything. Use platform ROAS to compare campaigns inside one platform, and MER to decide whether the whole budget is working. The Facebook Ads vs Google Ads ROAS guide and how to calculate ROAS by channel go further.
How to use it
- Connect. Shopify (or WooCommerce) and your ad accounts: Google Ads, Meta Ads, Microsoft Ads. All read-only, refreshed daily. TikTok and LinkedIn Ads have no connector, so bring those in as an export or a Sheet upload.
- Check the setup. Quiriz adds each connector's datasets and metric definitions to Company Context, and the cross-source metrics appear once both sides are connected. Set unit costs on your variants in Shopify, then replace the 8 percent and 3 percent assumptions with your real rates, or connect Shopify Payments for actual fees.
- Ask where you work. Excel, Google Sheets, Slack, Word, Docs, PowerPoint, Slides or the web app.
- Deliver. A table in a cell, a live figure in a sentence, a deck.
- Keep it current. The store and ad accounts refresh daily. Refresh the sheet or the deck next month.
Questions that answer by product and channel
- "Contribution margin before ads by product type last month." The Shopify sales data carries product, product type, sales channel and UTM columns, so margin before ads breaks down by any of them.
- "Which five products have the lowest contribution margin rate?"
- "Net sales and refund rate by sales channel this quarter."
- "Which products get returned most?"
Questions that answer for the store as a whole
- "Blended MER and break-even MER by month this year."
- "What did a new customer cost on Google Ads and on Meta Ads each month?"
- "What was Google Ads ROAS against Meta Ads ROAS last quarter?"
Ad spend is not split down to individual products. If you want a ratio by channel, an admin can map a dimension: one column per dataset that means the same thing, such as UTM source on orders and platform on ad spend. An admin can also define a custom metric from metrics on different datasets.
The monthly profit review, without the monthly rebuild
The profit review is the report that most often gets skipped, because rebuilding it takes a day. With the store and ad accounts connected, each piece is a question that refreshes daily.
- The product table, in Excel or Google Sheets. In Excel,
=QUIRIZ.ASK("contribution margin before ads by product type last month", "table")spills one row per product type; in Google Sheets it is=QUIRIZ("contribution margin before ads by product type last month", "table"). In Excel thechartmode draws a native chart beside it. Next month, refresh instead of repasting. - The break-even line, in a cell.
=QUIRIZ.ASK("Blended MER and break-even MER by month this year", "table")gives the month-by-month gap between what you earned per ad dollar and what you needed. - The written review, in Word or Google Docs. In Word, insert one figure, such as last month's contribution margin, inside your own sentence and keep it live on refresh. In Docs, type the question where the table belongs, select it, and press Table.
- The review deck, in PowerPoint or Google Slides. Describe it once, check the plan, build it, and use Refresh all next month. Two prompts are below.
- The quick check, in Slack. "Are we above break-even MER this month?" in the channel, answered in a thread. Slack is included from the Plus plan.
Install: Excel, Word, PowerPoint, Google Sheets, Google Docs, Google Slides.
Make a deck: two prompts to try
Use these in Quiriz for PowerPoint with your Shopify store, and your ad accounts for the second, connected or uploaded. Make a deck is in Beta. Quiriz plans the slides first, so any title or question can be edited before it builds. In a Consulting-style deck, each chart and table carries two to four takeaways written from that slide's own figures, and the executive summary and Recommendations are written from those slides.
Product profit review
PowerPoint, Consulting style. Tick your Shopify datasets, including product variants with unit cost.
"Product profit review for August 2026. Net sales, cost of goods sold and contribution margin before ads by product type for August, contribution margin rate by product type against the 2026 year-to-date average, units sold by product type, refund amount by product type, and the five products with the lowest contribution margin rate. End with recommendations."
What comes back, about nine slides:
- Agenda and executive summary.
- Net sales, cost of goods and contribution margin by product type: a table.
- Margin rate, August against the year to date: a clustered bar chart.
- Units sold and refunds by product type: two bar charts.
- The five lowest-margin products: a table.
- Recommendations, written from what those slides found.
Where the ad money went
PowerPoint, Consulting style. Tick your Shopify, Google Ads and Meta Ads datasets.
"Where the ad money went in 2026 so far. Total ad spend by month and platform, Facebook and Google ROAS by month, ROAS by campaign for 2026 year to date, spend and ROAS by month for our weakest campaign, attributed revenue against platform conversion value by platform, and Blended MER against break-even MER by month. End with recommendations."
What comes back: spend by month and platform as a stacked column, ROAS by platform as a line, ROAS by campaign ranked, the weakest campaign month by month so you can see when it turned, a table setting each platform's conversion value beside the revenue attributed to it, and MER against break-even by month. The Recommendations slide names what to cut or rebuild, from those figures.
Connect it or upload it
Connectors are read-only, refresh once a day and are included on paid plans. Uploading exports (Excel, CSV, PDF or images with tables, by upload, email or Slack) remains the route for anything without a connector, such as TikTok or LinkedIn ad exports, 3PL fees or a spreadsheet of landed costs. Messy Excel files, with headers not in row 1, are detected on import.
What the other connectors add
With several sources connected, Quiriz can answer questions that sit across them. Each answer says which source each figure came from.
- Email revenue against the whole store. "What share of net sales did Klaviyo attribute to email and SMS each month, and which flows earned the most?" From Klaviyo and Shopify. Klaviyo revenue is Klaviyo's own attribution, so it is a share of what it saw, not an amount that subtracts from Shopify net sales.
- Shopify sales against Stripe money movement. "Do March sales line up with Stripe gross volume, refunds and payouts?" From Stripe and Shopify, for stores that take payments through their own Stripe account rather than Shopify Payments.
- The store against the books. "How far apart are Shopify net sales and QuickBooks revenue each month?" From QuickBooks and Shopify. A gap is expected from timing and accounting entries; the question shows how large it is.
- Shopify revenue against Google Analytics. "Why does Google Analytics 4 report different revenue than Shopify, by day?" From Google Analytics and Shopify. The two count revenue differently, so see why they do not match.
What it will not answer
Ad spend by product is not on the list. Ad accounts know campaigns, not products, so nCAC, aMER, MER and break-even MER answer for the store as a whole, a period or a month. Margin before ads is the by-product figure.
Inventory turns, sell-through and days on hand are not pre-defined answers. All three need average inventory over the period, which is a balance rather than something you can add up. Ask Quiriz for inventory turns and it will say it cannot, name the two definitions people mean by it, and ask which you want rather than picking one silently. A connected store does carry current inventory by product, which answers "what is running low".
The numbers are not live. A connected store and ad account are re-read once a day, which suits the weekly or monthly review. Ad spend is in each ad account's own currency, with no conversion. Guest checkouts are not counted as new customers.
Pricing
You pay for the workspace, not for everyone who asks a question. Connectors, Slack and scheduled reports are included on Plus ($12 a month, $120 a year), Pro ($30, $300) and Max ($60, $600). Free is $0 for 5 files. Your VA checking margin on a SKU costs nothing extra. See pricing →
Your files stay yours, and we do not train on your data. Privacy policy →
Related reading
- Break-even ROAS calculator and the free tool: the formula and a worked example
- Shopify profit calculator and the free tool: profit per product after fees, discounts and refunds
- Contribution margin by product category: the metric, and the allocation choices underneath it
- Customer acquisition cost
- Facebook Ads vs Google Ads ROAS
- How to calculate ROAS by channel
- Net sales vs gross sales in Shopify: why three reports give three answers
- Gross margin by SKU from a Shopify export: the cost data nobody has
- Joining Shopify and ad exports
- Klaviyo and Shopify revenue by flow and campaign
- Stripe reporting, for stores taking payments through their own Stripe account
- QuickBooks profit and loss analysis
- WooCommerce analytics beyond the dashboard
- Why inventory turnover is not in your dashboard
- Agentic AI in e-commerce
- Quiriz for Shopify: store analytics, reports and decks
- All guides →