← Selected work
CASE 03 / NORTH STAR
ACCOUNT PRIORITIZATION · EXCEL

Which account needs
a closer look?

I used Excel to turn a fictional 60-account portfolio into a five-account leadership review. The useful part is what happens next: check the evidence, identify what is missing, and choose the right follow-up for each customer.

Try the account walkthrough ↓Download the Excel workbook
The questionWho needs leadership review, and who needs urgent follow-up?
What the evidence showsThe same High-risk label covers different situations—including improving adoption
Recommended next stepAssign case follow-up for Cedar and Silver; check Aspen’s risk label before deciding on an intervention
CONNECTION TO MY EXPERIENCE

Customer retention at AT&T informs my interest in why an account might leave. Export operations required prioritizing shipment changes and documentation deadlines. Here I apply that review discipline to fictional account data: use the numbers to choose where to look, then identify the customer question they cannot answer.

ONE-MINUTE WALKTHROUGH · FICTIONAL DATA

Choose an account. Follow the decision.

Five accounts share a High-risk label. Select one to see the evidence, the missing context, and the follow-up I would recommend.

Same five accounts · $2.358M ARR in either order. Neither ordering establishes operational urgency.

Annual recurring revenue
$628K
Nov–Dec adoption change
−2.1 pts
Open or escalated cases
4
01 · QUESTION TO ASK

Which unresolved case is preventing the customer from completing their work?

02 · RECOMMENDED FOLLOW-UP

Ask the account owner to confirm the primary blocker, assign a responsible person, and agree on a due date. Check the overdue action before creating another follow-up.

03 · WHAT COULD CHANGE THE DECISION

Declining adoption and four unresolved cases justify investigation. They do not establish the cause or prove that Cedar intends to cancel.

Trace these numbers in Excel

Open Executive Overview, row 19 in the workbook. ARR is in column C, adoption change in F, and open or escalated cases in H. Filter Accounts, Monthly Metrics, and Support Cases by ACC-044 to inspect the supporting records. Adoption change is December minus November, in percentage points. Count Support Cases with status Open or Escalated; the separate Accounts “Open Cases” field is not the source for this measure.

Interactive explanation of the workbook’s saved snapshot. Recommendations are proposed next steps; no outreach or case resolution has been performed.

Why changing the sort changes the conversationCompare revenue and unresolved cases within the same shortlist
TEST THE PRIORITY RULE

Changing the rule changes who gets discussed first.

I compared two orderings within the same five-account shortlist. Keeping the population fixed makes the trade-off visible; this does not reselect five accounts from all 22.

Revenue first

Cedar → Silver → Aspen → Bright → Atlas.

Sort ARR descending. This reserves leadership review time for the largest commercial relationships, but puts Aspen third despite no open or escalated cases.

Unresolved case count first

Silver → Cedar → Atlas → Bright → Aspen.

Sort open or escalated cases descending: 5, 4, 2, 1, 0. This brings active follow-up forward, but case volume cannot establish severity.

Worked comparison: Aspen moves from third to fifth; Atlas moves from fifth to third. The five-account ARR remains $2.358M because only the order changes.

Operational priority rule: first verify severity, customer impact, a hard deadline, and any blocked downstream work. A smaller account with a confirmed critical issue can take priority over Cedar. If those inputs are unknown, obtain them before ranking urgency; do not substitute ARR or case count.

Decision: retain the revenue-first shortlist for the leadership brief, then review Cedar and Silver’s case-level blockers before setting operational priority. A severity-first or renewal-first queue needs validated case severity, business impact, and renewal dates; this summary does not supply those inputs.

LEADERSHIP ATTENTION QUEUE

Start with the 22 accounts assigned a High-risk label in the source, sort by annual recurring revenue (ARR), and take the largest five. This is a revenue-focused selection rule, not a ranking of churn probability or urgency.

Swipe horizontally to view all columns.

ACCOUNTARRADOPTION ΔOPEN / ESC.REVIEW
Cedar Industries$628K−2.1 pts4Act now
Silver Industries$586K−3.5 pts5Act now
Aspen Industries$437K+4.6 pts0Validate
Bright Systems$396K−3.9 pts1Review
Atlas Health$311K−2.4 pts2Review
VERIFIED FIVE-ACCOUNT SUBSET$2.358M

Modeled snapshot: December 31, 2025. Adoption Δ compares November with December 2025, shown in percentage points. “Open / Esc.” counts cases whose current status is Open or Escalated. The supplied fictional risk score creates the review group; it does not predict churn or lost revenue.

My review recommendations: These labels are judgment calls for this snapshot, not an automated scoring rule. Case severity, renewal timing, or a new customer issue could move a smaller account ahead of this queue.

FROM A NUMBER TO A NEXT STEP

Cedar and Aspen need different conversations.

Cedar: assign follow-up

Adoption fell 2.1 percentage points and four cases remain open or escalated. I would ask the account owner which case is blocking the customer and agree on a next action and due date. “Act now” means start that review, not assume a cancellation is coming.

Aspen: check the label

Adoption rose 4.6 points and there are no open or escalated cases, yet the supplied label is High risk. I would check the reason and date behind that label before recommending an intervention. Those two positive signals alone do not prove the account is healthy.

Silver also combines falling adoption with several unresolved cases. Bright and Atlas remain in review; their smaller case counts do not establish lower severity. The brief starts a conversation—it does not replace that missing case-level judgment.

How the totals reconcileFive-account queue versus the full modeled review group
HOW THE TOTAL RECONCILES

$628K + $586K + $437K + $396K + $311K = $2.358M

WHY OTHER WORKBOOK TOTALS ARE LARGER

The workbook’s $4.149M figure covers all 22 accounts in the modeled High-risk group. The queue above intentionally narrows that population to five accounts for leadership review.

Positive signals should not erase unresolved friction. Check what is blocking the customer before treating improved adoption as reassurance.

Inspect the Excel workbookActual leadership brief, source tables, and review questions
INSIDE THE WORKBOOK

The leadership brief in Excel.

The opening sheet brings the verified totals, five-account queue, review questions, unknowns, and source records into one review page.

North Star Excel leadership brief showing verified risk totals, an account attention queue, and source records
Actual workbook view. Cedar Industries carries through from the leadership queue into the verified account brief and source notes below it. Select the image to inspect it at full size.
How I built and checked itData structure, formulas, measures, and reconciliation
HOW I BUILT THE REVIEW

Every summary number can be checked.

North Star is a working 12-sheet Excel file, not a set of screenshots. I kept the source data, definitions, calculations, and leadership summary separate so each final number can be checked.

DATA

60 accounts linked by Account ID to 720 monthly metric rows, 738 interactions, 470 support cases, and 120 actions.

EXCEL

COUNTIF and SUMIF calculate the modeled high-risk count, ARR in that review group, escalated cases, and overdue actions.

MEASURES

The KPI dictionary documents suggested DAX for ARR, weighted forecast, adoption, case status, action completion, and evidence coverage.

CHECK

The five-account queue totals $2.358M; the full 22-account modeled High-risk group totals $4.149M.

Self-directed analysis using fictional B2B SaaS data. The queue contains the five highest-ARR accounts in the modeled High-risk group; the figures demonstrate the method, not client results.