Customer purchase behaviour analysis for Urban Threads

Urban Threads is a rapidly growing boutique clothing retailer headquartered in the United States. Founded in $2010,$ the company has carved out a niche by catering primarily to young adults aged $18$ to $35,$ offering trendy, urban$-$style fashion that reflects the latest trends in streetwear, casual, and contemporary apparel. Urban Threads distinguishes itself from larger retail chains by focusing on a curated selection of clothing, accessories, and footwear designed to appeal to fashion$-$conscious young consumers who value individuality, quality, and affordability.

$3\mathrm{.}1$ Customer demographics and purchasing behaviour

Category: Age and gender analysis

$3\mathrm{.}1$

$\mathrm{.}1$ What is the average age of customers across different product categories $($e$.$g$.,$ Clothing, Footwear, Accessories$),$ and how does purchasing behaviour differ between male and female customers? $(5)$

Task: Calculate the average age of customers for each product category. Group the dataset by gender and compare average purchase amounts across product categories. Provide visual representations to showcase any significant differences.

$3\mathrm{.}2$

Product and sales performance

Category: Top$-$selling product categories and review impact

$3\mathrm{.}2\mathrm{.}1$

Which product categories generate the highest revenue for Urban Threads, and how do customer review ratings impact purchase amounts? Do higher$-$rated products result in higher sales? $(5)$

Task: Calculate the total revenue generated by each product category. Compare purchase amounts across products based on their review ratings $($group them as $<3\mathrm{.}0,3\mathrm{.}04\mathrm{.}0,>4\mathrm{.}0)$ and analyse whether higher$-$rated products drive more revenue.

MBA$5945$

$3\mathrm{.}3$ Customer retention and loyalty

Category: Subscription status and purchase frequency

$3\mathrm{.}3$

$\mathrm{.}1$ Question: How does a customer$$s subscription status impact their purchase frequency? Do subscribed customers purchase more frequently than non$-$subscribed customers? $(5)$

Task: Compare the average purchase frequency $($e$.$g$.,$ weekly, monthly$)$ between subscribed and non$-$subscribed customers. Identify patterns that could inform strategies to increase subscriptions and repeat purchases.

$3\mathrm{.}4$ Payment and shipping preferences

Preferred payment methods and shipping impact

$3\mathrm{.}4$

$\mathrm{.}1$ Question: What are the most popular payment methods among customers, and does the shipping type $($e$.$g$.,$ Express, Free Shipping, Next Day Air$)$ affect the average purchase amount? $(5)$

Task: Identify the most frequently used payment methods and analyse the average purchase amount across shipping types. Determine whether faster shipping options correlate with higher spending.

$3\mathrm{.}5$

Seasonal and regional trends

Category: Seasonal purchasing trends and regional sales performance

$3\mathrm{.}5\mathrm{.}1$

Question: How do purchasing amounts vary across seasons $($Winter$,$ Spring, Summer, Fall$),$ and which regions $($states$)$ generate the highest and lowest sales for Urban Threads? $(5)$

Task: Group the dataset by season and calculate total and average purchase amounts for each season. Identify the top and bottom$-$performing regions based on total sales and suggest region$-$specific marketing strategies.