How can old data be put to use?
What good are years of accumulated records? Old invoices, past orders, lost quotes sit in a folder. Most businesses never look; yet some of the cheapest opportunities hide there. 🗄️
Old data is the business’s own experience log: who bought, what, when they stopped, which quote was turned down.
Short answer: old data is scanned for four questions — who can be won back, what is always bought together, which periods are strong, why quotes were lost. The aim isn’t tidying the archive but finding opportunities. 🔍
Four opportunities in old data
BU BÖLÜMÜN ÖZETİ
- Lapsed customers
- Bought together
- Strong periods
- Lost quotes
All of them cheap. 💡
Lapsed customers
Those who bought and stopped; easier to win back than new customers. 😴
Bought together
Products often sold together; they suggest bundles and recommendations. 🧩
Strong periods
Which weeks of the year peak? The campaign calendar starts here. 📅
Lost quotes
Rejected quotes; price, timing or scope? The lesson is there. 📄
Make it reliable first
BU BÖLÜMÜN ÖZETİ
- Gather into one table
- Remove duplicates
- Fix formats
- Flag gaps
Four preparations. 🧹
Gather into one table
Records from different years merged with the same columns. 📋
Remove duplicates
No customer counted twice; see the duplicate records guide. 👯
Fix formats
Dates and amounts in one format; see the data entry guide. ✍️
Flag gaps
Incomplete records aren’t deleted but flagged; remembered when interpreting. 🏷️
Winning back lapsed customers
BU BÖLÜMÜN ÖZETİ
- Pull the list
- Check consent
- A personal message
- Measure
Four steps. 🔄
Pull the list
Regular buyers who bought nothing in the last year; priority goes to them. 📋
Check consent
Limited to those with marketing consent; no consent, no message. ✅
A personal message
Instead of a generic discount, “we’ve missed you” and a relevant suggestion. 💬
Measure
How many returned? At what cost? The basis for the next attempt. 📊
Four common mistakes
BU BÖLÜMÜN ÖZETİ
- Deciding on dirty data
- Bulk messages without consent
- Trying to analyse everything
- Deleting old data
All four make data misread. 🚧
Deciding on dirty data
A list with duplicates inflates the customer count. 📉
Bulk messages without consent
Messaging old lists without consent is a legal risk and a reputational one. ⚠️
Trying to analyse everything
Four questions are enough; endless tables don’t produce decisions. 🌀
Deleting old data
Not deleted before legal retention and value are known. 🗑️
Using old data regularly
BU BÖLÜMÜN ÖZETİ
- Lapsed list every three months
- Yearly period review
- Lost-quote notes
- Read with feedback
Four rhythms. 🔄
Lapsed list every three months
New lapses are caught early. 😴
Yearly period review
The campaign calendar is updated. 📅
Lost-quote notes
One-line reason per lost quote; patterns show by year end. 📝
Read with feedback
To understand why they left, look at feedback data too. 💬
What should I do today?
BU BÖLÜMÜN ÖZETİ
- Step 1: gather three years
- Step 2: pull lapsed customers
- Step 3: write to ten
- If you want help
Three steps, one hour. 🪜
Step 1: gather three years
Sales records in one table; same columns. 📋
Step 2: pull lapsed customers
Previously regular buyers with nothing last year; a list. 😴
Step 3: write to ten
A personal message to ten consented people; note the results. 💬
If you want help
Let us find opportunities in your old data: use the consult your expert form. For your current setup see the digital audit; the bigger picture sits in the data housekeeping roadmap. 🎯
Related reading from the archive: why customers leave · the campaign calendar.
📝 Notes From the Field
A business’s sales records spanning years had never been examined. Gathered into one table and cleaned, they revealed a large group of regular buyers who had bought nothing in the past year. Those with contact consent received a personal message and a relevant suggestion. A significant share ordered again, at a cost far below winning new customers.
📖 Short Glossary
Lapsed customer: a former regular who hasn’t bought for a while. Bought together: products often in the same order. Lost quote: a rejected quote. Retention period: how long a record must legally be kept.
⚡ Quick Summary
Old data is the business’s experience log. 🗄️ Lapsed customers, products bought together, strong periods and lost quotes are the cheapest opportunities. First gather into one table, remove duplicates and fix formats. Reach lapsed customers only with consent and a personal message.
🎯 Next Step
Let us find opportunities in your old data: use the consult your expert form. Data limits sit in the data limits guide; for your setup see the digital audit.
Frequently Asked Questions
Sık Sorulan Sorular
It depends on your purchase frequency. A customer who hasn’t bought for twice their normal interval is usually considered lapsed.
Only to people with marketing consent. People whose consent is unclear or missing don’t receive marketing messages.
Legal retention periods and personal data rules must be weighed together. Don’t bulk delete without accounting and legal advice.
Source: Turkish Personal Data Protection Authority — guidance