Report listing Contacts to Call

Hi

I have been asked if it is possible to create a report, that can be exported that lists people who have received an email from Hubspot Campaign. In other words all those that have received the campaign email, I need a list detailing

Names

Contact Number

Email Address

Company Name (primary)

Company Name (dealership)

I have gone in to the dealership record, clicked on all associated deals. Then filtered the particular campaign name. It lists the name and the company but I cannot see the contact number? I cannot add that column.

The only way I can see it possibly working is a custom report that brings together the deal campaign and the detail of the contact, filtered by dealer

I am not sure it should be a report or a list

@JGray30 -
I believe this could work as a saved view in your CRM.
Would it work to use the contact property "Last touch converting campaign" as the filter to pull through the relevant contacts and then use the ‘Edit columns’ button on the top right of the index table to add in the relevant contact properties and the assocaited company records?
You can then export this view.