Recent Projects
Andrew Lenzo
ABOUT ME
I’m a marketing professional based in Denver, Colorado, with a proven track record across hybrid and remote work environments. I bring hands-on experience in product marketing, digital strategy, and cross-functional project management, leading initiatives for both DTC and B2B brands. My work spans from crafting high-converting landing pages and optimizing SEO performance using Semrush to running KPI-driven campaigns across LinkedIn, HubSpot, and Google Analytics. I thrive on empowering teams, building trust through thoughtful service, and driving long-term, scalable solutions that boost both efficiency and impact. In 2024, I chose to pause full-time work to pursue a Master’s degree at the University of Michigan to expand my skills in marketing analytics, AI fundamentals, and business strategy.
SKILLS
Certified in Google Analytics 4
As a certified Google Analytics 4 (GA4) professional, I bring expert-level knowledge in tracking, analyzing, and interpreting user behavior across digital platforms. I’m skilled at:
Setting up and structuring GA4 properties to collect essential business data
Customizing events to organize and track important metrics
Creating detailed reports to uncover insights
My expertise includes using GA4 with Google Tag Manager and BigQuery to support data-driven marketing strategies, campaign optimization, and performance reporting across web and app platforms.
Proficient in SQL for Data Analysis and Reporting
I have a strong command of SQL, with hands-on experience writing efficient queries to extract, analyze, and manipulate data across relational databases. My skills include:
Sorting data with SELECT statements
Joining multiple tables to uncover insights
Performing aggregations using COUNT, SUM, and AVG
I’m comfortable working with subqueries, common table expressions, and writing data manipulation statements to support real-time business needs.
Project management Expertise across cross-functional marketing initiatives
I bring strong project management experience developed through leading go-to-market strategies and campaign rollouts across diverse marketing environments. This includes:
Coordinating with cross-functional teams, including sales, engineering, design, and customer service, to manage timelines, reviews, and executive communication.
Using project management tools like Asana, Teamwork, and Microsoft Project to support tracking progress, assigning tasks, and keeping projects aligned with strategic objectives.
Managed new product launches, managed asset libraries using Brandfolder, and refined digital platforms using WordPress.