Skills & Certifications
- Advanced Google Analytics Certified
- Google Ads Certified
- Tableau Certified Specialist
- Google Video Ads
- Google Display Ads
- Google Tag Manager
- RStudio
- SQL
- Mailchimp and Custom Contact
Description of Work
- Gather raw data from sources such as cell phone tracking, Visa spending, hotel occupancy, website usage, qualitative surveys and more to build comprehensive profiles of tourists visiting Centre County, PA
Tableau Work
This example combined two different sources of data. The first was a county-by-county breakdown of visitors to Centre County, PA from AirSage for the year of 2019. The second source was a general map of all the counties within 250 miles of Centre County, which is a distance we have determined over time to be a fair reach. The two sources of data were united using Tableau to develop a geographical heat map to find what counties saw the most visitors come. Graphs such as these often help determine what metro area publications we should engage in chats with about advertising purchases.
R Studio
The example below takes a look at 2,400 prospects in the ESPN Top 300 College Football Recruits from 2013-2020 looking at the balance between physical size vs. scouting grade broken down by position groups. There were some significant trends, including sweet spots for weights and heights that were seen to be more ideal than others.