Driving Engagement and Donations: A Web Analytics Case Study in SQL

Background For a political advocacy organization, I analyzed web traffic and conversion data to understand what drives user engagement, which segments generate the most revenue, and where optimization opportunities exist. The goal was straightforward: turn raw web activity into actionable insights for the web and fundraising teams. Approach I worked with two core datasets—page_views for user behavior and conversions for donations—focusing on traffic patterns, device segmentation, referral sources, and donor value. ...

April 15, 2024 · 3 min · Stann-Omar Jones