for Pharma
Toggle menu
Answers · Pharma operations

Our launch is three months away and the data platform is behind. What do we prioritize?

DataKitchen recommends building only the weekly reports the field and leadership read in launch week: launch and forecast tracking, field activity and performance, incentive comp, and specialty pharmacy dispense for a specialty brand. Put two reconciliation checks on every feed behind them. Defer lift, ROI, patient-level, and planning reports. DataKitchen's plan has field reporting live six months before launch.

Chris Bergh Published

Key points

  • DataKitchen's launch plan puts field reporting live six months before launch day, so a team three months out has half that window to make the numbers trusted.
  • Nine of the 24 reports in DataKitchen's commercial launch inventory run weekly: launch tracking, forecast tracking, claims, non-personal promotion, field activity, field performance, pre-call planning, incentive compensation, and stocking.
  • Promotional ROI, DTC lift, source-of-business patient views, and brand planning support run monthly or annually in DataKitchen's launch inventory, which is why DataKitchen recommends building them after launch day on a late platform.
  • Every feed behind a launch-week report needs two checks: extract-to-load reconciliation against the vendor's control record, and a diff of overlapping periods against the last delivery you kept.
  • Celgene's Otezla launch team shipped production dashboards at 70 percent done and hardened them in later sprints, which is the trade a late platform has to make on purpose.

Field reporting was supposed to go live six months before launch day. That is the milestone in DataKitchen’s launch timeline, and it exists so reps can find the bad numbers while a bad number is still cheap. You are at three months. Half that window is gone.

So stop planning the whole platform. Plan launch week.

A year out, the 12-month launch checklist orders the work as feeds, systems, stars, then reports. At T-3, run it backward. Start from the reports someone opens on launch Monday, and build only what they read.

Sort the 24 reports by who opens them in week one

The launch page lists 24 reports a commercial launch analytics team owns, with cadence and audience for each. Cadence is the sorting key. A weekly report read by the field is a launch-day dependency. A monthly ROI report is not.

PriorityReports (cadence from the launch inventory)Why
Launch week, must be rightLaunch tracking, forecast tracking, field activity, field performance, incentive compensation (all weekly)Leadership and every rep read these first, and comp pays out on them
Launch week, can be roughPre-call planning, claims reporting, stocking (weekly); target list development, plan of action and sales meetings, sales force logistics (periodic)Reps need them before the first call; a scrappy version will do
Launch week if it appliesSpecialty pharmacy dispense and status; REMS reportingA specialty or limited-distribution brand lives here; a REMS program sets its own cadence
After launchBrand team report, promotional mix and ROI, DTC, non-personal promotion lift, payer and plan, source of businessMonthly, except non-personal promotion (weekly); lift and adherence need post-launch history to measure
After launchBrand planning support (annual), forecast creation (quarterly), demand-based P&L, finance reporting (monthly)Slow cadence; schedule them, don’t build them now

The cadences come from the launch inventory. The launch-week and after-launch split is DataKitchen’s recommendation, not a record of a specific launch. Move finance reporting up if your finance team closes on it in launch month.

The drug launch case study is a useful check on the top row. When that team’s field reporting went live six months early, the reports it names as ready are claims, Rx, payer plan, incentive compensation, and marketing automation. Field and money, before planning.

Test the feeds behind the top row, and only those, first

A report is ready when its inputs pass, not when it renders. Every feed behind a launch-week report gets the two reconciliation checks: extract to load against the vendor’s control record, and a diff of overlapping periods against the delivery you kept. The post on the commercial data most likely to be wrong walks through both, and the feed-by-feed test list adds the check each feed type needs.

Incentive compensation needs more than that before its first run. A duplicated prescriber splits credit, and a realignment moves a rep’s numbers with every value valid. Run the relationship tests in testing territory alignment and incentive comp data before the first payout, not after the first dispute.

If you’re a specialty brand, the specialty pharmacy feeds are the ones the access team watches, and their integration is almost always somebody’s afterthought. Settle the event date and the calendar first, as in why specialty pharmacy, 867, and sales numbers don’t match. Reconcile later.

Ship rough, on tested data

Celgene’s Otezla team built a scrappy star first and shipped production dashboards at 70 percent done, then hardened them over later sprints. That’s the trade you are making now, and it’s a good one if you make it on purpose. A dashboard with an ugly layout is recoverable. A territory number that’s wrong in launch week isn’t, because the first 6 to 12 months set a drug’s lifetime revenue trajectory and you get one chance at the field’s trust.

Things to cut without guilt: the AI context layer, the second visualization pass, and every report in the bottom two rows of the table.

Don’t staff your way out

The instinct at T-3 is to add ten people. The case study points the other way. One engineer carried the pre-launch work for 1¾ years, and a second joined nine months out. It also notes that communication channels grow as (N² minus N)/2 with team size. Two people share one channel. Twelve share 66.

Add one or two people who already know IQVIA, specialty pharmacy, and Veeva feeds, then protect them from every report whose first reader is a quarterly business review.

Follow-up questions

Frequently asked questions

Is three months enough to get launch reporting ready?

Enough for the reports the field reads in launch week, not for all 24. DataKitchen plans field reporting live six months before launch day so reps can learn to trust the numbers. At three months you have half that window, so DataKitchen recommends cutting scope to the weekly field and leadership reports, testing every feed they read, and scheduling the monthly and annual reports for after launch.

Which launch reports can wait until after launch day?

DataKitchen recommends deferring the ones that need post-launch history or run on a slow cadence. In DataKitchen's launch inventory, promotional mix and ROI, DTC lift, source-of-business patient views, demand-based P&L, and brand planning support run monthly or annually. Lift and adherence views have little to measure before patients start therapy, so they lose little by following launch day.

Should we add more data engineers three months before launch?

Add few, and add people who already know the feeds. In one published launch case study, one engineer carried the pre-launch work for 1¾ years and a second joined nine months before launch. The same case study notes that communication channels grow as (N² minus N)/2 with team size, so a large late hire adds coordination faster than output.

What should we test first on a late launch platform?

The feeds behind the launch-week reports, with two checks each. Extract-to-load reconciliation counts rows and sums amounts against the vendor's control record, so a partial file stops in staging. A diff of overlapping periods against your last kept delivery catches a silent restatement. Then add the relationship tests incentive compensation needs before its first run.

Is it acceptable to launch with dashboards that are not finished?

Yes, if the numbers under them are tested. Celgene's Otezla launch team shipped production dashboards at 70 percent done and hardened them over later sprints, because feedback from real users beat waiting for a complete dashboard. An unfinished layout is recoverable. A wrong territory number in launch week costs you the field's trust.

Talk to the team that tests this data every week.

Half an hour on your stack, your launch window, and what the first sprint would look like.