by RonnieG on Fri Aug 28, 2009 6:39 am
Great idea, as some other CRM software already do this. It definitely could get complicated, especially for a medium to large office using the product! So complicated, that it may be a totally different advanced product offering, perhaps with tighter Outlook / Thunderbird integration, and maybe a local MySQL database, which would then allow the product to be more web assessable, especially if paired up with a Windows version of Apache! ? Followup Campaign Manager ?
Part of the paradigm shift here would be to rename "Mailing List" as "Followup Campaign".
In setting up a Campaign follow up item, the item needs to have a "Type" code, like: "E"mail which would be the default type as it is now, "C"all, "A"ppointment, "F"ax, etc., and the message for those items might be a call script, appointment goals/task list, fax document number, or some other prompt for the agent/rep to use as the task comes up, rather than an email. It may also need to have a "assigned to" field, because the task may be assigned to an agent/rep, a clerk, or some other party. It may even be a task for the subscriber to accomplish!
You would also need to have a task "Status" field, so the responsible party can check off that it has been completed. The responsible party may also need to be able to reschedule a particular task for a later date/time, or delete the task, with the program then prompting whether or not to reschedule all following tasks or leave their existing dates alone.
In addition to expanding the followup item to accommodate new fields, it may also be nice to have it auto-calculate and populate the future date of an item, not just the raw delay factor, so we can see the date of all upcoming activities for a subscriber. This may be an easy enhancement, separate from what we are discussing here.
The existence of the "Assigned To" field means a new database entity for those people, with the person's name, department, email, phone, etc., so Management can contact them if need be, like if necessary to re-assign scheduled tasks, get on them for not performing their scheduled tasks, etc. When management accesses an "Assigned To" person, or the assigned person accesses their own records, you would want them to be able to see only upcoming tasks for a specified period, which would need to be selectable: Today, Tomorrow, This Week, Next Week, This Month, Next Month, or a specified date range.
Selecting and displaying task assignments by responsible party and date range would probably be the toughest programming task to accomplish. In the beginning, emailing all scheduled tasks to the assigned persons when the subscriber is initially setup could be the easiest thing to do, and the assigned person could then organize the tasks as they see fit, perhaps in as an Outlook "Task" or Thunderbird "To Do" item. Reassigning tasks may then be as simple as forwarding the reassigned task(s) to the new responsible party. But then, tracking whether a task has actually been accomplished or not gets to be a management issue.