Hello, this is Matsubara, CRM Evangelist.

"That client hasn't placed an order recently," I realized—but they had already switched to a competitor.

Many sales representatives in wholesale and trading companies have likely had this experience. When relationships with clients become too commonplace, it becomes difficult to notice signs of change.

Maintaining relationships with existing customers is less costly than acquiring new ones, leading to overall business efficiency. However, many wholesalers and trading companies lack mechanisms to detect when a trading partner's relationship is starting to decline, and by the time they realize it, it's often too late.

This article explains how to use EMOROCO CRM Lite's dashboard and workflow automation features to build an "early alert" system that detects signs of customer churn "before it's too late" and allows you to take proactive measures.

Four structural problems in customer management faced by wholesalers and trading companies.

Problem 1: "Realizing the problem only after orders stop coming in" - a reactive response.

The most serious problem in managing trading partners for wholesalers and trading companies is,Signs of customer churn become visible only after orders reach "zero."It is that.

"We didn't get an order last month, but it'll probably come this month," "Maybe the person in charge has changed and they're busy"—while this kind of vague optimism continues, clients quietly switch to competitors.

There are always stages before a business partner decides to leave. A decrease in order frequency, a change in the person in charge, fewer inquiries, and an increase in price negotiations—these are all signals that they are about to leave. However, without a system to detect these signals, they will go unnoticed.

Problem ② Customer information exists "in the mind of the person in charge".

The inability to share project progress and the risk of losing deals, and the fragmentation of customer information among individual sales representatives, are common problems in the sales departments of wholesale and trading companies.

"Company B's purchasing manager, Mr. Tanaka, finalizes the budget every October," "Company C recently announced a cost-cutting policy, leading to increased price negotiations," "Company D is also frequented by its competitor, trading company X"—this crucial information exists only in the minds of veteran salespeople, and is lost when those individuals are transferred or retire.

When the person in charge changes, clients often feel that "communication has broken down" or "we have to rebuild the relationship from scratch." This is frequently the direct trigger for them to leave the company.

Problem 3: The ranking of business partners is based on "intuition".

Even if companies recognize that "Company A, Company B, and Company C are our important clients," the definition of "importance" is often vague and inconsistent.

Without a ranking system that comprehensively evaluates factors such as annual transaction volume, transaction frequency, profit margin, growth potential, and competitive landscape, the decision of "which clients to prioritize for resource allocation" will rely on intuition. As a result, follow-up with high-priority clients may be neglected, increasing the risk of losing them to competitors without realizing it.

Problem ④ Lack of visibility into the activity levels of each person in charge.

In many cases, managers are unaware of how each employee is approaching clients. "Has there been any activity with that client recently?" "Has follow-up stopped while the employee was on leave?" — When the actual situation can only be seen after monthly reports, problems are discovered late.

What is an "early alert"? Understanding the "three-stage signaling" of withdrawal.

Before systematizing the process using the EMOROCO CRM Lite dashboard, it's crucial to understand the steps that lead to customer churn.

A business partner leaving doesn't happen suddenly. It occurs after a series of three signals have accumulated over time.

Signal ① "Cooling" (3-6 months before withdrawal)

• The frequency of orders has decreased compared to before.
• Inquiries and consultations have decreased.
• The person in charge was late in responding.
• The number of responses "Maybe next time" and "I'll consider it" increased.

Signal ② "Comparison" (1-3 months before withdrawal)

• The topic of competitors has started to come up.
• Price negotiations and condition negotiations have increased.
• The person in charge has changed, and my relationship with the new person in charge is weak.
• Some items have been switched to being ordered from another company.

Signal ③ "Decision" (Just before leaving)

• Orders have almost stopped.
• Inquiries have completely stopped.
• I lost contact with the person in charge.

The ideal timing for intervention is signal ①, "cooling-off period." At this stage, you can rekindle the relationship with the right approach. If you reach signal ③, the chances of recovery decrease significantly.

Overall design of early alerts built with EMOROCO CRM Lite

Step 1: Designing custom fields for customer records

Design the information your wholesale and trading company needs with EMOROCO CRM Lite's no-code custom fields.

【取引先レコードの必須フィールド】

基本情報：
・会社名・住所・業種
・担当購買部門・担当者名・役職・連絡先
・担当営業（自社側）

取引実績：
・取引開始年月
・月次平均発注金額（直近3ヶ月）
・年間取引金額（実績）
・主要取引品目（複数選択式）
・最終発注日（最重要フィールド）
・発注頻度パターン（毎週/月2回/月1回/不定期）

取引先ランク：
・取引先ランク（A:最重要/B:重要/C:通常/D:休眠）
・ランク判定基準（年間取引額・頻度・利益率から設定）
・競合状況（他社が出入りしているか）
・成長性評価（拡大中/横ばい/縮小傾向）

関係管理：
・担当者との関係温度（ホット/ウォーム/クール/コールド）
・直近の変化・動向メモ（担当者交代・方針変更・コスト削減など）
・最終接触日
・次回アクション予定
・離脱リスク判定（低/中/高/緊急）

The two fields, "final order date" and "determination of exit risk," are at the core of the early alert system.This will update the dashboard, automatically highlighting "accounts that require immediate action."

Step 2: Dashboard Design – Create a single screen for your "To-Check This Morning List"

Set the following view on your EMOROCO CRM Lite dashboard. Just check it for 5 minutes each morning, and you'll see at a glance which accounts are your priority this week.

[Early Alert Management Dashboard (Overall)]

【赤アラート】緊急対応リスト（今週中に必ず動く）
条件：「取引先ランクA・B」× 「最終発注日から発注頻度×2倍以上経過」
  または「離脱リスク：緊急」
→ 重要取引先の発注が通常の倍以上止まっている。競合に切り替えられる直前。

【黄アラート】要注意リスト（今月中に動く）
条件：「取引先ランクA・B」× 「最終接触から45日以上経過」
  または「関係温度：クール以下」
→ 重要取引先との接触が途絶えてきている。感情が冷め始めているシグナル。

【青アラート】定期フォローリスト（今月のルーティン）
条件：「次回アクション予定が今週・来週」
→ 予定されているフォローアクションの確認。

【グレーアラート】休眠確認リスト（四半期ごとに確認）
条件：「最終発注日から180日以上経過」
→ 完全休眠の取引先。再起動できる可能性を探る。

[Activity Dashboard by Person in Charge (For Managers)]

担当者ごとの「最終接触から30日以上経過の取引先数」
  → フォローが止まっている担当者を特定

担当者ごとの「今月の発注獲得件数・金額」
  → 先月比での変化を週次で確認

「離脱リスク：高・緊急」の取引先と担当者の紐付け
  → どの担当者がリスクの高い取引先を抱えているか把握

今月の「新規発注が再開した取引先」一覧
  → アーリーアラートへの対応が功を奏したケースの記録

Step 3: Workflow Automation – Create a state where "the system operates before people even notice."

EMOROCO CRM Lite's workflow automation feature automatically generates tasks in response to each signal.

[Workflow for detecting Signal ① "Cooling"]

トリガー：最終発注日から「発注頻度パターン」の1.5倍日数が経過
  → タスク「【要確認】○○社の発注が遅れています」を担当者に自動生成
  → 内容：「先月より発注頻度が下がっています。状況確認の連絡を入れましょう」

トリガー：関係温度フィールドが「クール」に変更されたとき
  → タスク「【関係温度低下】○○社への価値提供型アプローチ実施」を自動生成
  → 内容：「価格交渉ではなく、新製品情報・業界トレンド・課題解決提案で接触する」

[Workflow for Signal ② "Comparison" Detection]

トリガー：離脱リスクフィールドが「高」に変更されたとき
  → タスク「【優先】○○社 離脱リスク高——マネージャーへの報告と対策会議」を自動生成
  → 担当者だけでなくマネージャーにも通知

トリガー：最終発注日から「発注頻度パターン」の2倍日数が経過
  → タスク「【緊急】○○社 発注停止——競合切り替えの可能性調査」を自動生成
  → 内容：「競合他社が入っていないか確認。担当者変更があれば新担当への挨拶訪問を優先」

[Workflow for the Risk of Personnel Changes]

トリガー：取引先レコードの「担当者名（先方）」フィールドが変更されたとき
  → タスク「【引き継ぎ対応】○○社 担当者変更——新担当への早期アプローチ」を自動生成
  → 内容：「新担当者への挨拶訪問を3週間以内に実施。関係再構築を最優先に」

[Workflow for regular follow-up]

取引先ランク「A」の取引先：最終接触から21日後にタスク自動生成
取引先ランク「B」の取引先：最終接触から30日後にタスク自動生成
取引先ランク「C」の取引先：最終接触から45日後にタスク自動生成
取引先ランク「D」（休眠）：最終接触から90日後に「再起動チャレンジ」タスク自動生成

Step 4: Make it a habit to "update the relationship level" after visits and contacts.

For early alerts to function, it is essential that the "current status" of each trading partner is updated in real time.

We will establish a rule that after a visit, phone call, or email, the person in charge will update the following three items within 30 seconds.

【接触後の必須更新（30秒ルール）】
1. 最終接触日（本日の日付に更新）
2. 関係温度（ホット/ウォーム/クール/コールドを選択）
3. 離脱リスク（低/中/高/緊急を選択）

By using a selection-based system, the effort required for data entry is minimized, and the dashboard alerts are automatically recalculated each time these three fields are updated.

Strict adherence to the "30-second rule" is crucial to the overall accuracy of early alerts. If this rule is not followed, we will consider it a design problem—that the system is not designed to encourage input—and will review the input fields.

Step 5: Accumulate data on successful "reboot" cases.

We will always record cases where our response to the early alert was successful (orders were resumed).

【再起動成功事例の記録フィールド】
・どのアラートレベルで検知したか（赤/黄）
・何日間発注が止まっていたか
・どんなアプローチをしたか（訪問/電話/新提案/価格調整など）
・なぜ発注が止まっていたか（競合/予算/担当者変更/ニーズ変化）
・再起動後の初回発注金額

As this data accumulates, patterns begin to emerge, such as, "At our company, if we take action within an average of 14 days of a red alert, there is a 70% chance that orders will resume," and "Clients with whom we were able to make a courtesy visit within three weeks of a change in personnel have a 40% higher retention rate than those with whom we were not."

This is precisely the shift to "data-driven sales," and the realization of systematic customer management that does not rely solely on intuition and experience.

To avoid "too late"—a 5-minute morning dashboard habit

Even if you implement an early alert system, it's meaningless if you don't make a habit of checking your dashboard every day.

We recommend a minimal routine: **"Spend five minutes each morning after starting work just checking the red alerts on your dashboard."**

【毎朝5分のダッシュボードルーティン】
1. 赤アラートリストを確認（今日緊急で動くべき取引先）
2. 黄アラートで今週中に対応すべき取引先を確認
3. 本日・今週予定のフォロータスクを確認
→ 所要時間：5分以内

Once this routine is established, the situation where "it's too late before you even realize it" will be structurally eliminated. Managers share dashboards at weekly meetings, and everyone reviews "why this happened and what to do" for clients with red alerts.

"You only realize the value of your business partners after you've lost them," so protect them before you lose them.

As demonstrated by the example of a company that nearly doubled the adoption rate of its products in sales activities with existing customers in just six months, properly managing and utilizing customer data has a significant business impact.

However, the prerequisite for this is a system that allows you to understand the current state of your relationship with your business partners in real time.

EMOROCO CRM Lite's dashboard and workflow automation can be built starting from just 1,500 yen per month. To begin, simply input the "last order date" and "order frequency pattern" of your existing business partners. That's all it takes to visualize the fact that "there were actually five important business partners who hadn't placed an order in over three months" the very next day.

"You only realize the value of your business partners after you've lost them," so protecting them before you lose them—that's the essence of Early Alert.
EMOROCO CRM Lite Product Page

Summary – Checklist for Building Early Alerts to Prevent Customer Charity Drop-offs

Designing custom fields:

• Are "Last Order Date," "Order Frequency Pattern," and "Supplier Rank" set?
• Are the fields "Relationship Temperature," "Abstention Risk Assessment," and "Competitive Situation" set?
• Is there a free-text field for "Recent Changes/Trends Notes"?

Dashboard design:

• Are lists of red alerts (urgent), yellow alerts (caution required), and blue alerts (regular) set up?
• Can managers see a list of follow-up statuses for each person in charge?
• Is the record of "successful clients restarting this month" visualized?

Workflow design:

• Will tasks exceeding the order suspension period be automatically generated?
• Will tasks be automatically generated when the relative temperature changes to "cool"?
• Will a "greeting visit task" be automatically generated when a client's contact person changes?
• Will regular follow-up tasks be automatically generated based on rank?

Operating rules:

• Is there a rule in place to update the "last contact date, relationship level, and risk of withdrawal" within 30 seconds of contact?
• Is checking your dashboard for 5 minutes every morning part of your routine?
• Are there rules in place for recording successful reboot cases?

Related article:[“The Moment Customers Leave”—Understanding Customer Abandonment Mechanisms Through Emotional Paths]

Related article:[From "Sales Based on Intuition and Experience" to "Data-Driven Sales": How SMEs are Transforming Decision-Making with EMOROCO CRM Lite]

Related article:[Why SMEs should be aware of LTV (Customer Lifetime Value) and how to cultivate it with EMOROCO CRM Lite]