Lead Information


I created a VBA project for Homestar Windows.  This company is owned and operated by my father, Dave Orgill.  It specializes in vinyl replacement windows and doors.  The business has 12 employees including three secretaries, six salesmen, and 2 installation crews.  Homestar Windows advertises through a diverse range of mediums including Home Improvement magazines and newsletter subscriptions, Google Adwords, the radio, Angie’s List, Yelp, and Facebook.  Homestar diligently tracks how new customers heard about it.  It also employs the use of CallSource.com.  This company produces 20 different phone numbers that Homestar utilizes.  A different phone number is used on each advertising medium.  When someone calls in, callsource.com recognizes the phone number and matches it to an advertising source.  That way, Homestar knows where people are learning about its products.

My projects simplifies and automates the lead tracking process for Homestar’s lead secretary.  It allows the user to input new lead information, produces executive level lead information, and brings in comparative data from callsource.com. 

http://files.gove.net/shares/files/14w/ammon13/Final_Project-Ammon_Orgill.xlsm

http://files.gove.net/shares/files/14w/ammon13/Ammon_Orgill_Final_Project.pdf