Open experiences

Experiences from all portals

Douglas College
New Westminster, British Columbia, Canada
Brita Cloghesy-Devereux
Faculty - Marketing
(2)
3
General
  • Undergraduate; Senior
  • 35 learners; teams of 6
  • 25 hours per learner
  • Dates set by experience
  • Educators assign learners to projects
Preferred companies
  • 1/1 project matches
  • Anywhere
  • Academic experience
  • Any company type
  • Any industries
Categories
Marketing Data analysis Customer segmentation Digital marketing Marketing strategy Marketing analytics
Project timeline
  • October 20, 2023
    Experience start
  • December 8, 2023
    Experience end
Overview
Details

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

Deliverables

Per team (usually 5-6 teams)

  • Presentation [10 mins./team] – depending on your availability (and Covid), either in-class or by on-line video conference
  • Final report [approximately 6 pages] - including the aforementioned sections, supported by visuals, grids, graphics, charts etc.
Project Examples

Based on previous experience, to ensure the best results for you and the students, this project needs to be supported by two important elements: good data and collaboration. You providing robust data forms the basis of student analysis and future recommendations; your participation and involvement leads to better outcomes and useful results.

Data presents itself in a variety of formats. Here are some historical examples -- by no means prescriptive or exhaustive -- that have proven useful: customer data (segment analysis, purchase behaviour); product data (description, SWOT analysis, sales/marketing, pricing); industry/market data (general environment, competitive analysis, market research); CRM data (if you have it – corporate or account information; lead source, score or status etc.).

Students can sign a standard non-disclosure agreement (NDA), if desired, prior to the project launch to support data privacy.

The final report will include:

  1. Overview - a brief overview of your industry, followed by an executive summary of key findings.
  2. Data mining - an analysis of your data sets, including a deep understanding of your current situation which could include: customers types, sales, distribution channels, marketing/media channels, a compare/contrast summary of figures year-over-year by sales numbers, accounts, regions etc. – all dependent on types of data provided.
  3. Segmentation - the identification/justification of your company’s THREE (3) best customer segment opportunities
  4. Persona - THREE (3) personas, each representing the goals and behaviours of the above hypothesized segment groups – with a goal to understanding each segment on three levels, as: Buyers, Users, People.
  5. Relationship Policy - THREE (3) business-customer relationship policies that articulate (per segment) a unique value proposition, customization, pricing and preferred communication channels.
  6. Promotional Campaign – THREE (3) high level promotional campaigns – ie: the translation of each relationship policy into sales.
  7. Summary – a brief synopsis; final insights and conclusions.
Required questions to apply

Companies must answer the following custom questions in order to apply to this experience:

The ideal project should be for a tangible/physical product, preferably one that is easy for students to understand the concept. If you’re offering a service, please refrain from submitting a request.