What lands in the abandoned-orders sheet?
With the EverCore COD Form, an order is saved as abandoned once the buyer has typed a complete, valid phone number. If no order follows, it’s added to a separate Google Sheet after a delay you choose. One browsing session counts once.
Each row holds what the buyer had typed (such as name, phone, wilaya, city and address), plus the product, cart and offer they’d picked. EverCore keeps these records for 30 days; the rows in your sheet stay in your Google account.
How should you set up the sheet for follow-up?
Add a few columns to the right of what EverCore writes, and keep them for your team:
| Column | What goes in it |
|---|---|
| Status | To call, called, no answer, ordered, not interested |
| Attempts | How many times you tried |
| Last attempt | Date and time |
| Notes | Question asked, objection, preferred delivery day |
Filter by status to see who’s left to call. A buyer who said “not interested” stays that way: don’t call twice.
When and how should you call?
- The same day. Interest fades quickly.
- Two or three attempts at different times, then stop.
- Short and helpful. You’re finishing an order, not selling from scratch.
A simple script:
- “Hello, this is [store]. You started an order for [product] on our site today.”
- “Did you have a question about the product, the price or the delivery?”
- If yes, answer it. If they still want it, confirm name, wilaya, address and total, delivery included, and create the order.
Messaging apps work too. Keep the first message short, with the product and the price.
Can you use the list in ads?
Ad platforms such as Meta and TikTok let advertisers upload customer lists to build audiences, for example to show a reminder ad. Before you do:
- Check consent. Your privacy notice and local rules must allow it.
- Remove buyers who ordered or said no.
- Keep the list fresh. An abandoned order from last month isn’t a warm lead.
How do you measure follow-up?
Count, every week: abandoned orders received, buyers reached, and orders recovered. Recovered orders ÷ abandoned orders is your recovery rate. Compare it by product and by ad: if one ad sends many abandons and few recoveries, look at its promise and the product page.
Recovered orders still go through confirmation and spam protection like any other.