I initiated, developed and maintained a sophisticated company database from scratch using Airtable. With Airtable's built-in scripting extension as my Javascript IDE, as well as native automations and 3rd party API's, I led the planning and execution of this project from start to finish. Here are just a few of the features I either built myself or planned and managed the completion of:- Migration of all client data from Monday.com to Airtable- Comprehensive CRM for logging account notes and storing client data- Development of a project management solution that used linked records to connect tasks to client account records, services, Google Ads accounts, site URLs and more- Development of custom Javascript automation that saved hundreds of cumulative hours during onboarding by programmatically creating task records and assigning collaborators based on services purchased by clients - Development of custom Javascript automation using Airtable's input.config() method and a custom filter function to automate task status changes based on completion of parent tasks- API-based automation connecting client billing statuses to real-time processing data through Stripe's API- API-based automation enabling real-time status update syncing and To-Do/Task creation between Basecamp 3 and Airtable- Business Intelligence solution developed with JS to create an Airtable interface view for top leadership to track new client acquisition, attrition, new revenue and net revenue against objective- Google Ads performance management tool that would get account data weekly from Google Sheets, perform calculations against baseline data and notify the team of underperforming accounts to save time on manual review - baseline data was calculated after segmenting for account spend and industries- Effective communication, management and collaboration with contracted career developer across international timezones for projects requiring advanced programming skills

My team was responsible for omni-channel new customer acquisition. I had two direct reports and broadly, our team was responsible for new customer acquisition through organic and paid channels.- directly accountable for performance and spend at enterprise scale- effectively managed greater than $1mil dollar in ad spend- acquired greater than 100k new customers- transformed legacy Google Ads account structure to leverage new tools and technologies released including Dynamic Search Ads and Smart-Bidding strategies like Target CPA- phased out reliance on legacy targeting strategy including campaign scheduling and bid increases on demographics such as gender and income level- replaced these legacy targeting settings with audience targeting/observation, seasonal bid adjustments and machine learning based strategies- led and managed SEO projects designed to provide greater value for organic users such as a real-time asynchronous web page that updated the market value of gold/silver investment products- led scalable strategy for updating meta-data for 35k+ webpages- managed massive scale project of updating SEO titles and descriptions for hundreds of category and blog pages- created strategy for programmatically updating SEO titles and descriptions of thousands product pages

Developed a fresh new Brand Kit and standards to execute a complete marketing overhaul of a family business that had been around for over 90 years.Worked directly with owners of the company and CEO to improve sales and revenue through a variety of acquisition channels including PPC, SEO, print and other traditional forms of media.

Managed All Budgeting & Logistics Planning For All Productions Resulting In Profitability Of All Projects And On-Time DeliveryHired Talent, Crew, And Supporting Functions For Professional Video ProductionsProduced All Television Ads For A Large Casino In Oklahoma in 2014-2015 Resulting In Increased Brand Awareness & RevenuesWrote, Produced, & Directed A Nationally Televised 60 Second Ad on ESPN Leading To Increase In Event Attendance Of A Professional Sports TournamentManaged & Performed Cinematography, Video Editing, & All Functions of Video Production Produced Ads, Music Videos, Films, & Web VideosManaged Large Video Production Teams

Consulted With Franchisees And Managed Marketing From Corporate OfficeDeveloped Internationally Visited WebsiteManaged Social MediaConsulted For Product Development Of New Flavors And Product OfferingsProduced Marketing Video To Add New Locations/FranchiseesManaged Production of Animated In-Store VideosDesigned Labels, T-Shirts, And Cup Dividers Shipped Internationally To All Locations

The first job I had out of college. Oklahoma allows applicants to test for and obtain an alternative teaching certification that doesn't require a degree in Education, just a degree. I'm glad I had the experience but this was largely a blip. The kind of job you get when you feel a little lost right out of college.