Ethan Shannon Email and Phone Number

• Managed and executed the multi-touch attribution reporting technique to evaluate effectiveness of marketing campaigns, and create data-driven strategies to optimize investments• Led digital advertising analytics for approximately 50 clients and associated sales teams with results totaling over $50M in client spend for 2023. Responsible for some of the highest spend clients/campaigns running digital attribution• Documented campaign performances through internal case studies, visualization dashboards, KPI reporting, such as cost per acquisition (CPA) or return on ad spend (RoAS), and benchmarking data• Executed brand studies with market research firms to analyze customer response to advertising (brand awareness and purchase intent metrics) and presented campaign results to inform strategic decision-making• Developed automated performance dashboards through the use of SQL and ETLs• Collaborated with go-to-market teams to ensure successful implementation of reporting products for campaign launchSkills & Tools: Microsoft Excel (Pivots/vlookup/macros), Data Visualization (Domo), Google Tag Manager, SQL, ETL Processes, Attribution Modeling, Dashboard Construction, Workflow Automation, Project Management, Client Communication

• Conducted advanced analyses of client datasets through the use of Oracle SQL Developer, AWS, and PostgreSQL• Collected and reported client KPIs, including Engagement Metrics, Churn Rates, Conversion Rates, and User Growth Rates• Produced live and interactive visualizations with Google Data Studio• Developed a standardized data report through implementation of the Google Heart Metrics framework

• Developed statistical hypothesis on the efficacy of Universal Basic Income (UBI) policy prescription• Cleaned and organized large datasets to ensure accuracy• Conducted data analysis with multivariate regressions through the use of Microsoft Excel & STATA• Researched academic literature on UBI and U.S. welfare programs