Thursday, June 12, 2008

Group Merge Available in Exported Reports

JangoMail has now updated our Super Reporting pages to again allow for merging Group data with reports during export. To use this feature, you must export by email (the envelope icon). The direct download to CSV will not perform the merge.

If you have sent a campaign to a JangoMail Group, you will be able to select that Group during export to see the list of data in the report, along with the data that was originally stored along with the email address in your Group.

Let's do an example:
  • A campaign is sent to a Group containing the following data:

    emailaddress, customerID, firstname
    jane@doe.com, 12345, Jane
    smith@yahoo.com, 12346, Bob

  • The Unsubscribes report shows that Jane unsubscribed, and we export that report.

  • With a standard export, the email address would be included in the report, along with the date and time the address unsubscribed (jane@doe.com, 06/13/2008 01:00:00 PM).

  • If the export is Merged with the original Group that received the message, the report would include the email address, the date and time of the unsubscribe, the customerID, and the firstname (jane@doe.com, 06/13/2008 01:00:00 PM, 12345, Jane).

This feature is most often used when exported data needs to be synchronized locally to other stored data. In the example above, we could then update Jane's information easily because we had her customerID -- and that is how our system tracks her.