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.