ReviewDNA — Paste Your Amazon URL, Get Three Facebook Ads Written in Your Customers Own Words

Q: Who can build ReviewDNA — Paste Your Amazon URL, Get Three Facebook Ads Written in Your Customers Own Words?

This is a beginner level project. DTC founders and in-house performance marketers at brands doing $10k-$500k/month on Amazon or Shopify — roughly 200k brands in this revenue range in the US.

Q: How does ReviewDNA — Paste Your Amazon URL, Get Three Facebook Ads Written in Your Customers Own Words make money?

Credit-based + subscription. 5 free runs then $49/month unlimited or $9 per 10-run credit pack for one-time users.

DTC brands spend thousands on ad agencies that write copy no customer ever said out loud. ReviewDNA scrapes your Amazon or Shopify reviews, extracts the top five emotional pain phrases via Claude, and generates three Facebook ad variants in the exact language real buyers use. No brief, no agency, no generic copy.

𝕏 Post Reddit HN

Difficulty

beginner

What is it?

The best ad copy is already written — by your customers in their reviews — and most DTC brands are too busy to mine it. ReviewDNA takes a product URL, extracts 200+ reviews, clusters the top five pain phrases using Claude NLP, and returns three ready-to-test Facebook ad variants: a pain-agitate-solve, a social proof angle, and a curiosity hook. Each variant uses verbatim customer language, which outperforms agency copy in CTR by 20-40% according to widely cited DTC split test data on r/ecommerce. Paste URL, get copy in 90 seconds, paste into Meta Ads Manager. Viable today because Claude's context window handles 200 reviews in one shot and Apify's Amazon scraper costs fractions of a cent per run.

Why now?

Claude's 200k token context window can now process 200+ reviews in a single API call for under $0.10 — making per-run unit economics profitable at $9 credit packs for the first time.

▸One-field input: paste Amazon or Shopify product URL and get results in 90 seconds (Implementation note: Apify scraper + Claude batch analysis)
▸Top 5 customer pain phrase extraction displayed before ad generation so marketer can validate
▸Three ad copy variants: pain-agitate-solve, social proof, curiosity hook — each under 150 characters for Meta
▸Copy-to-clipboard and one-click export to CSV for Meta Ads Manager bulk upload

Target Audience

DTC founders and in-house performance marketers at brands doing $10k-$500k/month on Amazon or Shopify — roughly 200k brands in this revenue range in the US.

Example Use Case

A DTC supplement brand pastes their Amazon listing URL, gets three Facebook ads featuring the phrase their customers actually wrote, tests all three in Meta Ads Manager, and cuts CPA by 31% in the first two weeks.

User Stories

▸As a DTC brand founder, I want to extract real customer pain phrases from my Amazon reviews, so that my ad copy uses the language buyers actually respond to.
▸As a performance marketer, I want three ready-to-test ad variants generated in under 2 minutes, so that I can cut creative briefing time from days to seconds.
▸As a Shopify store owner, I want to analyze competitor Amazon listings, so that I can write ads targeting the gaps my competitor's customers complain about.

Done When

✓Scraping: done when pasting a valid Amazon URL returns at least 50 reviews within 60 seconds without an error message.
✓Pain extraction: done when 5 distinct customer pain phrases appear on screen with their frequency count before ad variants are shown.
✓Ad generation: done when 3 formatted ad variants under 150 characters each appear with copy-to-clipboard buttons that work.
✓Billing: done when a user exhausting their 5 free runs sees a paywall and can complete Stripe checkout to unlock 10 more runs in under 2 minutes.

Is it worth building?

$49/month x 100 brands = $4,900 MRR. Math: post demo video to r/ecommerce (280k members) — 0.04% conversion is 112 paying brands.

Unit Economics

CAC: $8 via Reddit organic demo post. LTV: $588 (12 months at $49/month). Payback: 0.2 months. Gross margin: 82%.

Business Model

Credit-based + subscription

Monetization Path

5 free runs then $49/month unlimited or $9 per 10-run credit pack for one-time users.

Revenue Timeline

First dollar: week 1 via credit pack sale after demo post. $1k MRR: month 2. $5k MRR: month 5.

Estimated Monthly Cost

Claude API: $35, Apify: $20, Supabase: $25, Vercel: $20, Stripe fees: $15. Total: ~$115/month.

Profit Potential

Side income viable at $2k MRR, full-time at $8k-$15k MRR.

Scalability

High — add Shopify review scraping, TikTok ad format variants, Google PMax headlines, and team workspaces.

Success Metrics

Week 1: 200 free runs. Week 2: 15 credit pack purchases. Month 2: 60 active subscribers at $49/month = $2,940 MRR.

Launch & Validation Plan

Record a 60-second demo video pasting a real Amazon URL and showing the three ad variants — post to r/ecommerce and offer 10 beta spots at $49/month before building auth.

Customer Acquisition Strategy

First customer: DM 20 DTC founders in r/ecommerce who have posted about ad creative fatigue, share the demo video, and offer first month free for a written case study. Then: Twitter DTC community, ProductHunt launch, partnerships with Meta ad agencies who want to white-label the tool.

What's the competition?

Competition Level

Medium

What's the roadmap?

Feature Roadmap

V1 (launch): URL input, pain extraction, 3 ad variants, credit billing. V2 (month 2-3): Shopify review scraping, TikTok script format. V3 (month 4+): A/B result tracker, team workspaces, agency white-label.

Milestone Plan

Phase 1 (Week 1): scraper, Claude pipeline, ad card UI working end-to-end. Phase 2 (Week 2): Stripe billing, Supabase auth, deploy to Vercel. Phase 3 (Month 2): 60 paying subscribers, Shopify scraper added.

How do you build it?

Tech Stack

Next.js, Claude API, Apify Amazon Review Scraper, Supabase, Stripe — build with Lovable for UI, Cursor for API routes.

Suggested Frameworks

Claude API (Anthropic SDK), Apify client, Vercel AI SDK

Time to Ship

1 week

Required Skills

Claude API prompting, Apify API, basic Next.js API routes, Stripe.

Resources

Anthropic Claude docs, Apify Amazon scraper docs, Vercel AI SDK streaming docs.

MVP Scope

app/page.tsx (URL input + results display), app/api/analyze/route.ts (scrape + Claude pipeline), app/api/stripe/route.ts (billing), lib/scraper.ts (Apify client wrapper), lib/claude.ts (pain extraction + ad generation prompts), lib/db/schema.ts (runs + users), components/AdCard.tsx (copy result card with clipboard), .env.example.

Core User Journey

Paste URL -> see top 5 pain phrases -> receive 3 ad variants -> copy to clipboard -> paste into Meta Ads Manager.

Architecture Pattern

URL input -> Apify scraper job -> raw reviews -> Claude API batch prompt -> pain phrase clusters + 3 ad variants -> Supabase run log -> UI display -> Stripe gate for unlimited.

Data Model

User has many Runs. Run has one ProductURL, one PainPhraseSet, and three AdVariants. Run has a credits_used integer.

Integration Points

Apify for Amazon review scraping, Claude API for NLP extraction and copy generation, Supabase for run history and user accounts, Stripe for billing.

V1 Scope Boundaries

V1 excludes: Shopify review scraping, TikTok format, bulk URL batch, team workspaces, white-label, A/B result tracking.

Success Definition

A DTC founder pastes a competitor product URL, gets three ad variants, tests one in Meta Ads Manager, and reports a CTR improvement — without ever contacting the founder.

Challenges

The hardest non-technical problem is convincing performance marketers that AI copy is worth testing — the free tier must produce visibly better copy than what they are already running to overcome this skepticism.

Avoid These Pitfalls

Do not store full review text in your database long-term due to Amazon ToS exposure. Do not build team features before 20 paying customers. Acquiring the first 10 paying customers via Reddit requires a visibly impressive demo — invest 80% of week one in the prompt quality, not the UI.

Security Requirements

Supabase Auth with Google OAuth, RLS on runs table scoped to user_id, rate limit /api/analyze to 10 req/min per IP, validate URL format before scraping, do not log raw review content to application logs.

Infrastructure Plan

Vercel for Next.js, Supabase for Postgres and auth, no file storage needed, GitHub Actions for CI, Sentry for error tracking — total ~$75/month.

Performance Targets

200 DAU at launch, full pipeline (scrape + Claude) under 90 seconds, UI response under 500ms, page load under 2s LCP.

Go-Live Checklist

☐Pipeline tested with 10 different Amazon URLs.
☐Stripe credit and subscription flow tested end-to-end.
☐Sentry error tracking live on Vercel.
☐Supabase RLS verified on runs table.
☐Custom domain with SSL configured.
☐Privacy policy noting no long-term review storage published.
☐5 DTC beta users confirmed results usable.
☐Rollback: previous Vercel deployment reachable in one click.
☐Demo video and r/ecommerce post drafted.

First Run Experience

On first run: a sample Amazon URL for a popular supplement is pre-filled in the input. User can immediately click Analyze and see a real pain phrase extraction and 3 ad variants without creating an account. No manual config required: guest mode allows 2 free runs before sign-up prompt.

How to build it, step by step

1. Define schema: runs(id, user_id, url, pain_phrases jsonb, ad_variants jsonb, created_at) in Supabase. 2. Run npx create-next-app reviewdna and install @anthropic-ai/sdk, apify-client, stripe, @supabase/supabase-js. 3. Build Apify scraper wrapper in lib/scraper.ts that fetches up to 200 reviews for a given ASIN. 4. Write Claude prompt in lib/claude.ts that extracts top 5 pain phrases and returns structured JSON. 5. Write second Claude prompt that generates 3 ad variants using extracted phrases in pain-agitate-solve, social proof, and curiosity hook formats. 6. Build /api/analyze route that chains scraper then Claude calls and writes run to Supabase. 7. Build app/page.tsx with URL input, loading state, and AdCard result display with clipboard copy. 8. Add Stripe credit pack ($9 for 10 runs) and subscription ($49/month) with usage gating in middleware. 9. Add Supabase Auth with Google OAuth and link runs to user_id. 10. Verify: paste a real Amazon URL, receive pain phrases and 3 ad variants in under 90 seconds, copy one to clipboard — end to end without touching code.

Generated

May 4, 2026

Model

claude-sonnet-4-6

← Next

ContractDiff — Paste Two Contract Versions, Get a Plain-English Redline Report in 30 Seconds

ChoreLoop — The Telegram Bot That Manages Your Household So Your ADHD Brain Does Not Have To

Disclaimer: Ideas on this site are AI-generated and may contain inaccuracies. Revenue estimates, market demand figures, and financial projections are illustrative assumptions only — not financial advice. Do your own research before making any business or investment decisions. Technology availability, pricing, and market conditions change rapidly; always verify details independently.