Skip to main content

RONAN TILLOTSON

Marketing & Analytics

About

Marketing and analytics are the two subjects I find most interesting in business. I graduated in the spring of 2026 from CU Boulder with a BS in Marketing and Business Analytics, now pursuing an MSBA with a track in Decision Science.

Marketing draws me in through consumer behavior, understanding what customers need and what shapes their decisions. Analytics gives me the evidence, trends, and methods that point to a real solution. One builds my understanding of the customer. The other validates the approach.

What drives me is getting it right. I want to be the person you can trust to call the right move and back it with data that tells the story.

RT – profile photo

Projects

Dashboard Builder · 2025

Live Portfolio Tracking Sheet

Built an Excel tool to pull live data from the web to track pricing, volume trends, and portfolio insights in one place since I couldn't find anything that did it for me. Built with Power Query, VBA, and macro automation.

Excel Visual Basic for Applications (VBA) Microsoft Power Query Macro Automation
Natrol Logo
Influencer Marketing · Marketing Case Competition · 2025

Natrol Case Competition

Tasked with improving an existing marketing approach, our team researched the category, analyzed performance patterns, and identified opportunities.

We came up with a direction for future influencer work and a useful framework to help with making choices and planning content. We concluded with actionable recommendations to strengthen the overall strategy.

Influencer Strategy Marketing Analytics Quantitative Research Consumer Insights Best-in-Class Analysis
Analyst · BAIM3205, BAIM4120, MKTG3050, & MGMT4820 · 2025-2026

Business/Decision/Customer Analytics

Familiar in data analysis platforms like RStudio, Alteryx, SQL, and now Python, to clean messy data, find patterns, and turn that into decisions we can act on.

Google BigQuery (SQL) Rstudio Alteryx Python ETL
Intro Logo
Qualtrics Stats
Qualtrics Logics
More Qualtrics Logics
Product Strategy · MKTG3350 & MKTG4250 · 2025

Survey Building

Designed and ran Qualtrics surveys for brand perception, concept testing, and consumer insight. Used sampling, survey logic, and A/B testing to collect usable data.

Qualtrics Survey Design Screeners & Quotas Consumer Insights Survey Logic
Market Research · 32 Eight LLC · 2026

Go-to-Market Research

Working with a startup to research trends, competitors, and consumer interest for an early-stage product. Delivering recommendations on pricing, packaging, messaging, and launch.

Mintel Nielsen MRI-Simmons Google Trends

Photography

Lets Connect