Body: <p>When we run the Mail Open Report and include the "Mailing" Field it does not return consistent data.  We expected it to return the latest mailing opened but it does not and the title of the mailing is not consistent with the subject in the Mailings file which can be found when I click on the individual contact and review their mailings. </p>
  
  <p>How can I return the most recently opened email with the contact for this report?</p>
  
  <p>We are using version: CiviCRM 4.6.18.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-07-26T00:02:40.883Z
Comments.Text: Could you please edit the question to indicate your CiviCRM version?
Comments.UserDisplayName: Jon G - Megaphone Tech
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-07-27T09:51:31.500Z
Comments.Text: If you are looking for a list of contacts that have opened a specific mailing you might be better off first locating the mailing you are interested in from the list of 'Scheduled and Sent Mailings', and then click on the report link from that view. This shows a number of key bits of information about the given mailing, including the number of 'tracked opens'. To the right of this stat is a link to the 'Mail Opened' report specific to the mailing you are interested in.
Comments.UserDisplayName: Graham
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-07-27T09:53:11.110Z
Comments.Text: Also you should bear in mind that the number reported as 'tracked opens' should be considered as indicative rather than accurate given the variability in how mail clients are configured.
Comments.UserDisplayName: Graham
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-07-27T09:54:34.593Z
Comments.Text: Also, the title of a mailing is not the same as the subject line. The title is an administrative label, whereas the subject is what the recipient gets to see.
Comments.UserDisplayName: Graham
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-08-01T09:51:56.577Z
Comments.Text: Thank you Graham, we are trying to automate the report so we contact those people who have changed a behaviour and want to use the most recent email.
Comments.UserDisplayName: Caroline
Tags: <civireport>
Title: Where does the "Mailing" data come from in the Mail Opened Report?
ThreadText: # Where does the "Mailing" data come from in the Mail Opened Report?
  
  (Asked by: username_0 on 2016-07-25)
  
  When we run the Mail Open Report and include the "Mailing" Field it does not return consistent data. We expected it to return the latest mailing opened but it does not and the title of the mailing is not consistent with the subject in the Mailings file which can be found when I click on the individual contact and review their mailings.
  
  How can I return the most recently opened email with the contact for this report?
  
  We are using version: CiviCRM 4.6.18.
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_1**: Could you please edit the question to indicate your CiviCRM version?  
  > **username_2**: If you are looking for a list of contacts that have opened a specific mailing you might be better off first locating the mailing you are interested in from the list of 'Scheduled and Sent Mailings', and then click on the report link from that view. This shows a number of key bits of information about the given mailing, including the number of 'tracked opens'. To the right of this stat is a link to the 'Mail Opened' report specific to the mailing you are interested in.  
  > **username_2**: Also you should bear in mind that the number reported as 'tracked opens' should be considered as indicative rather than accurate given the variability in how mail clients are configured.  
  > **username_2**: Also, the title of a mailing is not the same as the subject line. The title is an administrative label, whereas the subject is what the recipient gets to see.  
  > **username_0**: Thank you username_2, we are trying to automate the report so we contact those people who have changed a behaviour and want to use the most recent email.  
  
  ---
  
  ## 0 answers
  
  