Blog · Board and management reporting · Pharmaceuticals
A pharma dashboard connects commercial sales results with account coverage and product mix. This guide works through the figures, the source files, the reconciliation checks and the decisions each view supports.
A pharma dashboard compares commercial net sales, account coverage and product mix on one consistent reporting basis. Its job is to show where the business missed its plan, which eligible accounts received attention and whether the revenue mix changed. A useful review ends with an owner and an action for each material exception.
Start with three questions: did the territory deliver its net sales target, did the team cover the intended organizational accounts, and which products made up the result? Putting the answers beside each other helps managers investigate. Combining them into an unexplained performance score hides the reason for the exception.
This page covers the reporting layout. The existing commercial KPIs for pharma sales teams guide owns the detailed definitions of access-aware reach, plan attainment and other field measures. Choose the relevant definitions there before adding them to the dashboard.
Define the sales stage as well. A manufacturer's sale to a distributor and that distributor's onward sale represent different events. The Census Bureau's wholesale definitions distinguish a distributor that buys and owns goods before reselling them from an agent earning a commission. Label the source stage so readers do not interpret a channel shipment as a final-customer purchase.
Use a sales register containing invoice or adjustment ID, posting date, organizational account, product, territory and USD amount. Keep the gross amount and the finance-approved deductions available separately. Under Regulation S-X Rule 5-03, net sales of tangible products are gross sales less discounts, returns and allowances. Finance should approve how the export reconciles to its own net revenue accounts.
Add the approved territory sales targets, a dated organizational account list and completed commercial activities. The account list establishes eligibility; the activity file establishes what happened. Retain unknown eligibility and unmatched account IDs as exceptions rather than dropping them.
Freeze one territory assignment for the reporting basis. If responsibility changed during the period, document whether transactions follow the assignment on the event date or a restated management structure. Apply that choice to both the actual and the target.
A fictional US pharmaceutical company reviews one completed commercial quarter. All amounts are USD. The three territories have separate account populations, and each activity is assigned once. Deductions in this example include all finance-approved adjustments needed to reach net sales.
Net sales = gross sales - deductions
Target attainment = net sales / approved sales target
Sales gap = net sales - approved sales target
| Territory | Gross sales (USD) | Deductions (USD) | Net sales (USD) | Sales target (USD) | Attainment |
|---|---|---|---|---|---|
| East | 900,000 | 90,000 | 810,000 | 800,000 | 101.3% |
| Central | 600,000 | 30,000 | 570,000 | 600,000 | 95.0% |
| West | 500,000 | 80,000 | 420,000 | 450,000 | 93.3% |
| Total | 2,000,000 | 200,000 | 1,800,000 | 1,850,000 | 97.3% |
The first check is $2,000,000 minus $200,000 equals $1,800,000. The second is the sum of the territory net sales against the financial control total. The company gap is $1,800,000 minus $1,850,000, or negative $50,000. Total attainment is $1,800,000 divided by $1,850,000, rounded to one decimal place.
Now place coverage beside the same territories. An account counts as reached if it has at least one eligible completed commercial contact during the quarter. Each organizational account appears once in the eligible population; repeated contacts affect frequency, not reach.
| Territory | Eligible accounts | Accounts reached | Completed contacts | Reach | Contacts per reached account |
|---|---|---|---|---|---|
| East | 80 | 64 | 128 | 80.0% | 2.00 |
| Central | 60 | 42 | 84 | 70.0% | 2.00 |
| West | 60 | 54 | 162 | 90.0% | 3.00 |
| Total | 200 | 160 | 374 | 80.0% | 2.34 |
Reach is reached accounts divided by eligible accounts. Frequency is completed contacts divided by reached accounts. Company frequency is 374 / 160 = 2.34 after rounding; it is not the simple average of the territory frequencies. The reach and frequency guide explains the detailed activity rules.
West has the highest reach and frequency but the lowest sales attainment. That observation supports an investigation into product availability, customer demand, adjustments or account mix. It does not support ordering more contacts before understanding the gap. Central's lower reach supports checking the unreached target list with its district manager.
The same net sales register can be grouped by product. This is another view of the existing dollars, so the product total must match the territory total.
| Product | Net sales (USD) | Share of company net sales |
|---|---|---|
| Product A | 900,000 | 50.0% |
| Product B | 600,000 | 33.3% |
| Product C | 300,000 | 16.7% |
| Total | 1,800,000 | 100.0% |
Each share is product net sales divided by $1,800,000, rounded to one decimal place. Do not add this table's revenue to the territory table. To explain West's shortfall, inspect its product rows using the same classification and compare them with its product targets. A company product share alone cannot explain a territory result.
Finance owns net sales and adjustment reconciliation. Commercial operations owns eligibility, account mappings and the reporting cutoff. District managers own follow-up on coverage gaps. The commercial leader decides whether the evidence warrants a territory or product priority change.
Keep the dashboard compact: sales versus target first, coverage exceptions second, product mix third. Show the source dates beside those views. The pharma analytics guide describes the broader business-file context; the reporting meeting should stay focused on the exceptions the current exports can establish.
Bring a sample of your own aggregate sales, targets and organizational account activity in a business file; Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your own export.
See Covirage for pharmaceutical businesses for the supporting industry context.
Include net sales against target, the adjustments from gross sales, coverage of eligible target accounts, contact frequency and revenue by product. Keep the reporting period, account definition and data cutoff visible. Start with measures that have a named owner and a decision attached.
Review account activity within the selling cycle and review finalized sales with finance after the period closes. Mark provisional figures clearly. A dashboard refreshed from an activity export can still contain sales adjustments that have not yet been finalized.
They can be compared when the territory, product, account population and dates match. Coverage describes recorded commercial activity, while sales describe a financial outcome. Seeing both rise together does not establish that the activity caused the sales increase.
No. The commercial view described here uses aggregate business sales, organizational account targets and activity counts. Those files support territory and product decisions without patient records. Clinical outcomes, safety surveillance and individual treatment decisions are outside this dashboard's scope.