Jakeschincariol/replica-skill / replica-entrepreneur
replica-entrepreneur
VerifiedResearches the app being cloned and reads what its real users say in public reviews (App Store, Google Play, G2, Capterra, Trustpilot, Reddit, Hacker News, its own feature-request board), then ranks what they hate, what is missing and what is unsolved, turns it into a fix plan for the clone and a positioning angle you can sell. Every quote is real, verbatim and linked. Use when the user says "what do people hate about X", "read the reviews", "how do I make mine better", "find the gap", "what features are missing", "how do I position this", "make it sellable", or after /replica-diff.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 4.7 KB |
| reviews.py | script | 12.1 KB |
| themes.json | config | 4.8 KB |
reviews.py
View on GitHub#!/usr/bin/env python3
"""Feedback ranker for replica-entrepreneur. Standard library only.
Takes the real reviews you collected about the app you are cloning and ranks
what its users hate and what they keep asking for, with the exact words and a
link for every claim.
python3 reviews.py replica/reviews.csv
python3 reviews.py replica/reviews.csv --out replica/feedback.md
python3 reviews.py replica/reviews.csv --json
python3 reviews.py replica/reviews.csv --themes my-themes.json
The CSV needs these columns (extra columns are ignored):
source where it came from: app-store, google-play, g2, capterra,
trustpilot, reddit, hacker-news, product-hunt, ...
url the link to the review or thread. Required.
date YYYY-MM-DD if you have it (YYYY-MM is fine)
rating 1 to 5 stars if the source has stars, else blank
text the review, copied exactly. Required.
A row without a url or without text is dropped and counted, never guessed.
This tool only reorganises what you give it. It does not write reviews, it
does not paraphrase them, and every quote it prints is a substring of a row
you supplied, with that row's link.
How a theme is ranked: every review that matches it adds a weight. A 1 star
review adds 1.0, a 5 star review adds 0.2, an unrated one adds 0.6. Reviews
older than --months (default 18) count half. Themes with fewer than 3 reviews,
or all from one source, are marked thin.
"""
import argparse
import csv
import datetime as _dt
import json
import os
import re
import sys
HERE = os.path.dirname(os.path.abspath(__file__))
DEFAULT_THEMES = os.path.join(HERE, "themes.json")
SENTENCE = re.compile(r"(?<=[.!?])\s+|\n+")
class FeedbackError(Exception):
pass
def load_themes(path=DEFAULT_THEMES):
with open(path, encoding="utf-8") as fh:
data = json.load(fh)
themes = []
for t in data.get("themes", []):
themes.append({
"id": t["id"], "label": t.get("label", t["id"]),
"kind": t.get("kind", "complaint"),
"patterns": [re.compile(p, re.I) for p in t.get("patterns", [])],
})
requests = [re.compile(p, re.I) for p in data.get("request_patterns", [])]
return themes, requests
def parse_date(text):
text = (text or "").strip()
for fmt, n in (("%Y-%m-%d", 10), ("%Y-%m", 7)):
try:
return _dt.datetime.strptime(text[:n], fmt).date()
except ValueError:
continue
return None
def parse_rating(text):
text = (text or "").strip()
if not text:
return None
m = re.match(r"^\s*(\d+(?:\.\d+)?)", text)
if not m:
return None
value = float(m.group(1))
if value < 1 or value > 5:
return None
return value
def load_reviews(path):
"""Return (kept rows, dropped count, duplicate count)."""
with open(path, newline="", encoding="utf-8-sig") as fh:
reader = csv.DictReader(fh)
if reader.fieldnames is None:
raise FeedbackError("%s is empty" % path)
cols = [c.strip().lower() for c in reader.fieldnames]
for need in ("url", "text"):
if need not in cols:
raise FeedbackError(
"%s has no '%s' column. Every review needs the link it came "
"from and its exact text: source,url,date,rating,text" % (path, need))
kept, dropped, dupes = [], 0, 0
seen = set()
for i, raw in enumerate(reader, start=2):
row = {(k or "").strip().lower(): (v or "").strip() for k, v in raw.items()}
url, text = row.get("url", ""), row.get("text", "")
if not url or not text or not re.match(r"^https?://", url):
dropped += 1
continue
key = re.sub(r"\W+", " ", text.lower()).strip()
if key in seen:
dupes += 1
continue
seen.add(key)
kept.append({
"line": i,
"source": row.get("source", "") or _host(url),
"url": url,
"date": parse_date(row.get("date", "")),
"rating": parse_rating(row.get("rating", "")),
"text": text,
})
return kept, dropped, dupes
def _host(url):
m = re.match(r"^https?://(?:www\.)?([^/]+)", url)
return m.group(1) if m else "unknown"
def weight(review, today, months):
r = review["rating"]
w = 0.6 if r is None else (6.0 - r) / 5.0
if review["date"] is not None and today is not None:
age_days = (today - review["date"]).days
if age_days > months * 30.4:
w *= 0.5
return w
def snippet(text, pattern, limit=220):
"""The first sentence of text that matches pattern, verbatim."""
for sent in SENTENCE.split(text):
if pattern.search(sent):
s = sent.strip()
if len(s) > limit:
m = pattern.search(s)
start = max(0, m.start() - limit // 2)
s = s[start:start + limit].strip()
s = ("..." if start > 0 else "") + s + "..."
return s
s = text.strip()
return s if len(s) <= limit else s[:limit].rstrip() + "..."
def analyse(reviews, themes, request_patterns, today=None, months=18):
if today is None:
today = _dt.date.today()
results = {t["id"]: {"id": t["id"], "label": t["label"], "kind": t["kind"],
"reviews": [], "score": 0.0} for t in themes}
requests = []
unthemed_negative = []
for rv in reviews:
w = weight(rv, today, months)
matched = False
for t in themes:
hit = next((p for p in t["patterns"] if p.search(rv["text"])), None)
if hit is None:
continue
matched = True
res = results[t["id"]]
res["score"] += w
res["reviews"].append({"rv": rv, "quote": snippet(rv["text"], hit)})
req = next((p for p in request_patterns if p.search(rv["text"])), None)
if req is not None:
requests.append({"quote": snippet(rv["text"], req), "url": rv["url"],
"source": rv["source"], "rating": rv["rating"]})
if not matched and rv["rating"] is not None and rv["rating"] <= 2:
unthemed_negative.append(rv)
total = len(reviews) or 1
ranked = []
for res in results.values():
items = res["reviews"]
if not items:
continue
rated = [x["rv"]["rating"] for x in items if x["rv"]["rating"] is not None]
sources = sorted({x["rv"]["source"] for x in items})
# Lowest rated first, then shortest, so the quotes shown are the sharpest.
items.sort(key=lambda x: (x["rv"]["rating"] if x["rv"]["rating"] is not None else 3,
len(x["quote"])))
ranked.append({
"id": res["id"], "label": res["label"], "kind": res["kind"],
"score": round(res["score"], 2),
"count": len(items),
"share_pct": round(100.0 * len(items) / total, 1),
"avg_rating": round(sum(rated) / len(rated), 2) if rated else None,
"sources": sources,
"thin": len(items) < 3 or len(sources) < 2,
"quotes": [{"quote": x["quote"], "url": x["rv"]["url"],
"source": x["rv"]["source"], "rating": x["rv"]["rating"]}
for x in items[:3]],
})
ranked.sort(key=lambda d: (-d["score"], -d["count"], d["id"]))
return {
"reviews": len(reviews),
"sources": sorted({r["source"] for r in reviews}),
"rated": sum(1 for r in reviews if r["rating"] is not None),
"themes": ranked,
"requests": requests,
"unthemed_negative": [{"url": r["url"], "source": r["source"],
"rating": r["rating"], "text": r["text"][:220]}
for r in unthemed_negative],
}
def _stars(r):
return "-" if r is None else ("%g*" % r)
def render(result, dropped=0, dupes=0):
out = ["# What users of the original hate and want", ""]
out.append("%d reviews from %d sources (%s). %d had star ratings." % (
result["reviews"], len(result["sources"]), ", ".join(result["sources"]) or "none",
result["rated"]))
if dropped:
out.append("%d rows dropped: no link or no text. Nothing is counted without "
"its source." % dropped)
if dupes:
out.append("%d duplicate reviews removed." % dupes)
if result["reviews"] < 30:
out.append("")
out.append("Small sample. Under 30 reviews supports a direction, not a "
"ranking. Collect more before you bet the roadmap on it.")
for kind, title in (("complaint", "What they hate"), ("request", "What they ask for")):
rows = [t for t in result["themes"] if t["kind"] == kind]
out.append("")
out.append("## %s" % title)
out.append("")
if not rows:
out.append("Nothing matched. Read the reviews by hand.")
continue
out.append("| rank | theme | score | reviews | share | avg stars | sources |")
out.append("| --- | --- | --- | --- | --- | --- | --- |")
for i, t in enumerate(rows, 1):
out.append("| %d | %s%s | %.1f | %d | %.0f%% | %s | %d |" % (
i, t["label"], " (thin)" if t["thin"] else "", t["score"], t["count"],
t["share_pct"], "-" if t["avg_rating"] is None else "%.1f" % t["avg_rating"],
len(t["sources"])))
for t in rows[:6]:
out.append("")
out.append("**%s**" % t["label"])
for q in t["quotes"]:
out.append('- "%s" (%s, %s) %s' % (q["quote"], q["source"],
_stars(q["rating"]), q["url"]))
if result["requests"]:
out.append("")
out.append("## Asked for in their own words")
out.append("")
for q in result["requests"][:25]:
out.append('- "%s" (%s, %s) %s' % (q["quote"], q["source"],
_stars(q["rating"]), q["url"]))
if result["unthemed_negative"]:
out.append("")
out.append("## Read these by hand")
out.append("")
out.append("Low ratings that matched no theme. Either noise, or a theme "
"themes.json does not have yet. Often the most useful part.")
out.append("")
for r in result["unthemed_negative"][:15]:
out.append('- (%s, %s) %s: "%s"' % (r["source"], _stars(r["rating"]),
r["url"], r["text"]))
return "\n".join(out) + "\n"
def main(argv=None):
ap = argparse.ArgumentParser(description=__doc__.split("\n\n")[0])
ap.add_argument("reviews", help="CSV with source,url,date,rating,text")
ap.add_argument("--themes", default=DEFAULT_THEMES)
ap.add_argument("--months", type=int, default=18,
help="reviews older than this count half (default 18)")
ap.add_argument("--today", help="YYYY-MM-DD, for reproducible runs")
ap.add_argument("--out", help="write the markdown report here")
ap.add_argument("--json", action="store_true")
args = ap.parse_args(argv)
try:
themes, req = load_themes(args.themes)
reviews, dropped, dupes = load_reviews(args.reviews)
except (FeedbackError, OSError, ValueError, KeyError, re.error) as exc:
print("reviews: %s" % exc, file=sys.stderr)
return 2
if not reviews:
print("reviews: no usable rows. Every row needs a url (http...) and the "
"review text.", file=sys.stderr)
return 2
today = parse_date(args.today) if args.today else None
result = analyse(reviews, themes, req, today=today, months=args.months)
result["dropped"] = dropped
result["duplicates"] = dupes
if args.json:
print(json.dumps(result, indent=2, default=str))
return 0
text = render(result, dropped, dupes)
if args.out:
with open(args.out, "w", encoding="utf-8") as fh:
fh.write(text)
print("wrote %s" % args.out)
else:
sys.stdout.write(text)
return 0
if __name__ == "__main__":
sys.exit(main())
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| add-product-e2e-evalpaperclipai/paperclipAdd or extend a Paperclip full-stack runner E2E workflow, fixture, matcher, or report evidence path for local or Daytona execution. | Stars: 115k | Updated | Claude CodeCodex | Verified | Install |
| add-runner-evalpaperclipai/paperclipAdd or extend a Paperclip Runner protocol evaluation definition, roster, assertion, or report fixture with provenance and narrow validation. | Stars: 115k | Updated | Claude CodeCodex | Verified | Install |
| diagnose-why-work-stoppedpaperclipai/paperclipCompatibility entry point for failed, stalled, looping, or over-recovered Paperclip work. Use fix-failed-paperclip-run for the full diagnosis, regression, repair, real verification, and green-PR workflow; honor an explicitly requested diagnosis-only scope. | Stars: 115k | Updated | Claude CodeCodex | Verified | Install |
| fix-failed-paperclip-runpaperclipai/paperclipDiagnose and fix failed, stuck, slow, or incorrectly blocked Paperclip tasks and runs. Use with a task/run URL or failure report to trace the root cause, prove a regression red then green, check second-order effects, verify the real workflow, and deliver a PR with passing checks. | Stars: 115k | Updated | Claude CodeCodex | Verified | Install |