Conducting and transparent optical ZnO thin films were deposited on glass substrates by a simple mini spray technique. Alternatively, some of the obtained films were doped with indium and ytterbium at the molar rates of: 1, 2, and 3% (In) and 100, 200, and 300 ppm (Yb). In addition to the classical structural investigations including XRD, microhardness vickers (Hv), and optothermal techniques, thorough optical measurements have been carried out for comparison purposes. The refractive indices and the extinction coefficients of the differently doped layers have been deduced from their transmission-reflection spectra over an extended wavelength range. Analysis of the refractive index data through Wemple-DiDomenico single oscillator model yielded quantum characteristics along with the values of long-wavelength dielectric constant, average oscillator wavelength, average oscillator strength, average oscillator energy and dispersion energy. Real and imaginary parts of dielectric constant have also been used to calculate free carrier plasma resonance frequency, optical relaxation time, and free carriers concentration-to-effective mass ratio. Finally, analysis of Urbach-Martienssen model parameters allowed proposing nanoscale explanations to the divergence about doping-related evolution of Urbach tails, this intriguing item having been intensively discussed in the literature in the last decades.