Weekly Customer Health Check in Zendesk

For a CS lead who wants an early warning system. One prompt pulls ticket spikes, CSAT drops, and renewal risk signals across the top 20 accounts and posts a ranked digest to your customer success channel.

ZEZendeskSASalesforce

Slack

The grind

Churn signals show up late

Here's what doing this by hand looks like today, and why it doesn't scale.

By the time a CSM notices ticket volume has doubled, the business review has already happened and the renewal conversation is two weeks out.
Zendesk data sits apart from the Salesforce renewal dates.
CSAT scores can slide for weeks without anyone noticing.
Every CSM keeps their own at risk spreadsheet.

MewCP collapses all of this into one prompt. Here's what that looks like.

The flow

5 steps · 3 servers

Your agent runs it end-to-end

List the top 20 accounts by revenue from Salesforce.

Pull ticket volume and CSAT per account week over week.

Flag any account with a ticket spike over 100 percent or a CSAT drop of more than one point.

Check the renewal date and flag anything due within 60 days.

Post a ranked digest to your customer success channel with recommended CSM actions.

The payoff

At risk accounts surface in time

The team sees churn signals two weeks before renewal instead of two weeks after. CSM actions get prioritized on data rather than on who is loudest in the general channel.

Paste this into Claude, Codex, or any MCP-connected agent. It'll connect your apps and run the task from start to finish.

Run it yourself

Copy the prompt

prompt

Goal: Weekly Customer Health Check in Zendesk

MCP servers needed (connected through MewCP): Zendesk, Salesforce, Slack

Steps:
1. List the top 20 accounts by revenue from Salesforce.
2. Pull ticket volume and CSAT per account week over week.
3. Flag any account with a ticket spike over 100 percent or a CSAT drop of more than one point.
4. Check the renewal date and flag anything due within 60 days.
5. Post a ranked digest to your customer success channel with recommended CSM actions.

Check with me before sending any message or changing data in a connected app.

More recipes

ZEHU