My Photo

Search The Blog



Bookmark and Share
Blog powered by TypePad
Member since 01/2004

Disclaimer

  • The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway. All postings and code samples are provided 'AS IS' with no warranties, and confers no rights. © Copyright 2008

Sponsored Ads

MS CRM Users: The Marketing Department

Accounts in the Top 10, 100, 500, 1000 lists

There are some key things in the world that are occassionally interesting to users of Microsoft Dynamics CRM. One of those things is which of the current accounts within a CRM database are in the US Fortune 1000 list and another twist on the same might be which current Fortune 1000 accounts are missing from a CRM database.

Given that the Fortune 1000 list changes every year this would need to be updated regularly.

Another area within the world of vendors playing in the AICPA space might be which accounts are in the SourceMedia Top 100 List,

In other worlds and industries there are other Top 10, 100, 500, 1000 lists.

Is anyone doing anything creative with the above? 


From business card to electronic lead

One of the tools I have used for years is the Cardscan 700c from Cardscan, Inc.

A couple of years ago they released a new piece of software that offered even more. The ability to scan a business card right into Microsoft Dynamics CRM as either a LEAD or a CONTACT.

Cardscan

The product comes with a small carrying case, plugs into your laptop via USB and fits in the palm of your hand.

A gadget that makes a difference in the world with software that offers users options!

For instant you can also use the Cardscan for Outlook software, scan your cards into Outlook and then selectively choose which card to track within the CRM software via the Outlook client for CRM.

Justifying Marketing Efforts

One of the most common requests that bubbles up in some of the marketing professional forums is how do I justify and find ROI around the work that I do.

This particular request is even more predominate in professional service firms who are measuring time invested against return and staff utilization. The trouble with this in the marketing space is that the marketing seeds that are planted today and the time invested today can  sometimes take  a good two to three years to be realized.

You also have a progressive measure.

For Example: You might start working on building up the market to grow a set of standardized lunch and learns, but the first lunch and learn could have a smaller audience than your lunch and learns later in the year. Measuring can take a number of forms.

1) You can measure total attendence.

2) You can categorize and then measure total attendees, such as people who are attending for training credit, people who are interested in a new product, clients who are getting value add from your company, business development connections who will be better referral sources and more.

3) You can measure total number of people invited versus total number of people who attended.

4) You can measure total people within certain titled roles such as CxO vs. Administrative staff.

and the list goes on. One of the things you can't do is easily measure any of the above without the support of some good software tools. Now it is true that you can create numerous Excel spreadsheets, but this is not the best system. In fact if you really thought about it, you could consider using Excel fairly manual.

One of the features that has been built into Microsoft Dynamics CRM is the ability to track an entire campaign. In my example above a campaign could be 2008 Lunch and Learns or it could be configured to focus on one specific lunch and learn event. A campaign tracks all of the different tasks associated with getting this event off the ground, the time associated with any activities, the mailing list or lists of people, the responses from said people and more.

Many firms have not used campaign tracking so I recommend you start small and build up your knowledge as time goes on!