Skip to content
← All case studies

AI Agents · Client build · 3 min read

Social Playbook

A content-operations SaaS that turns competitor activity into a reviewable strategy and weekly planning workflow.

Competitor research turned into a weekly content plan

Social Playbook project overview
Social Playbook project overview. Open image for a closer look.
01

Project overview

Competitor research that produces a weekly content plan

Services: AI Agents ; AI Workflow Automation
Delivery: Competitor-intelligence SaaS, AI strategy, subscriptions, and background processing.

02

Project Snapshot

FigureWhat it represents
14,200+ postsProcessing volume reported in earlier portfolio records
5 platformsInstagram, LinkedIn, TikTok, X, and Facebook
Up to 25 competitorsDocumented account-plan capacity
15 minutesTimeout introduced for stuck scrape jobs
2 minutesGrace period for correcting an accidental competitor addition

The processing count is a historical reported figure. Plan capacity and timeouts describe the product, not customer growth.

03

The Problem

The product needed to turn competitor activity into a strategy and content calendar for the user's business. That required more than a model call: competitor data had to arrive, remain usable, and refresh on a schedule.

Delivery exposed practical problems. Adding a competitor could create duplicate scrape jobs and spend collection credits repeatedly. Analysis could start before every competitor finished loading. Social-platform image URLs expired, leaving missing thumbnails. Stuck jobs left the interface loading indefinitely.

Those failures affected both the quality of the plan and the cost of producing it.

04

What We Delivered

Business onboarding establishes the brand context. Users add competitors, collection jobs gather platform activity, and the backend prepares that material for AI strategy generation.

The application presents the playbook, competitor benchmarks, weekly insights, and a content calendar. Subscription billing and plan limits control access and usage. Scheduled updates repeat the collection and analysis workflow.

The March 27 delivery record documents parallel collection, duplicate-job prevention, and a generation gate: strategy, weekly update, and calendar run once after competitor loading finishes.

It also records persistent thumbnail storage to avoid expired CDN links and a fifteen-minute timeout for stuck jobs.

05

Engineering Decisions

Make collection completion explicit. Generating a strategy before the inputs are ready risks producing an incomplete comparison and repeating paid model work.

Store media rather than depending on temporary URLs. The user needs to inspect the source post when reviewing the analysis.

Treat competitor slots as a billable resource. Deleting an accidental addition within two minutes refunds the slot. Later deletion does not reset consumption; slots renew with the billing period.

Make failure visible. A timed-out job needs an end state and an actionable message, not an endless spinner.

06

Results

The product connects ingestion, strategy, weekly updates, calendar generation, billing, and administration. Existing portfolio records report 14,200+ posts processed.

The dated delivery log records fixes for duplicate jobs, repeated generation, expiring images, and indefinite loading. These are concrete operational improvements; the records do not establish a percentage reduction in marketing labor or growth in audience engagement.

07

Technology stack

Next.js and React; TypeScript, Node.js, Express, PostgreSQL; Apify; Anthropic Claude streaming API with structured parsing and retries; S3 media storage, FFmpeg tooling; Stripe; Resend; background ingestion and weekly workers.

08

Project at a glance

Five social platforms to one weekly plan.
Social Playbook combines competitor collection, AI strategy, and content calendars. We built the subscription product and addressed duplicate jobs, incomplete inputs, expired thumbnails, and stalled processing along the way.

09

Project summary

Social Playbook analyzes competitor activity and turns it into a recurring content plan. We also handled the expensive operational problems behind that promise: duplicate scrapes, premature AI generation, and media links that stopped working.

Build a system around your workflow.

Tell us where the work gets stuck. We will map the first release, integrations, cost, and timeline.

Discuss a similar project