Can I vibe code KlickTipp?

Build a tag-based marketing automation backend and dashboard using Next.js, Supabase, and AWS SES/Resend integration.

1. DATA MODEL:
- Create `contacts` (id, email, first_name, status ['pending_doi', 'subscribed', 'unsubscribed'], created_at, doi_timestamp, doi_ip).
- Create `tags` (id, name, slug, description).
- Create `contact_tags` (contact_id, tag_id, created_at).
- Create `campaigns` (id, title, Subject, body_html, trigger_tag_id, delay_hours, step_order).
- Create `email_logs` (id, contact_id, campaign_id, status ['queued', 'sent', 'failed', 'opened', 'clicked'], provider_message_id, sent_at).

2. CORE FUNCTIONALITY:
- Implement a Double Opt-In (DOI) endpoint: when a form submits, create contact as 'pending_doi', dispatch a verification email with a signed token. On link click, update status to 'subscribed', log timestamp and IP, and trigger tag addition.
- Build a Tag Engine: adding a tag to a contact automatically scans `campaigns` for steps tied to that `trigger_tag_id`. Queue sequence steps into a pg_cron or background task runner based on `delay_hours`.
- Implement email sending worker via AWS SES or Resend SDK. Update `email_logs` on webhook callbacks (open, click, bounce, unsubscribe).
- Unsubscribe engine: every email includes an HMAC-signed one-click unsubscribe link. If clicked, set contact status to 'unsubscribed' immediately and suppress future sends.

3. INTERFACE:
- React UI using Tailwind CSS displaying contacts table, tag filters, simple rich text email editor, and sequence list.
- Analytics dashboard showing sent counts, open rates, click rates, and bounce rates.

4. FAILURE MODES & OUT OF SCOPE:
- Handle SES rate limits with exponential backoff retries in queue processor.
- Auto-suppress any email that receives a hard bounce or spam complaint webhook.
- Visual drag-and-drop workflow canvas is OUT OF SCOPE; use sequential delay-based lists instead.

$ each button prefixes agent-specific run instructions · build your own product, never copy proprietary code, trademarks or designs