23 November 2025 – 24 August 2026 · 11,279 successful transactions · Source: Odoo Sales Analysis Report
0 · Cross-check first
Before drawing conclusions, the Odoo sales export was reconciled against the separate Payment History booking report for their overlapping window, 13 July – 23 August 2026.
Measure
Odoo sales export
Payment History report
Delta
Transactions in window
1,736
1,700
+36
Paid / billed
1,344
1,306
+38
Free / zero-value
392
394
-2
Patient spend
$12,312
$12,088
+$224
Difference vs base
—
—
2.1% / 1.9%
The two files reconcile. They are the same transactions viewed from two angles.
The 36 extra rows and $224 in the Odoo file are explained by date basis: Odoo stamps the order date (when the call-centre agent creates the sale) while the Payment History report stamps the consultation date. Orders placed on a Friday for a Saturday appointment land in different buckets. Every Friday in the window shows 13–17 Odoo orders and zero Payment History consultations, which accounts for almost the whole gap.
Most importantly, blank Total values are not missing data. Odoo shows 392 zero-value transactions in the window; the booking report shows 394 consultations explicitly flagged Free. These are the same records. A blank Total means free consultation, and every row in this file is a completed, successful transaction.
1 · The nine-month picture
Successful transactions
11,279
across 272 trading days
Paid transactions
7,644
68% of all transactions
Free consultations
3,635
32% given at no charge
Patient spend
$59,114
total value transacted
Est. BAANO revenue
$9,477
at $1.24 commission per paid txn
Avg paid ticket
$7.73
median $8
Aug run rate
$9,159
patient spend / month, all-time high
Services sold
3
of 11 product variants recorded
Patient spend is not BAANO revenue.
The Total column is what the patient pays. Most of it goes to the doctor or hospital. From the Payment History overlap, BAANO's admin commission averaged $1.24 per paid transaction and is charged as a flat cost, not a percentage. Applying that rate across all 7,644 paid transactions gives an estimated $9,477 of BAANO gross margin over nine months — around $1,053 per month. That is the number to plan against.
2 · Volume is down. Revenue is up.
This is the most important pattern in the file, and it contradicts the internal "bookings are declining" narrative.
TransactionsPatient spend $
Month
Txns
Paid
Free
Free %
Avg ticket
Patient spend
Per day
Est. BAANO rev
Nov 25 *
174
56
118
67.8%
$6.31
$354
$44
$69
Dec 25
969
591
378
39.0%
$8.50
$5,024
$162
$733
Jan 26
1,331
744
587
44.1%
$8.42
$6,265
$202
$922
Feb 26
1,726
1,196
530
30.7%
$5.30
$6,340
$226
$1,483
Mar 26
1,579
1,039
540
34.2%
$5.41
$5,624
$181
$1,288
Apr 26
1,259
737
522
41.5%
$8.33
$6,140
$205
$914
May 26
956
744
212
22.2%
$8.66
$6,444
$208
$922
Jun 26
1,155
832
323
28.0%
$9.03
$7,516
$250
$1,032
Jul 26
1,182
915
267
22.6%
$8.83
$8,081
$261
$1,134
Aug 26 *
948
790
158
16.7%
$9.28
$7,327
$305
$979
* Nov 2025 covers 8 days from launch on 23 November. Aug 2026 covers 24 days to the 24th. Per-day column normalises both.
Transaction volume fell 45% from the Feb 26 peak. Patient spend per day rose 35% over the same stretch.
Feb 26 was the busiest month at 1,726 transactions, but it earned only $226 per day. August is running 948 transactions in 24 days and earning $305 per day — the highest of any month on record.
Two things drove that. The average paid ticket climbed from $5.30 in Feb 26 to $9.28 in Aug 26, and the free-consultation share fell from 67.8% at launch to 16.7%. Somebody has been tightening billing discipline, and it has more than compensated for the lost volume. That is an operational win worth naming and crediting internally.
Average ticket vs free share
Avg paid ticket $Free share % (÷10)
Patient spend per trading day
$ per day
3 · BAANO is a hospital booking business
Whatever the positioning says, this is what the ledger says.
Service
Transactions
Volume share
Free
Free %
Patient spend
Revenue share
Hospital Booking
8,894
78.9%
1,545
17.4%
$57,402
97.1%
Online Consultation
2,293
20.3%
2,070
90.3%
$1,189
2.0%
Homecare
90
0.8%
19
21.1%
$516
0.9%
Other / mis-keyed
2
0.0%
1
50.0%
$7
0.0%
Monthly transaction mix
Hospital BookingOnline ConsultationHomecare
Hospital Booking is 97.1% of revenue. Online Consultation is 2.0%.
Over nine months Hospital Booking produced 8,894 transactions worth $57,402. Online Consultation — the service BAANO leads with publicly — produced 2,293 transactions worth $1,189. Homecare, launched around March, has 90 transactions and $516.
Marketing is currently promoting a telemedicine identity while the business runs on brokering appointments into physical hospitals. Either the messaging changes to match the money, or the product changes to match the messaging. Continuing to do both at once is the expensive option.
Online Consultation: volume and value
OrdersPatient spend $
90.3% of all online consultations are free, and volume has fallen 81% from its peak.
2,070 of 2,293 online consultations carried no charge. Volume peaked at 413 orders in Mar 26 and is down to 80 in Aug 26. Its share of transaction mix has fallen from 26% to 8%.
This needs a decision, not a campaign. If free online consultation is a deliberate acquisition tool, it should be costed and measured on what it converts into. If it is a pricing failure, it should be priced. Right now it is neither — it is simply happening. Worth raising with Faisal and Dr. Nureini before any further promotion of the service.
4 · Recent trend
Weekly, June onward
TransactionsPatient spend $
The last four weeks are the strongest run in the dataset.
Weekly patient spend has held between $1,698 and $2,637 since mid-July, against a June baseline nearer $1,598. Any campaign launched in September starts from a rising base, not a falling one — which matters for how NASIIB-09 results get read afterwards. Set the baseline now, in writing, before the campaign runs.
5 · Demand timing
By day of week
TransactionsPatient spend $
Order creation by hour (Odoo timestamp)
Orders logged
Saturday is the strongest day. Friday is effectively closed.
Saturday leads on both volume (1,951) and spend ($11,501). Friday runs at 553 transactions, roughly a quarter of a normal day. Thursday carries 1,430 transactions but the weakest yield at $7.47 per paid transaction and a 44.1% free rate — the highest of any day.
Treat the hour chart with caution. These are Odoo entry timestamps, not patient behaviour. The spikes at 14:00, 15:00 and 23:00 do not match the 08:00 consultation peak in the Payment History file, which points to batch entry or a shift-handover logging pattern rather than when patients actually call.
6 · Price points
Paid transactions
Two price points carry the business.
$16 and $9 together account for a large majority of paid transactions. Because BAANO's commission is a flat $1.24 rather than a percentage, moving a patient from a $6 consultation to a $16 one adds nothing to BAANO's margin. Volume and commission structure are the only two levers that move BAANO revenue — price does not.
7 · App installs against transactions
Install data is available only for 13 July – 23 August 2026, so this section covers that window.
Installs in window
6,031
4,310 Android · 1,721 iOS
Transactions in window
1,736
1,344 paid
Est. BAANO rev / install
$0.27
commission ÷ installs
Android share
71%
of all installs
App installsTransactions
Installs fell through the window while transactions held steady.
6,031 installs across 42 days produced $1,619 of BAANO commission across all channels — roughly $0.27 per install, and that figure credits the app with revenue the call centre generated. Install volume is not the constraint. Buying more downloads before the conversion path works will raise cost without raising margin.
Android is 71% of installs. Any app-side testing, creative or store optimisation should be Android-first.
8 · Data quality
Fixable at source, and worth fixing before the September campaign needs clean reporting.
Free-text entry has produced a keyboard-mash row, a lowercase duplicate, an accessories line and a bank-charges line inside a sales report. Convert Product Variant to a locked dropdown.
Salesperson and Sales Team are dead fields.
All 11,279 rows read "Call Center" and "Sales". There is no agent-level view, no channel, no campaign source. Marketing cannot attribute a single transaction from this export.
12 duplicate order references.
Small, but it means Related Order is not a reliable unique key for reconciliation.
9 · What I would do next
1. Change the reported number.
Report BAANO commission, not patient spend. Nine-month gross margin is approximately $9,477, not $59,114. Get the exact commission figure by extending the Payment History export to the full nine months.
2. Reframe the "declining bookings" story.
Volume is down 45% from peak, revenue per day is up 35%, and August is the best month on record. The diagnosis was pointing at the wrong problem.
3. Decide what Online Consultation is for.
90.3% free, 2.0% of revenue, volume down 81% from peak. Price it, kill it, or formally treat it as an acquisition cost with a conversion target attached.
4. Add a source field to the Odoo sale flow.
One mandatory field on order creation. Without it no campaign in this system is measurable, including NASIIB-09.
5. Lock the Product Variant dropdown.
Five minutes of Odoo configuration removes a permanent reporting tax.
6. Record the pre-campaign baseline in writing now.
Current run rate: $305 patient spend per day, 40 transactions per day, 16.7% free. Agree these with the COO before 21 September so the campaign is judged against a fixed line.