TRES // jointres.co
AI-powered community intelligence for brand partnerships
Brands running community-led growth face a research problem: there are tens of thousands of relevant online and offline communities — running clubs, wellness groups, professional networks, subcultures — but no structured way to find, evaluate, and partner with them. The process was manual, slow, and impossible to scale.
TRES was built to solve this end-to-end: discover communities by describing what you need in plain language, evaluate fit with AI-generated scores and reasoning, initiate partnerships with structured workflows and escrowed payments, measure the resulting social performance, and attribute revenue through an affiliate commerce layer. Coralsoft was responsible for the entire product engineering surface — architecture, Convex backend, all frontends, ingestion pipelines, LLM enrichment, Typesense search, Chrome extension, Shopify app, and admin tooling — evolved continuously as the corpus grew from 3,000 to 85,000 communities.
The product surface
The platform is a pnpm monorepo with six distinct product surfaces sharing a single typed Convex backend. The flagship capability — Deep Discovery — is a natural-language search engine that grew from a simple RAG prototype into a production hybrid retrieval and LLM ranking system, returning a saved research report with ranked communities, fit scores, AI reasoning, and one-click outreach tooling.
Brand portal
Deep Discovery, partnerships kanban, social measurement and Stripe payouts in a unified workspace — the day-to-day surface where research becomes revenue.
Admin console
Corpus management, enrichment ops, custom discovery reports and EMV rate cards. The control panel for the data layer that powers everything else.
Shopify app
Embedded affiliate links, per-community discounts, webhook-based order attribution, and the full pending → approved → paid commission lifecycle.
Chrome extension
One-click community capture from Instagram, Facebook, Luma and Meetup. Built with WXT so the same code ships to all four browser stores.
Scraper fleet
Apify + Crawlee + Playwright pipelines for Luma and Meetup ingestion, feeding the enrichment queue alongside Bright Data Instagram imports.
Transactional email
React Email templates orchestrated through Loops for partnership notifications — AI-generated outreach copy seeded from the discovery report.
Decisions, not just dependencies.
Convex is the system of record for all product data, auth-aware APIs, scheduled jobs, and long-running orchestration. Frontends never call third-party APIs directly for sensitive operations — everything is mediated through typed Convex queries, mutations, and actions. This keeps the security boundary clean and makes the backend the single source of truth across six product surfaces.
The search architecture deliberately separates retrieval from judgment: Typesense provides high-recall candidates via keyword, vector, and hybrid modes with structured location filters; Claude Sonnet and Opus provide high-precision ranking. Legacy Convex RAG remains as an automatic fallback path. For social measurement, Instagram CDN URLs that expire are fetched once and stored durably on Cloudflare R2 with deterministic keys — ensuring media is always available for reporting regardless of source.
What was hard, and how we shipped it.
- 01
Search stack evolution from RAG to hybrid LLM funnel
Migrated Deep Discovery from a 3,000-record Convex RAG prototype to a Typesense hybrid retrieval engine with a two-stage LLM ranking pipeline — parallel Sonnet recall shards into an Opus final judge — capable of precision-ranked reports over 85,000 communities.
- 02
Industrial-scale enrichment pipeline
Batched four-stage Claude enrichment processes communities from Bright Data imports, Apify scrapes, and manual entry — with deduplication, quality tiering, and overnight bulk runs at rate-limit-aware scheduler cadence. The corpus grew 28× during the engagement.
- 03
End-to-end partnership OS
Full brand ↔ community lifecycle from Deep Discovery outreach through Stripe-escrowed payments, deliverable review, dispute flows, and community Stripe Connect payouts — with AI-generated outreach copy seeded from the discovery report.
- 04
Shopify affiliate commerce layer
Embedded Shopify app with per-community discount and commission configuration, dub.co click tracking, webhook-based order attribution, and a full pending → approved → paid commission lifecycle with Stripe invoicing and Connect payouts.
- 05
Dual-source social measurement
InsightIQ OAuth for authenticated accounts and Apify scraping for public profiles — unified into shared metrics tables with engagement rate and EMV calculations, campaign grouping, and durable Cloudflare R2 media storage that survives Instagram CDN URL expiry.
Looking at a project that sits at this kind of seam?
Bring us the architecture, the constraints, and the ship date. We will bring the rest.