Thursday, September 5, 2013

MSCRM: "Neglected Reports" in the Report Area and the "Not" Condition

A client recently asked how they could determine which Leads in his CRM system had not been acted upon in the last 30 days. 

This is an interesting topic because there is really no short answer to this question and the answer is really dependent on your needs and the level of detail that you are looking to reach.

First, there are reports that come out of the box: Neglected Accounts, Neglected Leads and Neglected Cases. These reports, display only active leads, with no activities or notes, in the number of days specified by the person running the report.  

These reports have the following limitations:

1.     These reports ONLY look at activities and notes, and do not take into account changes on the record itself. So if the primary contact, address and phone number were all updated yesterday but there haven’t been any activities or notes in a year, it would still be “neglected”.

2.     They also do not take into account non-standard activities. For example, if in your database, there are email activities actions for a third-party email add-in, these records are considered neglected even though they have email actions (opens, clicks) during the period.

3.     The actual queries that these reports are running is defined  behind the scenes and there’s no way to see what’s being included or tweak it, and certainly not to create it for different entities.

So, we are back to the question on how to report on Leads (or any other entity) that have truly not been acted on in a specified time frame.

Another limitation in Microsoft Dynamics CRM is allowing you to do queries on NOT conditions. For example there is no way through the User Interface to determine which Leads have had no activities during the last 30 days.
There is a workaround in which you could use marketing lists as follows:

1.     Build a Marketing List for all Open Leads that have had activity in the last nine months.

2.     Open the Marketing List and then Remove the members that have had activity in the last 30 days. This will leave you with Open Leads not contacted in the last 30 days.

One of the drawbacks of using this method is that it only works with static marketing lists and you would need to repeat the process any time you want an accurate count.
The best solution for getting an accurate picture of your neglected records would be to create a custom field on the record (i.e. Last Activity Date) and then update that field through a workflow when an activity regarding that record is closed. The Workflow would need to be written on each of the Activity types that you are tracking (i.e. Phone Call, Appointment, Any custom activity etc.)
In conclusion, there is no short answer to the question of identifying neglected records but hopefully this post gives you a better understanding of your options.

1 comment:

阿童木 said...

Although not anybody feels the rolex replica admiration to arise automated watch winder on their automated watch, those that are advantageous to acquire one archetype of these top craftsmanship, apprenticed copy accessories are accurate by the replica rolex chrism for the crop in watch accent architecture and utility. Ranging anywhere from a brace of hundred to lots of money, watch winders will not be a article item, nor aphotic beer advised to be. Automated watch winders accomplish the attention principals of the babyish watch itself, and bout it forth with the exact replica watches weighting and timing to alpha the abiding motion accepted to wind the watch after alfresco options for power.