top of page

Leads Density Analysis Preview

Consumer Marketing Intern | Cummins Inc.

PROJECT OVERVIEW

Led the development of an interactive lead density report for account executives across U.S. territories, helping them visualize high-opportunity counties and optimize their travel and outreach efforts. The tool combined cleaned location data, heatmaps, and interactive navigation to support more targeted sales strategies.

*Browse through a preview of the guide below

LD_1.png

PROCESS

Click each of the tabs below to explore each step of my process towards completing this project.

1. Data Cleaning & Preparation

  • Received a raw Excel file with lead entries tagged by various location types (e.g., cities, towns, zip codes)

  • Took the lead on the project, managing two interns and dividing responsibilities amongst the three of us

Excel.png

OUTCOME

  • Delivered a clean, interactive reporting tool that allowed account executives to quickly navigate lead density by region, state, and territory

  • Improved data accuracy by standardizing inconsistent geographic inputs and resolving zip code overlaps across counties

  • Provided actionable insights through supplementary charts highlighting the top-performing counties in each state

  • Successfully presented findings to national sales leadership, sparking discussions around territory prioritization and future strategy

  • Created a reusable template and documentation for future updates and rollouts

SKILLS

  • Data Cleaning & Standardization – Transformed messy geographic data into consistent, analyzable formats

  • Territory Mapping & Visualization – Created Excel-based heatmaps and geographic breakdowns for actionable sales insights

  • Project Management – Oversaw and delegated tasks to two interns, ensuring consistency across regions and deadlines

  • Interactive Reporting Design – Built a PowerPoint tool with clickable navigation by state and territory

bottom of page