Tracking Sheet

I created a detailed media tracking sheet to monitor coverage on E. coli. I also organized information in a clear, functional Excel format with columns for publication date, outlet name, media type, headline, author, URL, topic/theme, sentiment, and key notes. This tool allowed for efficient analysis of media trends, sentiment shifts, and message reach. The project demonstrates my ability to gather, organize, and evaluate data for actionable public relations insights.