# 2026-03-02

## 06:00 Memory Review (cron)

Reviewed: 2026-02-28, 2026-03-01, 2026-03-01-overnight daily logs.

### MEMORY.md updated
- Overnight Mar 1→2 work captured (trust pages, claim verification, TypeScript build fix, edge function auth, wrangler.toml, ACP/Claude Code enabled)
- Outstanding Rob-gated items noted (SUPABASE_SERVICE_KEY, DMARC record, Claude Code auth, duplicate migrations)

### Key open items this week
- **Mar 6 (Fri):** MN Lead Intelligence report → email Alan (alan.maher@tilt.ie), CC Rob. Snippet corrected Feb 27, data accumulating since.
- **Tradeify pre-launch (Rob gated):** SendGrid setup (Twilio), Stripe go-live (STRIPE_ENABLED), tradeify.ie DNS cutover, OAuth consent verify, SUPABASE_SERVICE_KEY to Cloudflare, DMARC record
- **Cair Google Merchant Center:** Review window opened Feb 26, status unknown. Check if phone still on contact page, verify ~20 EUR products in feed, request review if not done.
- **Tilt SEO pages:** 5 service pages + 4 blog/case studies still in draft (WordPress)
- **Irelandify:** Sanity CMS, Content Pool images (~20 counties), SEO pages
- **Rob back from Spain ~Mar 8**

## Illumination Lighting - Google Ads Deep Dive (18:49-19:15)

### Key Context from Rob
- Running ads on/off for 8 months, pause don't delete to preserve data
- Daily budget: €350 Google + €150 Meta = €500/day (~€15k/month)
- Want best ROAS possible
- Laura Ashley products sell well but only 35% margin
- Other products ("best sellers" collection) get 55%+ margin
- Brand campaign (Feb) killed ads for 1 week - DO NOT repeat this mistake
- Approach: improve existing performance, don't disrupt

## OpenRouter Test (21:22)
- Spawned sub-agent on openrouter/anthropic/claude-sonnet-4 - confirmed working
- Rob loaded €30 credits as emergency fallback
- Rule: only use OpenRouter in emergencies, notify Rob via Telegram + email before using

## Claude Code Security Review (21:26-21:36)
- Ran `/security-review` via Claude Code CLI (v2.1.27, Opus 4.5 on Claude Max)
- Initial `/security-review` command failed (no git remote origin for diff)
- Ran as direct prompt instead - full review completed
- Found 14 issues: 4 critical, 4 high, 4 medium

### Critical Findings
1. Hardcoded Supabase API key in scripts/generate-sitemaps.py
2. Zero auth on payment endpoints (create-checkout.ts, create-portal.ts)
3. 5 tables with RLS enabled but NO policies (quotes, invoices, payments, lead_notifications, payment_reminders)
4. CORS set to '*' on all API endpoints

## Claude Code Fixes (22:41-22:50)
- All 12 fixable issues patched by Claude Code in one pass
- Awaiting deploy to tradeify-app.pages.dev (Rob to approve)
- RLS policies for empty tables still need SQL migration (not in this fix batch)

## KiroTech / LEO Grant (21:56-22:13)
- KiroTech = Rob + Kieran's company for ventures like Tradeify (separate from Tilt)
- Registered in Fingal
- Rob emailed LEO Fingal from robert.doran@gmail.com enquiring about startup supports
- AI matching claimed in email - needs building before any demo
- AI matching plan: embed job descriptions against tradesperson profiles, weighted by proximity/ratings/availability

## Qwen 3.5 Small Models (22:15)
- Alibaba released Qwen 3.5 small series: 0.8B, 2B, 4B, 9B
- 4B interesting for lightweight local agents
- 9B closing gap with larger models
- Rob wants to install tomorrow but Intel Mac will be slow - real benefit comes with Mac Mini M4

### Actions Taken
- Accepted Google Ads MCC invite (max@tilt.ie added as Manager to 948-154-1805)
- Disabled ALL 13 auto-apply settings on Illumination Lighting (933-909-4194)
- Auto-apply was on since Jan 13, 2026 - added 34 keywords, 48 removed, 3 broad match, Display Expansion

### 8-Month ROAS Trend
- Jul 2025: €1,489 spend, 4.90x ROAS
- Aug 2025: €3,313 spend, 4.10x ROAS
- Sep 2025: €3,645 spend, 6.36x ROAS (PEAK)
- Oct 2025: €8,453 spend, 3.43x ROAS
- Nov 2025: €9,813 spend, 4.78x ROAS (Christmas season)
- Dec 2025: €3,505 spend, 2.21x ROAS (post-Christmas cliff)
- Jan 2026: €7,350 spend, 2.58x ROAS
- Feb 2026: €8,785 spend, 2.13x ROAS (worst)
- Total: €46,109 spend, €165,304 conv value, 3.59x overall

### Current Active Campaigns
1. PMax Oct 2025: €350/day, 2.27x ROAS, main workhorse
2. Search Jan 26 (Desktop/Tablet): €150/day, 2.40x ROAS
3. Smart/Location (Donabate 20km): €33/day, 0.26x ROAS (footfall only)
4. Remarketing: €200/day budget but essentially dormant

### Paused Campaigns of Note
- Old PMax (Tilt): Was 8.22x ROAS on €126 spend - why paused?
- Brand Search: Paused after killing ads for a week
- Search Jan Draft: All ads disapproved

### Best Sellers Collection (55%+ margin)
39 products on illuminationlighting.ie/collections/frontpage
Price range: €48 (plaster wall light) to €299 (Sweden pendant)
Mix of own-brand and Laura Ashley products in the collection

### Flags
- Advertiser verification needed for 1 account
- Remarketing campaign is dead (€200/day budget, 1 click in 30 days)
- Search draft has all ads disapproved

## Google Ads Access (18:39)
- Rob added max@tilt.ie to the Tilt Digital MCC (948-154-1805)
- Should give access to all linked accounts (Illumination, HQ Electrical, Eircode, Glenilen Farm)
- Need to accept the invitation and verify access level

### Morning status cron will fire at 8am
