Stripe Discount Effectiveness Analyzer v1.0.0

Monthly AI analysis of your Stripe coupon and discount performance — measures redemption volume, retention impact at 30/60/90 days, upgrade rates, and revenue per customer with KEEP/MODIFY/KILL recommendations.

Monthly AI analysis of your Stripe coupon and discount performance — measures redemption volume, retention impact at 30/60/90 days, upgrade rates, and revenue per customer with KEEP/MODIFY/KILL recommendations.

triggerSchedule01FetcherStripe API02Assembler5 Dimensions03AnalystKeep/Modify/Kill04FormatterBrief + SummaryNotionIntel BriefSlackExec Summary

Four Agents. Monthly Discount Intelligence. Zero Manual Analysis.

The Fetcher

Step 1 — The Fetcher

Code-only

Retrieves all Stripe coupons, paid invoices with discount data, and subscription records using paginated Stripe API calls within the configurable lookback window.

The Assembler

Step 2 — The Assembler

Code-only

Computes per-coupon effectiveness metrics across 5 dimensions: redemption volume, retention impact (30/60/90 day cohorts vs baseline), revenue per customer, upgrade rate, and discount type analysis. Generates KEEP/MODIFY/KILL recommendations.

The Analyst

Step 3 — The Analyst

Classification

Performs AGGREGATE discount effectiveness analysis. Identifies underperforming coupons, retention lift patterns, revenue impact by discount type, and generates prioritized strategic recommendations.

The Formatter

Step 4 — The Formatter

Creative

Generates a Notion discount intelligence brief with per-coupon scorecards and dimension breakdowns. Generates a Slack executive summary with overall health score and top KEEP/MODIFY/KILL actions.

What It Does NOT Do

×

Does not handle failed payments — use Stripe Dunning Intelligence (#29) for payment recovery

×

Does not compute customer lifetime value — use Customer LTV Intelligence (#33) for LTV analysis

×

Does not classify plan migrations — use Stripe Plan Migration Intelligence (#47) for subscription change analysis

×

Does not detect expansion revenue signals — use Expansion Revenue Detector (#12) for upsell timing

×

Does not provide real-time alerts — monthly batch analysis runs on the 1st of each month

×

Does not work with non-Stripe billing — this is Stripe-specific

The Complete Customer Success Bundle

6 files.

stripe_discount_effectiveness_analyzer_v1_0_0.json — Main workflow (26 nodes)
stripe_discount_effectiveness_analyzer_scheduler_v1_0_0.json — Scheduler workflow (3 nodes)
README.md — 10-minute setup guide
docs/TDD.md — Technical Design Document
system_prompts/analyst_system_prompt.md — Analyst prompt reference
system_prompts/formatter_system_prompt.md — Formatter prompt reference

Tested. Measured. Documented.

Monthly 5-dimension discount effectiveness audit with per-coupon KEEP/MODIFY/KILL recommendations and dual-channel delivery (Notion intelligence brief + Slack executive summary).

Stripe Discount Effectiveness Analyzer v1.0.0───────────────────────────────────────────────Nodes            26 (main) + 3 (scheduler)Agents           4 (Fetcher, Assembler, Analyst, Formatter)LLM Calls        2 per run (Analyst + Formatter)Model            Sonnet 4.6 (SINGLE-MODEL)Trigger          Schedule (monthly 1st 9:00 UTC) + WebhookPattern          AGGREGATE (monthly batch)Tool A           Stripe (configured) — coupons, invoices, subscriptionsTool B           Notion (httpHeaderAuth) — discount intelligence briefTool C           Slack (httpHeaderAuth) — executive summaryITP              8 variations, 14 milestonesBQS              12/12 PASSCost             $0.03–$0.10 per run

What You'll Need

Platform

n8n 2.7.5+

Est. Monthly API Cost

~$0.03-0.10 per monthly run. 1 run/month ~$0.03-0.10/month.

Credentials Required

  • ▪Anthropic API
  • ▪Stripe API (stripeApi type)
  • ▪Notion (httpHeaderAuth Bearer)
  • ▪Slack (Bot Token, httpHeaderAuth Bearer)

Services

  • ▪Stripe account with active coupons/discounts
  • ▪Anthropic API key
  • ▪Notion workspace
  • ▪Slack workspace (Bot Token with chat:write)

Setup Track

Quick Start

~15 min

All credentials live, n8n running

Full Setup

1–2 hrs

Needs API config + tables

From Scratch

2–4 hrs

No n8n, no credentials

Stripe Discount Effectiveness Analyzer v1.0.0 v1.0.0

$199

one-time purchase

What you get:

  • ✓26-node main workflow + 3-node scheduler
  • ✓Monthly 5-dimension discount effectiveness scoring for every Stripe coupon
  • ✓Redemption volume tracking with velocity and active/expired status
  • ✓Retention impact measurement at 30/60/90 days vs non-discount baseline
  • ✓Revenue per customer comparison (discounted vs non-discounted cohorts)
  • ✓Upgrade rate tracking for coupon users
  • ✓Discount type analysis (percentage-off, fixed-amount, free-trial)
  • ✓KEEP/MODIFY/KILL recommendations per coupon
  • ✓Notion discount intelligence brief with per-coupon scorecards
  • ✓Slack executive summary with overall health score
  • ✓Configurable lookback window, retention windows, and minimum redemption thresholds
  • ✓Full technical documentation + system prompts

Frequently Asked Questions

What discount effectiveness dimensions does it score?+

Five dimensions, each weighted 20%: redemption volume (adoption and usage patterns), retention impact (30/60/90 day rates vs non-discount baseline), revenue per customer (average revenue comparison), upgrade rate (plan upgrades among coupon users), and discount type analysis (effectiveness by percentage-off, fixed-amount, or free-trial). Each coupon receives a composite effectiveness score.

How does the KEEP/MODIFY/KILL recommendation work?+

The Assembler computes a weighted effectiveness score: retention lift (40%), revenue delta (30%), upgrade rate (20%), and redemption volume (10%). Coupons scoring 60+ get KEEP (positive ROI), 21-59 get MODIFY (needs adjustment), and 20 or below get KILL (negative ROI). The Analyst then provides strategic context for each recommendation.

How does retention impact measurement work?+

The Assembler builds two cohorts: customers who used each coupon and customers who never used any coupon. It measures subscription retention at 30, 60, and 90 days for both cohorts. The retention lift is the difference — positive lift means the coupon improves retention vs baseline.

How does it differ from Stripe Dunning Intelligence?+

SDI (#29) handles failed payments with intelligent recovery emails — it reacts to payment failures. Customer LTV Intelligence (#33) computes lifetime value across segments. Stripe Plan Migration Intelligence (#47) classifies subscription changes. This product uniquely measures coupon/discount effectiveness with cohort comparison and KEEP/MODIFY/KILL recommendations.

Can I customize the analysis parameters?+

Yes. Set LOOKBACK_MONTHS (default 6) for the analysis window, RETENTION_WINDOWS (default [30,60,90]) for retention measurement periods, and MIN_REDEMPTIONS (default 10) to filter out low-usage coupons. All configurable in the scheduler Build Payload node.

Does it use web scraping?+

No. All data comes from the Stripe API (coupons, invoices, subscriptions endpoints). No web scraping, no page parsing.

Is there a refund policy?+

All sales are final after download. Review the Blueprint Dependency Matrix and prerequisites before purchase. Questions? Contact support@forgeworkflows.com before buying. Full terms at forgeworkflows.com/legal.

Read the full guide →

Related Blueprints

Stripe Dunning Intelligence

Intelligent payment recovery with AI-personalized dunning.

$199

Stripe Plan Migration Intelligence

AI-powered subscription change analysis that classifies plan migrations, identifies the likely driver, and generates talking points for your CS team — triggered instantly when customers upgrade, downgrade, or switch plans.

$199

Customer LTV Intelligence

Monthly AI-powered LTV analysis across your entire customer base.

$249