Video Collection and Organization: Initiated by gathering videos posted on the client's Facebook group and those generated through the Coach's Eye Webcam Application. This step was crucial in consolidating content scattered across different platforms.

Online Spreadsheet Creation: Developed a detailed online spreadsheet to log and monitor the status of each video. This involved recording stages from downloading and uploading to final integration into the membership site. The spreadsheet was meticulously designed to include all relevant details necessary for comprehensive tracking.

Conditional Formatting Implementation: Applied conditional formatting to the spreadsheet, using different colors to signify various stages of the video management process. This visual aid was pivotal in enabling quick status checks and enhancing overall workflow efficiency.

Data Validation for Accuracy: Incorporated data validation rules to minimize errors and ensure the reliability of the tracking process. This step was essential in maintaining the integrity of the video management system, preventing duplicates, and ensuring only relevant content was processed.

Streamlining Management: The overarching goal was to simplify the complexity of managing a large volume of instructional videos. By employing strategic organization and digital tools, the project significantly improved the efficiency and accuracy of video management for the membership site.