Analyzing Customer Repeat Purchase Behavior at GlobalMart

Learning Objectives

Proficiency in writing SQL queries

Ability to use aggregate functions to calculate metrics

Competence in handling and formatting date fields

Overview

In this scenario, you are tasked with analyzing the repeat purchase behavior of GlobalMart customers to answer specific queries posed by the Customer Success Head. You will investigate whether customers are returning to make additional purchases, the frequency of their purchases, and their repeat rate.

The goal is to prepare a summary report that provides insights into customer retention and loyalty, which is crucial for understanding the overall health of the customer base and informing future business strategies.

Prerequisites

Knowledge of basic SQL concepts like SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOIN.
Knowledge of aggregations using functions like SUM, COUNT, and AVG.
Knowledge of CTEs and subqueries for structuring and simplifying queries.