Content Analytics Dashboard

Editorial Calendar & Production ROI Analytics — Bloom Health Tech

Last updated: 13 weeks ending Dec 23, 2024 • 6 FTE + 3 contractors

North-Star Goal

$580 / hour

Target pipeline per editorial hour

Pipeline / Hour

$498

+18% vs Q3

Publish Velocity

5.8

assets/week (plan: 6.0)

Backlog Aging

11d

+3d vs target

Slot Efficiency

1.08

+0.08 index

Rework Rate

14%

+2% vs Q3

Forecast Variance

−6%

vs Q4 plan

Velocity Miss: 3 Consecutive Weeks

Weeks 10–12 published 4.7, 5.0, 5.2 assets/week. Legal review bottleneck in Compliance theme. Backlog cleared Week 8.

Publish Velocity — 13 Weeks

Theme Slot Efficiency Score

Editorial Calendar — Q4 Plan vs. Actual

Theme

W40

W41

W42

W43

W44

W45

W46

W47

W48

W49

W50

W51

W52

Compliance

Product Guides

Case Studies

Lifestyle (cut Q1)

Planned

Published

Writer & Team ROI Ranking — Last 90 Days

Writer	Type	Assets	Production Cost	Influenced Pipeline	ROI	Efficiency
Sarah Chen	FTE	18	$22,500	$98,400	4.4×	High
Marcus Williams	FTE	14	$22,500	$72,100	3.2×	High
Jennifer Patel	Contractor	11	$16,500	$51,200	3.1×	High
David Kim	FTE	16	$22,500	$47,200	2.1×	Medium
Rachel Foster	FTE	12	$22,500	$38,900	1.7×	Medium
Alex Rodriguez	Contractor	9	$13,500	$22,700	1.7×	Medium
Emma Thompson	FTE	10	$22,500	$19,400	0.9×	Low
Chris Martinez	Contractor	7	$10,500	$4,200	0.4×	Low

Cost vs. Pipeline Attribution

Backlog Health Gauge

Target: ≤8 days median age

Key Insights & Actions

Compliance theme ROI 2.1×: Prioritize for Q1 — Sarah Chen leading production.
Lifestyle tangents ROI 0.4×: Cut from Q1 calendar; reallocate contractor budget to Product Guides.
Backlog spike Week 5: Legal review bottleneck added 7 days to draft cycle. Cleared by Week 8 with new review SLA.
Velocity recovery: Weeks 10–12 missed target (4.7–5.2 assets/week). Week 13 published 6.1 assets — back on plan.
Forecast variance −6%: Q4 pipeline tracking 6% below plan. Increase cadence to 6.5 assets/week in Q1 to recover.