Pharma Commercial Analytics Path · Mission 16 of 25Expert

HCP×product call-Rx ROI matrix

Multi-CTE pipeline that joins two facts at the same grain (HCP × product) and produces a ratio metric. Pharma ROI matrices are the bread-and-butter of brand-team weekly reviews: which target HCPs are converting calls into Rx, and which are absorbing call effort without follow-through?

The Brief

You'll practice

Multi-CTELEFT JOIN with COALESCEis_target filter