What does each channel earn after fees, ads and product cost?
Join Shopify, Amazon, both ad accounts and NetSuite. See each channel's contribution margin, month by month, against its own six months, and find the cost line that moved.
Open QuerriWhat you'll need
Querri (Free trial) to join five systems into one margin
Shopify, Amazon, Meta Ads, Amazon Ads and NetSuite: Step 1 says what each adds
Your contribution margin rule: so every channel subtracts the same costs
Free resources
Start your free trial here →Sample data sets
Synthetic data for Curio Supply, a made-up home goods brand. Not real customer, retailer or marketplace data.
Need help?
If you have any questions, you can request a demo or email our team.
Before we begin
Sales by channel and blended ad efficiency are the numbers the weekly meeting sees, and both can look fine for months. Neither says what a channel keeps after product cost, marketplace fees, fulfillment and its own ads. Those costs live in five systems, so contribution margin by channel usually gets built once, in a spreadsheet, and not again.
This playbook builds contribution margin for the store, Amazon and wholesale each month, compares each channel with its own six months, and finds the cost line and items behind any change.
How it works:
- • Connect Shopify, Amazon, both ad accounts and NetSuite
- • Build contribution margin by channel, month by month
- • Compare each channel with its own six months
- • Find the costs and SKUs behind the drop
- • Build the monthly channel margin view
Follow the steps
Connect Shopify, Amazon, both ad accounts and NetSuite
Five sources, one project:
- •
Shopify: store order lines and payout fees.
- •
Amazon Seller Central: orders, refunds, referral and FBA fees.
- •
Meta Ads: daily spend for the store's campaigns.
- •
Amazon Ads: daily spend for Amazon campaigns.
- •
NetSuite: wholesale invoices, landed cost by item and month, and 3PL and freight bills.
All five connect directly and sync on a schedule. Each channel gets its own ad spend: Meta for the store, Amazon Ads for Amazon, none for wholesale.
Tip: Pull six months before the month you're reviewing, so every channel is compared with its own history.
-
Shopify sales and payouts -
Amazon transactions -
Meta Ads -
Amazon Ads -
NetSuite sales, cost and 3PL bills
Build contribution margin by channel, month by month
Start by building one margin, the same way for every channel:
"Build contribution margin for the store, Amazon and wholesale each month: net revenue less product cost, fees, fulfillment and ad spend."
Wholesale, the smallest channel, earned the highest rate every month from April to October. Amazon's October rate of 24.0% was its lowest of the seven months.
| Channel | Monthly range | October |
|---|---|---|
| Wholesale | 28.1% to 31.5% | 30.6% |
| Amazon | 24.0% to 26.1% | 24.0% |
| Store | 16.3% to 22.6% | 19.9% |
Contribution margin rate by channel, April to October 2026, month by month.
Compare each channel with its own six months
Then hold each channel against its own history:
"Compare each channel's October contribution margin rate with its own April to September. Which one moved?"
Amazon moved: down 1.76 points to 24.0%, against 25.8% for April to September. The store and wholesale held, and each ad dollar brought in 6.20 of net revenue against 6.12.
| Channel | October net revenue | Rate change |
|---|---|---|
| Store | $1.66M | +0.19 points |
| Amazon | $1.22M | -1.76 points |
| Wholesale | $788.7K | +0.32 points |
| All channels | $3.67M | -0.21 points |
October 2026 against April to September 2026.
Find the costs and SKUs behind the drop
Take Amazon apart, cost line by cost line:
"Show each cost line as a share of each channel's net revenue, October against the prior six months. Which line moved on Amazon, and on which items?"
Amazon fees rose 1.65 points to 25.7% of net revenue; ad spend as a share of revenue stayed flat at 13.9%. The FBA fee change on three items cost $17,955 in October.
| Item | FBA fee per unit | October cost |
|---|---|---|
| Curio Linen Duvet Set, Queen | $11.50 to $25.50 | $10,794 |
| Marlow Comforter, Queen | $11.37 to $27.40 | $5,386 |
| Harlow Stoneware Mug Set | $8.84 to $12.05 | $1,775 |
| Total | $17,955 |
FBA fee per Amazon-fulfilled unit, August against October 2026, and the October cost of the change.
Build the monthly channel margin view
Four numbers for the meeting, and what each channel kept.
The narrative Querri writes:
Ad efficiency held in October, but Amazon's contribution margin rate fell 1.76 points, and the change is in fees.
What you can create or export:
- The table, to Excel, CSV or Google Sheets
- A live dashboard that refreshes with each sync
- A presentation for the meeting, to PDF or PowerPoint
| Channel | Contribution margin | Rate (prior) |
|---|---|---|
| Store | $331.31K | 19.9% (19.7%) |
| Amazon | $293.25K | 24.0% (25.8%) |
| Wholesale | $241.55K | 30.6% (30.3%) |
| All channels | $866.11K | 23.6% (23.8%) |
Contribution margin by channel, October 2026 (April to September 2026 rate).
Take three listings and their fees to the meeting.
Try it on your own dataTips for a channel margin people trust
Give each channel its own ad spend
Blended ad efficiency mixes channels with different costs. Charging Meta to the store and Amazon Ads to Amazon shows what each channel keeps.
Compare a channel with itself
Wholesale will usually out-earn Amazon on rate. The question each month is whether a channel moved against its own six months.
Teach Querri your rules once. Every answer after that follows them.
What contribution margin subtracts, which ad account belongs to which channel, how wholesale is defined: say each rule once and Querri applies it to every question on that data.
Show me how
Say it in chat
Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.
"Contribution margin is net revenue less product cost, channel fees, fulfillment and the channel's own ad spend. Save that as a rule for the channel margin view."
Or bring the document that already says it
Upload your margin definitions or KPI glossary like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:
- Channels: Store (Shopify), Amazon, Wholesale (NetSuite retail and distributor)
- Product cost: units times the item's landed cost for that month
- Amazon fees: referral, FBA, inventory and service fees
- Fulfillment: the month's 3PL and freight bills, by channel class
- Ad spend: Meta Ads for the store, Amazon Ads for Amazon
- Prior six months: pooled dollars over pooled net revenue
"Read our KPI glossary and propose the rules it states about contribution margin and ad spend. I'll review them in the Inbox."
Where the rules reach
A rule is attached to the data, not to one person's chat, so it follows the data everywhere:
- • Every question asked in chat, by anyone on the ecommerce team
- • Every view the Librarian builds on that data
- • Every step of a project, including the code it writes
- • Dashboards and scheduled runs, each time they refresh
- • Claude and ChatGPT, when they ask Querri
You stay in control
Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.
The payoff in the meeting
The meeting sees what each channel kept and which cost moved, the same way every month. Adding a cost line is a sentence.
Frequently asked questions
What is contribution margin here?
Why month by month and not week by week?
What did ad efficiency hide?
Why does wholesale earn the highest rate?
How are Amazon SKUs matched to product cost?
Does Querri attribute sales to ads?
Is this the same fee change as the finance playbook?
How often should this run?
Other popular resources
Playbook
Email revenue by flow
What share of store revenue comes from each email flow?
Playbook
In-stock rate and aged SKUs
Which SKUs are out of stock or aging, by channel?
Demo
Request a walkthrough
See Querri in action with your own data.
Pricing
Compare plans
Find the right plan for individuals, teams, or enterprise.