Reporting on Campaign Email Opens

I’m having difficulty getting the lead name or lead email address based on campaign activity to work in reports.

I’ve tried using different reporting modules but just can’t seem to grab the lead info.

I’m currently reporting on the CAMPAIGN LOG and selecting records where ACTIVITY = VIEWED MESSAGE which works great I can see the record and the number of hits field, the campaign name fields, but when I add any email address fields to the report or firstname, lastname fields there is nothing there???

There is an article on SugarCRM about how to do this and it says use the “MORE INFORMATION” field, but that is blank as well.

Anybody know how to generate a report of everyone that opens a mailing campaign?

I know you can see this in the campaign but I want to set up an automated report.

I’ve attached a screenshot of the report I’m trying to generate.

HI all,
I’m a newbie of SuiteCRM and I’ve the same exact problem.

I’ve also noticed that if I filter the data by “message sent/attempted” the more_information field returns the correct email address of the target.
Only in the case of “viewed message” filter the field remains empty.

Can someone help me?

Thanks in advance

Frank