Back to Portfolio

Maven Cafe Card Rewards Program: Customer Engagement Analysis

March 15, 20247 min read
Business
Share:
Maven Cafe Rewards Program Dashboard

Maven Cafe Rewards Program Dashboard

Introduction

Maven Cafe, a growing coffee chain, implemented a rewards card program to boost customer loyalty and increase sales. This analysis examines the effectiveness of their rewards program across different customer segments and promotional strategies.

Project Overview

The Maven Cafe Rewards Program dataset contains information about customer purchases, demographics, and promotional responses. By analyzing this data, we aim to identify patterns in customer behavior, evaluate the effectiveness of different promotional offers, and provide recommendations to optimize the rewards program.

Business Challenge

Maven Cafe faces several challenges with their rewards program:

  • Determining which promotional offers generate the highest response rates
  • Understanding spending patterns across different customer segments
  • Identifying opportunities to increase customer engagement and loyalty
  • Optimizing marketing spend by targeting the most responsive customer groups

Dataset Overview

The dataset includes information on 500 customers with the following key variables:

  • Customer demographics (age, gender, income)
  • Membership tenure
  • Purchase history (amount spent, number of purchases)
  • Promotional offer types and response rates
  • Store visit frequency
  • Product preferences
Sample of the dataset

Sample of the Maven Cafe Rewards Program dataset

Project Details

Category

Business

Date

March 15, 2024

Tools Used

Power BI
Excel
Customer Analytics

Key Metrics

Customers Analyzed

500

High-Value Customer Revenue

42% of total

Top Promotion Response Rate

BOGO (68%)

Highest Avg. Spend

Ages 25-34 ($12.85)

Feature Highlights

  • Customer segmentation analysis
  • Promotional effectiveness evaluation
  • Demographic spending patterns
  • Product preference insights
  • Implementation roadmap