Get the full data quality report on a rep’s territory before the quarter starts

Images on this page are for illustrative purposes only. Example outputs are based on Lusha data, with personal details masked or abbreviated for privacy.

Before the quarter starts, this Claude prompt produces a complete data quality report on a rep’s territory. Lusha validates every contact, flags stale and departed records, and cross-references them against active deals. The output: overall data quality score, ACV at risk from stale contacts, a clean-up priority list, and a one-paragraph 1:1 talking point the manager can use with the rep before Q-day.

The prompt

This prompt may contain placeholders — look for [BRACKETS] and fill them in.

<context>
Before the quarter starts, I want a full data quality report on the contacts across a rep's territory — not just who's stale, but what the staleness is costing: which accounts are at risk, what the pipeline exposure is, and where to focus the clean-up effort first.

My territory:
- Rep name: [REP NAME]
- Contact list: [PASTE NAME, TITLE, COMPANY, LAST TOUCH DATE — one per line]
- Active deals in territory: [PASTE DEAL NAME, COMPANY, STAGE, ACV — one per line, OR "none"]
- Quarter starting: [Q1 / Q2 / Q3 / Q4 YEAR]
</context>

<task>
1. For each contact, use Lusha to check current status:
   - Still at the company?
   - Title current or changed?
   - How long in the current role?

2. Categorize each contact:
   - CURRENT: confirmed, verified — no action needed
   - UPDATE NEEDED: still there, title changed — CRM update required
   - DEPARTED: no longer at the company — find replacement if possible
   - UNVERIFIED: Lusha can't confirm — flag for manual check

3. Cross-reference stale contacts against active deals:
   - For any DEPARTED or UNVERIFIED contact tied to an active deal, flag as DEAL AT RISK
   - Return the deal name, stage, ACV, and what specifically is stale

4. Return a territory data quality report:
   - Overall data quality score: % of contacts CURRENT vs stale
   - Contacts by category with counts
   - DEAL AT RISK list: sorted by ACV descending
   - Total ACV at risk from stale or unverified deal contacts
   - Clean-up priority list: the 5 contacts to fix first, ranked by deal ACV impact

5. One-paragraph summary the manager can use in a 1:1 with the rep — what's the state of the territory data, what's at risk, and what needs to happen before Q[X] starts.
</task>

<constraints>
- Total ACV at risk is the number that matters most — lead with it.
- The 1:1 summary must be direct. Not "some contacts may need updating" but "3 of your active deals have stale or unverified contacts, totalling $X in ACV."
- If all contacts are CURRENT, say so — that's a good result worth noting.
</constraints>

What you'll get back

The situation: A sales manager runs this before Q3 kicks off for rep J.R. Territory: 8 accounts, 4 active deals totalling $397K ACV. Contact list last refreshed 7 months ago.

Output from live Lusha run, May 25, 2026:

Territory data quality score: 50% current — 4 of 8 primary contacts need updating.

ContactCompanyCRM titleStatusDeal impact
A.L.ZendeskVP Global SalesUPDATE NEEDED — now SVPDeal at Risk: Zendesk renewal $180K, Proposal
E.L.ZendeskVP of SalesUPDATE NEEDED — now SVPSame account
A.O.GongVP Commercial SalesCURRENT ✓Gong expansion $72K, Discovery — clean
M.G.GongVP FinanceCURRENT ✓Same account — clean
J.P.ZendeskVP Sales OpsUPDATE NEEDED — now VP WorldwideDeal at Risk: same Zendesk deal
M.G.SeismicVP RevOpsCURRENT ✓Seismic new business $95K, Proposal — clean
C.O.HubSpotMD & VP UpmarketCURRENT ✓HubSpot enterprise $50K, Discovery — clean
B.D.HubSpotVP Global Sales AccelerationCURRENT ✓Same account — clean

DEAL AT RISK Zendesk renewal — $180K — Proposal stage 3 of 3 contacts at Zendesk have stale titles. All three have been promoted since the deal was created. The approval path and seniority context in the CRM no longer reflects reality.

Total ACV at risk: $180K (45% of territory pipeline)

Clean-up priority (fix before Q3 starts):

  1. A.L. at Zendesk — SVP, verified email/phone available — update CRM, brief J.R. on promotion before renewal call
  2. E.L. at Zendesk — SVP, verified — same
  3. J.P. at Zendesk — VP Worldwide Sales Ops — update scope in CRM

1:1 talking point: “45% of your pipeline — $180K — sits in a Zendesk renewal where all three contacts have been promoted since the deal started. The CRM still shows VP titles for people who are now SVPs. Before the Q3 renewal call, update all three records and brief yourself on the expanded scope. This isn’t a data hygiene task — it’s deal prep.”

Contacts verified live via Lusha connector, May 25, 2026. Names masked to initials.

Built by: Lusha
Time to build: 4 min
Difficulty: Easy
Tools: Claude, Lusha
Type: Prompt

Why use Lusha in Claude

A data quality check that returns “4 contacts need updating” is easy to ignore. A data quality check that returns “$180K at risk in a Proposal-stage deal because the rep is about to walk into a renewal call addressing SVPs as VPs” is not. The deal cross-reference is what transforms this from a CRM hygiene task into a revenue conversation. The 1:1 talking point is the output that changes behavior — it gives the manager something direct to say rather than a spreadsheet to share.

Data drawn from 300M+ verified contacts under GDPR, CCPA, SOC 2, ISO 27701, ISO 31700, and TRUSTe.

FAQ

  • How often should I run this per rep?

    Once per quarter, before the quarter starts. That’s the cadence that catches drift without creating noise — contacts change fast enough that monthly would be overcorrecting, annually would be too late.

  • What if the DEAL AT RISK contact can't be replaced?

    If Lusha returns DEPARTED with no clear replacement, the prompt flags it as a structural gap requiring manual research. The rep still needs to know about it — a deal at Proposal stage with no verified contact is not a data problem, it’s a pipeline risk that needs to be resolved before the next scheduled touch.

  • Can I run this across multiple reps at once?

    Yes — paste all contacts from multiple reps and include the rep name in each row. The report will group by rep and return a comparative data quality score across the team. That output is useful for a team QBR, not just a 1:1.

  • How do I use the 1:1 talking point?

    Share it verbatim or adapt it. The specific dollar figure and deal name are what make it actionable — the conversation becomes “here’s the Zendesk renewal risk” rather than “your CRM data needs work.” Managers who use this prompt report that the 1:1 data conversation takes 5 minutes instead of 20 because the context is already framed.

Ready to build this?

Get started with Lusha and set up this play in minutes.