While every business is different, the following set of example CRM requirements, which are based on a fictional kiosk manufacturer, provides a framework for the type of information that can be given to a would-be CRM implementation company.
This type of document can give CRM service providers a substantial amount of the information they need to more precisely estimate the scope of required CRM services. Many additional questions usually need to be posed before a services estimate is provided.
This approach goes beyond a traditional RFP, which is usually too general and is often more of a feature list than a set of requirements.
To get to this point, we recommend first going through a structured approach to gathering and prioritizing business requirements.
The example CRM requirements information below was previously only available as a gated PDF. We’ve decided to liberate the content.
Table of Contents
Business Overview & Current State
Abbott Ltd. has been in business since 1995. We sell kiosks directly to commercial and government accounts in the United States and Canada. We have a distributor in Europe and a distributor in Asia.
In the commercial arena, customers include retail chains, independent retailers and hotel chains. Kiosks are installed in retails stores, hotel lobbies, airports and other places. We currently have over 300 customers, with an average of 25 locations per customer. Many locations have more than one kiosk.
Our addressable market is over 10,000 companies.
We have 10 outside account executives (AEs), most of whom work from home offices. There is one AE for each of the nine U.S. census regions and one AE for Canada. Three inside, sales development representatives (SDRs) support the AEs. SDRs are not currently paired with AEs. Any SDR can work with any AE.
There are two regional sales managers (RSMs) that the AEs report to. One RSM is responsible for the east plus Canada. The other RSM is responsible for the west. The RSMs report to the VP of Sales.
There are also two sales engineers (SEs) who align with the two regions. SEs accompany AEs on sales calls when needed.
There is one major account representative who works on a dozen or so large accounts. This person reports directly to the VP of Sales.
Salespeople are currently using a combination of a contact manager, spreadsheets and email address books to manage their contacts. Adoption of our current contact manager by field users is very low.
Some AEs have PC notebooks and some have Mac notebooks. Some AEs use iPhones and some use Android devices. Half of our AEs use some type of tablet (iPad, Kindle Fire)
Our AEs are responsible for managing existing accounts, developing net new business on their own and following up on leads that have been handed off to them by SDRs.
AEs identify key players within target organizations, assess requirements and ultimately create proposals. Our proposals are 8 – 12 page documents with embedded pricing spreadsheets. Our quoting process is complex, as kiosks need to be engineered for specific customer requirements.
In companies with many divisions across different territories, the account may be split up among multiple AEs.
We have a marketing manager who reports to the VP of Marketing. About half our leads come from four different landing pages on our website, 20% come from trade shows, 20% come from webinars and 10% come from referrals / word of mouth.
We have a contract blogger who writes informational posts that are relevant to anyone who purchases or manages kiosks. Our CEO is a thought leader in the kiosk industry and also periodically writes blog posts. Calls to action at the bottom of posts drive visitors to landing pages where visitors can download additional informational content in exchange for providing information such as their name, company name, email address and phone number.
New website leads are currently emailed to all three SDRs. SDRs enter the lead information into our contact manager and then follow up via phone and email. We currently have five different email templates that our SDRs can choose from when communicating with leads.
We use Twitter, Facebook, LinkedIn and SlideShare to drive people who are interested in information about kiosks to our blog.
We use GoToWebinar to run our webinars. Invitees and attendees are managed outside of our contact management system.
Other types of leads, such as trade show leads, are manually imported into our contact management system. SDRs select from new leads, assign themselves as the manager of the leads, and make calls.
When an SDR qualifies a lead, based on five qualification criteria as well as their general sense on how viable the lead is, they send an email to the AE who is responsible for the corresponding region. AEs periodically email SDRs with updates on leads that have been handed off to them.
We currently send a monthly newsletter to selected contacts at customer accounts. This is being done outside of our contact manager.
We currently have three inside customer support representatives (CSRs) who report to a customer service manager. We have direct, online access to 90% of the kiosks in the field and have the ability to remotely diagnose and resolve about 75% of issues.
Kiosk issues are reported in various ways:
- Automated emails from the kiosk with diagnostic information
- Emails from a customer contact
- A filled in form on our website
- Phone calls from a customer contact (usually from someone at the kiosk location)
Support issues are currently logged into a shared Microsoft Access database. Our customers are encouraged to include the serial number of the kiosk in question whenever they are reporting an issue. If they do not provide the serial number on submission of the issue, a CSR will always request the number.
Emails and form submissions currently go to all three CSRs. An available CSR takes ownership of the issue to try and resolve the issue via remote access to the kiosk. If there’s a software issue that can’t be solved, the CSR will forward the email to one of our engineers or call an engineer.
If it is determined that a part needs to be replaced, the part will be shipped to the customer site. Some parts can be replaced by customers. Other parts can only be replaced by a field service representative (FSR). We have contract FSRs who can be dispatched by CSRs.
We have a homegrown knowledge base that is maintained by our IT department. Customers are encouraged to check the knowledge base before submitting a support case. Our CSRs will sometimes email links to specific knowledge base articles to more technically savvy customer contacts as part of the issue resolution process.
We currently use Microsoft Office 365 for our email. Our PC users are using Outlook 2016 on the desktop, but we have a variety of email clients across the organization, including:
- Outlook Web
- Mac Mail
- iPhone Email Client
- iPad Email Client
- Android Email Client
We have a legacy, in-house ERP system that runs on SQL Server. Our IT department manages our ERP system. Our IT team has the ability to create daily CSV exports. They also have the tools to write ERP data to a web services endpoint.
Project Success Factors
Based on our past experience with under-utilized systems the following are some of the success factors we’ve identified for our current CRM initiative:
- End-user input into the design process
- Third party recommended best practices
- An initial focus on the highest value functionality
- A comprehensive view of customer information from a single interface
- Easy access to key information from multiple platforms (PC, Mac, iPad, iPhone, Android)
- Internal ownership and support of the application after the initial rollout
- An ongoing training strategy
————— While you’re here —————
Get The CRM Buyer’s Cheat Sheet
A brief and easy guide that provides professional tips and advice for each step of the CRM selection process
————— Article Continues ↓ —————
Sales, Marketing and Support Processes
Lead Generation and Lead Management
We have four different landing pages on our website. One example is: http://offers.abbott-ltd.demo/how-to-spec-out-a-kiosk
We would like to capture leads from this form and three other forms directly into a CRM system. New leads should be distributed to our SDRs in a round robin fashion.
To support our business model, the SDRs should be able to view and/or maintain the following information for leads.
- Lead Source (website, tradeshow, webinar)
- Landing page name (for leads that came from our website)
- Lead Status (New, Working, Qualified, Disqualified, Customer)
- Reason Disqualified (Too Small, Unserved Geography, Bad Information, Competitor)
- Number of locations
- Currently using kiosks? (Y/N)
- Current kiosk vendor(s) (link to competitor company records)
- Personal LinkedIn profile URL
- Role (IT, Executive Management, Marketing)
- Rating (A, B, C) The rating will be calculated based on various data points in the lead
If a lead’s company already exists in the database, the SDR should have the ability to add that person to the existing company record.
When a lead is qualified by an SDR, the SDR should convert the lead to an account/contact and assign the account to the appropriate AE. The AE should receive an email notification that the account has been handed off to them.
SDRs should not create sales opportunities. An opportunity should only be created by the AE after he or she has had a discussion with one or more key contacts at the customer or prospect account.
Customer and Prospect Management
To support our business model, we need to track both office locations and locations where kiosks are installed in a parent/child relationship.
We need to track the following information at the company level.
- Customer Accounting ID
- Type (Prospect, Customer, Vendor, Competitor)
- Customer Sub-Type (Business Office, Kiosk Location)
- Status (Active/Inactive)
- Number of locations (in parent company record only)
Customer Related Information – Sales Order History
In order for our AEs to have easy visibility to recent sales orders, they should see a list of sales order header information for the last two years when looking at an account. AEs do not need to see sales order detail, but they should, at minimum, see the following information for each sales order:
- Sales Order Number
- P.O. Number
- Order Date
- Ship Date
- Total Dollar Amount
When looking at a customer account record, our AEs and other CRM users should also be able to see the following financial information for the customer.
- MTD Sales
- YTD Sales
- Previous YTD Sales
- Credit Limit
- Amount Past Due
Our IT team can schedule a daily CSV export of new sales orders from our legacy, in-house ERP system. They can also schedule a daily CSV export of customer financial data. These files can be posted to an FTP site.
Location Related Information – Kiosks
We need to track kiosks that are installed at each location. Our IT department can provide an export file of kiosks at each location with the following data points:
- Serial number
- Operating System
- Software Version
- Date Installed
- Warranty Expiration Date
Initially, we will manually enter or import any new locations and/or new kiosks into CRM.
Customer and Location Related Information – Support Cases
Our AEs, our SEs and our major account representative should have visibility to any open support issues when viewing a customer record.
There is information about contacts that we want to track and that may not be in the standard CRM configuration:
- Role (pick list – map values from leads on lead conversion)
- Email 2 (many contacts in our contact manager have more than one email address)
- Holiday Card (checkbox)
- Status (Active/Inactive)
- Personal LinkedIn profile URL
While viewing a contact record, our users should be able to see the account’s Status and Type, without having to navigate to the account record.
Opportunity Management and Forecasting
AEs should create opportunities in CRM for:
- Potential add-on sales to existing accounts
- Potential new sales to new accounts
We need to track:
- Type (add-on or net new business)
- SDR (if the opportunity originated as a lead so the SDR can be credited with a sale)
- Expected close date
- Expected revenue
- Stage (we have a five stage sales process)
- Commit (Yes/No)
- Competitors (there could be zero, one, or several competitors on a deal)
- Reason Lost (there are five general reasons that we lose deals)
The existing web forms on our four existing landing pages should be replaced with new web forms, which, upon visitor submission, will automatically create new lead records in the CRM system.
We would like to send our monthly customer newsletter directly from the CRM system and provide the ability for users to view opens, clicks and unsubscribes. We are not committed to any particular email marketing solution.
While we have had success with GoToMeeting, we are interested in a webinar platform that integrates with CRM so that we can accomplish the following:
- Have webinar registrants be automatically added into CRM as new leads (also – update leads or contacts if they already exist, rather than creating duplicates)
- View which live webinars each lead or contact attended
- View which recorded webinars each lead or contact viewed
- View engagement for each of the above (what percentage of the webinar they viewed)
We will be evaluating marketing automation systems later this year and want to make sure that the systems we are looking at will integrate with the chosen CRM system. The leading candidates are HubSpot, Marketo and Pardot.
We would like to manage our support cases within the CRM system.
Emails that go to email@example.com should automatically create new cases in the system. When a case is created, our three CSRs should all be notified of the new case. All email communication with the customer contact who submitted the case should be managed within the case.
We would like to replace the form on http://offers.abbott-ltd.demo/support with a form that, when submitted, creates a new case in the CRM system.
If a high priority case is not resolved within 24 hours, an email should go to the customer service manager.
The following is the information that we would like to track within the case:
- Type (Hardware, Software)
- Priority (High, Medium)
- Location (link to location/account record)
- Serial Number (link to kiosk record)
- Customer Contact (link to contact record)
Reports & Dashboards
The main goal for the use of reporting and dashboards is so that management can ensure:
- We are consistently feeding the top of the funnel with new leads
- New leads are being worked in a timely fashion by the SDRs
- Lead conversion continues to grow over time
- Management has visibility to new sales opportunities
- Management knows what the highest value opportunities are
- Customer service issues are being handled expediently
- User adoption can be monitored and under-adoption can be addressed
The following is the initial set of reports that we have identified:
- Number of new leads created QTD, by month (bar chart)
- Current status of all leads – Open, Working, Qualified, Disqualified (bar chart)
- Leads created this month by lead source MTD (pie chart)
- Lead conversion rate this month vs. last month
- Top five open opportunities closing this quarter (text)
- Opportunities by stage, closing this quarter, grouped by month (stacked bar chart)
- Opportunities by lead source, closing this quarter (pie chart)
- Dollar amount of opportunities expected to close this quarter, grouped by salesperson (bar chart)
- Number of lost opportunities, YTD, grouped by lost reason (bar chart)
- Average time to close deals (previous four quarters)
Case Management Reports
- Currently open cases by stage
- Cases solved MTD and QTD by Type
- Average resolution time (this quarter and previous two quarters)
- Recent logins by user
- New Accounts created YTD, by month (line chart)
- New activities created YTD, by month
We are currently using Microsoft Office 365, but only some of our users are using Outlook 2016 on the desktop.
At minimum, our users need to be able to attach sent and received emails — from whichever email client they happen to be using — to lead and contact records in CRM. When an AE emails a proposal, we want the AE to be able to attach the proposal to the contact record for the main contact and also attach the proposal to the Opportunity record if possible.
Users should optionally be able to synchronize their CRM calendar to their Outlook calendar.
Our AEs and SEs use a combination of iPhone and Androids. The most important required functionality for smartphones is:
- iPhone and Android device compatibility
- Search for contacts to access phone numbers and email address(es)
- Log detailed meeting notes after on-site meetings
- Search for accounts and review recent call, meeting, and email activity
- View MTD and YTD sales totals for customers
- View any open support cases
We only need to migrate the key information in our contact management system. We plan to keep the contact management system active and accessible for as long as necessary, in case users need to refer back to information that was not migrated.
- Record ID
- Company Name
- Contact Name
- Phone Number + Extension Number
- Mobile Number
- Email Address (our current system allows for multiple email addresses per contact)
- Street, City, State, ZIP
- Annual Revenue
- Last Result (only for reference. We do not need this field moving forward)
- Email History – going back to January 1, 2012
- Notes – going back to January 1, 2012
We do not need to migrate:
- Secondary Contacts
- File Attachments
Each of a customer’s multiple locations are in our ERP system as separate Ship To addresses. We plan to extract a CSV of all customer locations and we would like these to be added as separate account records in the CRM system, all with a relationship to the parent record.
Record and Field Permissions
The following are the general permissions needed:
- Customer Accounting ID should be read/only to all users except administrators
- SDRs should have read/only access to opportunity fields
- Each AE should only see accounts that are in his or her territory
- RSMs should only see accounts that belong to their AEs
- AE’s should be able to manually share specific accounts with one another
- Case and Kiosk fields should be read only for all sales users
Internal Systems Support
We are looking for an implementation partner for our Phase I implementation. As part of the commitment to a new CRM system, we plan to have our current contact manager administrator and one other person trained on CRM system administration.
We are also interested in having at least one of our in-house developers attend a developer training session for the selected CRM system.
Subsequent Phase Requirements
The following are some of the areas we would like to target in subsequent phases, after the initial rollout:
Additional ERP Integration
Automated updates of Ship To locations and kiosk information from the ERP system to the CRM system.
Automated Case Creation from Kiosks
Our kiosks can send alerts with multiple diagnostic data points. Eventually, we would like these data points to be written directly to fields within support cases so that we can intelligently prioritize and route support cases at the time they are created.
While our current knowledge base is working, we would like to ultimately have the knowledge base be a part of the CRM system.