Bloomwell Data Agent

What can you ask?

The agent knows about patients and their services. 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

Patient

One record per patient

Filter & group by

Patient IDcross-system unique key
Registration date
First service datederived from Service
Patient statusactive, inactive...

Count & measure

Count of patients+

"How many active patients do we have right now?"

Last service date+

"Which patients haven't had a service since March?"

Combines a patient's profile with their up-to-date status, worked out from Service every time you ask — so it's always current, never a stale snapshot.

joined by
Patient ID 1 many

Service

One record per visit or order

Filter & group by

Service typevideo, in-person, prescription order...
Service formatvideo / in-person / online
Service statusfinished / canceled / active
No-showyes/no
Doctor
Recorded viavideo booking system or online ordering system
Start / end time

Count & measure

Count of services+

"How many video consultations happened last month?"

No-show rate+

"What's our no-show rate by doctor?"

Total services per patient+

"Which patients have had more than 5 services?"

Service number (nth visit)+

"How many patients are booking their first appointment this week?"

Combines video/in-person appointments and prescription orders into one timeline. A few older appointments aren't linked to a patient, so overall service totals can run slightly ahead of per-patient totals.

Drafted — not yet connected to the agent

Prescription

One record per prescription

Filter & group by

Statusissued, shipped, expired...
Service typewhat issued this prescription
Doctor
Pharmacychosen by the patient
Medication substituteddoctor swapped in an equivalent due to a stock issue
Expiration dateusually 3 months after issued
Recorded viaprescription system or medication records

Count & measure

Count of prescriptions+

"How many prescriptions were issued last month?"

Time to shipping+

"How long does it take from prescription to shipment, on average?"

Prescriptions per patient+

"Which patients have the most prescriptions this year?"

Substitution rate+

"How often is a medication substituted due to stock issues, and does it delay shipping?"

Linked to Patient. A link to Service is planned once the two systems can be matched cleanly.

1 prescription →
up to 3 medications 1 ≤3

Medication

One record per medication

Filter & group by

Product name / strainBloomwell Marketplace
TypeFlower, Pieces, Capsule, Extract, Cartridge
Unitgram, pieces, ml
Manufacturer
Status

Count & measure

Count of medications+

"How many flower medications were prescribed last quarter?"

Amount prescribed+

"What's the average grams prescribed per prescription?"

Medications per prescription+

"How many prescriptions include more than one medication?"

Part of a Prescription — each prescription can include up to 3 medications. A few prescriptions are missing a medication because of system errors; that should be rare, but worth flagging if you see a lot of it.

Not yet drafted

Order
Payment

Filter & group by — pick a category, like "doctor" or "service type," to slice the data.

Count & measure — a number you can total up. Click one to see a sample question.

Drafted — the fields are written down, but the agent can't answer questions about this yet.

Not yet drafted — planned, but the fields haven't been worked out yet.