Purpose: Report received by Narvar showing all shipments that have been deemed undeliverable and returned to sender used by escalations team to proactively outreach customers and resolve or improve customers experience.
Requirements:
- Access to Box File- Customer Feedback- https://morphe.app.box.com/file/722512859804
- You will need an email report - Morphe - Daily Monitor Report - Undeliverable
- Open emailed report received. Select Column R – select Number format to – short date
Copy columns R thru AC.
- Paste columns you copied into BOX file.
- Select column B- Conditional formation- highlight cell rule, duplicate values.
- Delete any duplicates that were added in Box file. Duplicates will be highlighted in RED.
