Can I vibe code RedTrack?

Build a custom, lightweight ad tracking and server-side conversion attribution service using Next.js (App Router), Supabase (PostgreSQL), Cloudflare Workers, and Tailwind CSS.

1. DATA MODEL & SCHEMA:
- Create a Postgres schema in Supabase containing tables: `sessions` (id, visitor_id, utm_source, utm_medium, utm_campaign, utm_content, utm_term, referrer, created_at), `events` (id, session_id, event_name, event_id, payload, created_at), `orders` (id, shopify_order_id, total_price, currency, session_id, created_at), `ad_spend` (id, platform, campaign_id, campaign_name, spend, clicks, impressions, date).

2. CLIENT-SIDE EDGE TRACKING SCRIPT:
- Write a vanilla JavaScript tracking script hosted on Cloudflare Workers. It reads query parameters (UTMs), generates/persists a first-party UUID cookie (`_custom_vid`), logs pageview and click events asynchronously via fetch to `/api/track`, and injects the session ID into Shopify cart attributes.

3. SERVER-SIDE CONVERSION RELAY (CAPI):
- Implement an endpoint `/api/webhooks/shopify/order-created` that validates Shopify HMAC headers.
- Extract order details, customer email/phone, and the custom session ID from cart attributes.
- Hash customer PII (email, phone, zip) using SHA-256.
- Construct and execute HTTP POST requests to Meta Conversions API (`https://graph.facebook.com/v18.0/{pixel_id}/events`) and Google Ads Conversion Upload API, passing matching `event_id` structures to enable deduplication with browser pixels.

4. AD SPEND AGGREGATION & ATTRIBUTION DASHBOARD:
- Create a scheduled cron endpoint (`/api/cron/fetch-spend`) using Meta Graph API and Google Ads API to sync daily ad spend grouped by campaign ID.
- Build an admin UI in Next.js with charts for aggregated spend, revenue, and calculated ROAS per campaign.
- Implement SQL views for First-Touch, Last-Touch, and Linear attribution models linking sessions to final purchases.

5. FAILURE HANDLING & SCOPE:
- Wrap external CAPI network requests in exponential backoff retry loops stored in a background job queue.
- Out of scope: Automated ad rules engines, multi-tenant agency permissions, or real-time automated bid adjustments.

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