What Is CRM, Customer Relationship Management?

CRM stands for Customer Relationship Management (CRM).

It?s hard to find a definitive definition of what CRM means. So I?ll outline the broad meaning and then give some examples.

You may have heard of the terms CRM and Customer Relationship Management in regards to software. Well CRM is not just a piece of software. It?s more than that.

The CRM Customer Relationship Management software is a vital component, yet the whole business needs to understand CRM Customer Relationship Management in all departments and functions of the business and behave appropriately to make CRM Customer Relationship Management work.

An effective CRM Customer Relationship Management will include methodologies, strategies, software, and web-based capabilities that help an enterprise organize and manage customer relationships.

Why use CRM Customer Relationship Management?

CRM Customer Relationship Management is used to help businesses (a.) understand their customer, and (b.) understand their customers? wants and needs and (c.) help the business serve them more efficiently and effectively

In turn this will help the business to improve customer satisfaction, increase staff productivity, slash operational costs and maximize the effectiveness of each customer interaction.

Let?s talk about these three different areas.

CRM Customer Relationship Management to Understand The Customer

In a CRM Customer Relationship Management application and approach a user will collect as much information about a customer that they can. They?ll collect names, addresses, contact numbers, age, sex, number of children etc. A CRM Customer Relationship Management process does this to, amongst other things; help ?classify? their customers.

A benefit of a CRM Customer Relationship Management system is that a user can help analyse which types of customers are best for their business.

Then once they know what customer ?types? are best they can then market to them in a ?personal? way ? using the information gained about them.

CRM Customer Relationship Management to Understand The Customers Wants and Needs

As information is collected about the customers? personal life, information is also collected about their buying habits and stored in CRM Customer Relationship Management software.

Humans are creatures of habit. By analysing the information collected about the customer and their buying habits the CRM Customer Relationship Management can be used to help the business identify what the customers would most likely want or need to buy.

For example, if your CRM Customer Relationship Management information lets you know that your best customers typically like buying ?red apples? in November for an average sale price of $15. You can prepare a marketing approach that is sent out to them prior to November that will steer them towards buying $30 worth of apples.

The customer sees it as useful because it?s something they like to do at that time of year, and you?re offering them a reminder and perhaps an incentive to buy more. The business benefits by structuring the offer to increase the sales value and therefore increasing the profit return.

CRM Customer Relationship Management is Useful to Also Target New Customers

Information gathered in the CRM Customer Relationship Management will help the business to target more of the preferred customers. An analysis using CRM Customer Relationship Management software could tell the business, for example, that single males between 30 to 35 years of age that earn between $50,000 and $60,000 are the best type of customer for the business.

Knowing that information from the CRM Customer Relationship Management, the business can then hire a list from a direct mail list broker of all the single men that fit the description and target their marketing towards them.

The CRM Customer Relationship Management activity of improving the relationship with the customer is to help keep the customer more loyal to the company and thus improve the profitability of the business.

CRM Customer Relationship Management to Help Efficiency and Effectiveness of Business

A good CRM Customer Relationship Management application will help the business to become more efficient and effective.

The business can become more efficient because if a customer contacts the business, within seconds the customer service representative can produce the customers file. This will tell the employee all about the customer and their interaction with the business.

So a CRM Customer Relationship Management saves time for the business and is able to help the employees deliver high levels of personalised service.

A CRM Customer Relationship Management software program and approach can help the business become more effective. An example would be marketing.

Knowing all the information about the customers, the marketing strategies can be targeted towards the customers in a personal way. Thus marketing to a defined target market with a past history the potential of improved results is far greater than marketing to a ?cold? list.

This article should only be viewed a very broad overview of what CRM Customer Relationship Management is.

On this website you?ll find more detail and resources to help you understand and use CRM Customer Relationship Management for your business.

Casey A Gollan, The Business Growth Specialist for CRM Software Center - All the general information and resources for everything CRM - Customer Relationship Management. Visit http://www.crmsoftwarecenter.com and http://www.caseygollan.com.au

Microsoft CRM Customization - processing in/out-going email messages

We would like to give you several situations, when you may need custom development and programming to improve Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, database administrator.

Microsoft CRM, the CRM application from Microsoft Business Solutions utilizes almost all the recent Microsoft technologies: .Net (it is actually written in C#.Net with HTML and Javascript at the web client side plus has Microsoft CRM SDK with C# and partially VB.Net samples), Microsoft SQL Server, Microsoft Exchange 2003/2000 and others. Now to give you brief review from the workflow and messages - you can send email directly from Account, Contact or Lead and it will be processed by Microsoft CRM-Exchange connector. This email will have GUID in the message header. When addressee answers the email - it will be processed by the connector - it will recognize the GUID and will find the original activity and will attach this email as closed activity to the original object: contact, account or lead. This is very nice feature, but in the real world you may have these situations:

1. CRM user will not use CRM interface and will send email from his/her Outlook. Addressee will receive and respond and these emails will not be handled by Microsoft CRM-Exchange connector. They will not have GUID and connector has no idea on what to do with them.

2. Imagine, that you have Account Best Corporation, with contact person John john@bestcorporation.com. Now new person in Best Corporation, Susan sends you message from susan@bestcorporation.com - and her email will not be connected to your Best Corporation account, because this email doesn't have GUID and it also doesn't have matching email in the contact person. So - it is probably nice to catch emails by domain name as well, say - all the emails, coming from www.bestcorporation.com should be attached to Best Corporation account.

3. Now - your sales rep initiated the first email to the client from Microsoft CRM and got response, transferred back into CRM account. Then he occasionally replied on the reply from outlook - this reply, having GUID will be replied back and not transferred into MS CRM, because MS Exchange connector "thinks" that this message was already replied by the first reply.

4. To decrease the possibility that users will use outlook to send new messages and answer the messages from there - you would probably like the idea to delete them from MS Exchange database when they are transferred to the CRM. In this case they will not be seen in MS Outlook (We are not talking about Microsoft CRM Outlook client, where you actually see CRM data and objects)

If you are programmer or software developer - you can actually program these advancements and we'll give you the direction.

This technique is COM+ applications, registered as Microsoft Exchange sinks or handlers. You can use VisualStudio.Net, but you will not have debugging available, because these applications will work as event handlers. Microsoft Exchange allows you to alter it's logic in the events, exposed for custom handling. Incoming emails should be handled, when ONSYNCSAVE Microsoft Exchange Database event is fired before the commitment. You use Microsoft CRM SDK to create the email activity. You should use direct SQL update to flag the activity as closed (however not recommended by Microsoft - but Microsoft CRM SDK doesn't have the method to close the activity - so you really don't have an option from SDK side). Outgoing emails should be handled with so-called transport events firing, which is more complex and less documented part of Microsoft Exchange SDK.

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Microsoft CRM, Microsoft Great Plains customization partner, based in Chicago, California, Colorado, Arizona, Texas, Minnesota, New York, Georgia and Florida, Canada, UK, Australia and having locations in multiple states and internationally (www.albaspectrum.com), he is Great Plains Dexterity, SQL, C# and VB.Net, Crystal Reports and Microsoft CRM SDK developer.

akarasev@albaspectrum.com

IT Department Skills to Support Microsoft Great Plains and Microsoft CRM

Microsoft Great Plains as ERP and Microsoft CRM as Client Relation Management system is very robust combination and could serve midsize to large corporation as Business System. Being VP IT or IT Director you need to foresee the positions to have in your IT department to do internal MS Great Plains and MS CRM support.

Let us give you the directions, based on our research and consulting practice.

1. Microsoft SQL Server Specialist we specially do not name this position as MS SQL DBA, because both Great Plains and MS CRM are not very complex from the database administration side, they do not use indexes optimization, referential integrity, probably do not require complex transaction log backup/recovery scenarios. On the other hand this position requires Great Plains and Microsoft CRM tables structure analysis and some primary Great Plains data fixing skills via SQL queries, described in MBS Customer source techknowledge database. The best candidate should have some accounting background - to be able to address ongoing issues to MBS technical support.

2. Network Administrator with good Microsoft Exchange and Active Directory skills. Microsoft CRM uses all the newest Microsoft technologies, and Exchange is a workhorse here. In order to install and upgrade MS CRM this guy needs to understand the under-laying Microsoft technology. In the best case - she/he should know Exchange security structure and probably program Exchange handlers, due to the fact that CRM/Exchange connector is not a perfect tool yet.

3. C# or VB.Net programmer with excellent SQL Skills if you are midsize or large company - you should have this position - you will need web publishing and MS CRM customization and its support. Currently Microsoft CRM SDK has C# examples - so C# programmer would be the best fit, it may have more VB code in the future, so the C# - VB balance maybe restored.

4. Crystal Reports Designer/Programmer - Crystal Reports is the best tool available on the market to address both Great Plains and MS CRM reporting needs. This position maybe merged with one of the above.

These people should be probably cross-trained in both Great Plains, Microsoft CRM, Crystal Reports, SQL and C# programming, so you do not depend on the unique skills of one person. In our opinion, which is based on our long term consulting practice - these skills will allow you to keep the cost of IT support reasonably low and avoid paying high consulting price to your Microsoft Business Solutions Partner.

Happy hiring and training! But in any case you need to select Microsoft Business Solutions Partner/Var/Reseller to be your official representative. This is how MBS has its channel working - it assures that Microsoft Business Solutions products are properly implemented. If you want us to be your Microsoft Business Solutions Partner - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies USA nationwide Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Arizona, California, Taxes, New York, Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

akarasev@albaspectrum.com

Microsoft CRM Implementation for Large Corporation overview

Microsoft Business Solutions CRM is now approaching the phase of being mature product and the CRM solution you may consider for large publicly traded company.  Our view point considers the fact of multiple platforms and systems coexistence and balancing: UNIX, Linux, Microsoft Windows, Java, .Net, PC, AS/400, RS6000, Microsoft Exchange, Lotus Notes Domino, etc.  This increases the cost of maintenance, but decreases the risk of being trapped to one vendor/solution.

Microsoft Business Solutions CRM is now approaching the phase of being mature product and the CRM solution you may consider for large publicly traded company.  Our view point considers the fact of multiple platforms and systems coexistence and balancing: UNIX, Linux, Microsoft Windows, Java, .Net, PC, AS/400, RS6000, Microsoft Exchange, Lotus Notes Domino, etc.  This increases the cost of maintenance, but decreases the risk of being trapped to one vendor/solution.  So far weve seen successful implementations of Microsoft CRM in the following industries: Distribution, Logistics, Non-Profit, Chemicals, Pharmaceutical, Placement/Recruiting, Medicare/Hospitals, Retail, Wholesale, Education, Beverages, Services, Defense, Aerospace, Oil & Gas.

• In-house Implementation.  This is non-expected paradox.  Multiple clients, especially large companies, do it themselves.  The reason is Microsoft CRM utilizes all spectrum Microsoft Technologies: Exchange, Active Directory, .Net, Full-text search, etc.  Microsoft oriented IT people understand it and like to be involved.  So, you should consider self-implementation first.
• Integration.  Microsoft CRM has relatively simple business logic and sits in Microsoft SQL Server, which enables customization and integration with third party systems and databases.  If you have Microsoft Great Plains you can use MBS CRM-GP integration tool, based on BizTalk.  If you have UNIX-based ERP/Accounting, you can deploy MS SQL linked server to bridge MS CRM and ERP.  The same would work for Oracle ERP Oracle Financials.  Navision has third party integration tool and the one from Microsoft is on the way to be released.  Axapta is also candidate for the integration.
• Customization.  Microsoft CRM SDK describes majority of MS CRM objects and classes and enable VB.Net or C#.Net developer to build-in custom .Net application for Microsoft CRM existing screens.  And this is actually the way of the integration you realize integration in the custom .Net application.
• Messaging.  Microsoft CRM uses MS CRM-Exchange connector in its standard functionality.  However if you have IBM Lotus Domino email server you can deploy MS CRM-Lotus connector, developed and supported by Alba Spectrum Technologies.
• Data Conversion.  You should use Scribe for initial data migration.  However you need some programming work if you plan on bringing advanced data (email attachments from Siebel, for example)
• External consultants.  You should consider customization and integration initial design as candidates for outsourcing.  Then, when coding is done and implemented you may switch to your internal developers to support custom pieces.
• Nation-wide support.  Microsoft CRM is very innovative from the support side.  It means that Microsoft CRM partners tend to go to the nation-wide and international market to sell, implement and support the application.  Being web application Microsoft CRM could be accessed, customized and modified from anywhere.
• Internationalization.  Microsoft Business Solutions promotes MS CRM worldwide and has local versions of the product.

You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com

Andrew Karasev is consultant and CTO in Alba Spectrum Technologies ( http://www.albaspectrum.com ) Microsoft Business Solutions partner, serving clients in Illinois, New York, California, Florida, Georgia, Texas, Arizona, Virginia, Minnesota, Canada, UK, Europe, Australia, New Zealand, Asia, Russia.  He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer.  You can reach Andrew: akarasev@albaspectrum.com

Microsoft CRM Integration & Customization: Share

 Boris Makushkin

MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc. The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino. In this small article we describe the solution based on MS CRM integration with MS SharePoint.

Microsoft CRM is new player on CRM applications market and it is gaining its market share. Having different paradigm in its design (it stakes on Microsoft OS and technologies and completely disregards alternative platform, such as UNIX, Linux, Oracle, etc. based). Microsoft CRM market is very diversified: from small (5 users) to large (several hundred MS CRM User licenses) and it serves variety of industries: Transportation, Logistics, Lawyers, Pension Funds, High-Tech, and many others. Deploying technologies, like Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk, Microsoft Outlook, Internet Explorer, Microsoft Great Plains and Navision in close future - makes CRM a beloved system for Microsoft oriented IT departments.

Let's go right to the topic.

Major issue with storing documents in MS CRM in the form of attachments to Activity is inability to work on these attached files in cooperation with other colleagues, who do not have to use CRM. When several service people serve requests from the same client this is required. Currently you can use alternative way when you store office documents in the folders of your file system and when modifying document, you save it and reattach to CRM. This is inconvenient, because first it requires all your editing users to have CRM licenses, which delays CRM implementation.

We seem increasing popularity of document storage systems, like Microsoft SharePoint, Oracle Files, etc. Such systems, being implemented gives you time savings, related to documents revisions and versioning, approval cycles and workflows, web access through web-portals systems and the like.

The target of our product is Microsoft SharePoint integration with MS CRM for document storage. Let's take a look at the high level technical realization details:

• Main modification from the MS CRM side is standard system behavior change when you open attachment in Activity. Standard unmodified CRM suggests you to store documents in the file system. Modified version sores document in SharePoint Document Library (the required library is subject for setup by MS CRM system administrator) or keep it in MS CRM as is (for documents of minor importance). From the moment of saving the document in SharePoint Document Library it is not stored in MS CRM CRM will now store only the link/reference to the document. Also you are given the ability to open and modify the document at the place of opening, which speeds up MS CRM user performance substantially.

• Table, storing the links to the documents sits in separate database and doesn't deal with MS CRM tables (you know that you are banned to do structure changes in MS CRM db)

• Document saving into MS SharePoint process occurs in MS CRM and with its assistance SharePoint bridge, which does addition and update for the existing document into destination Document Library with MS SharePoint Web Services calls

• Upon the addition into Document Library, MS CRM SharePoint bridge registers the document in the special table for the future data extraction or notification mechanism registration

• Then, interested users can work with the documents just using MS Office 2003 or other programs/editing tools, assuming these tools have access to MS SharePoint

• Feedback is provided by MS SharePoint Event Handler component. This is special handler, inspecting document change status, transferred from MS CRM to document storage (SharePoint), and report Activity owner on the changes with home page notifications (User home page in MS CRM). User in turn can review the history of the document editing - who, when and where is the change

• Opening Activity, where document is "attached", and in fact placed into MS SharePoint Document Library, and pressing opening button, MS CRM user gets live version of the data

• This approach allows you seamless work with MS CRM document in the whole informational space of your company

• Additional enhancements to this product might be document library management directly from MS CRM (web interface - meaning remotely), administrative interface for MS Sharepoint documents revision, ability to create reports on the document storage status, rights/access management (Author, Reader, Contributor etc) from MS CRM, portal pages integration into MS CRM to name a few.

Happy programming, implementation, customization and modification! If you want us to do the job call use 1-630-961-5918, 1-866-528-0577! help@albaspectrum.com

Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies USA nationwide Oracle, Navision, Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, California, Arizona, Colorado, Texas, Georgia, Florida, New York, Canada, Australia, UK, Russia, Europe and internationally ( http://www.albaspectrum.com ), he is Oracle, Unix, Microsoft CRM SDK, Navision, C#, VB.Net, SQL developer.

BorisM@albaspectrum.comKeyword Prices Decline 3.0% in the First Quarter of 2005Tommy Maric

An analysis of webs most popular 20,000 keywords by TopPayingKeywords.com, found that keyword prices dropped 3.0% from January 2005 to April 2005 from an average bid price of 58.9 cents to an average bid price of 57.1 cents. The 20,000 most popular keywords are distributed in pricing as follows:

Keyword Price# of Keywords
$20.00-$49.9920
$10.00 - $19.99123
$5.00 - $9.99660
$3.00 - $4.99923
$1.00 - $2.993,918
$0.50 - $0.992,259
$0.25 - $0.492,115
$0.15 - $0.241,584
$0.10 - $0.142,962
$0.05 - $0.09592

Note that there are 4,379 keywords in the Top 20,000 keywords which have either a zero price or do not have three active advertisers.

Keyword pricing is critical for internet advertisers and also webmasters as expensive keywords allow them to maximize their profits using Googles Adsense program.

According to Dave Lavinsky, President of TopPayingKeywords.com, With the overall decrease in keyword prices this quarter, it is important to know which keywords remain profitable. What may not seem evident is that in fact many keywords enjoyed a large appreciation in value and now we have over 800 keywords in our database that are worth $5.00 or more.

There were many large increases in the value of certain keywords. The keyword shiva for example, went up 935% from a price of just $0.17 to $1.76. Medifast also made a giant leap in value increasing from $1.50 to $6.98. This surge in value is most likely due to increased consumer awareness of the Medifast brand and increasing competition among retailers.

With information changing so quickly it is important to keep abreast of the current value of keywords. The value of these keywords can change dramatically over a very short period of time making a once profitable website quickly unprofitable. For instance, the keyword Vioxx declined by 50% from $16 to $8 from January to April 2005 as the value of Vioxx litigation clients decreased. Keeping informed and up to date is of great importance to webmasters looking to turn a profit.

Tommy Maric is the manager of TopPayingKeywords.com. TopPayingKeywords.com is designed to help webmasters maximize their profits using Googles Adsense program. Through extensive research, TopPayingKeywords.com continues to develop up to date databases of the most popular keywords and their accompanying prices. For more information, please visit http://www.toppayingkeywords.com.tommy@toppayingkeywords.com