The problem
Each week, a team member exported shipped-order customers to CSV, cleaned the file, and uploaded it to the email platform. The process took about an hour and left the marketing audience up to six days behind current order data. Marketplace orders from Amazon, Walmart, and similar channels also contain relay addresses that must be excluded from marketing lists.
What we built
We built a scheduled pipeline that retrieves shipped orders from Extensiv, applies the client's customer-record cleaning rules, and updates the Klaviyo list used for the store's win-back audience.
Each run is archived for audit. A morning report records the imported records and any failures, giving the team a clear exception list to review.
What changed
The recurring weekly CSV process was removed, and the reactivation audience is now refreshed daily. Win-back flows operate from more current customer data, with the manual cleaning and upload work removed from the team's schedule.