Ground-based observations of Very High Energy (VHE) gamma rays from extreme astrophysical sources are significantly influenced by atmospheric conditions. This is due to the atmosphere being an integral part of the detector when utilizing Imaging Atmospheric Cherenkov Telescopes (IACTs). Clouds and dust particles diminish atmospheric transmission of Cherenkov light, thereby impacting the reconstruction of the air showers and consequently the reconstructed gamma-ray spectra. Precise measurements of atmospheric transmission above Cherenkov observatories play a pivotal role in the accuracy of the analysed data, among which the corrections of the reconstructed energies and fluxes of incoming gamma rays, and in establishing observation strategies for different types of gamma-ray emitting sources. The Major Atmospheric Gamma Imaging Cherenkov (MAGIC) telescopes and the Cherenkov Telescope Array Observatory (CTAO), both located on the Observatorio del Roque de los Muchachos (ORM), La Palma, Canary Islands, use different sets of auxiliary instruments for real-time characterisation of the atmosphere. In this paper, historical data taken by MAGIC LIDAR (LIght Detection And Ranging) and CTAO FRAM (F/Photometric Robotic Telescope) are presented. From the atmospheric aerosol transmission profiles measured by the MAGIC LIDAR and CTAO FRAM aerosol optical depth maps, we obtain the characterisation of the clouds above the ORM at La Palma needed for data correction and optimal observation scheduling.