Software Updates

Enhanced marketing analytics dashboard with geographic + device breakdowns

• Interactive pie chart + bar chart toggle for country distribution
• Country details expandable list with percentages
• Device type breakdown (desktop/mobile/tablet/other) with visual bars
• Top traffic sources (referer domains) analysis
• Peak hours bar chart showing hourly traffic distribution
• Device detection from User-Agent string
• Referer domain extraction and ranking
• Peak hours calculation (UTC time-based)
• Improved response structure for UI consumption
• Added MARKETING_ANALYTICS_ENHANCEMENTS_2026_06_08.md
• 24 feature ideas for future implementation
• Prioritization roadmap (3 phases)
• Success metrics and technical notes

Google tracking params + pricing update

• Extract and forward gbraid + wbraid (Google iOS app/web remarketing IDs)
• Extract and forward utm_matchtype + utm_device (Google ValueTrack params)
• Incoming UTM params on the /go/ request now WIN over link config defaults (previously link config would override incoming campaign params)
• All ad-platform IDs (gclid, gbraid, wbraid, fbclid, ttclid) forwarded
• Lab grown price: $9,000 → $7,000 (both hero strip and value proof card)
• Added note: 'stone only · casting & setting not included'
• Applied to both the mobile hero section and the desktop value proof cards

add gclid (Google Ads click ID) end-to-end attribution

• Click counter stuck at 94: Google Ads 'Final URL' was pointing directly to /engagement/consultation/777?... instead of /go/google. Direct traffic bypasses the /go/ route, so MarketingSmartLinkClick rows are never created. FIX: Change the Final URL in Google Ads to https://katura1999.com/go/google
• gclid not captured anywhere: use-attribution.ts hook read utm_*, fbclid, smart_link, sid from URL params, but completely ignored gclid. All Google Ads click IDs were silently dropped — no CRM attribution, no conversion tracking closure.
• use-attribution.ts: Added gclid to AttributionFields interface, initial state, fromUrl reading (params.get('gclid')), and merged result — now persisted in localStorage and included in every form submission
• offer-consultation-page.tsx: Pass attribution.gclid in all 3 form submit bodies (inquiry form, full booking, Saturday request)
• availability-request/route.ts: Added gclid to Zod schema; stores in EngagementLead notes as 'GCLID: xxx' line pending DB migration
• consultation/route.ts: Added gclid to Zod schema; passes to bookConsultation()
• booking.ts: Accept gclid in BookConsultationInput type; writes gclid to Consultation.gclid column (after migration)
• prisma/schema/engagement.prisma: Added gclid column to both Consultation and EngagementLead models
• prisma/migrations/add_gclid_attribution.sql: Migration to add gclid column to Consultation and EngagementLead tables in production DB

split inquiry form into Name + Email (required) + Phone (optional)

• Heading: 'GET CURRENT 7.77 AVAILABILITY' → 'INQUIRE ABOUT AVAILABILITY'
• Subtitle: 'Concierge will send current shapes, certification, and pricing.'
• Field 'First name' → 'Name' (accepts any name format)
• Replaced single 'Phone or email' field with:
• Email address * (required)
• Phone (optional)
• Applied to both the sticky sidebar copy and the mobile/hero copy
• Both forms now share the same leadName/leadEmail/leadPhone state
• Section border changed amber → blue (matching pricing strip)
• email is now required (z.string().email()) - no more optional fallback
• Removed .refine() either-or check
• CRM lookup now always uses email
• CRM create/update uses v.email directly (no phantom placeholder)

simplify attribution storage to avoid Prisma schema issues

• Store attribution data as plain text in notes field
• Build attribution string without creating objects with schema fields
• This avoids Prisma trying to validate column names that don't exist in db
• Still captures all attribution data until db migration is applied

remove debug log - availability-request now working

add debug log to verify deployment

availability-request API database schema mismatch

• Removed attribution fields (offerVariant, landingPageVariant, utm*, meta*) from EngagementLead.create() as these columns don't exist in production db
• Attribution data is now stored in notes field as JSON reference for now
• TODO: Apply database migration to add these columns
• Changed 'Inquire about availability' section border from yellow to blue to match the LAB GROWN DIAMONDS pricing section

improve error handling in availability-request API

• Added try-catch blocks for CRM operations (continues on failure)
• Added try-catch for EngagementLead creation with detailed logging
• Return error details in 500 response for easier debugging
• Better console logging for troubleshooting production issues

CRM submission + notification settings + heart shape + blue pricing

• availability-request API now uses plain prisma directly instead of tenantPrisma (eliminates RLS/extension layer that was causing silent failures); tenantId is still explicitly set in all create() calls
• Added leadFirstError state + error display in inquiry form — users now see a message if the API call fails instead of silent no-op
• Built full notification recipients settings page replacing the placeholder stub
• Add/remove email addresses per trigger type via live UI
• Two trigger types: 'Availability Request Form' and 'Full Consultation Scheduling'
• Stored in SaasTenant.brandSettings.notificationRecipients (no migration)
• New API: GET/PATCH /api/admin/crm/notification-settings
• availability-request route now reads dynamic recipient list
• consultation/route.ts now fires team notification email post-booking using the same dynamic recipient list
• Added Heart shape (heart.png) to the shape picker on /777 page
• Changed LAB GROWN price box from amber/yellow to light blue (bg-blue-50 border-blue-200 text-blue-800)

rebrand currency selector to 'Select Country' with native language display names

• Label: 'Currency' → 'Select Country'
• Format: 'US Dollar' → 'United States - USD'
• Format: 'Brazilian Real' → 'Brasil - BRL'
• Format: 'Japanese Yen' → '日本 (Japan) - JPY'
• Format: 'Israeli Shekel' → 'ישראל (Israel) - ILS'
• Format: 'Vietnamese Đồng' → 'Việt Nam (Vietnam) - VND'
• Format: 'Chinese Yuan' → '中国 (China) - CNY'

remove cpus:4 cap + reduce NODE_OPTIONS heap to prevent OOM on Standard

• Standard (8GB, 4 vCPU): cold build ~6-8 min, no OOM, warm builds 3-4 min
• Turbo (60GB, 30 vCPU): cold build ~3-5 min, warm builds 2-3 min

delete .npmrc throttle (was limiting Turbo to 1/30 cores) + remove redundant pnpm install from vercel-build

• [aff0ee0a] Route slug conflict [invoiceId] vs [id] — FIXED (was causing 208 runtime errors)
• [f9ed212a] Smart-links sequential timeouts — FIXED (parallelized via Promise.allSettled)
• [bb68d13b→this] Build throttle — FIXED (removed .npmrc, restored defaults for Turbo)

optimize for memory-constrained Vercel builds to fix OOM errors

• Add .npmrc with pnpm parallelization limits: fetch-parallel-limit=3, build-parallel-limit=2, workers=1 Reduces concurrent processes during install to prevent OOM on standard Vercel containers (~3GB RAM)
• Update vercel-build script to explicitly use --frozen-lockfile --no-optional --prefer-offline Ensures faster, leaner install without re-resolving or fetching optional deps

resolve dynamic route slug conflict ([invoiceId] vs [id]) causing INTERNAL_FUNCTION_INVOCATION_TIMEOUT

• Move check-stripe-payment + sync-stripe from [invoiceId] into [id]
• Delete orphaned [invoiceId] directory (sibling conflict crashed Next.js router)
• Delete orphaned literal \[locale\] directory (backslash-bracket name != dynamic route)
• Update params type from { invoiceId } to { id: invoiceId } in both moved routes

trigger redeploy to warm build cache after account pause

parallelize smart-links queries and add tenantId filter to stats

• Run links and stats queries concurrently via Promise.allSettled instead of sequentially
• Reduces worst-case timeout from 9s+9s=18s to max(9s,5s)=9s, well under 12s client timeout
• Reduce stats timeout from 9s to 5s (non-critical, zero-fill on failure)
• Add WHERE tenantId filter to stats to use index and avoid full table scan
• Fixes 'Request timed out' on /admin/marketing/links despite healthy DB

incident summary and verification checklist

add timeouts to login queries + create safe-query utility + investigation doc

add 3s timeout to jwt role-refresh DB call (was blocking all authenticated API routes)

smart-links GET uses rawPrisma directly + 9s timeout per query + proper error UI

add try/catch + 12s timeout to fetchLinks so spinner always resolves

Cmd+/ shortcut, screenshot capture, Yen AI analysis via GPT-4o Vision in /admin/support

restore middleware.ts (chromeless/employee-login), replace CalendarComponent in offer page

comprehensive meetings workflow guide + improvement ideas

EST time display, MISSED status, mark-missed workflow + reschedule flow with 30-day tokens + button-level CTA tracking

smart calendar + multi-recipient booking notifications

• Add ConsultationDatePicker component (src/components/engagement/):
• Weekends (Sat+Sun) disabled and greyed out
• Today + tomorrow → amber 'CALL FIRST' cells; clicking opens phone dialog
• Phone dialog has a simple math captcha before revealing +1 (404) 455-8989
• Future weekdays (2+ days out) → green 'OPEN' tint with availability legend
• Shared between /engagement/consultation and all /777 offer pages
• Wire ConsultationDatePicker into both page files; remove stale Calendar imports
• bookConsultation: send internal notification to both rosserembrasil@gmail.com and jewelryadvisor@katura1999.com (hardcoded, de-duped against CONSULTATION_NOTIFY_EMAIL env var) — all fired in parallel, from: sales@katura1999.com

fire Google Ads conversion_event_book_appointment on consultation form submit

enhance 7.77 stone alert popup with CRM recording and consultation credit offer

exclude email signup popup from /engagement routes

correct import path and status enum for engagement email signup endpoint

• Changed import from non-existent 'brevo-lists' to 'brevo'
• Changed status from invalid 'UNCONTACTED' to valid 'CONTACTED'

polish 777 consultation pages - restructured 777-b split-fixed layout, exit intent popup, carousel logos, pricing card optimization

• Restructured 777-b split-fixed layout with full booking form on left sidebar, hero content on right
• Created ConsultationExitIntentPopup with engagement-specific messaging ($100 credit toward ring)
• Added PressLogosCarousel component with CSS marquee animation for infinite logo scroll
• Optimized pricing card with financing info tooltip and third-party disclaimer
• Removed redundant pricing/financing blocks from 777 standard hero section
• Repositioned ring image between subtitle and h1 heading for 777 page
• Shortened earrings bonus copy to more concise messaging
• Updated hero title across translations: ANGEL-NUMBER → ANGEL NUMBER
• Added new Brevo ENGAGEMENT_SIGNUPS list for consultation exit intent subscribers
• Fixed navbar overlap on split-fixed sidebar form with pt-24 padding
• All TypeScript checks pass, accessibility verified

A/B test variant for 777 consultation with split-fixed layout

• Updated offer-consultation-page.tsx:
• Removed AB test variant assignment (layoutVariant state)
• Added 'experience' prop to switch between 'standard' and 'split-fixed' layouts
• Implemented split-fixed variant with fixed left sidebar on desktop (hero, CTA, proof cards)
• Moved lead-first capture to hero section for split-fixed variant
• Extracted leadCaptureCard and valueProofCards as reusable components
• Refactored FAQ items to use <details> element for better UX
• Updated Stripe icon imports (removed unused icons: ArrowRight, Diamond, Heart, Sparkles, Gift)
• Simplified hero description for 777 offer (shorter, more direct)
• Made console logging more accurate for split-fixed routing
• Added 777-b experience route:
• Created src/app/[locale]/engagement/consultation/777-b/page.tsx
• Passes experience='split-fixed' prop to enable new layout variant
• Added exact-case redirect in proxy.ts middleware for 777-B → 777-b
• Handles both bare /777-b and /[locale]/777-b URLs
• Updated availability-request API:
• Fixed phone-only lead capture (fallback email when not provided)
• Added source + status fields to CRM contact updates
• Improved concierge notification with lead admin link