Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-21467

Mailing Opens report displaying contact once only

          Details

          • Type: Bug
          • Status: Open
          • Priority: Minor
          • Resolution: Unresolved
          • Affects Version/s: 4.6.29, 4.7.25
          • Fix Version/s: None
          • Component/s: None
          • Labels:
            None
          • Versioning Impact:
            Patch (backwards-compatible bug fixes)
          • Documentation Required?:
            None
          • Funding Source:
            Needs Funding
          • Verified?:
            No
          • Overview:
            Hide
            When you run a mailing opens report and you want to see how many mailing one contact has opened, the result will always show only 1. The result will show the contact twice only if the different mailings were sent to different email addresses of the same contact. So probably the query is grouping by email address and shows only the first mailing.

            I have tested on 4.6.29 and on 4.7.25 demo site (https://civicrm.demo.civihosting.com)
            Show
            When you run a mailing opens report and you want to see how many mailing one contact has opened, the result will always show only 1. The result will show the contact twice only if the different mailings were sent to different email addresses of the same contact. So probably the query is grouping by email address and shows only the first mailing. I have tested on 4.6.29 and on 4.7.25 demo site ( https://civicrm.demo.civihosting.com )
          • How it works currently:
            Hide
            - go to Mailings / New mailing
            - create a mailing with title "Mailing 1"
            - send it to a group that contains your contact
            - then open it in Gmail so that it counts your open (usually when you open for example in Thunderbird, its not counted)
            - then create a new mailing again with title "Mailing 2"
            - send it to the same group you used before
            - then go to Gmail and open the mailing
            - check if both mailing reports shows your Open as counted
            - then go to the Mailing open report (/civicrm/report/instance/34)
            - and simply preview the report
            --> it should display both of the mailings opened by your contact, but it shows only the first mailing "Mailing 1"
            - then click the "Filters" tab of this report and select "Mailing 2" at the Mailing Name field (with criteria "is one of")
            - preview the report again, it will display your contact with "Mailing 2" - that is correct
            - but then if you add "Mailing 1" to the filter too, it will again display only "Mailing 1" and exclude "Mailing 2"
            Show
            - go to Mailings / New mailing - create a mailing with title "Mailing 1" - send it to a group that contains your contact - then open it in Gmail so that it counts your open (usually when you open for example in Thunderbird, its not counted) - then create a new mailing again with title "Mailing 2" - send it to the same group you used before - then go to Gmail and open the mailing - check if both mailing reports shows your Open as counted - then go to the Mailing open report (/civicrm/report/instance/34) - and simply preview the report --> it should display both of the mailings opened by your contact, but it shows only the first mailing "Mailing 1" - then click the "Filters" tab of this report and select "Mailing 2" at the Mailing Name field (with criteria "is one of") - preview the report again, it will display your contact with "Mailing 2" - that is correct - but then if you add "Mailing 1" to the filter too, it will again display only "Mailing 1" and exclude "Mailing 2"
          • How it should work:
            Hide
            - go to Mailings / New mailing
            - create a mailing with title "Mailing 1"
            - send it to a group that contains your contact
            - then open it in Gmail so that it counts your open (usually when you open for example in Thunderbird, its not counted)
            - then create a new mailing again with title "Mailing 2"
            - send it to the same group you used before
            - then go to Gmail and open the mailing
            - check if both mailing reports shows your Open as counted
            - then go to the Mailing open report (/civicrm/report/instance/34)
            - and simply preview the report
            --> it will display both of the mailings opened by you
            - then click the "Filters" tab of this report and select "Mailing 2" at the Mailing Name field (with criteria "is one of")
            - preview the report again, it will display your contact with "Mailing 2" - that is correct
            - and then if you add "Mailing 1" to the filter too, it will display both of the mailings opened by you
            Show
            - go to Mailings / New mailing - create a mailing with title "Mailing 1" - send it to a group that contains your contact - then open it in Gmail so that it counts your open (usually when you open for example in Thunderbird, its not counted) - then create a new mailing again with title "Mailing 2" - send it to the same group you used before - then go to Gmail and open the mailing - check if both mailing reports shows your Open as counted - then go to the Mailing open report (/civicrm/report/instance/34) - and simply preview the report --> it will display both of the mailings opened by you - then click the "Filters" tab of this report and select "Mailing 2" at the Mailing Name field (with criteria "is one of") - preview the report again, it will display your contact with "Mailing 2" - that is correct - and then if you add "Mailing 1" to the filter too, it will display both of the mailings opened by you
          • Acceptance Criteria:
            - all mailings are displayed that were opened by the contact

            Attachments

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  ritatorok Rita Torok
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated: