PRD: AI-Powered Ecommerce Ad Generation & Store Management Platform

01Executive Summary

This document defines the full product requirements for RevEngine — Rashida's unified AI-powered platform for ad generation, ecommerce store management, and autonomous revenue operations.

The platform solves a single core problem: Rashida is a solo operator managing two Shopify POD stores, multiple ad channels, GHL funnels, and a growing content operation. Without a unified system with maximum automation, she cannot compete at scale.

RevEngine integrates every tool in Rashida's existing stack:

• Family Gift Studio (FGS) and FTK (For The Kids) — Shopify stores
• Printify POD fulfillment
• Go High Level (GHL) for all digital checkout/funnels (never Gumroad)
• Seedance 2.0 (ByteDance) as the primary video ad engine
• Nano Banana 2 (Gemini 3.1 Flash) for illustrations/FTK imagery
• Fal.ai Dev for hyperrealistic product shots
• Claude.ai/design for static image ads
• Google Sheets as the batch input layer → Seedance 2.0 at scale
• Manus.ai for Facebook Ads, TikTok Ads, Google Ads deployment
• Supabase (self-hosted at supabase.insightprofit.live)
• Vercel (rashida-mendes-projects team) for hosting
• ClickUp for task management and escalation
• GitHub: viral-comedy-ad-generator

02User Persona

Primary User: Rashida Mendes

03Problem Statement

Current State (Broken)

Desired State

• One dashboard shows all store KPIs, active campaigns, pending tasks
• Batch generate 50–100 ads from a Google Sheet in one click
• AI agent runs overnight audits and posts findings to ClickUp by 6am
• Course KB is searchable in natural language
• FGS fully operational within 24 hours (Phase 1 emergency sprint)

04Goals & Success Metrics

Phase 1 Goals (Days 1–14)

Phase 2 Goals (Days 15–45)

Phase 3 Goals (Days 46–90)

05Technical Architecture

System Overview

┌─────────────────────────────────────────────────────────────────┐
│                        REVENGINE PLATFORM                        │
│                   (Vercel — rashida-mendes-projects)             │
├─────────────────┬───────────────────┬────────────────────────────┤
│   FRONTEND      │   BACKEND API     │   DATABASE                 │
│   Next.js 14    │   Next.js API     │   Supabase (self-hosted)   │
│   Tailwind CSS  │   Routes +        │   supabase.insightprofit   │
│   Mobile-first  │   Edge Functions  │   .live                    │
│   PWA           │                   │                            │
├─────────────────┴───────────────────┴────────────────────────────┤
│                        INTEGRATION LAYER                          │
├────────────┬────────────┬────────────┬────────────┬──────────────┤
│  Shopify   │  Printify  │    GHL     │  Seedance  │  Manus.ai   │
│  FGS + FTK │  POD sync  │  Funnels   │  2.0 Video │  Ad Deploy  │
├────────────┴────────────┴────────────┴────────────┴──────────────┤
│                        AI/ML LAYER                                │
├──────────────┬────────────────┬───────────────┬───────────────────┤
│ Claude.ai    │ Nano Banana 2  │  Fal.ai Dev   │  Seedance 2.0    │
│ Static ads + │ Gemini 3.1     │  Hyperreal    │  Video engine    │
│ Copy gen     │ Flash Image    │  product shots│                   │
└──────────────┴────────────────┴───────────────┴───────────────────┘

Frontend Architecture

• Framework: Next.js 14 (App Router) deployed on Vercel
• Styling: Tailwind CSS + shadcn/ui
• Auth: Supabase Auth (email magic link — mobile-friendly)
• State: Zustand for client state; React Query for server state
• PWA: Service worker for mobile home screen install

Key Pages

/dashboard          — Morning briefing: KPIs, CRO agent report, pending tasks
/ads/generate       — Google Sheets upload → batch ad generation
/ads/library        — All generated ads, filterable by store/format/status
/stores/fgs         — Family Gift Studio manager
/stores/ftk         — FTK manager
/ghl                — GHL offers and funnel status
/kb                 — Knowledge base search (PopeBot interface)
/agent              — CRO agent activity log and settings
/settings           — API keys, integrations, preferences

Backend Architecture

• Runtime: Next.js API routes + Vercel Edge Functions
• Queue: Inngest (serverless job queue) for batch ad generation
• Cron: Vercel Cron for nightly CRO agent audit (2am ET)
• Storage: Supabase Storage for generated ad assets
• Secrets: Vercel Environment Variables (never committed to GitHub)

06API Integrations Map

Data Flow: Ad Generation

Google Sheets (product data + copy angles)
         │
         ▼
Sheet Parser (/lib/sheets)
  - Validates required columns: product_id, product_name, store, angle, format
  - Enriches with Shopify product data via Shopify API
  - Fetches product image URLs from Printify (if POD) or Shopify CDN
         │
         ▼
Prompt Builder (/lib/prompts)
  - Selects template based on angle: comedy | emotional | testimonial | demo | comparison
  - Applies diversity directive: "Diverse cast — multiple ethnicities, ages 25-65"
         │
         ├──── Static ad? ──── Claude API → Returns ad layout JSON + copy → Canvas PNG/JPG
         │
         └──── Video ad? ───── Seedance 2.0 API → MP4 → Supabase Storage
         │
         ▼
Ad Library (Supabase: ad_creatives table)
  Status: pending_review | approved | rejected | published
         │
         ▼
Manus.ai Deployment → Facebook / TikTok / Google

07Feature Specifications

7.1 Ad Generation Engine

Google Sheets Batch Input

Rashida uploads or connects a Google Sheet with product data and copy angles. Up to 200 rows per sheet upload. Jobs queued via Inngest (~3–5 min per video ad, 30s per static).

Seedance 2.0 Video Ad Generation

The core video generation engine. All video ads route through Seedance 2.0 (ByteDance). Replaces Arcads.ai at $110–220/month.

Prompt Template Library

Template 1: COMEDY

HOOK (0-3s): [Relatable frustration or absurd situation related to {product_use_case}]
MIDDLE (3-12s): Product appears as the "obvious solution" — played for laughs
CTA (12-15s): "{offer_cta}" — direct address to camera, confident
VOICEOVER STYLE: Dry, slightly sarcastic, like a friend giving advice
VISUAL: UGC-style, slightly shaky cam, lived-in environment — NOT studio
CAST: Mix of ethnicities, ages 30-55, everyday clothes

Template 2: EMOTIONAL

HOOK (0-5s): [Heartfelt moment — parent/child, couple, milestone]
MIDDLE (5-20s): The gift arrives/is opened — genuine reaction shown
CTA (20-30s): Soft, warm — "Give them something they'll never forget"
VOICEOVER STYLE: Warm, slow, intimate — like a memory
VISUAL: Golden hour lighting, natural settings, candid feel
CAST: Multi-generational — grandparent + parent + child at minimum

Template 3: TESTIMONIAL

HOOK (0-3s): Real person holds product to camera — "Okay I have to show you this"
MIDDLE (3-20s): Unboxing + reaction + benefit explanation in their own words
CTA (20-30s): "{offer_cta}" overlay + link in bio instruction
VOICEOVER STYLE: Authentic, slightly imperfect — NOT polished corporate
VISUAL: Phone-filmed, bedroom or kitchen background, natural lighting

Template 4: PRODUCT DEMO

HOOK (0-3s): Product feature shown in 3 seconds flat
MIDDLE (3-15s): Three key features, each demonstrated once — show don't tell
CTA (15-20s): "Order yours at [store]" — clean product shot on white
VOICEOVER STYLE: Energetic narrator — "Feature 1. Feature 2. Feature 3."
CAST: Hands of diverse operators using product

Template 5: COMPARISON

HOOK (0-3s): "Still ordering from {competitor_category}?" — skeptical look to camera
MIDDLE (3-20s): Side-by-side: generic gift vs. {product_name} — clear winner visual
CTA (20-30s): "{offer_cta}" — urgency + price shown on screen
CAST: Mixed gender, ethnically diverse, 25-50

7.2 Ecommerce Store Manager

• Audit FGS Shopify store — list all products, identify unpublished/incomplete
• Printify sync — verify all POD products have active blueprints
• Collections — ensure all products assigned to correct collections
• Product descriptions — Claude generates SEO-optimized for any missing
• Pricing audit — confirm pricing covers Printify base cost + desired margin
• Theme check — verify FGS theme is mobile-optimized (critical for TikTok traffic)
• Analytics — Shopify Analytics + Facebook Pixel verified firing
• First ad — at minimum one FGS video ad live on TikTok or Meta within 24 hours

Printify Mockup Generation Workflow

New product request (design file URL + blueprint ID)
    │
    ▼
Printify: POST /v1/shops/{shop_id}/products.json
    │ (creates product with all variants)
    ▼
Printify: POST /v1/mockup-generator/generate.json
    │ (generates 4-6 mockup angles)
    ▼
Best mockup auto-selected (Fal.ai enhances for hero image)
    │
    ▼
Shopify: product images updated with mockups
    │
    ▼
ClickUp task: "New product live — create ad batch" (auto-created)

7.3 AI Agent — Chief Revenue Officer (CRO)

Audit Checklist (Automated)

1. AD PERFORMANCE AUDIT
   - Pull last 24h metrics from Manus.ai (Facebook, TikTok, Google)
   - Flag any campaign with CPC > $2.50 (alert: pause?)
   - Flag any campaign with CTR < 0.5% (alert: creative refresh needed)
   - Identify top-performing ad of the day — note angle + format
   - Calculate daily ad spend vs. daily revenue (micro-ROAS)

2. STORE HEALTH AUDIT
   - FGS: Check for any out-of-stock variants (Printify)
   - FTK: Same
   - Any Shopify products with no active ad campaign → flag as "orphaned product"
   - Check that all product pages load (HTTP 200) — flag any 404s

3. GHL FUNNEL AUDIT
   - Check all active GHL funnel pages return 200
   - Flag any funnel with 0 pageviews in 48 hours
   - Check GHL pipeline: any leads stuck in stage >7 days → escalate

4. GENERATE MORNING REPORT
   - Summary of all findings, formatted for mobile reading
   - Top 3 recommended actions for the day
   - Posted to ClickUp as comment on "Daily Operations" task

7.4 Knowledge Base System

4 Courses to Ingest

PopeBot Query Flow

Rashida asks: "What does Sam say about scaling ad budgets past $1k/day?"
    │
    ▼
Generate query embedding
    │
    ▼
Supabase vector similarity search: kb_articles WHERE course_id = 'IRNT0QrS'
  SELECT * FROM kb_articles ORDER BY embedding <-> query_embedding LIMIT 5
    │
    ▼
Top 5 chunks passed to Claude as context
    │
    ▼
Claude response: "Based on Sam's training, he recommends..."
  + Source citations: [IRNT0QrS, Module 4, Lesson 2]

7.5 Relational Database Schema (Supabase)

Connection: supabase.insightprofit.live  |  Extension required: pgvector for KB embeddings

Table: products

CREATE TABLE products (
  id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  store           TEXT NOT NULL CHECK (store IN ('fgs', 'ftk')),
  shopify_id      TEXT UNIQUE,
  printify_id     TEXT,
  title           TEXT NOT NULL,
  price           NUMERIC(10,2),
  status          TEXT DEFAULT 'draft' CHECK (status IN ('active', 'draft', 'archived')),
  collections     TEXT[],
  mockup_urls     TEXT[],
  hero_image_url  TEXT,
  printify_synced BOOLEAN DEFAULT false,
  shopify_synced  BOOLEAN DEFAULT false,
  tiktok_shop_id  TEXT,
  seo_title       TEXT,
  seo_description TEXT,
  created_at      TIMESTAMPTZ DEFAULT NOW(),
  updated_at      TIMESTAMPTZ DEFAULT NOW()
);

Table: ad_creatives

CREATE TABLE ad_creatives (
  id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  product_id      UUID REFERENCES products(id),
  store           TEXT NOT NULL CHECK (store IN ('fgs', 'ftk')),
  ad_type         TEXT NOT NULL CHECK (ad_type IN ('video', 'static')),
  angle           TEXT NOT NULL CHECK (angle IN ('comedy', 'emotional', 'testimonial', 'demo', 'comparison')),
  format          TEXT NOT NULL CHECK (format IN ('tiktok_916', 'meta_11', 'meta_45', 'youtube_169')),
  asset_url       TEXT,
  status          TEXT DEFAULT 'pending_review'
                    CHECK (status IN ('queued', 'generating', 'pending_review',
                                      'approved', 'rejected', 'published', 'paused')),
  diversity_applied BOOLEAN DEFAULT true,
  batch_id        UUID,
  created_at      TIMESTAMPTZ DEFAULT NOW()
);

Table: campaigns

CREATE TABLE campaigns (
  id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  store           TEXT NOT NULL CHECK (store IN ('fgs', 'ftk')),
  platform        TEXT NOT NULL CHECK (platform IN ('facebook', 'tiktok', 'google', 'tiktok_shop')),
  manus_campaign_id TEXT,
  ad_creative_id  UUID REFERENCES ad_creatives(id),
  name            TEXT NOT NULL,
  status          TEXT DEFAULT 'draft' CHECK (status IN ('draft', 'active', 'paused', 'ended')),
  daily_budget    NUMERIC(10,2),
  total_spent     NUMERIC(10,2) DEFAULT 0,
  objective       TEXT,
  target_audience JSONB,
  created_at      TIMESTAMPTZ DEFAULT NOW()
);

Table: performance_metrics

CREATE TABLE performance_metrics (
  id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  campaign_id     UUID REFERENCES campaigns(id),
  ad_creative_id  UUID REFERENCES ad_creatives(id),
  date            DATE NOT NULL,
  platform        TEXT NOT NULL,
  impressions     INTEGER DEFAULT 0,
  clicks          INTEGER DEFAULT 0,
  ctr             NUMERIC(6,4),
  spend           NUMERIC(10,2) DEFAULT 0,
  cpc             NUMERIC(10,2),
  purchases       INTEGER DEFAULT 0,
  revenue         NUMERIC(10,2) DEFAULT 0,
  roas            NUMERIC(6,3),
  cpm             NUMERIC(10,2),
  video_views     INTEGER,
  video_pct_25    NUMERIC(6,4),
  video_pct_100   NUMERIC(6,4),
  created_at      TIMESTAMPTZ DEFAULT NOW()
);

Table: kb_articles (pgvector)

CREATE TABLE kb_articles (
  id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  course_id       TEXT NOT NULL,
  source_file     TEXT,
  module_title    TEXT,
  chunk_index     INTEGER,
  chunk_text      TEXT NOT NULL,
  embedding       vector(1536),      -- pgvector — 1536 dims
  topic_tags      TEXT[],
  search_count    INTEGER DEFAULT 0,
  created_at      TIMESTAMPTZ DEFAULT NOW()
);

CREATE INDEX kb_articles_embedding_idx ON kb_articles
  USING ivfflat (embedding vector_cosine_ops)
  WITH (lists = 100);

08Tool Comparison & Recommendations

In-House Platform Cost Breakdown

093-Phase Roadmap

Phase 1: FGS Emergency Fix + Ad Engine MVP (Days 1–14)

Phase 2: Automation + Knowledge Base (Days 15–45)

Phase 3: Full Agent + Revenue Optimization (Days 46–90)

10Risk Register

11Appendix: Prompt Template Library

11.1 Full Video Ad Script Generation Prompt

You are an expert direct-response video ad scriptwriter for ecommerce.

PRODUCT: {product_name}
STORE: {store_name} ({store_url})
PRICE: ${price}
OFFER: {offer_cta}
TARGET AUDIENCE: {target_demo}
AD ANGLE: {angle}
DURATION: {duration_seconds} seconds
FORMAT: {format} ({aspect_ratio})

DIVERSITY REQUIREMENT (MANDATORY):
All cast members must be ethnically diverse. Include people of multiple
ethnicities and ages (range 25-65). NEVER use an all-white cast.
This is a non-negotiable creative directive.

Generate:
1. SCRIPT (with timecodes for each scene)
2. STORYBOARD (4-6 scene descriptions)
3. VOICEOVER TEXT (exact words spoken)
4. DIRECTOR NOTES (setting, lighting, energy, camera style)
5. ON-SCREEN TEXT (captions, price reveals, CTA overlays)

Output as structured JSON for API submission to Seedance 2.0.

11.2 Product Description Generation Prompt

Write an SEO-optimized Shopify product description for:

PRODUCT: {product_name}
STORE: {store} (Family Gift Studio | FTK For The Kids)
KEY FEATURES: {features}
PRICE: ${price}
TARGET BUYER: {buyer_persona}

Requirements:
- 150-250 words
- Lead with emotional benefit, not the feature
- Include 2-3 natural keyword phrases for SEO
- End with soft CTA that creates urgency without being pushy
- Tone: warm, genuine, not corporate
- For FGS: gift-giving occasion focus
- For FTK: child development / parent benefit focus
- Diverse, inclusive language — avoid assuming family structure

11.3 GHL Sales Page Copy Prompt

Write high-converting sales page copy for a Go High Level funnel page.

OFFER: {offer_name}
PRICE: ${price}
KEY BENEFIT: {key_benefit}
AUDIENCE: {audience}
GUARANTEE: {guarantee}

Generate:
1. HEADLINE (power word + benefit + curiosity, max 10 words)
2. SUBHEADLINE (who this is for + what changes, max 20 words)
3. LEAD PARAGRAPH (hook — identify the pain, 2-3 sentences)
4. BENEFIT BULLETS (5 bullets, each starting with action verb)
5. WHAT'S INCLUDED (offer stack list)
6. GUARANTEE COPY (1 paragraph, confident, eliminates risk)
7. CTA BUTTON TEXT (3-5 words, urgency-driven)
8. CLOSING LINE (1 sentence, FOMO-based)

Rules:
- No clichés ("game-changer", "revolutionary")
- Specific and concrete — use numbers where possible
- Written in 2nd person (you/your)
- GHL delivery — no Gumroad, no third-party checkout