hcp_prescribing_trend_by_segment
Identify quarterly prescribing trends for a product by region and specialty, then drill down to individual HCPs to find decliners or growers.
Instructions
Quarterly prescribing trend for one product, broken out by region and specialty (segment_rollup), plus per-HCP quarterly rows (hcp_quarterly) for drill-down into which specific HCPs are declining/growing. Use segment_rollup to compare regions/specialties side by side; use hcp_quarterly to find individual decliners within a flagged segment.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| region | No | ||
| specialty | No | e.g. Oncology | |
| brand_name | Yes | e.g. Oncovarin | |
| quarters_back | No |