Marketing Analyst, Ads Marketing Analytics
Google

August 2022 - Present
Mountain View, CA

• Led the conception, coding, and production launch of an automated email system (codenamed Shadowfax), which automatically delivers weekly event performance reports to 600+ PMMs

• Spearheaded the end-to-end development and launch of a new Company-Level Dashboard, managing the project from initial ideation and stakeholder alignment to backend infrastructure build and legal review

• Built a comprehensive reporting infrastructure and an interactive dashboard, empowering senior leadership with insights into Google’s event performance. This view enabled better strategic decision-making and budget allocation across regions. 

• Created efficient data pipelines with custom macros to calculate event impact metrics, reducing data processing time by 80% and making it easier to highlight top- and bottom-performing events 

• Created a program-level dashboard to analyze and compare the effectiveness of different event programs, empowering users to evaluate program spend, attendance, and cost per company attended. Facilitated performance benchmarking across programs, fostering informed resource allocation and optimization 

• Identified and recommended solutions to fix segmentation issues in existing workflow improving accuracy by 25%

• Implemented Causal Impact algorithm (Python, R) to identify top-performing subscription items, informing a data driven dashboard that recommended 7.5K new product additions and contributed to a 40% YoY growth in subscriptions. 

• Created a tableau dashboard for the Online Pricing team that analyzed historical, intra and post-event performance. This filled a critical gap in data visibility and reporting and helped save the team 55 hours of effort per event 

• Mentored an intern in the development of a diagnostic report of negative margin items, providing insights into the causes of negative margins and recommending actionable solutions. 

• Responsible for creating an innovative Newness report that focused on new assortment, allowing management to track new SKUs onboarded and their corresponding sales across categories and initiatives 

• Conducted SQL training sessions for the Assortment Growth team enabling them to write production level code and improve overall productivity of the team 

• Segmented customers on membership type, to identify trends and patterns in usage behavior using SQL and Tableau

• Performed congestion analysis to identify stations with the highest market potential based on demand and utilization 

Substack: Main Missions and Side Quests