Searchable public resume
View resume details

Cordelia Ashworth-Nkemelu

Marketing Analytics Intern
Salt Lake City, UT, United States

Professional Summary

Data-driven marketing analytics intern and University of Utah marketing student (Data Science minor, 3.8 GPA) who turns messy campaign data into decisions. Built GA4 funnel analyses and BigQuery-backed Looker Studio dashboards that cut weekly reporting time by 70% and surfaced a checkout drop-off worth an estimated $180K in annual revenue. Comfortable across SQL, Python (pandas), A/B test design and readouts, and paid social platforms. Known for clean tracking hygiene, clear stakeholder storytelling, and shipping analysis on deadline.

Employment History

Marketing Analytics Intern
Summit Ridge Outdoor Co. · Salt Lake City, UT
May, 2026 · Present
Built a GA4 funnel analysis across 1.2M monthly sessions that pinpointed a 38% shipping-step drop-off; the resulting checkout fix lifted conversion 11% (~$180K annualized). Wrote 25+ SQL queries in BigQuery feeding three Looker Studio dashboards, cutting weekly reporting prep from 6 hours to under 2 for the 9-person marketing team. Read out 14 A/B tests on email subject lines, landing pages, and promo banners, flagging 3 underpowered tests and standardizing a sample-size calculator now used team-wide. Cleaned up UTM taxonomy for 400+ live campaign links, reducing "(not set)" and unattributed traffic in GA4 from 22% to 4%. Own the Monday KPI report (revenue, CAC, ROAS, email CTR) for the CMO, adding week-over-week variance notes that cut follow-up questions by half. Partnered with paid social to build a Meta Ads creative-fatigue tracker in Python (pandas), reallocating $35K of monthly spend to top-quartile ads and improving ROAS 0.6x.
Digital Marketing Assistant (Part-Time)
University of Utah Office of Admissions · Salt Lake City, UT
Sep, 2024 · Apr, 2026
Managed organic Instagram and TikTok calendars for prospective students, growing followers 41% (18K to 25.4K) and lifting average engagement rate from 3.1% to 5.6%. Built a HubSpot lead-scoring view for 30K+ prospective-student contacts, helping counselors prioritize outreach and raising campus-visit sign-ups 17% year over year. Ran 20+ email A/B tests on subject lines and send times; winning variants improved open rate 9 points and application-start clicks 23%. Coordinated $12K in Meta Ads campaigns for out-of-state recruitment, cutting cost per inquiry from $14.80 to $9.20.
Research Assistant
David Eccles School of Business — Consumer Behavior Lab · Salt Lake City, UT
Jan, 2024 · Aug, 2024
Recruited and scheduled 320+ participants for 6 consumer-choice experiments on price framing and product labeling, maintaining a 94% show rate. Cleaned and merged Qualtrics survey exports in Python (pandas) and R, building reproducible datasets used in two working papers. Ran descriptive statistics, t-tests, and logistic regressions under faculty supervision, and drafted results tables and charts for a conference poster.

Education

B.S. Marketing, Minor in Data Science (Expected)
University of Utah, David Eccles School of Business · Salt Lake City, UT
Aug, 2023 · May, 2027
GPA: 3.8/4.0; Dean’s List (5 semesters); Eccles Scholars Program. Relevant coursework: Marketing Analytics, Consumer Behavior, Digital Marketing, Marketing Research, Statistics for Business, Database Systems (SQL), Machine Learning Foundations, Data Visualization.

Skills

SQL (BigQuery)
Python (pandas)
Google Analytics 4 (GA4)
Looker Studio
Tableau
Excel / Pivot Tables
HubSpot
Meta Ads Manager
A/B Testing
Statistics

Courses

Google Analytics Certification
Google Skillshop
Mar, 2025
HubSpot Content Marketing Certification
HubSpot Academy
Jul, 2025
Google Data Analytics Professional Certificate
Google / Coursera
Feb, 2026

Extra-curricular Activities

VP of Analytics
Utah Marketing Association (student chapter) · Salt Lake City, UT
Aug, 2025
Lead a 6-member analytics committee running member surveys and event attendance tracking for 180+ members.
Capstone Project Lead — Subscription Churn Model
Eccles School Marketing Analytics Capstone · Salt Lake City, UT
Jan, 2026 · Apr, 2026
Built a logistic regression churn model in Python on 48K anonymized subscriber records (AUC 0.81) for a local meal-kit startup.