PR Measurement: Coverage Tracking, Share of Voice, Message Pull-Through, Reach & Outcome Metrics
Measure PR the way it works: a coverage log, tiered reach, share of voice, message pull-through and the visits and sign-ups that follow, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you measure one fictional product launch's PR in eight interactive spreadsheet labs. You count coverage by month, tier and tone with COUNTIFS and EDATE, turn audiences into estimated gross and unique reach with XLOOKUP, and compare raw and tier-weighted share of voice with SUMPRODUCT. You code key messages and calculate pull-through per message and outlet, rate press releases and spokespeople, and measure visits and sign-ups in a window after coverage against a baseline. You see why ad-equivalent value misleads, build a weighted quality score and finish with a half-year dashboard and trend chart. Every cell is checked instantly.
Lessons
- The Coverage Log: Items by Month, Outlet Tier & Tone Pro
- Reach: Audience × Read-Through, Gross Reach & Estimated Unique Reach Pro
- Share of Voice: Raw Mentions, Tier Weights & Tier 1 Share Pro
- Message Pull-Through: Key Messages per Item, per Message & per Outlet Pro
- Releases & Spokespeople: Pickup Rates, Tier 1 Share & Quotes per Interview Pro
- Outcomes: Visits & Sign-ups in a Window After Coverage, Baseline & Cost per Outcome Pro
- Comparing Measures: Why Ad-Equivalent Value Misleads & a Composite Quality Score Pro
- The Monthly PR Dashboard: Rolled-Up KPIs, Targets in Points & a Share-of-Voice Trend Pro