Orphan Trapper ยท Complete Recovery Pipeline ยท ITS Platform
Admin: Switch OFF/ON Timer Update/Add
Only Admins can see this: Share (popup our socials etc) |QR Code | Gifiy | Audio (text to speach) | Follow | Contact (popup, load email, DM, Chat, whatsapp no, form, upload cv)
Orphan Trapper
This is a sharp piece of engineering โ you've essentially built a revenue capture loop out of what most platforms treat as a write-off. Here's exactly what we built and how it works:
๐ชค How the Trap Works
๐ The Complete Orphan Recovery Pipeline
- Scans all 24 database tables for orphaned records
- If clean โ offers to re-seed into
short_urlstable - Inserts tokenkey with default funnel URL
- This is the "birth" โ tokenkey now exists in the tracking system
- Creates
competition_contentrecord (the actual funnel) - Auto-creates
office_offermeta with defaults - Sets up campaign dates, CTA, content type, and recipient client
- This is the "body" โ tokenkey now has a functioning landing page
- Copies meta data from your best-performing campaign
- Performance dashboard shows views, sign-ups, and sales
- Sets the tokenkey up with polished social sharing previews
- This is the "presentation" โ tokenkey now looks professional
๐ Recovery Quick Links
Bookmark these โ the 3-step recovery for any orphaned tokenkey:
๐๏ธ System Architecture
| Component | Location | What It Does |
|---|---|---|
| its-orphan-trapper.php | /af/includes/ |
Include file added to lookup.php. Catches every incoming ?id=, checks competition_content and short_urls, and logs orphaned hits to its_orphaned_tokens with IP, referrer, user agent, and incremental hit count via ON DUPLICATE KEY UPDATE. Usage: Usage: include($_SERVER['DOCUMENT_ROOT'] . '/af/includes/its-orphan-trapper.php'); |
| its_orphaned_tokens | Database table | Stores every orphaned tokenkey with: hit_count, first_hit, last_hit, last_ip, last_referer, last_user_agent, status (orphaned / reseeded). Unique constraint on tokenkey for efficient upserts. |
| admin_orphaned_tokens.php | /af/ |
Admin dashboard ranked by hit count. Color-coded: ๐ด hot (10+), ๐ก warm (3-9), โช cold (1-2). One-click numbered buttons for the 3-step recovery. Filter by status. Paginated. |
| admin_cleanup_token.php | /af/ |
Full database sweep across 24 tables. Selective deletion with confirmation gate. Re-seed clean tokenkeys into short_urls with guided 3-step workflow. Audit logging on all actions. |
| inc_splash_page_lookup.php | /af/ |
Landing page creation tool. Auto-creates office_offer meta on submit. Full campaign management with dates, CTA, content type, and recipient assignment. Performance data on existing campaigns. |
| admin_cc_meta.php | /af/ |
Meta duplication tool. Copies Open Graph, SEO, and social preview data from source campaigns. Performance table with views, sign-ups, and sales for A/B testing decisions. Green border on high performers. |
The trap is not the product.
The re-engagement is.
Right now, you're logging and reseeding โ good. That's tactical. But strategic? That's using the pattern of orphaned clicks to:
- ๐ Map intent clusters Which dead links drew the most traffic? That tells you what your audience was searching for but couldn't find. That's product intelligence, not just traffic recovery.
- ๐ฏ Dynamic offer shaping Don't just reseed the same URL. Reseed with a twist: a discount, a comparison chart, a short video, or a direct chat link โ whichever historically converts that orphan segment best.
- ๐งฑ Funnel hardening If the same link keeps dying, fix the source. But more importantly, if the topic keeps dying (even through different URLs), you've found a content gap. Own it.
Now โ are you reseeding in real-time (sub-2s) or batch? Because the real killer app is sub-second contextual redirect based on referrer + query string + time-of-day. That's where you go from catching bounces to owning the detour.
Orphan Trapper ยท ITS Platform ยท intent-first recovery ยท JaySoftware Ltd
Learn More


