Customer Analysis & Relationship Plan

Douglas College
New Westminster, British Columbia, Canada
Brita Cloghesy-Devereux
Faculty - Marketing
(2)
5
Timeline
  • October 3, 2019
    Experience start
  • October 11, 2019
    Project Scope Meeting
  • October 25, 2019
    Midway Check In
  • November 30, 2019
    Experience end
Experience
1/1 project matches
Dates set by experience
Preferred companies
Anywhere
Any
Any industries

Experience scope

Categories
Marketing strategy
Skills
strategic communications customer segmentation customer relationship management data mining
Student goals and capabilities

How well do you know your customers? Are you targeting the RIGHT customers? Don’t waste resources on low-value or unprofitable customers. Here’s how our students can help, by: analyzing your database(s); extrapolating your three best customer segment opportunities; creating customer profiles /relationship policies for each; and, developing targeted, segment-specific promotional strategies. Based on your organization’s individual needs, this outline can be adapted.

Students

Students
Undergraduate
Any level
35 students
Project
40 hours per student
Students self-assign
Teams of 5
Expected outcomes and deliverables
  • In-class Presentation [10 minutes]
  • Report [6 pages], including exec.summary, overview and recommendations
Project timeline
  • October 3, 2019
    Experience start
  • October 11, 2019
    Project Scope Meeting
  • October 25, 2019
    Midway Check In
  • November 30, 2019
    Experience end

Project Examples

Requirements

The final report will include:

  1. Overview - prepare a brief overview of your industry in BC, followed by an executive summary of key findings.
  2. Data mining - analyze your data sets to provide a deep understanding of your current situation [sales, customer types, distribution channels, marketing/media channels etc.], and compare/contrast figures year-over-year, by sales numbers, accounts, regions and more – dependent on data type.
  3. Segmentation - identify THREE (3) unique customer segment groups.
  4. Persona - per segment, create a persona that represents the goals and behaviours of each hypothesized group of users. To develop an intensive relationship with each segment, we need to deeply understand each.
  5. Relationship Policy/Service Concept - per segment, define the ideal relationship [incl. the value proposition, unique customization, pricing and preferred communication channels].
  6. Promotional Campaign - develop three high level promotional campaigns; translate each relationship into sales.
  7. Summary – brief synopsis; final insights and conclusions.

Additional company criteria

Companies must answer the following questions to submit a match request to this experience:

  • Q - Checkbox
  • Q - Checkbox
  • Q - Checkbox