MBP Operations Hub

SEO Pipeline Status Proposals Staged

All SEO infrastructure is built. 294 proposals generated and validated for the pilot batch. Quality reviewed, pipeline bugs fixed (taxonomy codes, generic tag dominance, title truncation). Push awaiting manual go-ahead.

Component	Status	Detail
Vision analysis (GPT-4o)	Done	2,692/2,731 listings. 39 unfixable. $32 total.
listing_360_mat	Done	55+ columns: 16 vision fields, Printful COGS, GA4, sales
ChromaDB embeddings	Done	all-MiniLM-L6-v2, semantic search working
SEO pipeline (seo_pipeline.py)	Done (v2)	7-stage + buyer-friendly taxonomy map, junk term filter, smart title truncation
SEO diff engine (seo_diff.py)	Done	Compares proposed vs existing, protects high-performers
Push to Etsy (push_seo_changes.py)	Done	Reads seo_proposed, re-runs policy gate, PATCHes via API
Pilot sample	Done	350 listings (298 treatment, 52 control), stratified
Baseline snapshot	Done	Metrics captured for all 350 pilot listings
Pilot report (pilot_report.py)	Done	HTML report with A/B diff-in-diff comparison
Policy gate	Done	EXTREME/RISKY/ESCALATE tiers, context disambiguation
SKILL.md spec	Done	29 sections, 2,400+ lines
Taxonomy tables	Done	Synced to production data (all 16 enum fields)
o3 weakness fixes	Done	All 3 phases complete. Re-audited at 7.2/10.
SEO proposals generated	294	Full pilot batch. Quality validated, 0 policy blocks, 0 internal codes.
Changes pushed to Etsy	0 (ready)	Push script fixed and dry-run validated. Awaiting manual go-ahead.

SEO Design Decisions Locked

1. API push, not CSV upload. push_seo_changes.py uses Etsy API directly. Rate-limited to 1 req/sec.

2. Titles + tags together. Pipeline generates both simultaneously since they share evidence.

3. Full-catalog deploy pace, long measurement. Deploy fast (2 weeks), measure slow (8-12 weeks).

4. 200 control + 15% pilot control. Pilot has 52 control listings. Full-catalog uses 200.

5. No CVR-based decisions. GA4 only captures ~30-50% of traffic. Use value_score, orders, revenue, favorites.

6. Policy gate before every push. Shop is one strike from permanent ban. Re-run on every push.

Archived Planning Docs

Superseded by this hub. Kept for reference:

seo_experiment_plan.md -- v5 FINAL, detailed statistical framework (still valid for DiD methodology)
seo_rollout_plan.md -- v7, revised timeline with full-catalog fast deploy
o3_review_output/keyword_crossref/seo_plan_review.md -- o3 critique (6/10), identified gaps
o3_review_output/keyword_crossref/seo_plan_expansion.md -- o3 tactical playbook (20-hour action stack)
.claude/skills/etsy-seo/SKILL.md -- Comprehensive skill design spec (29 sections)

SEO Action Plan Prioritised

2/6

Run SEO pipeline on full pilot treatment group Done 14 Mar
294 proposals generated (4 no-change skips, 0 policy blocks). Pipeline v2 with taxonomy fixes.
Review proposals quality (spot-check 45+) Done 14 Mar
Found and fixed 7 issues: taxonomy codes in titles/tags, generic tag dominance, junk term leaks, DB timeouts, API param bug. All 294 validated clean.
Push canary batch (50 listings) Ready
Push script fixed and dry-run validated (50/50 passed). Wait 3-5 days after push. Confirm no Etsy flags.
python push_seo_changes.py --push --limit 50
Push remaining treatment group (~248 listings) 30min
python push_seo_changes.py --push
Wait 14-30 days, then measure pilot results 1h
Treatment vs control diff-in-diff on sessions, orders, revenue, favorites.
python pilot_report.py --compare
Scale to full catalogue if results positive 4-8h
Generate proposals for all ~2,731 active listings, deploy in 2-3 batches.

Conversion-Rate Pillar o3's Top Recommendation

0/5

Mockup GPT-4o audit + PSD iterations 45-90min
Download listing mockups, feed to GPT-4o for 3 rounds of critique. Duplicate PSDs before editing.
Add videos to listings 4-8h
Etsy gives video listings carousel priority. 15-sec reel per category.
Free shipping threshold (AU$45+) 30min
Free-ship badge is a proven CTR booster.
Framed print variant via Printful 2-4h
+A$40 upsell, ~8% take rate in similar shops.
Star Seller badge (autoresponder for SLA) 1h
+3-5% CTR in some verticals.

Dormant Listing Strategy 1,410 Zero-Session

0/2

Re-incarnate dormant listings (fresh IDs) 4-8h
Delete and re-upload with clean attributes, new mockup. 8% first-sale rate vs <1% renew.
$1/day Etsy Ads drip on re-incarnated listings 30min
Break zero-data curse on fresh listing IDs.

Quick Wins Low Effort

0/5

Attribute audit and cleanup 2h
Limit each listing to max 3 Room, 2 Style, 2 Subject values. Attributes indexed ahead of tags.
Taxonomy check (category #119 vs #2078) 2h
Verify listings in correct Etsy category. Misclassification filters out print buyers.
Processing time to 1 business day 30min
Printful auto-fulfils. Etsy boosts fast-ship listings in US search.
Favorites auto-coupon (10% after 4h) 30min
Typical reclaim: +8-10 orders/month at current scale.
FAQ keyword seeding 1h
First 300 chars of FAQs index in search. Add mid-tail phrases.

Infrastructure Issues CI / Ops

0/2

Fix listing_360_mat CI crash in daily email 5min
Add table-existence guard to get_seo_dashboard() or add refresh_mat step to daily-email.yml.
Bump GitHub Actions Node.js versions 2min
Update actions/checkout to v5 and setup-python to v6. Deadline: 2 June 2026.

Daily Email Fixes UX

Mobile-proof daily email HTML 30-60min
Replace flex with tables, SVG with CSS bars, bump font sizes, 2x2 stat cards on mobile.

Mockup Templates Conversion

Investigate landscape 8.psd smart object orientation 30min
Size comparison template may have portrait-oriented smart objects for landscape prints.

Future SEO Phases Backlog

0/6

Measure attribute push impact (2,707 listings) 1h
Baseline snapshotted 14 Mar in attribute_push_baseline table. After 14-30 days, compare sessions, orders, favorites vs baseline by health_status cohort. Look for dormant/underperforming listings gaining sessions.
SELECT b.health_status, COUNT(*), SUM(m.sessions_30d) - SUM(b.sessions_30d) AS session_delta, SUM(m.order_count) - SUM(b.order_count) AS order_delta FROM attribute_push_baseline b JOIN listing_360_mat m ON m.listing_id = b.listing_id GROUP BY b.health_status
Tag experiment (Level 2, after title results) 4-8h
External traffic plays (TikTok, Instagram, Google Shopping) 8-16h
Pricing optimisation (10% split test on 50 bestsellers) 2-4h
Bundle listings (pick-3, gallery-wall packs) 4-8h
Description experiment (Level 3) 4-8h

Priority Matrix All Workstreams

Task	Urgency	Impact	Effort	Category
Fix listing_360_mat CI crash in daily email	Now	90%	5min	Infrastructure
Run SEO pipeline on full pilot treatment group	Done	Done	1-2h	Seo
Review proposals quality (spot-check 45+)	Done	Done	30min	Seo
Push canary batch (50 listings)	Now	90%	30min	Seo
Push remaining treatment group (~248 listings)	Now	85%	30min	Seo
Attribute audit and cleanup	This Week	70%	2h	Seo
Taxonomy check (category #119 vs #2078)	This Week	70%	2h	Seo
Mockup GPT-4o audit + PSD iterations	This Week	85%	45-90min	Conversion
Mobile-proof daily email HTML	This Week	75%	30-60min	Infrastructure
Wait 14-30 days, then measure pilot results	After Pilot	80%	1h	Seo
Scale to full catalogue if results positive	After Pilot	95%	4-8h	Seo
Processing time to 1 business day	Soon	60%	30min	Seo