John Cockerham Email & Phone Number

Dallas/Fort Worth Area

• Worked with AdOps team to optimize campaign performance based on several KPIs such as clickthrough rate (CTR), cost per action (CPA), video completion rate (VCR), etc.
• Mitigating delivery issues for campaigns struggling to spend in full
• Working with various data sets from multiple sources. For example, comparing Simpli.fi reporting to Google's DoubleClick Campaign Manager (DCM) and Google Analytics reporting utilizing various SQL queries to our.
• Extensive work in Excel for data analysis and reporting for clients including various formulas, pivot tables, and occasionally VBA scripts
• Identifying and communicating strategic initiatives to client services team such as incremental budget opportunities, fine-tuning target audiences, improving cost basis and ROAS (return on ad spend) for clients
• Running and helping create Python scripts to help automate several optimization strategies

Denton, TX

• Worked with a variety of clients to determine system needs, marketing solutions, content needs, and the creation of processes for management and implementations of their websites
• Participation in requirements gathering, web design, marketing, branding, and media meetings
• Writing requirements documents and user stories for client project requests
• Collaboration with BA / QA teams and development teams to complete user stories and fix bugs on client sites
• Extensive usage of both Drupal and DNN CMS platforms
• Database / SQL familiarity; using databases and Excel for data extraction and analysis; generating custom reports for clients based on specific requests

Denton, Texas

• Working with service delivery team to ensure top quality in project management, as well as delivering projects in a timely manner.
• Content administration: adding content into websites via Drupal's content management system, including product edits on e-commerce sites.
• Web testing for both Drupal and DNN sites using Atlassian's JIRA platform to monitor bugs and track issues.
• Social media for the company's pages as well as writing social media marketing strategies for clients.

Denton, Texas

• Learning about and working with cross-functional teams across the organization.
• Introduction to content and e-commerce product management on client websites.
• Assisting Accounting & HR teams with document review, invoicing, printing.
• Social Media management and development of strategies.

Denton, Texas

• Made coffee drinks, served customers, cashiering duties, customer service responsibilities, cleaning, and closing duties.

Fairview, Texas

• Served gelato to customers, maintained clean restaurant and workspace, cashiering duties, as well as closing duties.

Mckinney, Texas

• Worked in a kennel taking care of dogs and cats.
• Fed, medicated, walked, and took out dogs.
• Helped vet with procedures for the animals.
• Developed strong Customer Service and interpersonal skills with pet owners and fellow team members.

Bachelor Of Business Administration - Bba, Marketing, Cumulative Gpa Of 3.9 (Magna Cum Laude)

Activities and Societies: Honors College, Intensive English Language Institute: volunteer helping international students learn and.

Bachelor'S Degree, Spanish Language And Literature, Cumulative Gpa Of 3.9 (Magna Cum Laude)

Activities and Societies: Honors College, Intensive English Language Institute: volunteer helping international students learn and.