Get node path for Entity Referenced in Views
You already have the Entity Reference module installed and that is sufficient.

Create a view with base table Offer. Then add a relationship as follows: Click on add relationship, select filter by Entity Reference which will only show the entity referenced endpoints. It will show the field in question from two directions. You are working from the entity that contains a reference to another entity. You therefore select the 'A bridge to the Content entity that is referenced via field_whatver.

This pulls in the related entity. Now you just have to add the new field (URL) to your view and make sure that you set the relationship when you add it to the relationship you defined.