The geographic tier is the price book foundation. PharmaDB joins molecule_country_flow to countries and computes the regional average median per molecule. Refresh cadence is weekly.
Build a region-by-region pricing tier map for any molecule. The empirical 3-tier or 4-tier classification anchored on actual trade clearance, not arbitrary adjustments.
Telmisartan India-out clears 21 destinations across 5 world regions in 2024 with a 28x spread between the highest and lowest regional medians. Asia clears at $16.78/kg average median (lifted by Turkey at $131.27); Europe sits at $1.28, Africa at $1.25, South America at $0.63, and North America at $0.59. The clean tier-1 tier-3 mapping is Asia (premium-mixed), Europe-Africa (mid-volume), and Americas (low-band volume). A pricing team applying a global list price across all 21 destinations is unanchored from the regional reality; the brief surfaces the tier table ready for the price book.
Type the molecule INN and the origin country. The AI agent pulls every destination with declared shipments and groups by world region.
Region-level average median, min median, max median, and total shipment count. Regions are ranked into tiers based on the average median percentile.
Citation-anchored brief: the tier table, the minimum price by tier, and an Excel-ready export for the regional sales team.
Country-by-country price lists are unmanageable. The regional tier map is the operational simplification: tier-1 / tier-2 / tier-3 price floors that the sales team can apply consistently.
Tiers reflect what each region actually pays, not an internal-strategy classification. The price book is defensible against negotiation pressure when challenged.
Destinations within a region that clear far above or below the regional average are flagged. Single anomalies do not contaminate the tier; the user can decide to keep them in or exclude as a special case.
Trade aggregates refresh weekly. The tier map reruns on every refresh; the brief carries the exact computation timestamp.
A real chat thread in PharmaDB. Type a question, the AI agent runs the tools, the answer lands as a saveable note.
pharmagraph_query Twelve molecule-region pairs · 2024 average median · USD/kg from India-out lanes.
The geographic tier is the price book foundation. PharmaDB joins molecule_country_flow to countries and computes the regional average median per molecule. Refresh cadence is weekly.
The `countries` table groups destinations into five canonical regions: Asia, Europe, Africa, North America, South America. Mid-East destinations are typically classified within Asia; small island states are classified by their geographic region. The mapping is exposed and configurable.
Each destination already has a lane median (computed across its shipments). Averaging the destination medians within a region gives an equal-weighted regional benchmark; this prevents one high-volume destination from dominating the tier. A volume-weighted alternative is available.
Destinations more than 3x the regional average are flagged. The brief surfaces them inline so the user can decide whether to keep them in the tier or price them as a separate special case (e.g., Turkey on telmisartan).
Asia spans both high-tender markets (Saudi Arabia, Bangladesh, the Gulf) and premium-equivalent markets (Turkey, Korea, Japan). The same molecule clears at very different bands within the region. The brief either splits Asia into sub-regions or flags the dispersion explicitly.
Output is Excel-ready: tier-1 / tier-2 / tier-3 floor per molecule, with the supporting average median. The regional sales team applies the floor against their local negotiation; finance gets the tier as the transfer-pricing anchor.
Trade aggregates refresh weekly. The tier map reruns on every refresh; the catalog row carries the exact timestamp.
Bring the molecule, the lane, or the supplier you're sourcing this week. The AI agent runs it on PharmaDB in 30 minutes. You keep the brief.