AFTER9, a dynamic media company, is seeking assistance in updating and optimizing its media contact list housed in AirTable. The current list requires a thorough review to ensure all contact information is accurate and up-to-date. This project aims to streamline communication efforts by refining the existing database and enhancing its usability. The goal is to provide AFTER9 with a reliable and efficient media contact list that can be used for future outreach and engagement. Additionally, the project involves generating insightful reports that analyze the current state of the media list, identifying trends, gaps, and opportunities for improvement. This project offers learners the chance to apply their skills in data management, analysis, and reporting, aligning with classroom knowledge in database management and communication strategies.

Key tasks include:

- Reviewing and updating contact information in AirTable.

- Ensuring consistency and accuracy across all entries.

- Generating reports that provide insights into the media list's current status.

- Identifying potential areas for expansion or improvement in the contact list.

The project deliverables will include an updated and verified media contact list in AirTable, ensuring all entries are accurate and consistent. Additionally, learners will produce a set of comprehensive reports that highlight key insights, trends, and recommendations for future improvements. These deliverables will provide AFTER9 with a robust tool for effective media outreach and strategic communication planning.