Access Your Free Tool

Enter your name and email to unlock this tool from Reputation Intelligence by Dr. Evan Escobedo.

No spam. Unsubscribe anytime.

📈 MRS Roll-up Calculator

Aggregate article scores into pillar MRS, overall MRS, and competitive benchmarks

Brand Intelligence. Delivered.
Instructions
MRS Calculator
Monthly Trend
Competitive

Purpose

Tool 5 scores individual articles. This tool aggregates those scores into the numbers that actually go to Henrik — pillar-level MRS scores, a weighted overall MRS, month-over-month trends, and competitive benchmarks. This is the executive-facing output layer of your measurement program.

The Key Insight: The overall MRS is a single number Henrik can track month to month. Pillar scores tell you where reputation is moving and why. The competitive delta tells you whether you're winning or losing the narrative battle. These three numbers — overall MRS, pillar breakdown, competitive delta — are the core of every SIGNAL Brief.

How It Works

Step 1: Set Up Your Pillars

In the MRS Calculator tab, define your 3–5 reputation pillars (from your PBI work) and assign each a weight. Weights must total 100%. The weights reflect how much each pillar matters to Henrik's specific business priorities.

Step 2: Enter Monthly Pillar Scores

Each month, calculate the average article score for each pillar from your Tool 5 article log. Enter those averages here. The calculator produces your weighted overall MRS automatically.

Step 3: Track Trends

Use the Monthly Trend tab to build a running history. Enter each month's pillar scores and watch the trend emerge. This is the chart you'll use in QBR presentations — "Trust has been declining for three months, here's why, and here's what we're doing."

Step 4: Add Competitive Scores

Use the Competitive tab to track competitors' MRS by pillar. This powers the Gap Analysis section of your SIGNAL Brief. When Trust is declining for you and rising for Competitor A, that's the story that gets executive attention.

Interpreting Your MRS

  • 70–100: Strong — positive narrative momentum, proactive opportunity
  • 50–69: Moderate — adequate but vulnerable, monitor closely
  • 30–49: Weak — narrative gaps, reactive risk, needs investment
  • Below 30: Critical — active reputational headwinds, escalate