SOW Patterns from Agency Research

Purpose: Document common painpoint → solution patterns from agency conversations to inform SOW creation and pricing.

Last Updated: 2026-02-12
Source Conversations: 1
Related: gtm/sales/sow-framework/


How to Use This Document

  • Reference when creating SOWs for agency clients
  • Match client painpoints to proven solution patterns
  • Inform pricing based on scope patterns
  • Connect to SOW framework templates

Pattern #1: Internal Knowledge Base Build

Painpoint Pattern

Client Says:

  • “Our data is scattered across tools”
  • “Teams can’t find information”
  • “BI team has data but other teams can’t access it”
  • “We’re exploring Cursor/Claude Cowork but not sure how to implement”

Underlying Issues:

  • Siloed departments and data
  • No single source of truth
  • Tool exploration without clear implementation plan
  • Cross-platform compatibility concerns

Evidence: Ayzenberg (Michael’s project), general agency structure

Solution Pattern

Approach: 2-Week Internal Knowledge Base Sprint

Phase 1 - Week 1: Foundation

  • Audit existing data sources and silos
  • Identify key user groups and their questions
  • Select appropriate tools (platform-agnostic where possible)
  • Design architecture and data flow
  • Set up initial infrastructure

Phase 2 - Week 2: Implementation

  • Build knowledge base with unified data access
  • Create chat/query interface
  • Implement cross-functional access controls
  • Train initial users
  • Measure baseline → current state

Deliverables:

  • Functional internal knowledge base
  • Documentation and training materials
  • Usage metrics dashboard
  • Handoff and support plan

Pricing Pattern

2-Week Sprint: 30K

  • Mid-size agency (50-200 employees): 25K
  • Larger agency (200-500 employees): 30K
  • Enterprise agency (500+ employees): 40K

Add-ons:

  • Extended training: +$5K
  • Custom integrations: +10K
  • Ongoing support (monthly): 5K/month

Success Metrics

Track These:

  • Time to find information: Before vs. After
  • Cross-functional queries per week
  • Team adoption rate (% using system)
  • User satisfaction score
  • Questions answered without human intervention

Follow-On Opportunities

  • Workflow automation on top of KB
  • Additional data source integrations
  • Advanced AI features (summarization, proactive insights)
  • Training for additional teams
  • Expansion to client-facing knowledge base

Pattern #2: AI ROI Measurement & Optimization

Painpoint Pattern

Client Says:

  • “We’ve invested in AI tools but can’t show ROI”
  • “Team is using co-pilots but we don’t know if it’s working”
  • “CEO wants to see AI impact but we don’t know what to measure”
  • “Tools are adopted but value is unclear”

Underlying Issues:

  • No baseline metrics established
  • Tool adoption without impact tracking
  • Pressure to justify AI investment
  • Risk of AI fatigue or budget cuts

Evidence: Ayzenberg (co-pilot ROI concern), general mid-maturity agency challenge

Solution Pattern

Approach: AI ROI Assessment & Measurement Setup

Phase 1: Baseline & Audit (3-5 days)

  • Catalog all AI tools in use
  • Identify workflows where AI is applied
  • Establish baseline metrics (time, cost, quality)
  • Survey team on current usage and pain points

Phase 2: Measurement Framework (5-7 days)

  • Define key metrics aligned with business goals
  • Set up tracking dashboards
  • Implement time-tracking for AI-assisted work
  • Create before/after comparison system
  • Train team on measurement

Phase 3: Optimization (ongoing or separate engagement)

  • Identify low-ROI tool usage
  • Recommend optimizations or replacements
  • Consolidate redundant tools
  • Develop best practices

Deliverables:

  • AI tool inventory and usage report
  • ROI measurement dashboard
  • Baseline metrics documentation
  • Optimization recommendations
  • Monthly/quarterly reporting template

Pricing Pattern

Assessment + Measurement Setup: 20K

  • Includes: Audit, framework design, dashboard setup, training

Optimization Engagement: 15K (separate)

  • Includes: Analysis, recommendations, implementation support

Ongoing Measurement Support: 3K/month

  • Includes: Monthly reporting, metric refinement, recommendations

Success Metrics

Track These:

  • Time savings per tool/workflow
  • Cost savings (efficiency gains)
  • Quality improvements (error rates, client satisfaction)
  • Tool adoption rates
  • Team satisfaction with AI tools

Follow-On Opportunities

  • Tool consolidation or replacement
  • Custom AI tool development for high-value workflows
  • Team training on high-ROI tools
  • Executive reporting and communication support

Pattern #3: Rapid AI Implementation (General)

Painpoint Pattern

Client Says:

  • “We tried working with a consultancy and it took forever”
  • “We need to move fast but don’t have internal expertise”
  • “Our CEO wants to see AI results quickly”
  • “Can you really deliver in 2 weeks?”

Underlying Issues:

  • Frustration with slow traditional consultancies
  • Need for speed without sacrificing quality
  • Executive pressure for visible progress
  • Skepticism about fast delivery claims

Evidence: Ayzenberg (impressed by “2 weeks vs. year”), general agency feedback

Solution Pattern

Approach: 2-Week AI Sprint (Scope-Specific)

Framework (applies to various use cases):

  • Week 1: Discovery, design, foundational build
  • Week 2: Implementation, testing, training, handoff

Key Success Factors:

  • Tightly scoped deliverable (no scope creep)
  • Daily standups with client
  • Working software/tool by end of week 1
  • Client involved throughout (not waterfall)
  • Clear MVP definition upfront

Deliverables (customized by use case):

  • Functional tool/system
  • Documentation
  • Training
  • Metrics dashboard
  • Handoff plan

Pricing Pattern

Base 2-Week Sprint: 25K (depending on complexity)

Pricing by Scope:

  • Single workflow automation: 20K
  • Internal knowledge base: 30K
  • Custom AI tool/platform: 40K
  • Multi-workflow system: 50K

Speed Premium: Some clients may pay premium for guaranteed 2-week delivery

Success Metrics

Track These:

  • On-time delivery (2 weeks or bust)
  • Client satisfaction (NPS or survey)
  • Time-to-value (days until client sees benefit)
  • Adoption rate post-handoff
  • Follow-on engagement rate

Follow-On Opportunities

  • Sprint 2, 3, 4+ (iterative builds)
  • Ongoing support/optimization
  • Training for additional teams
  • Expansion to new use cases

Pattern #4: Team Enablement & Training

Painpoint Pattern

Client Says:

  • “Our team needs to learn these tools but we don’t have time”
  • “We want to build internal capacity, not dependency”
  • “Can you teach us to fish, not just give us the fish?”
  • “Co-pilots are available but team doesn’t know best practices”

Underlying Issues:

  • Tool access without training
  • Fear of consultant dependency
  • Desire for internal capability building
  • Need for ongoing support during learning curve

Evidence: Implicit in Ayzenberg’s exploration of tools (Cursor, Claude Cowork)

Solution Pattern

Approach: AI Tool Enablement Program

Phase 1: Assessment (2-3 days)

  • Current tool usage and skill levels
  • Team roles and use case mapping
  • Learning style and schedule constraints

Phase 2: Training (5-7 days)

  • Tool workshops (hands-on)
  • Best practices and workflows
  • Real work sessions (learn by doing)
  • Q&A and troubleshooting

Phase 3: Support (2-4 weeks)

  • Office hours (weekly)
  • Slack/email support
  • Review of team’s work
  • Iteration and refinement

Deliverables:

  • Custom training materials
  • Tool setup and configuration
  • Best practice documentation
  • Office hours and ongoing support
  • Certification or completion assessment

Pricing Pattern

Enablement Program: 20K

  • Small team (5-10 people): 12K
  • Medium team (10-25 people): 18K
  • Large team (25+ people): $20K+

Per-Person Pricing: 1,000 per person (for larger rollouts)

Ongoing Support: 5K/month (optional)

Success Metrics

Track These:

  • Tool adoption rate (before vs. after)
  • Proficiency assessment scores
  • Time savings per team member
  • Reduction in support requests over time
  • Team satisfaction

Follow-On Opportunities

  • Advanced training sessions
  • Custom tool development for team
  • Ongoing advisory/support
  • Train-the-trainer program (agency trains their clients)

Emerging Patterns (Need More Data)

Pattern: Client AI Maturity Assessment

Potential Painpoint: “We work with clients at different AI stages and need to adapt our approach”

Potential Solution: AI maturity assessment service + client education program

Status: Need more conversations to validate


Pattern: Enterprise AI Adoption Strategy

Potential Painpoint: “Our enterprise clients have board-level AI mandates but no clear plan”

Potential Solution: Strategic AI adoption roadmap for agencies serving enterprise clients

Status: Referenced in Walmart opportunity; need more validation


Pattern: Boutique Agency AI Consulting

Potential Painpoint: Small agencies need AI guidance but can’t afford big consultancies

Potential Solution: Lightweight advisory + group training programs

Status: Mentioned by Jocelyn; need to explore this market segment


SOW Template Mapping

Connect to SOW Framework

  • Pattern #1 (Internal KB) → Use template: gtm/sales/sow-framework/templates/data-platform-implementation.md
  • Pattern #2 (ROI Measurement) → Create new template: “AI Assessment & Optimization”
  • Pattern #3 (Rapid Sprint) → Use template: gtm/sales/sow-framework/templates/rapid-prototyping.md
  • Pattern #4 (Training) → Use template: gtm/sales/sow-framework/templates/team-enablement.md

Create Missing Templates

  • AI ROI Assessment & Measurement template
  • 2-Week Sprint framework template (adaptable)
  • Team Enablement program template

Pricing Insights

Agency Pricing Sensitivity

Mid-Maturity Agencies (like Ayzenberg):

  • Budget range: 40K for defined projects
  • Prefer: Fixed-price over hourly
  • Want: Clear deliverables and timelines
  • Value: Speed and proven ROI

Retainer Hesitation: Mid-maturity agencies want proof before committing to ongoing engagements

Speed Premium: Willingness to pay more for 2-week delivery vs. 2-month

Pricing Strategy Recommendations

  1. Lead with 2-week sprints (30K range)
  2. Offer follow-on sprints (not retainers initially)
  3. Bundle measurement into all engagements (prove ROI)
  4. Create case study discount (10-15% off for publicity rights)

Next Research Questions

  • What are boutique agencies willing to pay? (vs. mid-size)
  • Is there appetite for group training programs? (cohort model)
  • Would agencies pay for ongoing advisory? (monthly calls, strategic guidance)
  • What does enterprise agency pricing look like? (Walmart scale)

Changelog

2026-02-12: Initial SOW patterns document created from Ayzenberg conversation. 4 primary patterns identified, 3 emerging patterns noted.