Who Are Our Most Valuable Customers?

This project uses dbt and BigQuery to answer this question by building a customer lifetime value model from raw transactional data. Customers are segmented by loyalty and ranked using a weighted score that rewards both high spend and consistent return visits.