Budget Presentation

Minnesota Star Tribune

Star Tribune Media Company, LLC

Executive summary

MST Studios — Scope by Phase

Milestone-level view matching the Asana board. Remaining hours = current estimate.

At a glance

Scope Summary

Committed Scope

652 hrs

MVP + Phase 2

MVP

360 hrs

Target launch Sept 30

Phase 2

292 hrs

November 1

Phase 3

120 hrs

December 1 — TAP transition

All Phases

772 hrs

MVP + Phase 2 + Phase 3

Under Consideration

144 hrs

Sized, excluded from total

Phase 1

MVP — target launch September 30

Everything required to go live.

Milestone / itemStatusRemaining hrs
M8 · Transition & launch activities — prod setup, GAM migration, reporting cutover, trainingIn progress130
MVP launch cutoverIn progress90
M2 · Fulfillment Studio — forms & tasksComplete40
M9 · Performance & scaling of the StudiosIn progress30
M6 · Pre-run change process (interim)In progress20
Rate override — custom pricing by ad typeIn progress16
M3 · Naviga integration — advertiser & line-item write-throughComplete8
M4 · Naviga ↔ GAM integrationComplete8
Overcoming objections — billing validationComplete8
Campaign naming conventionIn progress8
Order Studio product dropdown — alpha-sortedComplete2
Digital inventory calendars (Star Tribune)CompleteTBD
M1 · Digital product catalogComplete
M5 · Day in the life for a new dealComplete
On-site working session, 24–26 AugComplete
Sales automation process reviewComplete
MVP Total360 hrs

Phase 2

Phase 2 — November 1

Committed, sequenced after launch.

Milestone / itemStatusRemaining hrs
Validation, Testing, & Updates8
M10 · Mid-run changes — full Naviga integrationNot started120
M11 · Remaining products + integrations; training buildIn progress64
Phase 2 launchNot started40
Ticket automation — status updates from task actionsIn progress16
Full rate approval processNot started40
ATOL print integration verified against new catalogNot started4
Phase 2 Total292 hrs

Grand total — committed scope (MVP + Phase 2)

652 hrs

Phase 3

Phase 3 — December 1

Sequenced after Phase 2

Milestone / itemStatusRemaining hrs
TAP transition — data prep
Pull full extract of every active TAP digital order (reference/backup dataset)Not started6
Pull TAP line item details for lines needing migration (400+ lines) - Product, Start Date, End Date, Cost, etc.Not started10
Map old TAP/Naviga product names to the new HubSpot product catalog conventionNot started10
TAP transition — data prep subtotal26 hrs
TAP transition — migration test & build
Initial sandbox test - deal importNot started10
Import the deals into HubSpot, tag as Tap migratedNot started14
Import the line items with the external Naviga IDs attached to those dealsNot started16
Confirm whether a TAP order can be deactivated without breaking its GAM campaignNot started8
Build a reference UI to house legacy TAP dataNot started16
Set final TAP go-dark dateNot started6
TAP transition — migration test & build subtotal70 hrs
TAP transition — segmentation, rollout & timing
Finalize and document the segmentation rulesNot started10
Communication & Change ManagementNot started14
TAP transition — segmentation, rollout & timing subtotal24 hrs
Phase 3 Total120 hrs

Backlog

Under consideration — not in committed scope

Excluded from the grand total. One of seven items has been sized.

Milestone / itemStatusRemaining hrs
Naviga ID auto-populate + revenue amount & last billing date — active vs. inactive advertisersIn progress24
Programmatic DSP integration for media-buying automationNot startedTBD
Rates & discounts — tiered structure and maintenance cadenceNot started40
Add digital to ATOL, incl. creative sizes on the production formNot started20
Attach the same creative to several tickets at onceNot started40
Close a campaign task from the ticket cardNot startedTBD
Auto-assign campaign teams to a company and route to queuesNot started20
Sized under consideration144 hrs

Source: Asana project “Star Tribune — 08052025-01 — HubSpot Consolidation.” Hours summed from the subtask-level Hrs field. TBD = in scope, not yet estimated.