IMG
IMG Home
Skip Navigation Links
Blogs
Richard Knudson
Eric Skaggs
Go Search

 

The Information Management Group, Inc. > Blogs > Richard Knudson
Blogs by Richard Knudson

 Richard Knudson's Dynamics CRM Trick Bag

Tips, tricks and traps for people who use, install and customize Dynamics CRM

 

Subscribe to the Trick Bag: RSS Feed

I'm the president and founder of IMG, and spend a lot of my time thinking about how businesses can improve their ROI on their IT investment. Lately I've been almost exclusively focused on the so-called "front-office" functions like sales, marketing and service -- in short, on CRM. Dynamics CRM, more specifically, and even more specifically on Dynamics CRM 4.0. My blog has reflected that focus and since every blog worth its salt has to have a name, that's what I decided to call mine. I hope some of the things I post on make it into your personal bag of tricks for Dynamics CRM 4.0 -- let me know if you find them helpful!

Richard Knudson
richardk@imginc.com 

Technorati Profile Add to Technorati Favorites
New Recordings, a New User Group, SharePoint Online

New Recordings, a New User Group, SharePoint Online

A delightful week in Edina, and new higher-quality recordings

I spent the week in Minneapolis doing another round of Dynamics CRM 4.0 bootcamps. We’ve had smaller groups lately than we did last year, and this week’s sessions held true to form: 6 in Applications, 3 for Installation/Deployment, and 7 for Customization/Configuration. I’m not sure if our low attendance is from the lousy economy or the fact that the classes are so hard to find on the MS Partner Learning Center. In any case, I thought the sessions were excellent, but then again I always like my own sessions!

I’ve started recording all of the classroom sessions I do. I use a tool called Camtasia and a new release just came out. Those of you who’ve taken the Customization class and have access to the class on the Student Portal will have a chance to appreciate the quality improvement of the new recordings I’ve just posted. In terms of production quality they are MUCH better than the recorded E-Live sessions, for which I use the Live Meeting recording tool. Camtasia is designed for recording and producing things like this, and Live Meeting really isn’t. Anyway, I rolled them out first for Customization and Configuration, so if you’ve got access to that classroom, let me know what you think.

If you don’t have access, you can buy a self-paced version of the class; we refer to it as a “SkillPack” and you can find information about it here.

Here’s an example of the new recording style exposed so anybody can get to it. It’s on one of my favorite topics in Dynamics CRM 4.0: creating custom entity relationships. CRM 4 has some important new features in that area, and in the demo I use them as illustrations. My son Jack thinks things like system-to-system, many-to-many, and self-referential entity relationships are boring, but I hope you find them interesting:

Dynamics CRM 4.0 Custom Entity Relationships – PowerPoint Presentation
Dynamics CRM 4.0 Custom Entity Relationships – Demonstration

A brand-new Dynamics CRM 4.0 Users Group, first meeting 12/18

I first posted information about a new Dynamics CRM User Group on my blog about a week ago, and judging from the response so far (15 registrations) we’ll have a pretty good turnout. I’ve always liked user groups and I think our new one will be fun and interesting. You can provide some guidance and help us figure out which topics we should cover by taking the online survey. It takes less than five minutes, plus it’s a SharePoint 2007 survey list, and who wouldn’t want to fill out one of those!?

And we’re going to try a “blended” approach to user groups: you can attend in-person or online, so when you register let us know how you want to attend, and for online attendees we’ll send out Live Meeting information prior to the meeting. But remember: Live Meeting attendees don’t get my home-made egg-nog.

More Software as a Service – now SharePoint!

If you’ve read many of these posts or heard me present, you’re probably aware of my enthusiasm for hosted software – often referred to as “Software as a Service”. I really think that for a broad segment of the market, the benefits of not having to invest in infrastructure and maintenance will outweigh the costs of a hosted solution. Dynamics CRM Online has been out since last spring and in my view is ready for prime-time, certainly for our small to medium sized customers. It’s now joined by the Business Productivity Online Suite (BPOS), which consists of SharePoint, Exchange and Live Meeting. You can find out more here, and sign up for $15 per user per month for the Standard BPOS version.   

For most of our Dynamics CRM and SharePoint customers, the tradeoffs of the hosted model will be in three areas:

1.       Feature limitations of online. Take CRM as an example: the basic limitation is that you can’t put files on the online server (where is the server?). So there are some customization techniques --   custom RS reports, server-based ASPX files, plug-ins – that don’t work (yet) for the online version. Doubtless SharePoint Online will have some of those as well. I don’t know them well enough yet as we’ve just signed up for our account, but I’ll let you know what I learn.

2.       Data location issues. There will be organizations that either need their own data on-premise for backup, integration, or other purposes; or, that simply can’t get past storing proprietary data outside their firewalls. There’s definitely a leap of faith that takes place when you start storing your customer data “in the cloud”. My guess is that leap gets smaller and smaller over time, but for many people it’s still an issue.  

3.       Scaling costs. I won’t go through an extended exercise in server license and CAL costs here, but if you’ve got 5,000 users, you’ll probably pay more at $59/user per month with Dynamics CRM Online than you would for on-premise. Clearly you’d want to compare apples:apples and see what your discount would be in both models, but generally speaking, the “rental” model of online will compare less and less favorably to the “purchase” model of on-premise, the more users you have.

Anyway, with my company’s strategic focus on Dynamics CRM and SharePoint, I’m glad that SharePoint is now available in an online (in MS-speak, “Software plus Services”) version. I think a lot of our customers are going to like the online option, and a big part of the services we offer will be to help you decide which is your best option, and to help you get there!

Richard Knudson
richardk@imginc.com

Brand-new Dynamics CRM User Group
Dynamics CRM User Group: first meeting December 18
 
I've always liked user groups. They're fun, plus they're a great way to learn from and network with people who have some common interests. To me it appears that the Chicago market is underserved when it comes to Dynamics CRM, so I thought we ought to start up a new group for Dynamics CRM. You have to be able to pronounce a user group, so I tentatively propose "dikermug", for "Dynamics CRM User Group". We could go with "shydikermug", for "Chicago Dynamics CRM User Group", but that seems a little longish.
 
Anyway, I've got to get to day 2 of the Applications bootcamp delivery here in lovely but cold Edina MN before the students do. Just wanted to get this out there first. Here's a link to the announcement page... and you can even attend online, so check it out even if you aren't from Chicagoland.
 
Richard Knudson
 
  
The Case of the Missing Assessments
Where did those Darned Dynamics CRM Assessments Go?
 
For about the last six months, I've concluded most of the Dynamics CRM 4.0 training and certification bootcamps I've conducted with a group walkthrough of the assessments that have been available on http://learning.microsoft.com  I put up a bunch of blog posts about those assessments, how to find them & so forth, made recorded versions of these walkthroughs that we link to from various places in the site and in the blog posts. I've made the point repeatedly that while these assessments aren't great...they are good, and if you want some practice answering test questions before you take the actual certification exams, they're the only game in town.
 
So what happened to them? Over the last few days I've been getting pinged by a bunch of students wondering where they went...and sure enough, if you go up to http://learning.microsoft.com, where you used to be able to click on the "Assessments" link on the quick launch bar (underneath "Learning Resource Types"), now you don't see them anywhere.
 
Yikes, I thought -- what am I going to do in that last hour or so of class? So I pinged my friend Todd at Microsoft Learning and I was relieved when he emailed me back that they're still there. (Phew -- I don't have to come up with another hour of presentation!)
 
I'm not sure which principles of UI design influenced this particular redesign, but here's the deal:
 
If you don't mind navigating, click the "Learning Plans" link. Then enter "dynamics crm" in the search box, and click Go. Then you'll see the 3 Learning Plans for our three favorite Learning Resource Titles (although I never thought of them like that before!).
 
So, click on the one you need -- Applications, Customization and Configuration, or Installation and Deployment -- and then finally you can click "Take Assessment".
 
OK, so they're still there. Just way hidden. Lousy UI design if you ask me. The assessments now only exist in the context of a learning plan, even though most people I know come to these assessments after their learning plan's already just about complete. But anyway, at least they're still there! 
 
To navigate more directly, try this:
 
 
Cheers --  and have a fantastic time taking those assessments!
 
Richard Knudson
 
     
 
 
 
Dynamics CRM 4.0 Accelerators have Arrived

There’s been discussion of these so-called Dynamics CRM Accelerators for some time, and now the first three are released! These are:

  • Event Management 
  • Notification Services  
  • Extended Sales Forecasting

Here’s the page on codeplex that has info about them: http://www.codeplex.com/crmaccelerators

If you want to go straight to the downloads page, here it is: http://www.codeplex.com/crmaccelerators/Release/ProjectReleases.aspx?ReleaseId=19132

I haven’t worked with them much yet, but I got enough of a start on the Sales Forecasting one to get the main idea. After downloading and extracting the files, you can run a Setup.exe if you want to, but it doesn’t really do anything other than explain what to do. The real action (at least for the sales forecasting accelerator) is in the customizations.xml file that you’ll import (Settings/Customization/Import Customizations…) and then publish. It includes a couple of custom entities that let you enter goals for various sales users. (You must have fiscal years turned on to take advantage of this, apparently.) There are also some custom reporting services reports (rdl files) that you can import.

As I said, I haven’t actually worked with it yet, but I get asked about these a lot so I thought I’d post re. their availability. I’ll put some more detail up on this after I work with it some!

 

Richard Knudson
President, The Information Management Group
www.IMGinc.com

 

Streamline Dynamics CRM Data Entry with Workflows
Streamline Dynamics CRM Data Entry with Workflows
 
Processes are to workflows what quarterbacks are to football: they get all the glory. And in Dynamics CRM, it's often entities like Opportunities and Cases that will have complex multi-stage business processes implemented as a workflow.
 
But workflows can provide yeomanlike, behind the scenes functionality as well, such as bulk data updates where you need to update certain fields depending on the existing value of other fields, or where you need to copy data from existing rows in one entity to new rows in another.
 
Another example of this utilitarian type of workflow is when you want to streamline data entry for new records. This will really work for any entity in Dynamics CRM, but the example I go through in this new video I just posted has to do with the Account entity.
 
The example has some interesting characteristics:
 
  • Updates the Territory value based on what the user enters for zip/postal code
  • Illustrates a good use of Stages in CRM 4 workflows, to organize your workflows and make them more readable
  • Illustrates conditional processing based on the Account Category value selected. In particular, it shows how you can use a CRM Queue to assign accounts on a first-come first-served basis, even though you cannot assign accounts to queues in CRM.

Anyway, here you go: Account Setup workflow recording

I hope you find it useful...and if you do, it's taken from our Building Workflows SkillPack, a subscription to which gets you the book I wrote on workflows, and access to the online site where you get content updates, full recorded content, plus bi-weekly live Q&A sessions with me. And who wouldn't want that! :-)

Richard -- richardk@imginc.com
11/3/2008

Use a Workflow to Audit CRM Opportunities
Use a Workflow to Audit CRM Opportunities
 
Out of the box, Dynamics CRM doesn't maintain a history of records such as Accounts, Contacts, Opportunities, Cases and so forth. Every entity has these four fields:
  • Created On
  • Created By
  • Modified On
  • Modified By

But those are snapshots: Created On and Created By never change, and the "modified" fields just contain information on the last change.

There are various ways to maintain a history of changes -- an "audit trail" -- and the easiest is probably with a workflow. In the example I demonstrate here, I show you how to create an audit workflow on the Opportunity entity, specifically to create a history of deleted records. If you've ever had a situation where somebody accidentally -- or on purpose! -- deleted a bunch of opportunity records, the utility of a workflow like this will be very obvious!

The technique I use in this demonstration is to create a custom entity -- I call this one "Opportunity Audit" -- and write out a record to it when specific things happen to an Opportunity record. You can do this with an Automatic workflow, using triggers to define what those "specific things" are you want to audit. The triggers you can work with in Dynamics CRM 4.0 workflows are richer than in 3.0 -- in particular, you can now trigger a workflow when any field on a record changes, and when a record is deleted.

This last point -- the "record is deleted" trigger -- is what you'll wish you had known about the first time you're on the hook for a bunch of important records that got ... uh, inadvertently deleted!   

Here's the Opportunity Audit workflow demonstration -- I hope you find it useful.

 

This is taken from Chapter 4 of the Building Workflows in Dynamics CRM 4.0 book and SkillPack. Find out more...

Special Halloween Lead Assignment Workflow
Special Halloween Lead Assignment Workflow
 
I wanted to do something topical, so I came up with a workflow that's got a trick...plus, it's a real treat! OK, I'm stretching a little, but I like it and I hope you find it useful. 
 
Suppose you want to assign leads on a "first-come first-served" basis to a team of sales reps. If you're familiar with Dynamics CRM, you might wish you could assign a Lead record to a Queue. Unfortunately, you can't do that in CRM -- only Cases and Activity records can be assigned to a Queue.
 
Watch this video to learn how to use a Dynamics CRM Queue to assign Lead records, and how to build recursive workflows to "looping" types of processes.
 
Check out the special Halloween Lead Assignment workflow.
 

This is taken from Chapter 4 of the Building Workflows in Dynamics CRM 4.0 book and SkillPack. Find out more...

Google Map in an IFRAME
Google Map in an IFRAME
 
Recently I delivered a private bootcamp for a consulting firm, and one of the students in that most excellent group embarassed me by finding a piece of information on my own site that I couldn't find! It turns out she was authenticated on our Student Portal and this little nugget was a locked-down announcement on the portal. I was anonymous at the time and it wasn't exposed outside. A little too well-hid, I thought to myself, so I re-used it for a blog post.
 
here's the orignial post, from April of 2008: 
 
I'd been close on this a bunch of times but kept getting a script error (something like "GMap Application undefined..."). But then in San Francisco, Glen Willson of Millenium Systems showed me this code snippet that actually works! Here's the note from Glen (with working jscript):
 
 
This is how I did it:  Made a new tab with an iFrame, added a custom bit value (yes or no radio buttons) called "shmap" and added this code as an onchange event.  Enjoy!!  ...and don't forget my credit on the web page!
 
if (crmForm.all.address1_postalcode.DataValue != null){
crmForm.all.IFRAME_gmap.src = "http://maps.google.com/maps?q=" +
crmForm.all.address1_line1.DataValue + "+" + crmForm.all.address1_city.DataValue + ",+" + crmForm.all.address1_postalcode.DataValue;
}
else
{
crmForm.all.IFRAME_gmap.src = "about:blank"
}
 
*******
 
There you have it. Thanks Glen -- you rock!
Four perfect days in Phoenix, three new CRM videos
Four perfect days in Phoenix, three new CRM videos
 
Last week saw me in Phoenix for another round of Partner Academy Dynamics CRM Bootcamp deliveries. When I wasn't enjoying the weather, watching MLB playoffs on TV or the latest stock market gyrations, or  I took advantage of some of my hotel-room time to record some videos on topics that come up a lot in the sessions.
 
Here are links to three of them -- let me know if you find them useful, interesting, or otherwise!
 
 
 
 
Richard -- richardk@imginc.com
 
 
Internet Marketing in Dynamics CRM Online, Part 2

Internet Marketing in Dynamics CRM Online, Part 2

 

I made an initial post on this topic a couple weeks ago; now that I've had some more experience I'll give you some more details, what I like, what needs work, my $.02 on what could be improved.

How it’s implemented

Settings/Business Management has a new link, Internet Marketing, where you go to request activation. When you request activation, you actually have to use an additional account. If you’ve got extra (unused) accounts, it will create one for you – “Internet Marketing User” – but if you don’t, you actually have to add a new user. You have to pay for the user, too, but they end up crediting the monthly fee against anything you spend on advertising. So…unless you’re planning on actually spending some advertising dollars, don’t activate!

Once you activate, you create a new Campaign, and there’s a new Campaign Type: “Internet Marketing”. Select it and save your campaign, and things get different.

What’s different about this new Internet Marketing campaign type?

There’s only one kind of campaign activity: unlike in a normal campaign where you add various kinds of campaign activities and then select a channel for each one, in an Internet Marketing campaign the only kind of campaign activity is an Internet ad campaign.

When you create and then edit that campaign activity, the UI is outside of CRM. It’s essentially a wizard UI that goes up against the MS AdCenter site, where you can create Ad Groups and Ads, bid on Keywords to drive traffic for your campaign, and create the landing pages those keywords will drive traffic to. Here’s what you see when you  

After you create a campaign activity (set up your ads, purchase your keywords, create the landing pages and point your ads to those landing pages), then you’ll see new links from your campaign form: under Marketing you’ll see Landing Pages, and under Sales you’ll see Internet Leads. When somebody sees your ad, clicks on it and goes to the landing page, fills out the form and clicks submit, they become an “Internet Lead”. What you do is review these incoming Internet Leads, select the ones you want to import, and import them. Once you do this, they become “real” CRM lead records.

What’s good about it?

It integrates directly into your CRM Online. One of the best things about it is how easy it is to set up very nice looking landing pages. Lots of marketing and sales managers don’t necessarily have the savvy or permissions to create their own landing pages, but in the MS Internet Marketing model, you use a template-driven approach to create pages that CRM Online will host for you, so it’s pretty easy.

If a lead comes in from an Internet Ad associated with your campaign, it is automatically associated with the campaign as a campaign response. So if you ultimately convert it to an Opportunity and close it as a sale, you get real closed loop marketing and can measure campaign ROI.

If you don’t have lots of (or any!) experience with purchasing Google Ad Words or MS Ad Center keywords, the “direct from CRM marketing campaign” UI presented in this approach gives you an easy entry into Internet Advertising.   

What’s missing?

Currently the only kind of campaign activity that gets you the “closed loop” marketing functionality is a real Microsoft adCenter ad.  You can drive traffic to your landing pages from anywhere – your own web site, Google ad words, an email campaign – but if you use any of those non-adCenter approaches you don’t get any tracking back to the source. All you get in any of those cases is a lead record that has a Lead Source value of “Internet Marketing”. It doesn’t create a campaign response record, and there doesn’t seem to be any way of telling (from with CRM Online, anyway) where it came from, which landing page they went to, or anything else.

The integration with adCenter is incomplete. For example, you authenticate to your CRM Online site with a Windows Live id. And when you edit your campaign activity from within CRM Online you can do it without authenticating again, with your Windows Live id. But if you go into adCenter and try to use your Windows Live id…sorry! You have to create another account specifically for adCenter. Just what you need: another user name and password to remember!

You can only create three landing pages, and each landing page you create is associated with every one of your Internet Marketing campaigns! So at first I thought I could get around the “adCenter” only restriction by having different  campaigns, each with their own landing page…but that doesn’t work.

How could it be improved?

Let you create your own Landing Pages, as many as you want, and each one creates its own Internet Lead records. Essentially, there should be a Landing Page entity, and an Internet Lead entity, and a 1:N relationship from Landing Page to Internet Lead.

If this worked, you could create campaign activities independently of the landing pages, and simply point your ads to landing pages, or include links in your emails or from web pages, etc., to those landing pages.

Then, if you could add a Landing Page record to a Campaign (1:N from Campaign to Landing Page), any submit from a Landing Page could be recorded as a Campaign Response. This would be the way to go! This would let you do a very general Internet Marketing. Or maybe better yet would be to have a 1:N from Campaign Activity to Landing Page. This way, you could have campaigns with something like the following structure:

·         Campaign Activity 1: AdCenter ad

o   Links drive traffic to Landing Page 1

·         Campaign Activity 2: Google ad

o   Links drive traffic to Landing Page 2

·         Campaign Activity 3: Email blast

o   Link 1 drives traffic to Landing Page 3

o   Link 2 drives traffic to Landing Page 4

o   Link 3 drives traffic to …you get the picture

With this structure, you could have submits from those landing pages create Campaign Response records, each of which could be tied to everything you need: the campaign, the campaign activity, and the specific landing page they came from.

In Summary

It’s a great start…but needs some work to really give you full-blown and flexible closed-loop Internet marketing. I guess the primary limitation is that it forces you to treat an Internet Marketing campaign as a standalone thing, rather than integrating Internet marketing with the rest of your marketing activities.  

Richard Knudson -- richardk@imginc.com

1 - 10 Next

 ‭(Hidden)‬ Admin Links


Build Workflows with Dynamics CRM 4
To get the most out of Dynamics CRM 4 you need to know workflows! IMG's new SkillPacks are a great way to learn at your own pace, and our Building Workflows SkillPack is available now! 

Find out more...

CRM 4.0

 

Microsoft Gold PartnerTwenty Years of Skills and Solutions on the Microsoft Platform
Call today to ask us anything you want, using our brand new toll-free 866-940-4464 Copyright ©2008, The Information Management Group. All Rights Reserved.