Customer purchase flow
Tom Papantos
0
Data Scientist
Marketing Analytics Specialist
Data Analyst
Microsoft Power BI
MySQL
To better understand our customers I’ve built a purchase flow for their first 4 orders.
Steps:
I grouped customers based on the product categories purchased for each of their orders.
Based on those groups I displayed the aggregated data (number of customers, revenue, AOV, days between orders, etc) for each of the groups.
This way the marketing team had a better understanding of customers purchase patterns.
This analysis helped optimize retargeting, e-mail marketing campaigns, amongst other things.
Like this project
0
Posted Apr 10, 2024
Optimize your marketing strategy by squeezing every possible insight from your historical sales data (days between orders, AOV, IPO, etc).
Likes
0
Views
0
Clients
Mott & Bow
Tags
Data Scientist
Marketing Analytics Specialist
Data Analyst
Microsoft Power BI
MySQL
Tom Papantos
Data Wizard: Analyst & Scientist 📊
Maximize Customer Lifetime Value (LTV)
Refunds reduction
Customer Segmentation
Marketing Mix Modeling - MMM