Reports

AlumnIQ Platform email reports are available in different locations, varieties, and formats; each intended to serve a specific need in a specific way.

• Individual message performance: (On-screen) Shows fairly granular data about opens and clicks over time for a single message -- on the detail screen for that message.

• Mail Dashboard: (On-screen) Displays a rolling 2-week window of messages sent and their engagement.

• Basic Performance Report: (Excel download) Allows you to specify a date range and shows summary stats per message.

• Mail Permeability: (CSV download) Available in Mail > Reports. FYTD per-person counts of sent, opened, and clicked. Generated monthly on the 8th of the month.

• Individual contact history: (On-screen) Available in Mail > Reports. Search by email address or xid and get a listing of marketing and transactional messages the constituent was sent, and relevant activity such as unsubscribes.

• Raw data is available from our API.

  • /mail/lists Summary of all lists, including type, member counts, and filters (if applicable).

  • /mail/lists/{listId} Detail listing of all attributes and members of a list. Includes email and xid, if available.

  • /mail/lists/{listId}/xids Returns an array of the xid's of all list members.

  • /mail/messages Summary of created messages.

  • /mail/messages/id-only List of message ID's SENT in a given date range.

  • /mail/messages/{messageId} Detail for an individual message.

  • /mail/messages/{messageId}/contacts/xid-only Returns an array of xid's for constituents who were SENT a copy of the message. Subset of List Members (minus unsubscribes, recent bounces, etc).

  • /mail/message/recipients/{messageId} Recipients for whom the mail server accepted and made an attempt to deliver the message. Includes lists without xid's.

  • /mail/message-activity Returns an array of email message events. Think: open, click, spam, unsubscribe.

  • /mail/messages-basic-performance Same data as the Basic Performance Report (see below), but available via API.

  • /mail/subscription-categories Returns an array of all subscription categories, both active and inactive.

  • /mail/subscription-preferences Get existing subscription preferences. Search by xid, iqid, and emailAddress (whichever values you provide will be OR'd together). If you don't pass any parameters, we'll return the 500 most recently created preferences.

  • /mail/subscription-preference-changes Get subscription preference changes since a given date. Be mindful of flip-floppers in how you use this data.

  • /mail/subscription-preference-changes-individual Get all subscription preference changes for an individual. Will show all flip flops.

  • /mail/suppressions Returns the latest snapshot of bounce suppression data.

  • /mail/all-bounces Returns an array of bounce data aggregated from Mailgun suppressions and hard_bounce data events. dateTimeCreated is translated to your campus local timezone. All suppressions are returned regardless of date;remember to purge suppressions after proper processing!

  • /mail/unsubscribe-all Returns an array of people who have enabled unsubscribe-all. Each row includes the email address, iqid (if available), and xid (if available); and the date/time it was created/removed.