As a Regional Operations intern, I built an end-to-end funnel analysis spanning Awareness → Consideration → Purchase → Retention, synthesizing paid-media, web-analytics, lead, and CRM data across thousands of monthly leads and 5 channels to give regional marketing leadership a single view of where the funnel leaked.
I diagnosed a double-digit percentage decline in lead-to-sale conversion and isolated Brand Website as the highest-converting channel, converting at roughly 1.6× the rate of dealer sites, surfacing it as the highest-ROI reallocation target. Then I reframed a suspected “traffic problem” as a purchase-intent problem: visits rose while lead submissions fell, with a sharp year-over-year paid-traffic decline tracing to the spring tariff onset.
1.6×
Brand-site conversion vs dealer sites
5
Channels · one funnel view
Funnel Analysis
Customer Journey
SQL
Tableau
Pricing Strategy
Specific figures are generalized to respect Audi’s internal data; methodology and full detail available in conversation.