Daily Review — Pipeline Deep Dive

Run this at the end of each day to close out the day and set up tomorrow.

Process

1. Pipeline Snapshot

Query Supabase for current pipeline state:

-- Opportunities by stage
SELECT stage, COUNT(*) as count, SUM(estimated_value) as total_value
FROM opportunities WHERE status = 'active'
GROUP BY stage ORDER BY stage;

-- Deals closed this week
SELECT * FROM opportunities
WHERE status = 'won' AND updated_at > NOW() - INTERVAL '7 days';