« May 2008 | Main | July 2008 »

June 2008

June 23, 2008

7 Best Practices to ensure Sales and Marketing Funnel Integrity

Last week we launched a new Demand Generation campaign that ran into a minor hiccup prior to launch. None of the Leads we were capturing were getting published to Salesforce.com. Upon troubleshooting we found out that there was a data type mismatch between a field we were capturing in marketing and the corresponding field in Salesforce.com. Our marketing process was asking for a range of values for Annual Revenue:

  • $1 million to $50 million
  • $51 million to $250 million
  • $251 million to $500 million
  • $501 million to $1 Billion
  • > $1 Billion

But Salesforce.com expects Annual Revenue to be a number field on the Lead object in Salesforce.com. One of our new operations team members made this change without knowing the constraint on salesforce.com. Fortunately, our system allows us to have one set of values that a Prospect sees on a Landing page and another set of values that can be published to Salesforce.com. We were able to quickly fix the problem and launch the campaign.

Broken_link

This is one of the many process and data related issues that can break the integration between marketing and sales funnels. Here is a list of best practices that we have built over time to ensure that the integrity of marketing and sales funnels is always maintained.

Guaranteed Delivery - Ensure mandatory information is always captured: Most SFA systems require a few fields to be always filled in. For example, in Salesforce.com the default configuration expects Last Name and Company Name to be required fields. Most companies make modifications to this default setting and might add more fields to the list. Some typical fields I have seen are Email, Work phone, Job Title, Time frame, Budget among others. Marketing processes might or might not be able to collect all the required information from online and offline interactions. In such cases ensure that there is always a default value that the system can assign to these fields. For example, at Market2Lead we assign a default value of 'noemail@market2lead.com' for email, 'UNKNOWN' for Budget. This will ensure that Leads are propagated to the SFA process.

Appropriate Assignment - Ensure Lead's get assigned to the right sales rep: The one process misalignment that I am very cautious of is broken lead assignment rules. I have seen a few instances where customers find hot leads that require timely follow-up are stuck in some administrator's queue because the lead assignment rules were not triggered appropriately. Marketing processes should ensure that data values that trigger lead assignment rules are always in synchronization between marketing and sales systems. If the sales process uses geo based routing then check whether the rules are based on ISO codes or full names for states and countries. If the routing is more complex like a combination of geo information and product mix then ensure that along with geo values the product names match between the sales and marketing systems. At the end of the day administrators of marketing and sales systems need to keep their systems in sync to ensure Leads end up in the right rep's inbox.

Provide Progressive Intelligence - Search before creating a new Lead: One of the goal's of Lead Nurturing is to keep the sales reps' abreast of marketing activities and their Lead's response to these activities. This objective is defeated if the marketing system is not incrementally updating the Lead record that the sales rep is looking at and instead creates a new record for every interaction. Marketing systems should always search for an existing Lead in the sales system before creating a new Lead. If a match is found the existing Lead should be updated. The search and merge criteria has to be robust too. Here are a few things to keep in mind:
    a. Email is not a water tight method to detect existing Leads. In fact, reps rely on phone numbers more than emails. So, the detection process should be sophisticated to include a combination of multiple checks like email, first name + last name + company name, first name + last name + work phone among others.
    b. *NEVER* update key fields in the sales process without a rep's permission. Marketing systems are good at collective basic information through online interactions but are not always the most reliable method to capture critical fields like phone number. Imagine the plight of a sales rep if you update a real phone number with a bogus number like 111-555-1212 that marketing collects from an online form. marketing should work with the sales team and identify fields that can be automatically updated and fields that require a sales rep's manual oversight. In the second case it's a good idea to publish new information to the comments field and allow the rep to make appropriate changes.      

Align with Sales Follow-up Process - Make it easy for reps to access marketing Leads: Sales reps like to spend as much time as possible selling (and rightfully so). Therefore, it is the responsibility of the operations team to support the sales team by making it easy for them to access Leads from SFA systems and also minimize any change to the way they are used to interacting with these systems. Marketing might be providing top quality Leads to the sales but will not be assured of appropriate follow up if they make it difficult for the reps to access these Leads. Before setting up an automated Lead
delivery method marketing teams should familiarize themselves with the method/methods sales reps use to access Leads from the sales system. In Salesforce.com I have seen different methods being used. A couple of examples are:
      a. Rep based views: Sales rep's have their own views setup and they look for new Leads within this view. In some cases the filter criteria for the views is standardized across the organization and in other cases it varies by territory, product line or other criteria. Get a holistic view of how these view's are structured.
     b. Dashboards with alerts: In other cases I have seen sales organizations use more sophisticated dashboards that have a combined view of Leads, events, tasks, alerts and Initiative based follow-up procedures. Get an understanding of how these dashboards are setup. 

Ensure Timely Follow-up - Ensure sales reps are sent alerts when Leads respond: It is always a good idea to alert the sales team when marketing is able to generate a response from an existing Lead or generate a new Lead that requires timely follow-up. Get a good understanding of how the sales team is setup before coming up with an alerting scheme. For example, in some organizations all follow-ups triggered by marketing have to through an Inside sales organization. In other cases the follow-up process is dependent on where the Lead is in the sales cycle. Early stage Leads will require a follow up by inside sales and advanced stage Leads/Opportunities require follow up by field sales. Depending on the need alerts can be delivered to the the rep's dashboard in the SFA system or can be a combination of dashboard alerts and emails to the reps. Ensure you strike a balance between alerting the sales team and bugging them :-).

Avoid Data Black Holes - Align data standards between marketing and sales systems: I have seen quite a few companies suffer from what I call the 'Phantom Record' syndrome. One will be surprised how many records get buried in the database and don't show up on anybody's dashboard purely because the data values are not visible in the UI. CRM systems are notorious for being very forgiving when it comes to enforcing data integrity checks. For example, salesforce.com allows data to be imported to a pick list that does not match the pre-defined list of values. Here is a typical example. Let's say, a company uses personalized Lead views to allow their sales team access Leads and these view are geography based. One of the area manager Joe's territory includes California, Nevada and Oregon. The view is based on 2 character ISO codes CA, OR and NV. marketing publishes a set of hot leads from California and the state name is set to 'California'.  Joe will never see these Leads since the view will not pull these records and Joe can't access them manually too since the state pull down menu in the UI has 2 character codes. It is always a good idea to have proactive oversight procedures in place to avoid users violating data policies when systems can't enforce them. The next bullet talks about reactive procedures that can be put in place to catch issues that slip through the cracks.

Track Outliers - Setup Exception reports to track outliers: It might not be feasible to systematize all the processes and best practices and build logic  based rules to catch errors pro-actively. As the saying goes, it's better to be safe than be sorry. Always augment proactive checks with reactive exception reports to catch outliers. Some typical reports could be:

    a. Weekly lead flow reports: A mature marketing and sales process will provide guidance into typical lead flow on a weekly basis. Setup a 10%-20% tolerance and trigger alerts if the system detects unusual Lead flow. A few month's back we were working with a customer who used to get regular data feeds from an external source. At some point one of the system parameters (FTP location information) was changed by the operations team to consolidate data feeds from multiple sources. The receiving function was not aware of the change and for a few weeks these Leads went untouched. The problem was caught and rectified before too much damage was caused. An exception report would have caught a sudden decline in the Lead flow and the resolution could have been much more timely.

    b. Weekly lead follow-up reports: It is a good idea to track how many Leads are being followed up by sales. This is a good way for marketing to stay on top of any process changes that might take place within the sales team that requires a change in the Lead publish method. For example, in a particular situation, one of our customer's changed the 'Lead Status' values and the associated follow-up business rules. The marketing team was not made aware of the change and the workflow rules were still setting 'Lead Status' values that was no longer used by sales. With an exception report the marketing team realized that existing Leads were not being followed up on and upon investigation found the cause and made appropriate changes. In this case the exception reporting process was in effect and helped catch the problem right away.

To conclude integrating marketing and sales funnels requires proper attention from both marketing and sales teams since it's a cross functional responsibility. Over and above the 7 steps I mentioned above, a robust communication protocol is extremely critical to ensure that the two functions are always working in tandem. This might sound banal but I still get surprised to see many organizations not investing enough in this critical integration that can directly impact top line revenue.   

June 14, 2008

Can Data Quality break Integration between Marketing and Sales systems?

Last week I was discussing with one of my clients the criticality of data de-duplication and having the same consistent strategy for both the Marketing Automation system (MA) and the Sales Force Automation system (SFA). The question is, can we have a reliable Lead Management process that cuts across Marketing & Sales if the Marketing Automation system has clean data but the SFA system allows duplicates.

Data_confusion_9  

Some of the assumptions I am making here are:

1. There is a bi-directional integration between the two systems.
2. Marketing is sourcing new Leads into the sales process and also providing sales reps real time visibility into Leads' (and Opportunities) responses to Marketing campaigns. These could be email activities, web site activities and offline activities.
3. Marketing is getting automated feedback from the sales system on progress being made by sales both from a Lead follow up perspective and Opportunity creation and promotion perspective.

The challenges I see with the SFA system (Salesforce.com as an example) not having a de-dupe process  or a flawed de-dupe process are:

1. Ineffective sales alerts based on Lead activity: I don’t see how we can reliably notify a sales rep on a Lead’s response to Marketing campaigns. For example Joe, a Prospect, meets the criteria of a sales ready Lead and we publish Joe’s as a Lead into Salesforce.com. One of the inside sales rep’s follows up with Joe and, based on the potential deal size, promotes him for a follow up from a field rep. Best practices suggest that any of Joe's responses to follow up Marketing campaigns (email responses, web activities etc.) need to be sent directly to the rep who owns the opportunity. If the de-dupe process is not consistent the system might create a new record for Joe and this new record might go through an elaborate process and eventually might or might not reach the field rep in a timely manner. One of the big benefits Marketing can provide to Sales is to create opportunities for follow-up conversations. This purpose is completely defeated without a consistent de-dupe framework.

2. Broken SLA & ROMI reporting: Marketing Automation solutions bring two big benefits to Marketer's from a reporting standpoint.
    a. Visibility into Sales follow-up of Leads and SLA compliance: One of the big promises of an integrated (MA + SFA) solution is elimination of subjectivity (the dreaded *sales sniff test*) from a Lead follow up standpoint. Marketing can now get real insights into whether Leads are followed up with or not and is the follow up timely. This report will not work if we end up creating multiple records for Joe in the sales system.

   

b. ROI tracking: Marketing can now analyze how many of the Leads sourced by Marketing are turning into Opportunities and how many how many other existing Leads/Opportunities are being influenced by Marketing. Taking Joe's example from above, let's say the rep creates a potential sales opportunity. Joe responds to another campaign a week later and we end up creating a new record for Joe for this follow-up Campaign. The ROI report will show that we sourced 2 Leads and got one Opportunity when technically we sourced one Lead and the second interaction should be counted towards Marketing influence.

We strongly encourage our customers to a) clean up the SFA system before implementing a Marketing Automation solution and b) enforce the same data quality standards across both the systems. At the end of the day, the promise of an integrated Marketing & Sales system is to provide an organization the true integrated Marketing & Sales funnel. And this will remain a dream if the data foundation is inconsistent.

June 10, 2008

Periodic tune-up for your Marketing database

I recently took my wife's car, a 2000 Mitsubishi Eclipse convertible, for a tune-up. The service agent at Jiffy Lube inspected the car and came back with a list of recommended services:

1. Oil change (of course)
2. Oil filter change
3. Recycling of power steering fluid

and so on....

I bought a few additional service options along with the oil change based on the service reps suggestions.

Funnymechanicsconverted_2

This experience got me thinking about a tune-up for Marketing Processes & Databases. The first question that came to my mind was, "Do Marketing Databases really need a periodic tune-up if the right processes and policies are set in place to begin with?". My answer to self was - ABSOLUTELY. Going back to the car tune-up analogy I consider myself to be a conservative driver who stays within the recommended guidelines of the car company (including using 92 octane gas - ouch!!!). But my car needs regular service just like everybody else's for all the obvious reasons like wear & tear, recycling etc.

Here are a few areas where a Marketing database can use a quarterly tune-up:

1. De-duplication checks: We all know that automated checks can only de-dupe new Leads entering a database around 80% of the time. Data enters a Marketing system through different channels - online registrations, off-line file imports, synchronization from CRM (SFA) systems like Salesforce.com. It is always a good idea to verify the de-dupe counts once a quarter using checks like -

    a. Email
    b. First Name, Last Name, Company Name
    c. First Name, Last Name, Address 1, City, Zip

In my experience a company is doing a pretty good job if they keep the dupe counts to less than 5%. 


2. Data normalization checks:
There are certain key fields like State, Country, Job Level, Industry, Company Size etc. that are used in key marketing functions like segmentation, scoring, automation etc. Again, since data comes into the system from multiple sources it is extremely difficult to systematize data normalization. The biggest culprit is file imports from third party sources like content syndication vendors, partners, tele-marketing vendors among others. How many times have we seen segmentation rules like -

        "Country contains united states, usa, u.s.a,"
        "Job level contains vice president, v.p"

The minute I see such rules I picture a Program Manager crossing his fingers and hoping that the system pulls all the records that should be included in the campaign.

3. Opt-in checks: It is extremely critical to ensure that permission fields like email opt-out are in sync between your Marketing database and sales database since emails are not always sent from the Marketing system. Sales people send emails directly from sales systems like salesforce.com.

4. Qualified Lead profile checks: I see almost every company having a spec of a qualified Lead. But, the real story we get from running database profiling queries is, more often than not, quite different. It is very rare that customer's have information beyond the basic Demographic fields filled in more than 50% of the time. The reasons for this problem could be process related and sometimes it could be due to  lack of appropriate technology to populate the contact profile.

5. Database trending: It is always a good idea to trend key metrics like:
    a. Database size - How rapidly is the marketing database growing?
    b. Unsubscribe rate - Checks to verify the overall unsubscribe percentage is a good indicator of issues      like content relevance, touch frequency among others
    c. Contact info availability - It's good to get a trending of availability of contact fields like email,             phone and postal address.
    d. Profile trending - How is the overall profile richness growing?

Market2Lead will be announcing a series of new services in the coming weeks to address some of the operational issues we typically see our customers run into. Stay tuned.