Analytics & Optimization
Trim Old Click Data
Click history is the largest thing URL Shortify stores. A busy site can accumulate millions of rows, which makes the database bigger and reports slower. Trim Clicks deletes click records older than a chosen age.
When to use it
- Reports and the dashboard have become slow to load.
- Your database or backups have grown uncomfortably large.
- Your data-retention policy says visitor data should not be kept indefinitely.
Trim click history
- Go to URL Shortify → Tools → Trim Clicks.
- Choose how far back to keep:
- Clear clicks older than 30 days
- Clear clicks older than 60 days
- Clear clicks older than 90 days
- Confirm the action.
This cannot be undone
Deleted click records are gone permanently. Take a database backup first, and consider exporting your click data to CSV if you may need the history later.
What is and isn't removed
| Removed | Kept |
|---|---|
| Individual click records older than the chosen age | Every short link, its slug and destination |
| The detail behind historical reports — referrers, devices, countries, per-click timestamps | Groups, tags, domains and settings |
Your links keep working exactly as before. Only the recorded history behind them is trimmed.
Keeping the table small in the first place
Trimming is a cure. These reduce the growth:
- Filter out robot clicks so crawlers never create records.
- Exclude your own IP addresses so internal testing isn't recorded.
- Turn off tracking on links you don't need statistics for, in the link's own settings.
- Use Anonymise Clicks Data in Settings → General if you want click counts without storing personal data.
FAQ
Does trimming clicks delete my short links?
No. Only click records are deleted. Every link, slug and destination stays exactly as it was and keeps redirecting.
Can I recover click data after trimming it?
Not from within URL Shortify — the deletion is permanent. Restore a database backup, or keep a CSV export before trimming.
Will my total click counts change after trimming?
Yes. Reports are built from the click records, so periods you trimmed will no longer show detail.
How do I stop the clicks table growing so quickly?
Filter out robot clicks, exclude your own IP addresses, and disable tracking on links that don't need statistics.