Notice: Please visit Enginius.biz for our latest Marketing Engineering software
Marketing Engineering for Excel has reached end of life and is no longer receiving updates. Please visit Enginius.biz to explore our newest online marketing analytics platform which is designed to replace the Marketing Engineering for Excel add-in.
Students: If your instructor has specifically told you to use Marketing Engineering for Excel software, please continue on this site.

News

Segmentation/Targeting Model (Classification)

on . Posted in Commercial Software Models

What you put in... What you get out...
  • Customers' importance ratings for each measure of value for offerings in a product class
  • Customer descriptors (demographic or firmographic variables)
  • Number, size, and profile of needs-based market segments
  • Identification of factors that differentiate segments, both in terms of needs and descriptors
  • Classification tool to allocate any potential customer to a segment based on customer descriptors

segmentationSegmentation/Targeting is an analytic technique that helps firms to segment customers in a market.

Segmentation is the process of classifying customers into homogenous groups (segments) such that each group of customers shares enough characteristics in common to make it viable for the firm to design specific offerings or products for selected segments. The application finds customer segments using needs-based variables called basis variables. Cluster analysis helps firms to:

  • Better understand their customers.
  • Identify different segments in a market.
  • Choose attractive customer segments for targeting its marketing programs.

Resource Allocation

on . Posted in Commercial Software Models

What you put in... What you get out...
  • Number of market segments, products, geographies or other basis for resource allocation
  • Current level of spending and associated sales
  • Profit margins
  • Response functions - how sales would change if spending were higher or lower than current spending
  • Constraints (minimum / maximum) for each basis unit
  • Optimal level of total spending
  • Optimal allocation of spending across units
  • Profit associated with optimal plan versus current plan
  • Incremental gain or loss associated with changes from current or optimal plan

resourceResource Allocation helps optimize resource sizing and resource allocations across segments, products, channels, etc. It answers such questions as

  • How much should we spend in total during a given planning horizon?
  • How should that spending get allocated to each product or market segment? To each marketing mix element? How much of our budget should be spent on advertising and other forms of impersonal marketing communications? On sales promotions? On the sales force?
  • How should budgets given to an individual (e.g., salesperson, manager of department) be allocated? To customers? To geographies? To sub-elements of the marketing communications mix? Over time?

There are four primary steps:

  • Enter data for current efforts and outcomes-- typically these are hard data about current market situations.
  • Enter calibration data--typically these are judgmental data, unless there are data available from experimentation.
  • Calibrate the response curves. Check to ensure that the curves fit the points.
  • Run the analysis (and optionally enter constraints).