Frankie Pike

Elections Web Scraper

The Associated Press•  June 2024 - November 2024•  New York, NY (Remote)

Configured Python-based web scrapers to gather real-time primary and general election data across counties in Pennsylvania, Wisconsin, California, and Illinois, producing timely quantitative insights into voter trends and candidate performance metrics. Standardized and cleaned disparate data sources—including HTML, XML, JSON, JavaScript-rendered content, CSVs, and scanned PDFs—ensuring data quality and consistency for downstream statistical analysis.

Brand and Paid Media Strategist

3rd + Lamar Performance Marketing Agency•  June 2023 - April 2024•  Austin, TX (Remote)

Implemented a comprehensive, replicable data reporting and visualization dashboard using Looker Studio for 3 largest clients, enabling real-time KPI tracking and driving a 56% increase in ROAS and a 29% reduction in CPC for Sanabul, a leading boxing gear product brand; the system remains in use to optimize campaign performance and resource allocation. Spearheaded a 20% year-over-year revenue surge for a key client through data-driven Google Ads strategies, achieving a 35% rise in website traffic and a 41% boost in purchase value. Delivered polished, client-facing presentations as the final reviewer and editor for all communications, demonstrating a proven track record in ensuring clarity and precision in business communication to diverse audiences.

Brand and Advertising Coordinator

3rd + Lamar Performance Marketing Agency•  October 2021 - June 2023•  Austin, TX (Remote)

Developed a multivariate linear regression model to evaluate the effect of marketing activities on lead generation, providing actionable insights that informed targeted recommendations for improved customer acquisition. Executed and project managed company-wide rebrand, significantly increasing key performance metrics post-rebrand, including a 44% rise in website visitors, a 332% jump in social media impressions, and a 68% increase in engaged users.

Content and Marketing Specialist

3rd + Lamar Performance Marketing Agency•  May 2021 - October 2021•  Austin, TX (Remote)

Integrated advanced content strategies and marketing projects, contributing to improved operational outcomes. Identified the need for and initiated a company rebrand, which contributed to a 48% boost in U.S. web traffic.

Consulting Associate

The Ronnie K. Irani Center for the Creation of Economic Wealth•  January 2020 - May 2020•  Norman, OK

Consulted one-on-one with startup client to analyze quantitative market trends, consumer behavior, and economic indicators. Delivered a research-backed logistic model that quantitatively determined optimal expansion locations, guiding client's strategic decision-making process.

NASA Grant-Funded Economic Research Intern

Norman Economic Development Coalition•  June 2019 - November 2019•  Norman, OK

Conducted comprehensive economic research and provided actionable insights that informed strategic decisions.