Print
|
|
|
Understanding the Audience Export Summary
The Export Details section provides more detailed information about the export file:
To view columns to the right and rows below those currently displayed, use the scroll bars.
Note: Click the Show Summary in Excel link to download this export report to an Excel document.
Lists
This section details information about values in each column for audience, seed, and proof lists.
Column |
Description |
List ID |
ID of the list |
Type |
Kind of list: seed | proof | audience |
Name |
Name of the list |
Alias List ID |
This is only applicable in rare cases when multiple List IDs are aliased as a single list for reporting purposes. This can be stripped out when sending to clients. |
Alias List Name |
This is only applicable in rare cases when multiple List IDs are aliased as a single list for reporting purposes. This can be stripped out when sending to clients. |
Source |
Initial number of e-mail addresses in the audience list. Typically, the data team has already removed certain types of invalid e-mail addresses, records with data that does not fit the column type restrictions in the client schema, and duplicate records; as a result, they are not be included in th Source number. |
Include |
Number of people included in the export file that e-Dialog attempts to mail to. Due to bad data and delivery issues, this might not be equivalent to the actual number mailed. |
Unique CID |
Number of unique CIDs across audiences. This number is only meaningful in the Total row, because it is different from the Include column only if there are CIDs that are found in multiple audiences within a given campaign. |
Dupe |
Number of duplicate records across audiences, plus records deduped by cell-level dedupe criteria, plus records eliminated by join conditions or WHERE criteria. This column can also include records that are in an existing audience list but not in the master database. If the dupe column contains negative numbers, the JOIN table may contain multiple records for a given CID; you need to add WHERE criteria to avoid getting multiple records for a CID. |
Suppress |
Suppression through suppression lists, cross-client global unsubs, cross-client global domain suppression and client domain suppression |
MobileSuppress |
Number of recognized mobile users who are being suppressed. (Mobile users should only receive transactional messages; this is configurable in the cell.) |
Unsub |
Number of CIDs in the list who have unsubscribed. Some clients manage Unsubs via suppression lists, in which case the unsubs do not appear in this column. These CIDs are not mailed unless configured specially in the cell for some types of transactional messages. |
Undel |
Records that have been flagged as undeliverable (not mailed unless configured in cell). |
Formats |
All the formats are listed. Indicates how many users are configured to receive each format of this e-mail. |
Suppression Lists
This section matches each suppression list with each audience and indicates how many CIDs were suppressed by each suppression list for each audience.
Column |
Description |
List ID |
ID of the suppression list |
Name |
Name of the suppression list |
Audience ID |
List ID of the audience that the suppression list is being scrubbed against |
Audience Name |
List Name of the audience that the suppression list is being scrubbed against |
Suppress Count |
Number of records suppressed from the listed audience by the listed suppression list |
Print