Target products by creation date and add advanced discount rules

I want the ability to target products by their created_at date, set priority between multiple coupons/discounts, exclude items that are already on sale, randomly select products for promotions, and set a fixed final price for all products in a collection.