AT&T List Clean Process
- AT&T List Clean Process
Prep the list(s) following direction that the acct mgr included in Seeker.
If the list *non-transactional*,
- Upload the list to TM - Pull a list of the pre-BE unsubs. Name the file NC62335_PreBEUnsubs_YYYYMMDD (SV##### for SV jobs) - Prepare a list/lists of the records TM kept; the pre-BE unsubs. Name the file NC62335_YYYYMMDD_prepped
without
- Check that the # of records in the prepped file/files equals # of records in the original file *minus* pre-BE unsubs - Post file/files to PREPPED folder - In your timestamp, as fyi for acct mgr, note if there were pre-be unsubs or if there were dupes
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, split into more manageable volumes (I don’t have details on how this is decided and completed) Place multiple files in PREPPED folder as needed. For very large volume jobs, you may need to manage how many records with the same domain go out at the same time (I know this is a consideration but do not have detail)
Results – complete the following if/when the acct mgr requests results. Post files to the PREPPED folder
Transactional BE
- Pull the PDF results report. Name the file “NC62335_Report_YYYYMMDD’ USE THE DATE THE BE WAS SENT
- *You may need to pull multiple reports if there are multiple versions or if the list had so many records that it was split up into multiple smaller volumes (we call these ‘splits’)*
- Pull a list/lists of emails sent. Name the file ‘NC62335_Sent_YYYYMMDD’ - Pull a list of pre-BE unsubs. Name the file ‘NC62335_PreBEUnsub_YYYYMMDD’ - Pull a list of post-BE unsubs. Name the file ‘NC62335_Unsub_YYYYMMDD’
Non-Transactional BE
- All of the above, except for the list of pre-BE unsubs. (These should have been pulled when the list was uploaded to TM)
For 62714 –
Following the process above, remove the pre-BE unsubs from these files that are in the PREPPED folder and rename them
62714_Apple RCS_Jan 2025 Notice_ATT Bus for BE
62714_Apple RCS_Jan 2025 Notice_FN lists for BE
New filenames –
NC62714_ 20250204_ATTBus_prepped
NC62714_20250204_FN_prepped
Rename the pre-be unsub files that were placed in the PREPPED folder today-
FROM
Unsubscribe-62714_Apple RCS_Jan 2025 Notice_ATT Bus for BE
Unsubscribe-62714_Apple RCS_Jan 2025 Notice_FN lists for BE
TO
NC62714_PreBEUnsubs_ATTBus_20250203
NC62714_PreBEUnsubs_FN_20250203