Add 'Email date received' as an available field in RE Query, plus 4 other changes to RE/BBNC email data interface

the 'date received' field is available in RE on individual's Netcommunity tab, but frustratingly not on the list of fields available to query. By adding it to Query, we would be able to select all emails received by constituents over a given period, rather than at present having to select by 'Email name is one of......' and manually selecting all the email names sent during the required period.

Whilst I'm on, I'd like to suggest some other changes/fixes to the way RE interacts with BBNC email data, which would hugely increase the power of this functionality:

• Expand the current Y/N ‘link clicked?’ functionality in RE to include which link(s) had been clicked (which BBNC knows, but can’t show which individuals clicked them)

• Fix the bug where a criteria “Email name does not equal x’ only excludes recipients of email x from the query is they have never received any other email either! This is the only field in RE that works like this.

• Allow some form of housekeeping on the list of email names in BBNC that appears in RE as a query field drop-down. Currently we have over 900, which appear in alphabetical order, take ages to load, and then you have to know the names of the emails you want to include in your query.

• Fix the bug that if you attempt to modify an existing ‘Email name equals’ criterion, the RE client crashes.

  • David Smith
  • May 4 2012
  • Attach files
  • Guest commented
    March 17, 2016 23:29

    It would also be great to query for the date someone unsubscribed from emails (or the date "requests no email" was checked