Integrating multiscale static and dynamic reservoir data to predict well productivity for risk reduction