Presently the Amazon Ads data is not available at an hourly granularity , which is required in order to estimate the hourly spend and the availability of the latest data at datetim. Amazon has a different API Amazon Marketing Streams (AMS) that can provide hourly data. We'd like to have this in the Amazon Ads connector as it improves the functionality of the connecter