Andrew Whitacre Email & Phone Number

Beloit, Wisconsin, United States

Greater Chicago Area

Downers Grove, Illinois, United States

• Evaluated clients’ sales data, ZIP Code scoring, traffic patterns, competition, local market insight, and advanced demographic profiling to identify the core customer and determine the best media outlets to reach them• Performed spatial analysis with the aid of Alteryx and ArcGIS to define client trade area boundaries and utilize available first- and third-party data to magnify customer composition, creating highly targeted media strategies• Grew NSA Media’s digital product offering by developing tools used to automate both the planning and reporting processes, including database design and API feeds, campaign-optimization tools, and internal and external-facing campaign performance reporting• Created insightful Tableau dashboards for a range of projects, which provided clients with a unique visual insight into their store locations, customer profiles, ROI, and sales performance• Performed as a member of highly collaborative and innovative team that supported the organization through development of new strategy for both existing and prospective clients

• Supervised a team of analysts in optimizing weekly newspaper advertising program for several leading retailers• Developed strategy and various methodologies in consultation with clients for analysis of weekly circular program

• Analyzed and maintained weekly print advertising program, determined optimal media outlets and appropriate coverage levels.