Catapult Data Services creates a wide variety of
reports that give you the most accurate
information from your data. On this page
you will find several sample reports along
with a short description of each report.
Click
here for a printable version of the
report descriptions in Adobe
PDF format.
Summary Report
This one page report summarizes the counts
throughout the entire job process on a
list-by-list basis. Each list is on its
own row and each column counts the records
purged for the various reasons. This report
also lists the keycodes for each list
and details any splits that may have happened
for testing purposes. This is called a
summary report because all the counts
listed can also be found elsewhere in
the report booklet, however this one page
summary makes quick work of the details.
This report can also serve as a "List
Broker Report" that would count purged
records that result from DMA Preference
hits, Intra-list dupes and even "Bad
Address" records.
View
sample report
Top of the
page
Input List
Summary
This report presents counts of input records
per input list and suppress list (if any).
Each row describes a list.
Columns:
- Match Id Records - count of keycoded
records for each list
- Default Records - count of non-keycoded
records added to a list by default (rarely
used)
- Net Input - total records assigned
to each list
View
sample report
Top of the
page
List Quality
This report presents counts of records
with blank and/or unparsed fields for
each input list and suppress list. This
report provides an indication as to the
quality of each list. Each row describes
a list.
Columns:
- No Parse - count of records where
address could not be parsed into standard
components - detail counts for each
list are provided below
- No Address -count of records with
blank or unparsable addresses
- No Firm - count of records where
a firm/company name was not identified
- No Title - count of records where
a title/position was not identified
- No Last Name - count of records where
a last name was not identified
- No First Name - count of records
where a first name was not identified. Following
the Totals are details of the No Parse
records for each list.
Rows:
- Blank - count of records with blank
city, state, and zip fields
- Bad Lastline - count of records with
bad city, state, or zip fields
- Bad Address line - count of records
that could not be parsed into street
number and street name
View
sample report
Top of the
page
List
Duplicates
This report presents counts of records
by match status. Each row describes a
list. There are totals for all lists including
and not including any suppress list(s).
Columns:
- Suppress Dupes - count of input list
records that match suppress list records
(purged)
- Single List Dupes - count of input
list records that match other records
within same list (purged)
- Multiple List Dupes - count of input
list records that match records from
other input lists (purged)
- Total Dupes - sum of previous three
groups which represents the total of
purged records
- Uniques - count of input list records
not matching any other record from any
list (kept)
- Single List Masters - count of input
list records that match other records
within the same list (kept)
- Multiple List Masters - count of
input list records that match records
from other input lists (kept)
- Total Non Dupes - sum of previous
three groups which represents total
of kept input records
- Suppress List Uniques - count of
suppress list records not matching any
other suppress list record
- Suppress List Masters & Suppress
List Subord - counts of suppress list
records that match other suppress list
records
Summary Information
This report summarizes each list by
match status. Each row describes a list.
There are totals for all lists including
and not including any suppress list(s).
Columns:
- List_Id - usually the keycode - if
not, Catapult Data Services assigns to track each
list
- List Type - either NORM for input
list, SUPP for suppress list, or SPEC
for seed list
- List Priority - set by Catapult Data Services
according to customer instructions -
lower number, higher priority - suppress
or seed lists are always zero
- Total Dupes - count of input list
records purged as duplicates or matching
suppress records
- Total Non Dupes - count of input
list records kept as unique or master
duplicate
- Net Input - original input count
for all lists - see Total Non Dupes
for pre-filter output counts
View
sample report
Top of the
page
List Match
Description.
This report presents counts of how many
matches there were by list against each
of the lists. This report breaks out the
List-by-List Match Report into easy-to-read
blocks that detail the matches on a list-by-list
basis.
View
sample report
Top of the
page
List-By-List
Match
This report presents counts of how many
records from each list matched records
in each other list. The input lists are
arranged in a matrix. There is a row and
column for each list. The values in the
matrix are the count of matches between
each pair of lists.
View
sample report
Top of the
page
Multi-List
This report presents counts of how many
records from each list matched other lists
multiple times. Each row describes a list.
The columns detail how many records in
each list matched records in 2 other lists,
3 other lists, etc. Single list matches
are not counted.
View
sample report
Top of the
page
Duplicate
Records
This report presents a sampling of the
records identified as duplicates. Records
determined as duplicates are grouped with
blank lines between. The sampling is usually
arbitrarily set to be the 101st through
250th duplicate records. The first column
is the keycode and/or list id. The remaining
columns are the name and address elements.
View
sample report
Top of the
page
Output File
Detail Information
This report presents counts of output
records surviving the purge and any filtering.
Each row describes a list. All of the
columns are described in the List Duplicates
Report-Detail description above, except
Filter Drops. Filter Drops are records
that are dropped after the purge by filtering.
Usually, these are records that are determined
to be undeliverable.
Summary Information
This report summarizes counts of output
records surviving the purge and any filtering.
Each row describes a list. All of the
columns are described in the List Duplicates
Report-Summary description above, except
Filter Drops. Filter Drops are records
that are dropped after the purge by filtering.
Percentages of records filtered and output
are also provided.
View
sample report
Top of the
page
Executive
Summary
This report summarizes all of the above
reports. Most lines are self-explanatory,
but a couple of comments are warranted.
The Input Posting/Purging section is not
applicable to Catapult Data Services merge/purges;
separate output lists are generated rather
than posting to and purging original lists.
Group Posted Records are records that
are updated with data from duplicates;
this feature is rarely used.
View
sample report
Top of the
page
State Summary
This report presents counts of output
records by state abbreviation.
View
sample report
Top of the
page
SCF Summaries
This report presents counts of output
records by SCF both in alphabetic and
descending output quantity order. Note
that not all 3-digit zips (commonly called
an SCF) are associated with a Sectional
Center Facility (SCF).
View
sample report
Top of the
page
3-Digit ZIP
Summary
This report presents counts of output
records by 3-digit ZIP.
View
sample report
Top of the
page
Let Catapult Data Services help you get the most out of your valuable marketing dollars. Call us toll-free at 1-877-735-DATA or e-mail us for more information.
Give us data. Get results.™ |
