Random Dynamics CRM help phone call

I just got off the phone, and I don’t even know who I was speaking with but I saved their CRM, or so they tell me.

Here’s the story…

Folks around my office are pretty good about gatekeeping and eliminating random sales calls.  I was in a meeting and the phone rang.  They told Joy when she answered the phone that they were in CRM crisis and had credit card in hand to pay whatever they needed to to get right again.  I don’t know how they found me or our company.  But ok, they had my attention, not sure what I could do, but hey give I a try.

Their CRM Online org had some 4000 Account records currently divided between two salesmen, both CRM users.  They had been assigned to a total of four at some point but were now down to the two.  The guy on the phone was not exactly sure what he did or how he did it, but he managed to accidentally get all 4000 accounts assigned to himself.  He wanted the do-over button.

CRM 2011 came with limited undo/redo edit options, but that wouldn’t help here.  Having no clue how he managed to re-assign all the records, I was going in pretty much blind.  Let’s look at auditing records, if there’s data, maybe I can workflow it backward.  Nope, auditing turned off.  Ok, let’s look at system jobs.  Nope nothing there.  So, maybe we could revert ownership via workflow to the record creator, then mass re-assign like that had already done previously.  Nope, records were created by system user when imported from old system. 

Then I get my epiphany and kick myself for taking the hard way.  Let’s do an Advanced Find on all accounts modified today.  Yup, the results were about the same number of records that had been accidentally changed.  Now it was a matter of select all->assign to that user.

There are two morals of the story…

  1. know what you are doing in CRM, and slow down when doing things that have far reaching effects like re-assigning all records
  2. when troubleshooting try the easiest solution before you try the hardest

Now they have a little clean-up of records that were modified in others ways beside ownership but that would be fewer than 25 out of some 4000.

Joy thinks she might know who was on the phone, but I still don’t.

Previous Post

Are insults protected speech?

May 27
Today I came across two stories that made me go, hmmmm. First story is of an American jailed for insulting a king in Thailand, story here. Dude is up for 15 years in jail. Yes, can you say outrageous? (I’d...
Next Post

Social CRM has nothing to do with CRM

Jun 28
Yup, that’s right. If Social CRM has anything (IF) to do with CRM it I secondary at best. Any social strategy is about the message, not about the software. I keep hearing people asking about social CRM and I have...



You're a hero!

I had a client call me recently with a Google crisis. Their previous IT guy had set up all their Analytics Accounts under his own Google account. Then he left the company. So they conscientiously deleted all his user accounts, and zap -- bye-bye analytics, all history, everything.

I was asked if there was anything I could do to fix it. Unfortunately, since Google didn't make any mistakes, the answer was no.

I did help them set up a new analytics account, this time under googleadmin@(companyname).com instead of any one person.

Tough lesson to learn.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)