How To Create A Data Capture Procedure Checklist For Your Small Business Crm Software
|
Fortunately one of the most common reasons cited for the high failure rate of CRM systems - poor data quality - is also one of the easiest to avoid. Your CRM software is only as good as the information it contains. As the old programmers motto goes 'garbage in, garbage out'.
So how can you avoid incomplete, incorrect, irrelevant or out-of-date and generally unfit-for-use data from permeating your CRM software?
You need to gather your key CRM users together and thrash out a DATA CAPTURE PROCEDURE document, defining the rules of use.
Spell out:
? Who has what rights to the system; who can Create, Insert, Modify or Delete records, assuming your software supports all these functions? Forward this information to your system administrator to action.
? Decide on a procedure to check for any duplicates before creating a record. Depending on what 'de-duping' or 'data scrubbing' features your system has, this might require some simple searches before starting a new record.
? Do you allow abbreviations or acronyms? For example: IBM, or I.B.M, or International Business Machines Inc. or Incorporated and so on. A policy on ensuring consistency of input will help to avoid duplications in future.
? Are records going to be created in Upper and Lower case and when are CAPS acceptable?
? By when do you expect records, notes and so on to be created or updated? Same day, on return to the office?
? Check to see whether your Postal Services have specific requirements. Ensure your data meets these criteria.
? Is the primary address of clients to be created as a postal or a physical address?
? Make sure everyone checks spellings if they are unsure and do not trust spellchecker! When in doubt, ask the client ? they'll respect that. Is it Clark with an 'e'; Shawn, Sean or Shaun? One certain way to get your mail binned is to spell someone's name incorrectly.
? Also confirm the kind of corporation e.g. LLC, Inc, PTY Ltd. and so on.
? Make rules for creating new profiles or User Definable Fields (UDF) (or whatever your specific CRM software calls them.) Place a lot of emphasis on this. Every time a new UDF is needed, it should first be approved. Otherwise duplicates will permeate your database e.g. Lead Source: Yellow Pages, YP, yelo pages.
? Ensure that email addresses are put in correctly. Basic but common mistake!
? Set up procedures, if not supported by your software, of how to create records from inbound emails.
? If applicable, are you going to use Mandatory/Forced fields?
You might as well address the issue of Backups while you are about it.
? Who is the responsible person for backing up your databases/s? Who covers for them when they are absent or unavailable?
? How frequently are backups to be done? Diarise!
? How are backups done e.g. by the Grandfather, Father, Son method.
? Ensure backups are made on good quality CD's or whatever format you are using. It's no good doing a backup, then finding on attempting a Restore that it doesn't work! It is also a good idea to copy backups onto more than one data format.
? Where are the backups to be stored?
? Are the backups secure? This is important for both security and practical reasons.
Once your Data Capture Procedure Document is finished, get everyone to sign it off as READ! As standard practice, ensure that document is handed to all new employees at your company. Refer back to this document for possible revision every three months or so.
Try this: select a couple of records - both good and bad - every week, to put on the overhead at staff meetings. Make sure you don't unduly embarrass anybody but watch this become the light-relief highlight of your meetings! People learn best when having fun!
What if your database is in one unholy mess?
Has the rot set in so deeply that your database needs a complete overhaul? Turn this seemingly insurmountable task into an opportunity to you. This is an excellent excuse to re-establish contact with your clients and let them know you care. You can always put lapses down to data crashes but tell them you have fixed the problem!
Importantly, help your staff understand what you need from the data to facilitate more accurate marketing and reporting and hence the success of your business and their careers.
By creating a sense of pride and ownership in the company database, you are nurturing the essential process of buy-in, necessary for the success of your CRM initiative. Don't compromise this critical tool by allowing your CRM software to be infected by inferior data.
About the Author: Perry Norgarb has specialized in Small Business CRM solutions for the last 15 years.
Contact him or find out more about CRM, Contact Management and other Sales Tracking software tips and solutions for small businesses at: http://www.smallbizcrm.com
You are free to re-publish this article as long as this bio box and copyright remain intact. © 9 March, 2004.
|
|
|
Manufacturing Outsourcing: Microsoft Great Plains Implementation, Customization & Reporting
Manufacturing in the USA is far away down from mid 20th century top of the hill or its golden time. However ...(related: Software)
The Dirt On Screensavers
Remember back in the days where screensavers were the coolest thing at the office? You could stare at your co-worker's "fish in the ocean" screensaver at the cubicle next...(related: Software)
Upgrading Great Plains Dexterity Customization ? Switching To New Technologies: Sql, Crystal, Econne
1. Replace Dexterity cursor with SQL Stored Procedure
Dexterity was designed as multiplatform technology (primarily Btrieve, Ctree, SQL Server, potentially Oracle). Dexterity data retrieving mechanism is based on Range start, Range End, Get First and Get Next clauses. It is in fact similar, however a little bit slower to cursors in Transact SQL. Long ranges in Dexterity are good candidates for replacement by SQL stored procedures with update clause.
For example, consider to replace following Dexterity code:
Range clear SOP_HDR_WORK.
Clear 'SOP Type' of table SOP_HDR_WORK.
Clea...(related: Software)
An Introduction To .net Framework
.Net Framework is a platform or development environment to seamlessly create web-applications that are accessible through client machines from across the globe. These web-applications adopt open s...(related: Software)
Microsoft Great Plains Integration Manager ? Advanced Techniques
Great Plains Integration Manager scripting and translation - overview for programmer, software developer, database administrator, IT specialistMicrosoft Business Solutions main middle market ERP application - Microsoft Great Plains has multiple integration options: MS SQL Scripting (stored procedures and views), ADO.Net programming, Microsoft SQL Server DTS packages. You certainly can deploy such SDK tools as eConnect. However here we would like to show you how to program the simplest user friendly tool: Microsoft Great Plains Integration Manager.We assume that you are familiar with Microsoft script...(related: Software)
Getting Technical Support Help Online
Sometimes your PC will start acting strange for no apparent reason or a programwhich you use regularly will all of a sudden stop working as it should. Thiscan be a frustrating experience especially if you have no idea where to go forhelp. If this happens to you, don't panic! Here are some simple tips which mayturn your frown upside down.1. Don't assume that ...(related: Software)
Microsoft Crm: Data Conversion ? Import From Act!
Best Software Act! is very popular CRM for small and mid-size organization. This system attracts business owner by its low price, plus system is very easy to use. However if your business is growing you should reach the moment to implement more advanced CRM solution. Natural question is ? how do we convert the data from Act! to new CRM solution and the mapping of your objects for conversion. You would probably like to avoid operator data entry with potential numerous errors and mistypes. Assuming that you are IT specialist, we'll give you technical side of Act to MS CRM data migration:? First you need to download Act! SDK from Best Software website? Install Act! SDK on the computer, where you plan to do programming? We'll use asynchronou...(related: Software)
Microsoft Navision Customization Upgrade ? Tips For Programmer/it Specialist
Currently Microsoft Business Solutions is on the way of creating so-called suites: Microsoft Financials, Microsoft Distributions, Microsoft HR, Microsoft Manufacturing. It is very difficult to say which product will be the core of which suite, but the best guess is this: Microsoft Great Plains - Microsoft Financials and probably Distribution/Supply Chain Management and HR, Solomon - Microsoft Project or Professional Services, Navision - Microsoft Manufacturing. If you have Microsoft Business Solutions Navision and support it for your company then you need to know some technical details about Navision version upgrade and what is going on behind the scenes, which options do you have in case of C/SIDE customization or Jet Reports.The challenge of Navision Upgrade This should be unde...(related: Software)
Crystal Reports - Microsoft Sql Server
Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. Crystal Reports is the most flexible tool on the market and it has market recognition. Multiple software vendors offer Crystal Reports as the main reporting tool: Microsoft, Best Software, Oracle to name a few.Sometimes developers try to use Crystal directly to pull data from multiple database platforms - we understand the need to give you additional tips to increase Crystal report flexibility. Also common case when Crystal report should pull data from multiple database platforms. Assuming that you are creating Crysta...(related: Software)
Microsoft C# Vs. Vb.net
Hi, Guys,I believe a lot of programmers are trying to speculate which Microsoft language is the language of the future .Net applications. We did some research here and we think that at this moment Microsoft doesn't have an answer or a direction - they just try to place both VB.net and C#.net into competition with each other and see who will be the winner over time.Example - Microsoft CRM SDK - Microsoft says - they will have examples in both languages: C# and VB - but for now C# seems to be the winner and if you are vb.net programmer - it is really hard for you to program Microsoft CRM SDK.The other example is more favorable for VB.net. If you plan to program M...(related: Software)
Is Your Small Business Ready For A Crm Software Solution?
I have yet to see a business that, sometimes in spite of themselves, didn't benefit from implementing a Customer Relationship Management (CRM) or a simpler Contact Management software solution.Your small business might be the rare exception, but if you can relate to some of the following scenarios, you may be ready to take advantage of the improved and inexpensive CRM systems coming on-stream.Mary, your star sales performer, has just been poached by your opposition. She departs your employ with im...(related: Software)
Microsoft Update - 5 Reasons To Update Service Pack 2
Microsoft released Service Pack 2 (SP2) for the Windows XP operating system back in August (2004), re...(related: Software)
Erp Remote Support: Microsoft Great Plains Analysis ? Pluses & Minuses
Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions Great Plains serves midsize and corporate clients as ERP...(related: Software)
site-map - Copyright © 2006 | Contact Webmaster | All Rights Reserved. | Software