Sample Commercial Insights report
Sample report · Example insights from anonymised demonstration data · company & customer names fictional, figures illustrative
Crakd.ai
Sample commercial insights report
Prepared from a demonstration company’s Pegasus Opera data · Illustrative - 2026
What Northwind’s own Opera data says

Northwind’s growth is already inside its customer base.

We asked AiCopilot a series of plain-English questions about Northwind’s sales, margins and customer accounts. Every finding below comes from Northwind’s own Opera SE records for January to September 2026, and each one ends with what to do about it.

Web orders2×Customers who order online spend twice as much per order as by phone or email (£580 vs £290).
Out-of-hours orders£1.18mof web orders placed before 9am or after 6pm in just two months, with nobody needing to answer a phone.
Bigger baskets online12 vs 6products per order on the web, against phone or email (12.2 vs 6.4 lines).

Every figure comes from Northwind’s own Opera records and reconciles to the sales ledger within 0.02%.

Disclaimer. Company and customer names are fictional and figures are illustrative; based on a demonstration Pegasus Opera dataset.

Each figure is marked:Checked read directly from OperaEstimate calculated from checked figuresScenario what-if, with the assumption stated
1 · Web ordering

Customers who order online buy twice as much per order.

Northwind has always felt web orders were bigger. The data confirms it, and shows why: online, customers see the range and add more products to the basket.

Asked AiCopilotFor customers who used both web and normal entry in August and September 2026, excluding credit notes, non-trade accounts and orders under £50: how many had a higher web average order value?

The same customers spend more per order online

Higher order value on web372 of 418
Share of orders via web56%
Share of order value via web63%

Order value: the 418 customers who use both channels. Lines per order: all orders over £50. Shares: all invoiced and open orders. Both August–September 2026. Checked

Asked AiCopilotWhat time of day are web orders placed, and how much is placed out of hours?

Almost 3 in 10 web orders arrive when the office is closed

01,0002,0003,00000–03: 269 web orders00–03: 269 web orders00–0303–06: 79 web orders03–06: 79 web orders03–0606–09: 316 web orders06–09: 316 web orders06–0909–12: 1,584 web orders09–12: 1,584 web orders09–1212–15: 2,791 web orders12–15: 2,791 web orders12–1515–18: 1,532 web orders15–18: 1,532 web orders15–1818–21: 859 web orders18–21: 859 web orders18–2121–24: 881 web orders21–24: 881 web orders21–24

Web orders by time placed, August–September 2026 (invoiced and open orders only). Highlighted: before 09:00 or after 18:00. Checked

Before 09:00 or after 18:002,404 orders
Value of those orders£1.18m
Between 18:00 and midnight1,740 orders

Restaurants order after service. None of these orders needed anyone to answer a phone or key anything in.

Asked AiCopilotList the customers with the most phone and email orders in August and September 2026, with their web orders alongside.

20 busy restaurants still order only by phone or email

They placed 496 orders worth £194k in two months, all keyed in by hand, at 6.4 lines per order against 12.2 on web. Three are chains, and the chains go much further than these sites: 70 of Mizu Group’s 78 sites and 20 of Nori & Broth’s 21 order only by phone or email (735 and 364 orders in the two months).

CustomerOrders (2 months)Value (2 months)Web orders
Mizu Group Twickenham, Reigate, Leeds and Staines98£37,9800
Nori & Broth Fountain Bridge, Renfield, Gateshead, Manchester (M9) and Soho112£63,9400
J9 Modern Japanese (Fetter Lane and Coleman Street)59£24,2100
Tsuki28£11,4800
Blue Lotus25£7,6900
Harbour Izakaya Bolton24£10,9800
Sora (Retail)23£14,1100
5 further restaurants126£24,8800
Suggested action
  • Set each one up on the web shop and take their next order online with them.
  • About 2,950 manually keyed orders a year (£1.16m) move online. If their spend rises by even 10%, that is about £116k more sales a year. Across the whole Mizu Group and Nori & Broth chains the opportunity is several times larger. Scenario
The full report

Read the rest of the report

Seven more findings - split-buying, the tale of two sites, where the growth is hiding, and the plan to act on it. Enter your email to unlock.

Takes a second. We’ll send the odd note as we ship new apps - no spam, leave any time.

2 · Gaps in the basket

Many restaurants buy their side dishes from Northwind and their core ingredients elsewhere.

Fifteen products are the most widely bought across Northwind’s Japanese restaurants (customer type R02). The ones most often missing from a customer’s basket are Northwind’s best-margin lines.

Asked AiCopilotFor R02 customers in 2026, how many bought fewer than 8 of the top 15 R02 products, and how does their spend compare with customers who buy 12 or more?

228 Japanese restaurants buy less than half the core range

Average spend per customer, January–September 2026. Checked Larger restaurants naturally buy a wider range, so we size the opportunity conservatively below.

Core productR02 customers buying itGross margin
Kaede Premium Rice 20kg24448.3%
Shirakiku Premium Unagi Eel22846.1%
Shirakiku Horseradish (wasabi) Powder19253.4%
Shirakiku Goma Wakame26849.2%
Shirakiku Edamame28643.1%
Shirakiku Soy Sauce Sachets24138.2%
Shirakiku Tobiko Orange21321.4%

Margin on each sale, across all customers, January–September 2026, before any customer rebates. Northwind’s overall margin is 30.4% after rebates. Checked

Suggested action
  • If each of the 228 added just two core products at typical spend, that is about £292k more sales and £129k more gross profit a year. Scenario at £452 per product per 9 months and 45% margin.
Asked AiCopilotList R02 customers who spent over £20,000 but bought fewer than 9 of the top 15 products, and which ones they have not bought.

25 established accounts, worth £872k, buy core products elsewhere

CustomerSpend, Jan–SepCore range bought
Haru Kitchen Borehamwood£106,4806 of 15
Yuki Kitchen£73,1207 of 15
Akari Restaurant£69,2108 of 15
Hoshi Restaurant£52,1408 of 15
Kaze (Old Compton St and South Kensington)£51,2903–4 of 15
Fox & Crane (head office)£30,8704 of 15
Ume (Regents Park)£30,5602 of 15

Checked Akari Cheltenham (closed) removed from the total.

Haru Kitchen is the clearest example. They buy the sauce from Northwind but the main ingredient from someone else. They order Northwind’s unagi (eel) sauce every week, but not Northwind’s unagi eel. They order Northwind’s rice vinegar every week, but not Northwind’s premium rice. They have kept buying everything they ordered regularly earlier in the year, so this is a loyal customer who is buying their eel and rice elsewhere.

Suggested action
  • Give each account manager this list with the specific missing products per account, and quote on rice and unagi first.
3 · Mizu Group

Mizu Group is two businesses under one name.

On paper Mizu Group is one customer with one margin. Look underneath and there are two very different businesses for Northwind: the frozen chicken, and everything else.

Asked AiCopilotFor all Mizu Group accounts, show sales, margin and the share of sales from frozen chicken leg (A91020). Then the price charged per case at each site, and the margin on that product.

Every £1 Mizu Group spends with Northwind earns one of two very different amounts

£1 of frozen chicken6p5.8% margin, the same figure in every check we ran
£1 of everything else36p35.6% margin across Mizu Group’s other products before rebates (28.9% after setting its rebate against them): about six times more per £1

Gross profit per £1 of sales, Mizu Group sites, January–September 2026. Checked Chicken and other products add up exactly to the total in the same query. The chicken price is the same across the chain (£31–£33 a case), so this is about what each site buys, not what it pays. Mizu Group also has a rebate account: −£154,900 in January–September. After it, Mizu Group as a whole earns 20.3% on £2.28m of sales.

A tale of two Mizu Group sites

Two sites, same brand, same prices, almost exactly the same spend with Northwind. One buys mostly chicken; the other buys none.

2.9×the profit from the same spend. Sevenoaks actually earns Northwind 36% on the non-chicken products it buys. It just buys very few of them.

The pattern holds right across the chain: every dot below is a Mizu Group site, and the more of its spend goes on chicken, the lower its margin.

10%20%30%40%0%20%40%60%80%Share of the site’s spend that is frozen chicken (A91020)Mizu Group UK (office): 28% chicken, 30.0% marginMizu Group Southampton 1: 58% chicken, 20.2% marginMizu Group Glasgow: 39% chicken, 27.4% marginMizu Group Nottingham: 49% chicken, 24.1% marginMizu Group Hersham: 0% chicken, 29.9% marginMizu Group Sutton: 56% chicken, 19.1% marginMizu Group Hastings: 25% chicken, 24.0% marginMizu Group Southampton 2: 57% chicken, 20.3% marginMizu Group Harlow: 59% chicken, 18.7% marginMizu Group Tunbridge Wells: 61% chicken, 19.9% marginMizu Group Morden: 57% chicken, 19.4% marginMizu Group Croydon: 59% chicken, 21.9% marginMizu Group Durham: 37% chicken, 26.6% marginMizu Group Peterborough: 51% chicken, 21.4% marginMizu Group Poole: 65% chicken, 16.9% marginMizu Group Bristol: 65% chicken, 17.7% marginMizu Group Twickenham: 58% chicken, 15.2% marginMizu Group Staines: 64% chicken, 16.1% marginMizu Group Clapham: 59% chicken, 17.8% marginMizu Group Sevenoaks: 77% chicken, 13.1% marginMizu Group Basingstoke: 0% chicken, 39.6% marginMizu Group Reigate: 10% chicken, 26.5% marginMizu Group Kingston: 10% chicken, 34.1% marginMizu Group Epsom: 5% chicken, 32.3% marginMizu Group Bournemouth (closed): 46% chicken, 25.3% marginMizu Group Eastleigh: 66% chicken, 16.7% marginMizu Group Imperial College: 1% chicken, 43.1% marginMizu Group Dorking: 49% chicken, 22.1% marginMizu Group Gloucester: 58% chicken, 19.8% marginMizu Group Bedford: 55% chicken, 18.9% marginMizu Group Putney: 0% chicken, 35.1% marginMizu Group Camberley: 0% chicken, 41.0% marginMizu Group Surbiton: 0% chicken, 40.7% marginMizu Group Cheltenham: 47% chicken, 22.4% marginMizu Group Newbury: 58% chicken, 20.6% marginMizu Group Maidstone: 0% chicken, 39.5% marginMizu Group Liverpool: 17% chicken, 31.9% marginMizu Group Farnborough: 1% chicken, 37.8% marginMizu Group Watford: 0% chicken, 29.4% marginMizu Group Tooting: 1% chicken, 42.9% marginSevenoaks 13%Basingstoke 40%

Gross margin against the share of each site’s spend that is frozen chicken, 40 largest Mizu Group sites, January–September 2026. Hover a dot for the site. Checked

Try it: what if Mizu Group bought more of everything else?

Extra gross profit a year£55,000

Scenario Mizu Group’s £1.42m of non-chicken sales after its rebate (January–September), grown by the chosen percentage, at their 28.9% margin after rebate, shown as a full year. No price changes.

Suggested action
  • Grow the rest of the basket at the chicken-heavy sites, using Basingstoke and the other high-margin Mizu Group sites as the example of what the chain already buys.
  • Several Mizu Group sites already buy little or no chicken from Northwind and buy the wider range instead, so the chain is clearly happy to buy it from Northwind.
4 · Oko Kitchen

Oko Kitchen buys like a model customer. One question decides what it is worth.

Asked AiCopilotFor Oko Kitchen’s accounts, show total sales, gross profit and margin for January to September 2026, before and after its rebate account. Then show how the rebate account is posted and paid.
Sales before rebates£2.18m
Margin on invoices47.8%
Rebates, Jan–Aug−£681k
Margin after rebates25.1%

Checked 33 trading accounts plus one rebate account. Northwind’s overall 30.4% is after all rebates.

What the data shows

Oko Kitchen buys a broad, premium range with no single product above 10% of its spend, and its invoices earn Northwind 47.8%. A separate rebate account then receives one credit at the end of each month (“JUL REBATE”, “AUG REBATE”), which is paid back to the group about two weeks later, some marked “retro”. The monthly amount varies from £58k to £102k, between 28% and 40% of that month’s sales. After it, the group earns 25.1%. Around nine other customer groups have rebate accounts on a smaller scale.

What the data cannot show

How the monthly amount is worked out. It could bring invoices back to an agreed contract price, apply to particular ranges, or cover wider terms such as marketing or franchise support. Only Northwind knows, and the answer changes the picture: on its invoices Oko Kitchen is Northwind’s best-margin group; after the rebate it is close to average.

A question for Northwind
  • How is Oko Kitchen’s monthly rebate calculated, and does it still reflect what the group buys?
  • Whatever the answer, it helps to manage Oko Kitchen as one account with one named owner and to report on it as a group, after rebates.
5 · Spotting changes early

Opera shows when a customer’s buying pattern changes, as it happens.

Riverbank and Fresh Larder were the 3rd and 4th largest trading customers in the first half of 2026. Both have changed how they buy since the summer. AiCopilot picked this up by reading sales and the sales ledger together, which gives the account team a reason to call while the conversation is easy.

Asked AiCopilotFor Fresh Larder Production, show monthly sales for 2026, the current balance and amount overdue, and how quickly they usually pay.

Fresh Larder Production: buying has changed since July

Worth a conversation
£0£20k£40k£60kJan: £32,606Jan: £32,606JanFeb: £37,689Feb: £37,689FebMar: £50,569Mar: £50,569MarApr: £31,330Apr: £31,330AprMay: £40,748May: £40,748MayJun: £46,708Jun: £46,708JunJul: £53,842Jul: £53,842JulAug: £26,960Aug: £26,960AugSep: £2,984Sep: £2,984Sep

Net sales by month, 2026 (£). August and September highlighted. Checked totals agree exactly with the sales ledger.

Average month, Jan–Jul£41.9k
September£3.0k
August invoices still open£27.0k
Credit limit · on stop?£90k · No

Every one of their main products fell at the same time (nori, rice seasoning, rice, ginger, wasabi), so the change is across the whole account rather than one product. Fresh Larder normally pays by BACS around the 6th to 8th of the month after next. August’s £27.0k would normally have arrived by 8 October and, as at 14 October, is about a week behind that pattern.

Suggested action
  • A call from the account manager to understand what has changed for them.
  • An account worth about £500k a year in sales at their January–July rate. Estimate
Asked AiCopilotFor Riverbank Foods, show net sales by month from January 2025 to September 2026.

Riverbank Foods: growing fast, and due its next bulk order

Growing
£0£25k£50k£75k£100kJan 25: £0Jan 25Feb: £20,700Feb: £20,700Mar: £14,800Mar: £14,800Apr: £18,298Apr: £18,298AprMay: £0Jun: £67,457Jun: £67,457Jul: £0JulAug: £0Sep: £89,700Sep: £89,700Oct: £342Oct: £342OctNov: £194Dec: £4,620Dec: £4,620Jan 26: £89,010Jan 26: £89,010Jan 26Feb : £89,700Feb : £89,700Mar : £1,277Mar : £1,277Apr : £-1,396Apr May : £89,700May : £89,700Jun : £6,600Jun : £6,600Jul : £0Jul Aug : £0Sep : £43

Net sales by month, January 2025 to September 2026 (£). Checked

2026 so far vs all of 2025£275k vs £216k
Typical order~£90k
Longest previous gap4 months
Since last load (May)4½ months

Riverbank is a growing customer that buys in large, infrequent loads at a margin of around 45% (from our earlier analysis), so each missed load is roughly £40k of gross profit. Estimate Their buying runs in a clear rhythm, and on that rhythm the next load is due now.

Suggested action
  • A timely call to line up the next load.
  • About £365k a year in sales at their 2026 rate. Estimate
6 · Putting it to work

One way to put this to work: give every account one clear job.

This is a suggestion, not a prescription. Northwind’s team knows its customers best and will decide what fits. As an example, the findings above sort customers into four groups, each needing a different kind of attention.

Protect

Accounts whose usual buying pattern has changed

Now
Fresh Larder, Riverbank
Action
A prompt call to understand what has changed
Measure
Spend back to normal

Grow

Large accounts missing core products, and chicken-heavy Mizu Group sites

Now
Haru Kitchen, Ume, Fox & Crane, Kaze, Yuki, Mizu Group
Action
Quote on the two or three biggest missing products
Measure
Core products bought (of 15)

Convert

Restaurants that only order by phone or email

Now
Mizu Group (76 sites), Nori & Broth (22 sites), J9 Modern Japanese, Tsuki, Blue Lotus
Action
Set up web ordering and take the next order online together
Measure
Share of orders via web

Automate

Smaller, steady accounts

Now
The long tail of restaurants
Action
No account manager time; the web shop prompts “you usually order…”
Measure
Lines per order

What a weekly rhythm could look like

  1. Monday list. Each account manager gets three short lists from AiCopilot: customers at risk, customers due to order, and gaps to fill.
  2. Before each call. A one-page brief: what this customer usually orders, what is overdue, and what they buy elsewhere.
  3. Monthly review. Four numbers per account: spend against normal, core range bought, web share and margin.
7 · What else to ask

This is a taster. The next question is Northwind’s.

Everything above came from a handful of plain-English questions. Northwind knows its business better than anyone, and the questions that matter most will be Northwind’s own. A few examples of what the team could ask next:

SalesWhich of my customers are due to order this week, based on how often they usually buy?
SalesBefore I call Haru Kitchen: what do they usually buy, what is overdue, and what do they buy elsewhere?
FinanceWhich customers are buying less and paying more slowly than usual?
FinanceAre we charging different prices for the same product to similar customers?
BuyingWhich products are growing or falling month by month, so we can plan stock?
DirectorsHow is Oko Kitchen trading this month as a group, compared with last month?

Each answer arrives in about a minute, worked out from Northwind’s own Opera records and checked a second way where possible.

Suggested next step
  • A short call to walk through the findings and hear which questions matter most to Northwind.
8 · How we checked

How this was produced

Every finding came from a plain-English question typed into AiCopilot, which reads Northwind’s Opera SE data and never changes it. We checked each answer before using it, re-asked where results looked wrong, and left out anything we could not confirm.

AgreesTotal sales January–September 2026: £27,861,540 from sales analysis against £27,856,980 from the sales ledger, a difference of £4,560 (0.02%).
AgreesFresh Larder’s January–June sales match the sales ledger to the penny (£239,649.20).
AgreesMizu Group’s chicken margin comes out at 5.8% in every query, and chicken plus other products add up exactly to the total.

Limits. Opera keeps how an order was entered (web or manual) only for August and September 2026, so the web findings cover those two months and we could not measure customers before and after they moved online. Branch delivery accounts invoice through head-office accounts, so customers are compared at invoice-account level. Scenarios use the assumptions stated beside them. Northwind overall: £27.86m sales, 30.4% gross margin and 1,840 active trading customers, January–September 2026, excluding customer type EX (2 accounts, £303,900 of sales at nil cost; £28.16m and 31.1% with them). Customer groups include their rebate accounts. Order counts and values include invoiced and open orders only, not credit notes, quotes, proformas or unposted documents.

Web ordering. Every web figure in this report comes from Northwind’s Opera sales orders, not from a web platform.