Editing AT&T List Clean Process (section)

== If *transactional*, (example – rolled up list with BTNs or BANs) ==

# Prep the records based on directions the acct mgr provided.
# Double check a few rolled up records to confirm accuracy
# Check that data elements are in the correct columns (there have been times when a record in the original list was missing a data element and it threw off the subsequent records)
# See if the total # BANs or BTNs in the prepped list match the total # of BANs or BTNs on the original file
# Place rolled up list in PREPPED folder. Name the file NC62335_YYYYMMDD_prepped
# Pre-BE unsubs are available when the emails are sent. Either pull a list of pre-BE unsubs when you send out the BE, or in a few days when results files are requested. Depends on project and acct mgr.
# In your timestamp, as fyi for acct mgr, note if there were pre-be unsubs or if there were dupes
# * If a prepped list has too many records for TailoredMail to handle in one shot, 
## Divide the list into those with more than 15 entries and those with less than fifteen entries.
## Export the list(s) as a tab deliminated txt file
## upload that file to http://generate.attacctinfo.com/prep/ ... This will create a txt file that you can open back into excel to resave as a xls to use for importing the list. 

=== Large List ===
# Use the JSON file to upload to http://generate.attacctinfo.com/ to create your landing page
# you will get a new TXT file with the pw and z columns
# you will now need to create from that a new xls file that you will use to upload to TM to make a new list