Home / E-commerce
For e-commerce operators

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.

Try it on sample store data → No signup, no app install on your store. Or try your own file.

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

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.

MetricDefinitionWhat it is for
Net salesgross 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 soldUnit cost of goods sold, at the cost in force on the order dateA 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 adsnet sales − cost of goods sold − shipping and fulfillment − payment feesWhat 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 adscontribution margin before ads / net salesThe percentage that sets your break-even.
Break-even MERnet sales / contribution margin before adsNet 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 MERnet 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 nCACad spend / new customersWhat a new customer cost. Guest checkouts count in neither number.
Meta Ads aMER, Google Ads aMER, Blended aMERnew customer net sales / ad spendFirst-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 ROASplatform conversion value / platform spendThe 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.

LineAmount
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,0001.96
Ad spend$40,000
MER: 100,000 / 40,0002.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,0000.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

  1. 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.
  2. 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.
  3. Ask where you work. Excel, Google Sheets, Slack, Word, Docs, PowerPoint, Slides or the web app.
  4. Deliver. A table in a cell, a live figure in a sentence, a deck.
  5. 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

Questions that answer for the store as a whole

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.

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:

  1. Agenda and executive summary.
  2. Net sales, cost of goods and contribution margin by product type: a table.
  3. Margin rate, August against the year to date: a clustered bar chart.
  4. Units sold and refunds by product type: two bar charts.
  5. The five lowest-margin products: a table.
  6. 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.

Ask the sample store → Then upload one month of your own exports and check it against a figure you already trust.

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.

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

Questions

Should I connect Shopify or upload exports?
Either works. Connecting Shopify is read-only, refreshed daily and included on paid plans; it brings in orders, line items, refunds, a sales ledger that matches Shopify's own report, products and variant cost history. Google Ads, Meta Ads, Microsoft Ads, Klaviyo, Stripe and QuickBooks connect the same way, so questions can span them. Upload exports when you would rather not sign in to an account or the source has no connector. Either way the numbers are as fresh as the last refresh or download, which suits a weekly or monthly profit review rather than a live dashboard.
What is contribution margin, exactly?
Net sales minus the costs that move with each sale: cost of goods sold, shipping and fulfillment, and payment fees. Quiriz's Contribution margin before ads stops there. Subtract ad spend to get contribution margin after ads. Overhead and fixed costs are excluded, so it is not net profit. It answers whether a product or a month pays for itself before you decide what to spend on advertising.
How do I calculate break-even ROAS and break-even MER?
Divide 1 by your contribution margin rate before ads. If that rate is 51 percent, break-even is about 1.96: you need roughly $1.96 of sales for every ad dollar just to cover variable costs and the ad itself. Quiriz's Break-even MER metric computes it as net sales divided by Contribution margin before ads. Above it, ads add profit; below it, they lose money.
What is the difference between MER and ROAS?
ROAS is one platform's reported conversion value divided by that platform's spend, counted by that platform's own attribution. MER is your store's net sales divided by total ad spend across platforms, so it uses Shopify's figure rather than any platform's. In Quiriz, Google Ads ROAS and Meta Ads ROAS are the first kind and Blended MER is the second. MER is the better test for the whole business; ROAS is the better tool inside one platform.
What are nCAC and aMER?
nCAC is ad spend divided by new customers in the same period. aMER is first-order net sales from new customers divided by ad spend. Quiriz adds them automatically for each connected ad platform, such as Meta Ads nCAC and Google Ads aMER, and adds Blended nCAC, Blended aMER and Blended MER when Meta and Google are both connected. They answer for a period or a trend by month, not by product or campaign.
Can Quiriz show profit by product or by channel?
Yes, before ads. Contribution margin before ads can be broken down by product, product type and sales channel because the Shopify sales data carries those columns. Ad spend is not allocated down to products. An admin can define a custom metric across datasets and map a dimension such as UTM source on orders and platform on ad spend to break a ratio down by channel.
Do I need unit costs for this to work?
For cost of goods sold, contribution margin and break-even MER, yes. Unit cost on your variants is what makes the cost computable. For a connected store that is the unit cost you have set on each variant in Shopify. Where it is blank, cost counts as zero and margin is overstated by that share, which Net sales without a unit cost shows. Net sales works without unit costs.
Does it use my real shipping and payment fees?
Shipping and fulfillment starts as 8 percent of net sales and payment fees as 3 percent of total sales. Both are editable assumptions: an admin replaces them with real rates in Company Context. With Shopify Payments connected, Contribution margin before ads (actual fees) and Break-even MER (actual fees) use the fees Shopify Payments actually charged. Fees from PayPal and other gateways are not included.
Does this work with WooCommerce?
WooCommerce connects read-only and gives you net sales, orders, average order value and new customers by product, with the same daily refresh. The pre-built profit metrics (cost of goods, contribution margin, break-even MER, nCAC and aMER) are defined for Shopify. For a WooCommerce store, an admin can define a custom metric from the metrics and datasets you have.
Can Quiriz build the monthly profit review deck?
Yes. In Quiriz for PowerPoint or Google Slides, describe the deck, such as a profit review for last month, and Quiriz shows a plan of slide titles and questions to edit before it builds. Every chart and table is answered from your store and ad data with the same definitions as on this page, and next month you use Refresh all instead of rebuilding the deck. Make a deck is in Beta.