CRM Software Logo

Microsoft CRM experts provide reviews, comparisons and opinions to professionals in the CRM software selection process

 
 
Anya Ciecierski, CAL Business Solutions, Inc.

How to Quickly Pull Marketing Statistics from Microsoft Dynamics CRM for Your Next Sales Meeting

Email | Print

Less than 24 hours before a big sales meeting my boss told me he wanted me to report on our marketing statistics for the year to date.  Yikes – what is an overworked, overstressed, marketing manager like me to do! Two years ago I would have been up all night trying to come up with statistics I needed for the meeting.  Good thing we now use Microsoft Dynamics CRM!

With Microsoft CRM I was quickly able to get these reports ready in about an hour:

  • # of leads received – total year to date, and broken out by month.
  • # of leads received from each marketing activity – such as telemarketing, direct mail etc..
  • % of leads that turned into opportunities and sales
  • % of leads from each marketing activity that turned into opportunities and sales.

Plus I was able to compare all this information with the same time period from last year.

The information is tracked in CRM, then I can easily export it into Excel to do subtotals and analyze data.  Then I can make it easier to present in graphical charts. (My strategy in meetings has always been to dazzle people with the fancy pie charts).

Based on the statistics I pulled out of Dynamics CRM, our sales team could figure out helpful trends such as:

  • Our average close rate when selling Microsoft Dynamics GP accounting software.
  • What times of the year are our “slow seasons” for new sales. (so we can plan vacations)
  • What marketing activities are generating not only the most leads but also the most closed deals. (so I know where to spend my marketing budget)

I truly believe that information is power. And having the information at my fingertips has not only empowered our organization and my marketing efforts – but now I can get much more sleep too!

By CAL Business Solutions, Connecticut Microsoft Dynamics GP Partner

Email | Print

Ask The Author

Related Posts

  1. Sales And Marketing Work As A Team With Microsoft Dynamics CRM
  2. Maximize Revenue by Aligning your Sales and Marketing Teams Through Dynamics CRM
  3. Unleashing the Marketing Power of Microsoft Dynamics® CRM Part 2: Feeding the Sales Pipeline and Tracking Marketing Results
  4. Effective Customer Segmentation Helps Move Sales Quickly Through Cycle
  5. The Different Spectrums of Microsoft Dynamics CRM: Sales, Marketing, and Customer Service

2 Responses to “How to Quickly Pull Marketing Statistics from Microsoft Dynamics CRM for Your Next Sales Meeting”

  1. [...] Related posts:How to Quickly Pull Marketing Statistics from Microsoft Dynamics CRM for Your Next Sales Meeting [...]

  2. This is a good piece of content, I discovered your web site researching yahoo for a related topic and came to this. I couldnt get to much other info on this article, so it was pleasant to find this one. I will end up being returning to check out some other articles that you have another time.

Ask This Expert a Question / Leave a Comment

 

 
 

Switch to our mobile site