# 2026-03-05 - Daily Log

## AdPilot Chrome Extension - NEW PROJECT
- Rob's idea: Chrome extension for autonomous Facebook ad management
- Users install, connect their Facebook ad account with one click, upload product database, set budget, and it runs
- "Ticking retainer" model -- set and forget
- **Pricing:** €79/month (1 brand), €150/month (2 brands), custom for agency (3+)
- **Key feature:** Retailer feed integration -- connect stock/rate-of-sale feed, auto-pause ads when out of stock, auto-resume when replenished, scale spend based on sales velocity
- **Campaign timelines:** Always-on, fixed duration, or seasonal recurring
- Full spec at: projects/adpilot/spec.md
- MVP Chrome extension BUILT by Claude Code: projects/adpilot/extension/
  - Manifest V3, React + Tailwind + Vite
  - 6 screens: Welcome, Account Selection, Upload Products, Set Budget, Dashboard, Settings
  - Dark theme (#18181b) with green (#55bf95) accents
  - Mock Facebook API (real API wiring needed)
  - dist/ folder ready to load in Chrome as unpacked extension
  - Sample products CSV included
- Claude Code session killed by signal 15 twice during build, but completed before second kill
- Rob asked about "Shipper" tool by @chhddavid -- told him we already have Claude Code, don't need a wrapper
- Facebook App Review needed for production (2-4 weeks), can test with dev mode (5 users)
- Chrome Web Store: $5 one-time dev fee, 1-3 day review

## AdPilot - Retailer Feed Deep Dive (18:30-19:00)
- Rob wants **store-level data** -- how many units of a product are on shelves across ALL stores
- This data comes from retailer supplier portals (Tesco Data & Insights, Walmart Retail Link, Kroger 84.51, etc.)
- Brands already have access to this data -- they just don't connect it to ad spend
- Rob shared a screenshot of **Tesco EPOS data** -- Noreast Beers (Legacy Barrel, Legacy Cider) showing sales volume + value per store per week across all Tesco Ireland locations
- This is the perfect proof-of-concept dataset for the feed module
- **AdPilot geo-targeting play:** Map store locations to ad geo-targeting. Low stock in Dublin = reduce Dublin spend. High sales in Cork = increase Cork spend. No one else does this at €79/month.
- **Tesco API:** Developer portal shut down (devportal.tescolabs.com). No official API access. Scraping works for online stock, but store-level data must come from the brand's supplier portal export.
- **Costco:** No public API either. Scrapable via Apify for online data.
- **US market opportunity:** Walmart (Retail Link), Amazon (Product Advertising API), Kroger (public dev API) -- same product, massively bigger market. $99/month US pricing potential.
- **Feed ingestion plan:** Brand exports weekly CSV from retailer portal, uploads to AdPilot. Future: automate the export (email forwarding or API connection to supplier portal).

## Notes
- Claude Code at 79% weekly limit (resets 4am Dublin time)
- Rob said "start building straight away" -- no hesitation on this one, he's excited
- Rob is thinking BIG on this -- US market, store-level data, retailer feeds. Not just a simple ad tool.
- The Tesco EPOS screenshot suggests Rob has a client or contact in FMCG (Noreast Beers) who could be a beta tester
- Claude Code build session (grand-haven) may still be running -- check status next session
