Can I vibe code Sellics?

Build an Amazon PPC Bid Automation and Analytics Service using Node.js/TypeScript, PostgreSQL, and Prisma ORM.

1. DATA MODEL
- Account: id, sellerId, lwaRefreshToken, amazonRegion.
- Campaign: id, accountId, amazonCampaignId, name, budget, targetingType, state.
- Keyword: id, campaignId, amazonKeywordId, keywordText, matchType, bid, state.
- AdPerformance: id, keywordId, date, impressions, clicks, spend, sales, orders, acos.
- BidRule: id, accountId, targetAcos, minBid, maxBid, maxAcosThreshold, increaseStepPercent, decreaseStepPercent.

2. API INTEGRATION & ETL
- Implement OAuth flow for Amazon Advertising API using LWA credentials.
- Schedule daily cron jobs to request Sponsored Products Reports (asynchronous v3 reports).
- Implement exponential backoff for Amazon API rate limits (HTTP 429 status).
- Parse compressed JSON/CSV report downloads, mapping performance metrics to AdPerformance schema.

3. BID OPTIMIZATION ENGINE
- Execute a nightly cron task evaluating 14-day aggregated performance per keyword.
- If Keyword ACoS > BidRule.targetAcos AND Clicks > 10, reduce bid by decreaseStepPercent (floor at minBid).
- If Keyword ACoS < BidRule.targetAcos AND Spend > $10, increase bid by increaseStepPercent (ceiling at maxBid).
- If Clicks > 15 AND Sales == 0, set Keyword state to paused or mark as negative target candidate.
- Log all bid changes to a BidAuditLog table with oldBid, newBid, triggerReason.

4. DASHBOARD & UI
- React dashboard display: Total Ad Spend, Total Revenue, Blended ACoS, and TACoS (Total ACoS).
- Data table showing Keyword performance with inline controls to manually update bids or toggle rules.

OUT OF SCOPE:
- Multi-currency conversions, inventory forecasting, and organic SERP scraper implementation.

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