Overriding default ClickBank affiliate hoplink target page

I have a blog where I sell an ebook that helps men build confidence via ClickBank. There’s a heap of free content on the blog, and I’d like my affiliates to be able to generate hoplinks that land on the most relevant page or post to their customers. For example, if I do a promotion targeted at Speed Dating Companies, I’d like the hoplinks they create to land on my article about successful speed dating, since that’s what is most relevant to their customers.

ClickBank allows extra parameters to be passed so I can instruct my affiliates to add a parameter to their hoplink to override the default hoplink target page like this:
https://AFFILIATE.VENDOR.hop.clickbank.net/?p=112
This gets redirected to:
https://confidentman.net/confident-man-ebook/?hop=AFFILIATE&p=112

Unfortunately this confuses WordPress, which returns a 404. Ideally I’d like it to honor the p=… parameter and redirect to that post, instead of the default hoplink target in the URL: /confident-man-ebook

I tried creating a regular expression with the Redirection plugin to match this, but couldn’t quite get it to work. Anyone else know of a plugin to do this, or another way to vary affiliate hoplink targets?

Thanks,
Graham