Pipeline Hygiene — AI workflow for Malaysian SMEs
Pipeline Hygiene turns CRM export into duplicate/missing/stale record report. AI writes the first draft. You check it before it goes out.
Ready-to-use prompts for Pipeline Hygiene
Create prompt
Create prompt
Create a first-pass deliverable
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
Create duplicate/missing/stale record report. You will get CRM export from me. Treat this as pipeline hygiene for SMEs with many leads, inconsistent follow-up, or weak pipeline visibility. Keep every section short and concrete. End with the one action to take next. Give me a clean copy-paste version too.
Replace “CRM export” with your real data.
Analyse prompt
Analyse prompt
Analyse the input and identify the highest-impact insights
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
Analyse my pipeline hygiene data. I will give you CRM export. Pull out the five findings that matter most. Rank or quantify them where the data allows. Explain what each one means for the business. Then produce duplicate/missing/stale record report. Finish with the top three moves to lift data quality score.
Replace “CRM export” with your real data.
Optimise prompt
Optimise prompt
Improve an existing version for better business results
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
Task: optimise pipeline hygiene. You will see CRM export together with the current version. Be blunt about what is not working. Return a stronger duplicate/missing/stale record report. Structure the changes as: issue found, recommended change, expected effect on data quality score.
Replace “CRM export” with your real data.
Automate prompt
Automate prompt
Turn the task into a repeatable AI-assisted workflow
Setup · same in all four
You are helping a small or medium Malaysian business in [industry]. Write in plain English. Use short sentences. If customers will read it in Bahasa Malaysia, add a natural BM version. Do not invent numbers, prices, laws or customer details. If something needs a human to check, say so.
Replace [industry] with yours — “F&B”, “construction”, “retail”.
The task
The task: automate pipeline hygiene. The workflow fires on CRM export and must produce duplicate/missing/stale record report. We use CRM, email, calendar, WhatsApp Business. Specify trigger conditions, required fields, the AI's exact job, decision rules, approval gates, fallback handling, data retention and how data quality score gets tracked. Simple beats clever here.
Replace “CRM export” and the listed systems with what you actually run.
New here? How the four prompts work together
They are one sequence, not four options. Run them in order on the same piece of work, feeding each answer into the next.
Create
Paste your real data. You get a first draft. Most people never need to go further than this.
Analyse
Paste that draft back in. It tells you what is weak, missing or wrong before a customer sees it.
Optimise
Paste the draft again with what Analyse found. You get a stronger version.
Automate
Only once the output has been good five times running. This is the one people reach for too early.
Nothing forces you through all four. A good Create draft that you edit yourself is a finished job. The longer version.
Specification
- You give it
- CRM export
- You get back
- Duplicate/missing/stale record report
- Moves
- Data quality score
- Run it
- Daily
- Priority
- P0
- Works with
- CRM, email, calendar, WhatsApp Business
- Tool guides
- WhatsApp Business
Is this for you?
- Pick it for
- SMEs with many leads, inconsistent follow-up, or weak pipeline visibility. No setup needed. If you can copy and paste, you can run it.
- What you get
- Drafted in minutes, not built from scratch. It aims at growth. Watch one number: data quality score.
- Reach for it when
- Most SMEs run it daily. If you are doing it by hand more often, automate it first.
How to run it
- 01Collect the input: CRM export.
- 02Copy the Create prompt and paste it into ChatGPT, Claude or Gemini.
- 03Replace “CRM export” in the prompt with your real data, then run it.
- 04Read the output against what you already know and correct anything the model guessed at.
- 05Track data quality score. Only wire up the Automate prompt after five useful runs in a row.
The tools you will need
The prompts run in any chat assistant — ChatGPT, Claude or Gemini. These are what you need around them to get the input in and the output somewhere useful.
- calendar
- WhatsApp Business
Check the rules yourself
This workflow touches rules set by someone else. Check the current requirements yourself before you act on the output.
- JPDP
- Pasting customer or staff records into an AI tool is a transfer of personal data. Consent, notice, retention and cross-border rules still apply when the tool is not yours.
Links go to each authority’s own site. See all Malaysian authorities.
Data & privacy
This workflow involves customer names, contact details and deal history. Under the PDPA your business stays responsible for it, and pasting it into an AI tool may be a disclosure to a third party. Replace names and numbers with initials or references first — the prompt works just as well on “Customer A”.
Using customer data with AI tools in Malaysia covers what to check with any provider before you paste.
For this website, it works differently.
Nothing you type here is sent to us or to an AI model. The prompts are static content, and the copy button works directly inside your browser.
Related workflows
- Account ExpansionTurns customer purchases and usage into upsell/cross-sell opportunities.
- CRM Note SummarisationTurns call notes and emails into clean CRM summary.
- Deal Risk DetectionTurns pipeline records into at-risk deal list.
- Deal Stage ValidationTurns deal activity history into recommended stage corrections.
All crm & pipeline management workflows: CRM & Pipeline Management
Maintained by Naven Pillai