Find Self-Serve Accounts Likely to Convert

This automated monthly workflow analyzes product usage from Mixpanel and revenue data from Stripe to identify which free accounts are most likely to convert to paying customers. Claude AI finds behavioral patterns in converted accounts (events, active days, feature usage), scores each free account from 0-100 based on similarity to those patterns, and generates specific sales recommendations for high-intent leads. Results are automatically sent to Airtable and Slack.
Complexity (to Build):
High
Complexity (to Run):
Low
Human Input:
Low
Copy-paste each agent
Use This Template
Find Self-Serve Accounts Likely to Convert

Important note: This isn't an agent you can simply "copy-paste". The Retool workflow needs to be adjusted to your specific stack and usage tracking configurations. The Claude API call should also be modified to look for specific usage patterns you know are important in your product.

Why this agent is valuable if you have a self-serve product:

  • Gives marketing a list of accounts to attribute ad budget to.
  • Helps sales and success reps prioritize accounts to engage first.
Notion-Style Callout
πŸ’‘ Need something more complex and customized to your flow & tools? Let's talk (15 min).

Workflow summary

Monthly Schedule Triggered by Relay.app Webhook:

↓

1. Query Mixpanel API β†’ Get user events (last 30 days)

2. Query Stripe API β†’ Get customer/subscription data

3. Aggregate by account domain (in-memory in Retool)

4. Prepare Data for analysis β†’Β  Converted vs Free accounts β†’ Compared against usage data

5. Call Claude API β†’ Analyze patterns β†’ Recommend top accounts and explain reasoning.Β 

6. Write results to Airtable β†’ High Intent Accounts Table

7. Send top accounts to GTM team in Slack

Retool Workflow

Important Tip for Retool

β†’ Before setting up the workflow with API calls to your stack, build the workflow end-to-end with fake data (using JS code) (ask us, or Claude AI, to help you). This way, you can iterate until you have the desired output before you start making real API calls.

Relay.app Agent

‍

‍

‍