Full Sail Partners Blog | CRM (7)

Posts about CRM (7):

Clean Your Dirty Data and Improve Data Integrity

Posted by Sarah Gonnella on May 07, 2013

Clean Up Dirty Data for Data Integrity, Deltek Vision, ERPNow that Spring has arrived, it is an excellent time to clean-up your database. Is your data clean, consistent, and accurate? Almost everyone you talk to would answer this question with an emphatic "NO" for one reason or another. Data is always degrading in any database you review because information is constantly changing. Contacts leave companies, projects progress, and opportunities move through the sales cycle.

Data integrity impacts our ability to determine business trends, success rate, and just know who and what to pursue. Misleading queries and inaccurate reports result in making wrong decisions when data is incomplete or incorrect. With an integrated ERP system everyone can help with the clean-up, but on the other hand they can sometimes add to the mess. So what do you need to keep in mind when tackling data clean-up?

Clean your dirty data by evaluating these four areas: decision points, standardization, automated clean-up, and dedicated resources.  Let’s walk through an example and apply each of these four areas to project data.

  • Step 1 –  Decision Points: It is helpful to start by doing a search criteria to help make a decision. First, determine what fields need to be cleaned-up and what fields need to be evaluated so you can narrow down the list.  Maybe we want to update the project status to determine if it should be dormant, inactive, or active. Our first criteria could be to search all projects that are active to see how many we need to evaluate. Then we need to narrow the search. Depending on what information you can search, you could do a search on when the project was opened and/or if time has been billed in the past two months.  Understanding your decision points narrows down the list and reduces the number of projects that need to be evaluated.
  • Step 2 – Standardization: Sometimes during the clean-up you realize there are fields or options that are not really needed. This is a great time to establish or re-establish corporate standards and expectations. Is everyone using the same definition? In our example, are you finding employees that are using inactive instead of dormant?  Adding tool tips can provide a definition to help users know how to update the field.
  • Step 3 – Automated Clean-up: Now that you have gone through the exercise of cleaning up the information. Think about how you can update the information periodically or better yet provide an alert to you or employees when they should update the information. Is there a specific timeframe that the status should be evaluated? Workflows can help keep the data accurate. By identifying a trigger, a workflow could alert someone to review the information or even update the status to dormant based on lack of activity.
  • Step 4 – Dedicated Resources: As the saying goes, the information is only as good as the data on which is based. So dedicate the necessary resources to clean it up and better yet, maintain the data. Setting up a quality control schedule and setting expectations helps keep the data clean and manageable.

Does your firm have dirty data? For a fresh clean feeling, take the time to establish your firm’s process to clean it up! By following these four steps, your firm will improve data integrity.

 

Discovery How a Navigational Analysis Can Empower Your Firm. 

Are Forums Just as Good as Top Consulting Firms?

Posted by Sarah Gonnella on April 30, 2013

In keeping up with CRM related forums, someone asked about the best approach to handling and maintaining their CRM system.  It started to make me think about the value of what is communicated in these forums and how much people trust advice from others they believe to be their peers. It made me wonder why people instantly trust others that may or may not have all of the background information that top consulting firms discover when providing their services.  

Top Consulting Firms, Deltek Vision, ERP, Forum AdviceIn this situation, I observed people giving advice as opposed to just sharing experiences.  I found it curious that contributors to the forum assumed many of the variables the person inquiring had not provided and further, the person making the inquiry hoped to find solutions without providing any background or specifics.  

No two companies are alike. Sure there are similarities, but my experience in consulting has led me to believe that if you want a true solution to your issue, you have to take the time to identify the “who”, “what”, “where”, “when”, “why”, and “how” (wwwwwh) questions and the most important question, “What do you need?”.  As the forum conversation continued the inquirer thanked people for their input, but soon added more information as the responses were not really the direction they were looking for.  This occurred to me to somewhat frustrate many of the individuals that had already offered their “advice”.  One such comment was “well if you had told me that when you asked the question.” 

So What Happened?

When we ask a question, individuals drive off of their experience and what worked for them. However, they don’t necessarily provide context of why that worked for them and include those specific reasons. This poses a huge problem to the answers they receive. Many people go directly to wanting a solution without having any true understanding of the context of their question. When the basic “wwwww” are not qualified, the inquirer runs the risk of not addressing their true needs. Even some of the top consulting firms tend to take the same approach with their clients.  In fact earlier in my career I used the phrase, “when I was in industry, what worked for us was…”. 

So why do individuals seek a solution in these forums before building context and clearly defining what they need?  Here are a few thoughts I had on why this may occur:

1)     We seek good ideas from others in the same industry

2)     We crave solutions with little challenge

3)     We need immediate answers

4)     We love FREE advice!

Just like the advice provided by contributors in a forum, consultants sometimes fall into this pitfall of providing quick advice. In order to not challenge a client, consultants may diminish the level of anxiety to both their client and themselves by giving “a solution”.  As a consultant, ready-made solutions give a sense of accomplishment.  But sometimes that solution is short-term because the question asked is out of context of the bigger issue.  Because the question was asked in a vacuum (forum), there is little room for further qualifying discovery. 

Inquiring about what others in industry are doing and or have done allows one to know others experiences.  From this may come ideas that generate further inquiry, but the inquirer should look to put this further inquiry in context of their “wwwww” questions.  The key here is to be able to have these “wwwww” questions already established and to quickly hear the advice against what you already know.  The same preparation should be part of ones working relationship with the consultant. The difference is, one can dynamically interact with a consultant and establish the context.

So an important distinction the next time one works with a consultant: if the consultant is not looking to build the context of your issue, they likely are going to only provide short-term solutions that do not fit well in the long run with your company’s needs. 

Do you have any stories to share about a consultant that applied the “wwwwwh” principals that allowed you to develop a true solution and avoid thinking short-term? Share in our comments section below. 

Deltek Vision Tips: Setting Up Remote Access for Deltek Touch

Posted by Wes Renfroe on April 19, 2013

Vision UnleashedSo, you’ve heard about the new Vision Unleashed, Deltek Touch Time and CRM mobile applications and want your smartphone users to be able to utilize these applications to access Vision offsite. Perhaps you like the idea of your Vision users having the ability to work from home or abroad or maybe you think the new Navigator interface would be really helpful for project managers out in the field.  However, you feel opening up Vision access from the web sounds kind of scary and you have questions. Is it safe? Is it expensive to set up? Is it hard to configure? 

Well, let’s take a look!  

Is it safe?

Yes it is!  When properly deployed using Secure HTTP and a strong password policy, accessing your Vision data from anywhere is as safe as accessing your banking information. 

Is it expensive?

Only in the time to set up (generally an hour or two) and the purchase of a security certificate. The certificate is good for several years and costs only a few hundred dollars. 

Is it hard to configure?

For a single server install the process is simple and can be completed with very little downtime or afterhours with proper planning.  Multi-tier installs offer a bit more complexity and should be discussed to ensure all the nuances are covered before beginning.  Full Sail Partners has assisted many firms with the transition. Feel free to reach out to us for support.  

Here are the steps to open Deltek Vision to the internet to allow your firm access to new features like Deltek Touch.

  1. Configure a Fully Qualified Domain Name (FQDN) that you will use to reach Vision from offsite. ‘Vision.yourcompanyname.com’ is a common format.
  2. Purchase and install a SSL security certificate for your new FQDN on your Vision server.
  3. Modify your firewall rules to allow port 443 (secure http) traffic to be forwarded to your Vision server. Note: This is a good time to try visiting your Vision login page to see if everything is on the right track, in Internet Explorer. Visit HTTPS://Vision.yourcompanyname.com and make sure it loads.
  4. Verify the FQDN is also reachable internally, DNS may need tweaking.
  5. In Reporting Services Configuration Manager, under the Web Service URL tab, add the SSL identities now available since applying the new security certificate.
  6. In the Vision Weblink, on the reporting tab, change the Server URL to your new FQDN/reportserver. For example: https://vision.yourcompanyname.com/reportserver. Note: Be sure to click the Test button to verify you have it right!
  7. Voila! You should now be able to log in from both onsite and offsite and successfully run reports.  Once verified, you can notify all of your users to use the new link for their Vision needs. 

iAccess, Deltek Touch, and Vision Unleashed can now be deployed.  Enjoy safely and securely accessing Vision, anywhere, anytime! Let us know your experience.

Deltek Vision Customization: Past Trends Provide Insight into the Future

Posted by Sarah Gonnella on March 11, 2013

When evaluating your professional services firm, understanding your past trends can provide valuable insight into the future.

It is important to know where you are going, as well as, where you have been. Understanding mistakes and achievements is paramount to truly understanding how to progress your firm. The old adage by George Santayana remains true, “Those who cannot remember the past, are condemned to repeat it.”

Luckily, firms don’t have to rely on people’s memory. There are all kinds of ways to track information. However, having the tools set-up to extract, dissect, and analyze the data is a different story. When it comes to proposals, it is essential to know the Win to Loss Ratio (Hit Rate).

 

In a recent 2012 survey, SMPS Technology Committee reported firms are tracking the following marketing metrics:

56% | Win to Loss Ratio
50% | Client Satisfaction
46% | Marketing Expenditures
39% | Revenue
30% | Sales Funnel/Pipeline
27% | Sales Potential Forecast
26% | Proposal Cost vs. Revenue         Generated
24% | Referrals

In a recent, SMPS Technology Committee survey, only 56% of firms stated they tracked this information, which is surprising. This type of report allows you to evaluate the overall hit rate by the firm, a division, the pursuit lead, or other criteria.  You can also evaluate it by percentage or by revenue.  Knowing both provides you a different story.

Take William Apple, who has a 50% hit rate for the number of projects he has pursued.  He pursued 10 and won 5.  Ann Johnson on the other hand only has a 33% hit rate. She pursued 3 and won 1.  Seems like William is doing better, right?  However, if you evaluate them on revenue, William only has a 24% while Ann has a 73% hit rate.  Why the difference? 

Well, the one project Ann won, was a large project worth millions of dollars.  William however, won a lot of smaller projects and lost out on the bigger project. Both are important to the business.  However, if you start to see that William is constantly losing out on the large projects or maybe particular project types, this type of analysis would be valuable information that could be acted upon.

Key metrics like the Win to Loss Ratio allow a quick snap shot to determine if you need to dig deeper.  The historical progress of an opportunity sometimes provides further clues. 

  • Were you realistic with your expectations?

  • What stage did you lose the opportunity?

  • Did you have an established relationship and effective pursuit strategy?

Is your firm able to answer these questions or are you repeating the same mistakes? Let us know how your firm learns from your success and failures and how your firm is improving your hit rate by leaving a comment. Interested in more historical trends information?

Deltek Vision How-To: Info Center Help

Posted by Sarah Gonnella on January 10, 2013

Welcome to our first Deltek Vision How-To Video Series. Today we will learn about Deltek’s Vision Info Center Help section. This video will answer some common questions asked by clients are:

  1. Do you have a complete list of the fields in Vision?
  2. Do you have a help guide so I can learn about the fields available?

   

Check out additional how-to videos by clicking here. 

Deltek Vision Tips: Workflow for Modified User

Posted by Sarah Gonnella on December 21, 2012

It looks like the world will not come to an end! So back at it campers. Let's learn some quick tips about Deltek Vision.

As the first of our Deltek Vision Tips & Tricks Series we would love to hear if you find the information helpful. Recently I came across a question about how to know who modified a record. Of course the audit reports can provide this information, but there are two easier ways to get this information.

In every info center you can hover over the name of the record at the top of the record. It will tell you who created the record and on what date. Additionally, it will tell you who last modified the record and on what date. So in the image below for item #1, the mouse is hovering over the word Paul A. Collier in blue. If you need to know what field was modified then you would need to run an audit report.  

Deltek Vision Record Audit Trail

 

 

 

 

 

 

 

Additionally, you could set-up a field that displays who modified the record. This is accomplished through a workflow. First create a new character field. (Note: An employee field will not work.)  In this example it is named Modified By.  See image item #2 above. 

Then set-up a User Initiated Workflow. Choose the Application, which in this instance will be the Contacts. Click Insert on the Workflows grid. The Workflow Table will be Contact Record and the Workflow Type will be Change. This simply means every time the contact record is changed, the workflow will trigger.

User Initiated Workflow

 

 

 

 

User Initiated Workflow Contacts

 

 

 

 

 

 

 

Now on the Actions grid click Insert to add an action. Choose Column (Field) Change for the Actions column. Next, choose the field to update. In this case it is ContactCustomTabFields.CustModifiedBy.  Then set-up a SQL Expression. The expression is simply, a field that already exists: [:Contacts.ModUser]. Find that code and click Add Column. Then click Save. Be sure to add descriptions so you know what the workflow is related to and then Save the workflow. To test it, change something on a Contact record. You should see the users login name filter in.

Column Field Change

 

 

 

 

 

 

Column Field Change SQL Expression

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Check back in 2013 for new blog entries related to Deltek Vision tips. Let us know if you learned something new by leaving a comment. Wishing you a wonderful 2013!

 

What Singer Adele and Business Building Strategies Have in Common

Posted by Sarah Gonnella on September 07, 2012

marketing campaigns, Business Building Strategies, Measuring Return on InvestmentAnyone that knows me, knows I love music and sing karaoke.  I was learning one of Adele’s songs and listening to the lyrics: “Should I just keep chasing pavements, even if it leads nowhere?” I started thinking about the things we chase in our own life that lead nowhere. Even though this song by Adele is referring to love, it really can apply to pursuing business or ways to grow business.  Does your firm have a way to analyze if the business you chase is leading anywhere?  Better yet, do you know what efforts are paying off?  Below are things to consider when evaluating the effectiveness of your business building strategies:

Are You Chasing the Flavor?
A recent client described that each week they discuss the potential business everyone is pursuing.  However, each sequential week everyone was chasing the flavor of the week.  She had no idea what happened to the previous week’s pursuits and if anyone was even following up until she received a proposal request.  To avoid chasing the flavor and ensure your firm is following-up on all opportunities, consider these steps:

  1. Document All Stages with Action Items: You don’t need a proposal to document the opportunities you are pursuing.  Even if business is in a discovery or assessment phase, documenting these efforts with actions items can remind you to follow-up. 
  2. Identify Trends and Outstanding Items: Using an integrated system allows marketing and executives to track the progress of the entire company through reports to identify if there are trends or items that are outstanding.
  3. Administrator and Automation: Identifying someone to administer and review your pursuits is critical to ensuring progress. Also look at ways to automate alerts to remind you when you should follow-up.
  4. Win/Loss Report: It’s important to know how successful you are. Knowing the history of past pursuits can help future go/no-go decisions and improve your win rate. By developing a win/loss report and evaluating how successful you are by department, opportunity champion, and the type of project can help you make better decisions in the future.

Are You the Nurturing Type?

Many of us attend events, are a part of an organization, and are involved in business development efforts in hopes to nurture business.  However, most individuals and firms don’t know the effectiveness of their efforts.  To ensure your firm is making good use of your time, consider these steps: 

  1. Network vs. Attend: Not every event you attend will result in business.  There are many reasons to network.  However, showing up to an event doesn’t equate to networking. After attending an event log who you talked with. What did you discover about the individual and what was important to them?  Think about how you might follow-up with that individual. Maybe there is a subject they are interested in, someone they want to meet, a project they are working on, or you found out something about their personal life. How can you use your knowledge or connections to follow-up?  Social media is making it easier to connect with people and stay up-to-date with their changes. Be sure to personalize your request.
  2. Get Involved: If you are a member of an organization, take the plunge and be active.  Think about your audience when you chose an organization and then get involved in a committee, the board, or become a speaker. Volunteering can help you gain exposure, connect you with decision makers, and allow you to demonstrate your expertise. Joining SMPS was one of the best decisions I could have made for my company and career.
  3. Return on Investment: We all tend to hear the phrase, measuring Return on Investment related to effectiveness of business efforts.  Another way to look at ROI is ask yourself, if you had to pay for the marketing or business effort out of your own money, do you think it would be worth the effort?  A great way of looking at the marketing effectiveness is to track the time you spend toward business development efforts and compare it to the business you obtained from those efforts.  When you compare the expense vs. the business you received, was it worth the effort? Sometimes efforts take months or even years to pay off. So to determine trade show ROI or events that happen on a yearly basis, allow two years to determine the effectiveness. 
  4. Building Business: Most people look at clients as Existing or New.  I would challenge you to look at them as one of three categories: Prospective, Nurturing, and Maintenance. Prospective clients are those you want to do business with, maintenance clients are those you continue to do business with, while nurturing clients are those you’ve done business with or have recently received business from.  Your message and how your firm will gain business from all categories will vary. Keeping in mind that it is seven times easier to maintain an existing client than is to go out and get a new client; moving clients to the maintenance category is the goal.  So where should you spend your time and how do you know when you are effective?  First you need to define what justifies a maintenance client.  Is it the number of projects or dollar amount over a period of time?  With an integrated database system, your data can trigger when the criteria is met and send out an automated report.  This information informs “Client Champions” and executives when client business increases or decreases and provides marketing with insight for nurture campaigns.

I hope my inspiration from Adele will help your firm build business and avoid chasing pavements. Let us know what inspires you and what your firm does to ensure growth. View our webinar: Get the Most from Your Conference.

Latest Posts