Executive ROI Dashboard Blueprint for Earned Media

Executive ROI Dashboard Blueprint for Earned Media

N.B. Attach field-level mapping documents and any API limit dashboards. If sandbox endpoints exist, include links for validation runs.

📄 Prompt Template

Design an executive-ready blueprint for an earned media ROI dashboard for [CompanyName] covering [Timeframe]. Prioritize alignment to [BusinessObjectives] and define a concise metric hierarchy that connects media coverage to commercial impact. Specify the minimum viable dataset (monitoring feeds, web analytics, CRM) and the attribution logic using a [AttributionWindowDays]-day window. Include a clear definition and formula for each of the [PrimaryMetrics] (e.g., Quality-Adjusted Mentions, Reach-Weighted Sentiment, EMV with caveats, Pipeline Influenced, Payback Period). Detail governance: update cadence, data QA checks, and escalation rules for the [ExecutiveAudience].
Output requirements: (1) A dashboard spec table with columns: Module, Decision Question, Metrics, Data Source, Refresh, Owner. (2) A metric glossary with formulas and edge cases. (3) A one-page narrative (≤200 words) explaining how the dashboard informs quarterly investment decisions and risk flags. (4) A success KPI set with baselines and targets for the next two cycles.

⚙️ Customize Your Prompt

Scroll to Top