Purpose
The purpose of this article is to reduce duplicate real estate agent records by outlining how to correctly search for existing agents, identify the correct record to keep, and merge duplicate records. Following this process helps maintain accurate reporting and system data.
Associates are responsible for searching for an agent correctly to prevent creating duplicate records. Agents must also check for existing duplicates and take appropriate action. To avoid extending call time, gather all required information during the call and complete follow‑up work after the call.
Scenario
1: Handling Duplicate Agent Records When One Has an ARC
1.
If you have the agent live on the phone, always use your Sticky
Note tool to record the following:
- agent name,
- office name
- location
- agent
email address.

2.
Search TIMX for the agent. Be sure to search the system
using different variations of the agent's name.
- In the example below, DAV
was entered as the first name in case the agent was in the system as Dave or
David.

3.
How many active Dave/David Walkers are there? Three
- Are
they all in the same office address? No. Two are the same, and one is different.
4. Do
any of them have an ARC account? You have to click into each active agent
record to find out.
|
|
- Example 1:
Agent ID 142379990
- If the Website Username field is populated, then there is an ARC
account.
This is the
account that we want to keep. Make sure the information on this
account is current (i.e., correct email, correct office, etc.) and update
accordingly. |
|
|
|
Example 2:
Agent ID 141943747
Examples 1
and 2 have the agent reporting to the same office.

|
|
|
|
Example 3:
Agent ID 141943746
This example
shows the agent reporting to a different company.
Ask if the
agent used to work for this office.
- IF yes, THEN cancel the agent record.
- IF no, THEN leave the record alone - it's for a different person.
|
|
Important Rules to Remember:
- IF the duplicate agent records that you want to merge are tied to
the same office, THEN follow the Keep/Merge Process.
- This process merges
all of the duplicates into the record you want to keep and moves the warranty
production over without manual intervention.
- IF the duplicate agent records are tied to different
offices, THEN you need to cancel the agent account.
- Warranty production
stays with the office, unless a particular warranty was entered under the old
office in error.
Scenario
2: Handling Duplicate Agent Records When No ARC Account Exist
1.
If you have the agent live on the phone, always use your Sticky
Note tool to record the following:
- agent name,
- office name
- location
- agent
email address.

2.
Search TIMX for the agent. Be sure to search the system
using different variations of the agent's name.
- In the example below,
MELI was entered as the first name, so we don't miss various spellings of the
name.

3.
How many active Melissa Roops are there? Five
- Are
they all in the same office address? Yes
4. Do
any of them have an ARC account? You have to click into each active agent
record to find out.
|
|
Example 1:
Agent ID 141825747
- No ARC account
- Email looks different than the others.
- Reports to Century 21 Precision
| |

|
|
Example 2:
Agent ID 142372700 - No ARC account
- Email same as the other 4
- Reports to Century 21 Precision
| |
Example 3: Agent ID 142379464 - No ARC account
- Email same as the other 4
- Reports to Century 21 Precision
|

Example 4: Agent ID 142377409
- No ARC account
- Email same as the other four
- Reports to Century 21 Precision

Example 5: Agent ID 145959762
- No ARC account
- Email same as the other four
- Reports to Century 21 Precision