Construct a KPI tree for [CampaignName] ([Timeframe]) that connects media activity for [TargetAudience] to the [NorthStarMetric] under the agreed [FunnelDefinition]. Define input metrics (e.g., Tier-1 placements, authority-weighted reach), quality screens (message pull-through, sentiment), mid-funnel effects (branded search, site engagement), and commercial outputs (MQL/SQL, influenced revenue). For each node, specify formula, owner, and target/thresholds; show how variance at each node compounds to ROI. Include collaboration points with [PRAgency].
Output requirements: (1) A hierarchical KPI table (Node, Definition, Formula, Owner, Target, Alert Rule). (2) A sensitivity worksheet specification showing which two nodes most influence ROI. (3) A one-page target rationale referencing historical baselines and aspirational stretch.