Skip to content

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 Querri

What 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

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

Open Querri →
1 Step 1:

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
Querri One project
2 Step 2:

Build contribution margin by channel, month by month

Start by building one margin, the same way for every channel:

Prompt

"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.

Build contribution margin by channel, month by month
ChannelMonthly rangeOctober
Wholesale28.1% to 31.5%30.6%
Amazon24.0% to 26.1%24.0%
Store16.3% to 22.6%19.9%

Contribution margin rate by channel, April to October 2026, month by month.

3 Step 3:

Compare each channel with its own six months

Then hold each channel against its own history:

Prompt

"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.

Compare each channel with its own six months
ChannelOctober net revenueRate 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.

4 Step 4:

Find the costs and SKUs behind the drop

Take Amazon apart, cost line by cost line:

Prompt

"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.

Find the costs and SKUs behind the drop
ItemFBA fee per unitOctober 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.

5 Step 5:

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:

Build the monthly channel margin view
ChannelContribution marginRate (prior)
Store$331.31K19.9% (19.7%)
Amazon$293.25K24.0% (25.8%)
Wholesale$241.55K30.6% (30.3%)
All channels$866.11K23.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 data
Querri for ecommerce growth See how Querri helps growth teams see real profit by channel and campaign, with fees, ad spend and product cost in one place. See Querri for growth

See Querri for the whole brand

Tips 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.

Prompt

"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
Prompt

"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?
Net revenue less product cost, channel fees, fulfillment and the channel's own ad spend, divided by net revenue for the rate. It is Curio's rule, and you change it in one sentence.
Why month by month and not week by week?
The 3PL and freight bills arrive monthly, so a weekly contribution margin would need invented allocations. Monthly keeps every cost real.
What did ad efficiency hide?
Each ad dollar brought in 6.20 of net revenue in October against 6.12. That looks healthy, while Amazon's contribution margin rate fell 1.76 points on fees.
Why does wholesale earn the highest rate?
It carries no ad spend and no marketplace fees. At $788.7K of October net revenue it was the smallest channel and earned 30.6%.
How are Amazon SKUs matched to product cost?
Through the SKU map in NetSuite's item cost table. A few old Amazon SKUs match nothing; their 469 rows, $15,392.80 of net revenue from April to October, are left out and listed.
Does Querri attribute sales to ads?
No. Ad spend is charged to the channel it ran for. The page compares cost lines; it doesn't claim which ad drove which sale.
Is this the same fee change as the finance playbook?
Yes. The SKU margin playbook finds the same three items and the same $17,955 October cost, from the same Amazon data.
How often should this run?
Monthly, once the month's 3PL and freight bills are in NetSuite. A fee or cost change shows up in the first full month it applies.