[object Object]

CRM has a User record. People has an Employee record. They almost always share an email address and almost never share data. That gap costs you ramp analytics, clean offboarding, and a single source of truth for “who is on the sales team this quarter.”

Add three custom fields to the CRM User record: Employee_ID, Hire_Date, Manager_Email. Populate them from People nightly via a Deluge schedule. That alone gives you tenure-based reports.

employees = zoho.people.getRecords("employee","department=Sales");
for each emp in employees
{
  user = zoho.crm.searchRecords("Users","(email:equals:" + emp.Email + ")");
  if(user.size() > 0)
  {
    zoho.crm.updateRecord("Users", user.get(0).get("id"), {
      "Employee_ID":emp.EmployeeID,
      "Hire_Date":emp.DateOfJoining,
      "Manager_Email":emp.Reporting_To.Email
    });
  }
}

Ramp analytics you cannot do without it

With Hire_Date on the User, your CRM Analytics can chart attainment by months-since-hire across all reps. The pattern is universal: month 1-2 zero, month 3-5 climbing, month 6 expected at 100%. If your curve is flat through month 9, your enablement is broken, not your reps.

Offboarding that does not orphan deals

When People marks an employee as Terminated, a Workflow Rule should fire that:

  1. Deactivates the CRM User after 24 hours.
  2. Reassigns open deals to the manager listed in Manager_Email.
  3. Reassigns open accounts to the same manager.
  4. Removes the user from Territories.
manager = zoho.crm.searchRecords("Users","(email:equals:" + leaver.Manager_Email + ")");
mgrId = manager.get(0).get("id");
deals = zoho.crm.searchRecords("Deals","(Owner:equals:" + leaverId + ") and (Stage:not_equal:Closed Won) and (Stage:not_equal:Closed Lost)");
for each d in deals
{
  zoho.crm.updateRecord("Deals", d.get("id"), {"Owner":mgrId,"Reassign_Reason":"Termination"});
}

PTO awareness in routing

Round-robin lead assignment that ignores PTO is a leaky bucket. Pull today’s PTO list from People once an hour, store in a CRM picklist or custom setting, and exclude those users from the assignment rule. The lead never lands in a vacation inbox.

Clean reporting hierarchies

CRM has a Reporting_To field on User but most orgs leave it empty. People owns the org chart. Sync it. Then forecast roll-ups by manager actually match your real org.

Skip what does not transfer

Do not pull comp, performance review, or PII like SSN into CRM. Even with role security, an AE in CRM with no need to know is the wrong audience. Keep payroll data in People where the access boundary is enforced by HR.

What to do this week: add the three User fields, schedule the nightly People sync, and build one ramp-curve report. Within a quarter you will run sales differently because of it.

[object Object]
Share