Yes. Campaign tags adds a tag to every product in the sale and removes it when the sale ends. You can use the tag for a "Sale" collection, for badges or filters in your theme, or to let other apps (feeds, ERP) skip sale items.
Learn more: Price reduction - Settings/targeting