Agent Name Assignment SOP for Mutual of Omaha
Objective
This SOP outlines the steps to assign agent names based on agent IDs when the agent's name is not provided in the statement from Mutual of Omaha.
Key Steps
Step 1: Identify Missing Agent Names 0:00
- Check the statement from Mutual of Omaha for the agent's name.
- If the agent's name is not provided, note that the agent ID is available.
Step 2: Create an If-Then Rule 0:31
- Open the If-Then rules application.
- Create a new folder and name it 'Agent Name Wizard'.
- Set up the rule: If the agent ID is [specific ID], then the agent name is [specific name].
- Use 'contains' or 'equals' for the condition.
Step 3: Input Agent ID and Name 1:13
- Paste the agent ID into the rule.
- Assign the corresponding agent name in the designated field.
Step 4: Run the Rule 1:39
- Execute the rule by clicking 'Run'.
- Verify that the agent name has been filled in correctly for the corresponding agent ID.
Step 5: Create Multiple Rules Efficiently 2:40
- Prepare a list of agent IDs and their corresponding names in a separate spreadsheet.
- Copy the agent IDs from the spreadsheet.
- Paste them into the If-Then rules application.
Step 6: Assign Agent Names 3:26
- Copy the corresponding agent names from the spreadsheet.
- Paste them into the If-Then rules application next to the respective agent IDs.
Step 7: Pull Down to Create Additional Rules 4:04
- Use the pull-down feature to replicate the rules for multiple agents without manual entry.
Step 8: Final Run of All Rules 4:27
- Click 'Run' again to apply all the rules created.
- Check for any agent IDs that still do not have names assigned.
Cautionary Notes
- Ensure that the agent IDs and names are accurate to avoid misassignments.
- Double-check the rules before running them to prevent errors in data entry.
Tips for Efficiency
- Maintain an updated list of agent IDs and names to streamline the process.
- Use keyboard shortcuts (e.g., Ctrl + V for paste) to speed up data entry.
- Regularly review and update the If-Then rules as new agents are added.
Comments
0 comments
Please sign in to leave a comment.