π§ Active Work
Loading active work...
β
Live Numbers
Paying Customers
β
MRR
β
Gas Prospects
β
Opt-in Consumers
β
Gas Emails Sent
β
PipeIQ Clients
β
GLP-1 Tracker Users
β
Gumroad Buyers
β
Tasks
Opportunity Radar
Weekly radar of the fastest sellable-solution opportunities on our existing assets. Mark each Yes / No / Maybe and add notes β decisions persist so a later session can process them.
Outreach Pipeline
| Channel | Sent Today | Total Sent | Remaining | Progress |
|---|---|---|---|---|
| Loading... | ||||
Recent Activity β daemon/heartbeat noise excluded
PipeIQ Clients
| ID | Name | Plan Status | Credits | Joined |
|---|---|---|---|---|
| Loading... | ||||
Cold Outreach Stats
Total Prospects
β
Emails Sent
β
Remaining
β
Last 20 Outreach Emails
| Company | Status | Clicked | Sent | |
|---|---|---|---|---|
| Loading... | ||||
Ltd Prospect Pool β Companies House limited companies, enriched. Corporate subscribers, so PECR reg 22 consent does not apply
Reachable
β
Clean Email
β
Mobile
β
Contacted
β
| Vertical | SIC | Total | Clean email | Flagged | Mobile | Reachable | Contacted |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
SMS Delivery β confirmed carrier delivery, not just dispatch
Delivery Rate
β
Delivered
β
Undelivered (carrier failure)
β
Sent, no DLR yet
β
| Agency | Total | Delivered | Undelivered | No DLR | Rate |
|---|---|---|---|---|---|
| Loading... | |||||
Recent Undelivered (last 20)
| Agency | Error Code | Provider | When |
|---|---|---|---|
| Loading... | |||
Gas Engineer Stats
Total Prospects
β
Emailed
β
Remaining
β
Today's Sends
β
Last 10 Outreach Emails
| Company | Sent At | |
|---|---|---|
| Loading... | ||
Gas Leads Captured
No inbound gas-lead capture is wired. There is no leads / gas_leads table and gas.tradeboostuk.co.uk has no opt-in form feeding one, so this stays empty by design. Gas is currently an outbound-only prospect list (see stats above). Wire an opt-in form to a leads table to activate this panel.
Meta Ads β Driving Schools (Aria)
Social Media Profiles β current channel state (static, verified)
π’ Facebook β 4 pages (via Graph API)
π’ PipeIQ β official channels
Other channels (personal / QumranHealth β not PipeIQ)
Recent-posts feed removed: business_logs holds no social-post rows (no platform column), so the table was permanently empty. Channel states above are maintained manually and verified against live credentials.
Site Status
Checking...
Phone Numbers & Capabilities
Every owned Twilio number, what product/brand it's wired to, and its live voice/SMS routing β single source of truth, replaces ad-hoc notes.
| Number | Friendly name | Owner / brand | Voice | SMS | Voice URL | Notes |
|---|---|---|---|---|---|---|
| Loading... | ||||||
Google Ads β Live Status
Loading...
Meta Ads β Driving Schools (Aria)
Loading...
Content Calendar
β NOT CURRENT β content calendar last updated w/c 23 Jun 2026
Mounjaro tips β contrarian angle
What nobody tells you about the first 90 days on Mounjaro β glucose drops before weight, fasting reading on waking is your key number, nausea peaks at week 2-3 of each dose then eases, dose escalation timing matters, 90-day chart changes psychology.
Planned weeks below β all three dates have passed and none was actioned. Kept as the backlog, not as a schedule.
Week 5 β w/c 30 Jun Β· lapsed
Patient journey β food photo feature
Week 6 β w/c 7 Jul Β· lapsed
NHS data import β authority angle
Week 7 β w/c 14 Jul Β· lapsed
Mounjaro Dose Escalation Guide β Β£12
Video Pipeline
β³ Under Review
TikTok @qumranhealth
First video submitted β HeyGen, Kaitlyn avatar
β Overdue
Script 2
Was due Mon 29 Jun 2026 β a month past, not delivered
β
Auto-running
YouTube
Auto-video Mon 09:30 BST β youtube_video_maker.py (local PC only)
β
Ready
TikTok Scripts
4 scripts ready in tiktok_scripts_batch2.md
Social Profiles
TikTok
@qumranhealth
Instagram
@qumranhealth
X / Twitter
Suspended
Reddit
u/KamranKhanUK
Facebook
facebook.com/qumranhealth
Recent Social Posts
| Date | Platform | Content |
|---|---|---|
| Loading... | ||
B2C Contacts Overview
Total Contacts
β
Gumroad Buyers
β
Tracker Users
β
Both
β
Last 10 Contacts Added
| Source | Name | Added | |
|---|---|---|---|
| Loading... | |||
Self-Perpetuation Status β tallies below count the manual known-gap backlog, not a live readout
π’ Green (self-running)
β
π‘ Amber (fragile)
β
π΄ Red (broken / needs human)
β
Total known gaps
β
β Top single point of failure
Everything real runs on one GCP VM with no version control and no file backups
deadman.py (*/15 + 08:00 BST digest), all 16 instrumented cron jobs, Aria and the email bridge all sit on the single GCE box 34.73.127.10 β no git repo, no .bak copies, no failover, so "what did this file say last week?" is unanswerable. Other headline SPOFs: GitHub Actions still billing-blocked (16 of 19 workflows disabled, and the 2 still-enabled real workflows fail at dispatch β verified 31 Jul), Supabase anon SELECT open on 92 tables + service key on user paths, and an exposed plaintext GitHub PAT in .env.
A Β· Watchdog Run-Status
| Monitor | Last Run | Expected Cadence | Status |
|---|---|---|---|
| Loading run-status... | |||
GREEN = ran within cadence Β· AMBER = approaching / cadence unknown Β· RED = stale, overdue, or run-status not yet reported to DB.
B Β· Known-gap backlog (manual) β manually-maintained audit list, rebuilt 30 Jul 2026, last updated 01 Aug 2026 Β· NOT a live readout
Hand-curated backlog of known infra/compliance gaps β it does not auto-update and never turns GREEN (resolved items are removed, not flipped). The live health signal is the data-driven Watchdog Run-Status table above. Fix column = the one action that clears each gap.
Cost Picture β v1 β internal, snapshot 14 Jul 2026
Real cash / month (now)
~Β£5β15
Free tiers + donated credits. 0 paying customers, Β£0 Stripe income yet.
Gross margin @ 1st paying agency
~55%
Β£386 profit on Β£699 revenue (Β£199 + 5,000 SMS/mo, 10 clients).
Margin per Β£199 customer
Β£102 β Β£136
51% as sole agency β 68% at scale (fixed infra spread across agencies).
β οΈ Blind spots β real costs not captured in any tracker
Automated reconciliation has not run since May 2026 β treat these as unverified until checked at source.
Cost Register β source: G:\AI_Business\PipeIQ\COST_REGISTER_14Jul2026.md
v1 = read-only static snapshot seeded from the register. Live auto-pulls (Twilio/Stripe/GCP) are a later phase. β = figure is estimated or unverified.