Bloomwell Data Agent
The agent knows about patients, their services, prescriptions, medications, and orders. Use the map below to understand what questions it can answer, what you can filter and group by, and what's coming next.
Connected to the agent
Filter & group by
Count & measure
"How many active patients do we have right now?"
"Which patients haven't had a service since March?"
Always current — patient status is recalculated from Service on every query, never a stale snapshot.
Filter & group by
Count & measure
"How many video consultations happened last month?"
"What's our no-show rate by doctor?"
"Which patients have had more than 5 services?"
"How many patients are booking their first appointment this week?"
Combines XpertyMe appointments and HubSpot therapy orders into one timeline. A few older appointments aren't linked to a patient, so overall totals can run slightly ahead of per-patient totals.
Filter & group by
Count & measure
"How many prescriptions were issued last month?"
"What's the average grams prescribed per prescription?"
"Which patients have the most prescriptions this year?"
"How many prescriptions include more than one medication?"
Flattened to one row per active medication line — a bundle prescription expands to one row per sub-product. Cancelled prescriptions are excluded. Joins to Service via service_id (most resolve; a minority of older appointment IDs don't — known gap, not a modelling error).
Filter & group by
Count & measure
"What was our revenue by product category last quarter?"
"How many grams of flower were sold last month?"
"Which patients have ordered more than 10 times?"
"What's the average time from order to delivery by pharmacy?"
"What share of orders were cancelled last month?"
One row per order line item (order + product). Revenue comes from line_total_eur — already multiplied by quantity, do not multiply again. Merchandising columns (promotion, slot, carousel) are point-in-time as at ordered_at; ratings are current. Product-level coverage starts 2023-07-20; order counts before that must come from the order header. Delivery timestamp is NULL on pickup orders even when delivered.
Drafted — not yet connected to the agent
Filter & group by
Count & measure
"How much was collected via invoice last month?"
Fields not yet finalised.
Filter & group by — pick a category to slice the data.
Count & measure — a number you can total up. Click to see a sample question.
Subset — covers a specific slice of patients (app users only).
Drafted — planned but not yet connected to the agent.