During my internship, I utilized SQL within Snowflake to aggregate member data and develop personalized push notifications on golf statistics for our users. I also used SQL to pull detailed and nuanced customer lists, enabling us to target our ads in a more strategic manner. I worked on developing lifetime value models to understand how to maximize return on investment. Additionally, I contributed to implementing a universal holdout group for testing marketing strategies and created a query to evaluate specific campaigns against this group, optimizing marketing budget allocation.