The first and easiest solution would be to leverage Microsoft Excel for customer data entry. Excel can make it simple to adjust the data captured to reflect the specific needs of your individual customer, keeping in mind that the information captured may not be the same across all customers. You can attach the spreadsheet to your customer account, a sales opportunity, or a support case. While this is by far the simplest solution, it may not be the most effective because of the risk of multiple attachments of the information and the inability to report on or search for the information.
Dynamics CRM's customization framework – specifically the ability to create custom entities – is a more sophisticated solution, but will likely offer a great deal more flexibility than an Excel solution. Using the entity builder, you can create a completely custom component for CRM that could be linked to an account and to multiple cases or opportunities. CRM even provides tools for designing an intuitive user interface for laying out the questions in logical groupings by tabs and/or sections. What is even better, new entities created through the Dynamics CRM tools will work with the Web and online/offline Outlook clients.
The nature of the questions would determine the best way to configure the new relationship. When we have created this type of configuration for a client, we have typically created a new entity that stores all of the questions, and then configure the relationships so that the entity can be linked to the appropriate Dynamics CRM account, case, etc. This makes it possible to access the data from both the account and the case record, for example, and to search for data using advanced find. Using SQL Reporting Services, you can also develop reports on the data.
One of the best benefits of using the custom-entity approach for customer data entry is the ability to create exactly what you need, in terms of the fields (questions and answers). If the information that you need to capture dramatically changes over time, it is possible to either extend the entity with additional fields or to create another entity that reflects the new information that is critical to your business. In working with clients to select and implement CRM solutions, we have found Dynamics CRM's customization support to be some of the best in the industry for enabling customers to model their business in their CRM solution.
Dig Deeper on Marketing automation
Related Q&A from Richard Smith
In this Q&A, learn more about the current list of Microsoft accelerators available for Microsoft Dynamics CRM 4.0 and get tips for deploying them ... Continue Reading
Find out about integration between Dynamics CRM 4.0 and Lotus Notes. Lotus Notes users can find tips for monitoring emails through Dynamics CRM 4.0. Continue Reading
Learn about Microsoft's eLearning options for users looking to get trained in Microsoft Dynamics CRM 4.0 in this expert tip. Continue Reading