I need to generate a report showing parent/child Lead campaigns (and the email template used) with "Opens" from the HTML email status report.
The report would show the Parent Campaign, summarizing the child campaigns. The column headings would include: Number of Leads, Number of Opens and Number of Converted.
I tried creating a joined report with HTML email status, but found every report I tried to join to be an incompatible report type with zero common fields.
Perhaps I could auto-export the original HTML status report to an FTP site, and then try to reimport into a different object?
Can I add in a 'common field' with Leads or Contacts into the HTML Status report?
Any thoughts would be much appreciated!