Mark the asset review record with whether a request exists or where and when it was sent.
Keep campaign reviews tied to the files sent to reviewers.
Your campaign reviewer gets the right file and question, while the review row keeps a link to the request.
Mark campaign assets ready to route when no review request exists.
Your asset row shows whether the current file version already has a review request, so your team can avoid asking twice.