Keyword Research & PPC Analytics Project

Overview: Analyzed real PPC data for a neuromarketing agency, identifying high-performing keywords and cost-efficiency insights through advanced Excel modeling. Extracted actionable marketing recommendations from complex datasets using SEMrush and Google Keyword Planner.

As part of a skills assessment for Adaptive X—a global leader in Neuromarketing and Applied Analytics—I completed a data-driven keyword research and PPC optimization project. Using real datasets from SEMrush and Google Keyword Planner, I evaluated four competing advertisers in the mesothelioma legal market to identify the most profitable and cost-efficient keyword strategies.

I built advanced Excel models incorporating formulas, pivot tables, and cost-per-lead projections to assess keyword performance, search intent, and ROI potential. My recommendations focused on optimizing ad copy, targeting high-intent search terms, and balancing spend efficiency with conversion opportunity.

This project strengthened my ability to turn raw marketing data into actionable strategy, enhancing my skills in Excel analytics, SEO/PPC optimization, data visualization, and campaign forecasting.

Skills: Excel (VLOOKUP, FILTER, Pivot Tables), SEMrush, Google Keyword Planner, Data Analytics, PPC Strategy, SEO Optimization, Neuromarketing