For more information contact: Craig Sharrow


Marketing Database Analysis & Recommendations for Educational Software Company - A Sample Report

This document contains a sample report of an initial marketing audit conducted for a Telemarketing & Database Corporation on behalf of one of its clients, the fictional Educational Software Company.

The purpose of this document is to demonstrate the process and structure of conducting a database marketing audit and provide an example of the type of considerations which might be contained in the analytical report presented to the client company's management.

Table of Contents


I. Background

A. Purpose & Objectives


B. Process

1. Information Gathering

2. Information Synthesis & Analysis

3. Recommendations


C. Overview of Educational Software Company

- Return to Top of This Document


II. Situation Analysis

A. Overlapping Sales Channels for School Market

Schools may purchase software from:


B. No Internal or External Database Captures Complete Sales History


C. Limited Customer Profiling data

- Return to Top of This Document


D. TM Corp Telemarketing Database Limited in Scope & Integration


E. Limited Sales & Marketing Analysis of Marketplace; Limited Marketing Programs

- Return to Top of This Document


F. Multiple, non-linked, incompatible, hierarchical (flat-file) databases


G. Limited ESC Marketing Activities; Limited (or Non-Existent) Links to Databases

- Return to Top of This Document


H. ESC Is in Preliminary Stages of Upgrading MIS Capabilities; Has Concerns Regarding Development of External Database and the Expansion of TM Corp’s Role

- Return to Top of This Document


III. Recommendations

A. Presentation of Recommendations to Educational Software Company


B. Changes Effected In TM Corp’s Telesales Process

- Return to Top of This Document


C. Initial Changes In TM Corp Database Structure & Reporting


D. Design, Contents and Application of ESC’s “Next Generation” Marketing Database

1. Design Parameters for the Database

- Return to Top of This Document


2. Contents of the Database

Note: Following is a proposed group of data tables which contain the minimum data elements appropriate for developing a usable, full-function sales and marketing database for Educational Software Company. The tables and their contents are representative, not definitive. The structure of the database requires significant review, planning and analysis by programmers and systems analysts familiar with the design of relational databases.

a) Customer/Prospect Contact Table

- Return to Top of This Document


b) School/District Table


c) ESC Product Purchase Table

*Note: Included in database only if linked with shipping & customer service

- Return to Top of This Document


d) Marketing Communications & Promotions Table

e) Authorized Dealer Table

- Return to Top of This Document


3. Application of the Database

Note: Following are most of the initial key applications for which the proposed database will be used.

- Return to Top of This Document


E. Sales & Marketing Reports and Data Analysis

.Note: Sorry, we can't provide detailed information on this section of the report with disclosing proprietary data. Following are simply some of the report titles.

- Return to Top of This Document


F. Enhancements to ESC’s Sales & Marketing Programs

1. Need to collect more complete data on all product sales and schools/districts

2. Conduct “trial analyses” of data to build experience base of sales patterns for future marketing activities and to identify criteria for Purchase Probability Model

3. Increase frequency of contact to key customers & prospects

4. Assess establishment of non-overlapping sales channels based on product and customer differentiation

5. Reduce number of in-bound phone numbers to one “800” number with automated call branching to ESC Customer Service or TM Corp TSRs

- Return to Top of This Document


IV. Appendices

Appendix 1. Initial TM Corp Management Discussion Topics for Database Marketing Review of Educational Software Company

1. Introduction to Sharrow & Associates: Corporate and analyst backgrounds

2. Objectives:

3. Review of Educational Software Company

4. TM Corp Telemarketing

5. Back-end analysis & reporting

6. MIS systems

7. Open discussion: other topics & issues

8. Next steps

- Return to Top of This Document


Appendix 2. Sales & Marketing Discussion Topics for Database Marketing Review of the Learning Company

1. Overview of the Educational & Consumer Sales & Marketing program

2. Current distributor, dealer, customer information (i.e. $ sales, products, demographics, profiling, etc.)

3. Are there ESC user support group, frequent purchaser programs, newsletters or other ongoing communications / relationship marketing programs in place?

4. What process/procedure is in place for cross-selling and upselling existing users?

5. What are the characteristics of strong vs. weak geographic market/sales areas?

6. What are the characteristics of strong vs. weak dealers?

7. What processes/procedures are in place to develop “low computer usage” schools as future customers?

8. What sales and marketing information/reports do you currently use to make marketing management decisions?

9. What sales and marketing information/reports would you like to have?

10. How is marketing research and analysis currently conducted within ESC?

11. How are marketing/sales/advertising program effectiveness analyses conducted? What data and criteria do you use?

12. How and when do you solicit product usage and satisfaction criteria?

13. Do you incentivize users to make prospect referrals? What is the process?

14. Discuss the warranty card program. What information do you solicit? How is the program used? How effective is the current program?

15. What evaluation of calling list sources have been made? Screening criteria?

16. What is your vision of ESC ideal marketing database? How it would be used? Who would access it? What linkages would it have with other ESC computer applications (i.e. shipping, accounting, etc.)?

17. What features of TM Corp’s current Telesales program do you like? Which could be improved?

18. What features would an ideal telemarketing/telesales program have?

- Return to Top of This Document


Appendix 3. Accounting and M.I.S. Discussion Topics for Database Marketing Review of Educational Software Company

1. What software is accounting/inventory management etc. operating under currently?

2. What are ESC’s mid-range (2-5 year) MIS strategy and plans (i.e. hardware/software, database software applications, operations/inventory/accounting integration & automation, etc.)?

3. Do you currently have a multi-year purchase history by product for any category of accounts (e.g. consumers, distributors, dealers, schools)? What percentage of total sales revenue or quantity shipped does this represent?

4. What is the current level of integration that occurs between accounting, inventory management, sales, shipping & receiving and customer service? (E.g. Does a single data entry generate an invoice, create a pick & pack slip and address label, tally sales revenue, update the “inventory on hand” records, revise the account purchase history and flag marketing to revise their promotional follow-up to this customer?)

5. What type of operations, sales and marketing management reports are currently generated?

6. Would there be difficulties in integrating an off-site database into your current system, or in periodically downloading data from your system to populate a separate marketing database?

7. Are there system functionalities that you would want to have in an off-site marketing database? Any that you plan to incorporate into your "next-generation" corporate MIS capabilities that do not currently exist?

8. What is your vision of ESC ideal marketing database? How it would be used? Who would access it? What linkages would it have with other ESC computer applications (i.e. shipping, accounting, etc.)?

- Return to Top of This Document


Appendix 4. Customer Service & Operations Discussion Topics for Database Marketing Review of Educational Software Company

1. Describe the process (particularly as it related to computer data entry, data management and report generation) for processing school orders. Does this differ from the process for dealer or distributor orders?

2. How is the warranty card data logged and used? What percent of school vs. consumer product sales result in returned warranty cards? Are you satisfied with the information being captured by the warranty cards? (Reminder: Get copy of warranty card)

3. Discuss the nature of customer contacts with the customer service department. Are the calls categorized and logged (by nature of inquiry or by customer/prospect)? Is any follow-up contact made to these callers (by mail or phone) immediately following their contact or at any time in the future?

4. What type of customer information (or type of report) that is not currently available would make you operation more effective and productive? Are there programs or processes that you would like to implement which are currently prohibited because of a lack of proper sales/ marketing/ customer data?

Other Sharrow Davies Townsend Marketing Documents

- Quickie Overview of Database Marketing [for creatures returning to earth from a distant galaxy after 20 years]. Contains the ever-popular "Marketing stuff that SHARROW can do for your organization" pitch. It's graphic! [Real GIFfy]

- Who is Craig Sharrow ? Call it a "professional biography". Call it a "curriculum vitae". It's just a "resume" put to song and dance, complete with smoke & mirrors and a silent laugh track.

- Alternative Marketing Organization Models . Non-definitive proof that there's no one correct way to set up a marketing function for optimal efficiency and results. A "must-read" for organizations experiencing growth, confusion, and/or self-doubt.

- How Integrated Marketing Can Boost Sales . A review of the elements of a Sales Management System ["What, we need systems, processes and procedures, not just a couple of hot reps?"]. Presents a rational argument for the need to integrate marketing functions ["Yes, that's different that just putting them all in a box and shaking!"].

Your comments, or [preferably] hugely lucrative consulting assignments are welcome.

Contact Craig Sharrow via email or phone (415)-454-1839


Restricted Proprietary Information - The information contained herein is for use solely by Sharrow & Associates, its authorized agents and representatives and such other individuals or organizations as have express written permission. It is intended to provide clients or prospective clients with information necessary to make a determination regarding the retention of Sharrow & Associates to provide marketing consultation services. The intellectual property represented by this document is copyrighted under the laws of the United States and may not be used in whole or part without permission of Sharrow & Associates. This document may be distributed electronically via the Internet for educational and informational purposes. It may not be modified or excerpted.


- Return to Top of This Document

- Return to SHARROW HomePage

- Return to BizInfo© Resource Center


Your comments, suggestions and/or inquiries are welcome (no flames please). Please send to webmaster@sharrow.com

or go to the SHARROW Comments Form

SHARROW & ASSOCIATES Copyright © 1994-96