# Stripe

Analyze payments, subscriptions, and revenue metrics

Connect Stripe to Scoop to analyze your payment data, track subscription metrics, understand customer lifetime value, and monitor cash flow.

# AI-Assisted Setup

When connecting Stripe to Scoop, choose **"Guide me with AI"** for an intelligent, guided setup experience.

## Available Analysis Templates

| Template | Object | Data Mode | Best For | What You'll Analyze |
|----------|--------|-----------|----------|---------------------|
| **Revenue & Transactions** (Default) | charges | Snapshot | Payment analytics | Amounts, refunds, payment status |
| **Subscription Analytics** | subscriptions | Snapshot | Recurring revenue | MRR, churn, billing cycles |
| **Customer LTV** | customers | Sync | Customer value | Acquisition, delinquency |
| **Invoice Analytics** | invoices | Snapshot | Collections | Payment status, amounts due |
| **Cash Flow & Payouts** | payouts | Snapshot | Bank transfers | Arrival dates, payout status |

## Example Questions You Can Answer

**Revenue & Payments:**
- "What's our daily/weekly/monthly revenue?"
- "What's our refund rate over time?"
- "How do payment success rates trend?"
- "Which payment methods are most popular?"
- "What's our average transaction size?"

**Subscriptions:**
- "What's our MRR trend?"
- "How many subscriptions are active vs churned?"
- "What's our trial-to-paid conversion rate?"
- "How many customers are on each plan?"
- "What's our churn rate by month?"

**Customer Value:**
- "How many customers are delinquent?"
- "What's our customer acquisition trend?"
- "Which customers have the highest lifetime value?"
- "How does account balance distribute across customers?"

**Collections & Billing:**
- "What percentage of invoices are paid on time?"
- "How much is outstanding in unpaid invoices?"
- "What's our average collection time?"
- "Which invoices are overdue?"

**Cash Flow:**
- "When does money arrive in our bank?"
- "What's the average payout amount?"
- "How many payouts failed this month?"
- "What's our net cash flow trend?"

## Need Something Different?

If the templates above don't match your needs, select **"Something else"** and describe what you want to analyze. For example:

- "I want to track MRR by plan"
- "I need to see failed payment trends"
- "I want to analyze subscription cohorts"

Scoop's AI will recommend the right configuration for your specific use case.

## Snapshotting for Financial Analysis

Payment data changes over time - charges get refunded, subscriptions cancel, invoices get paid. Configure your extracts as **Snapshot** datasets to:

- Track revenue growth over time
- Monitor refund rate trends
- Analyze subscription status changes
- Compare billing periods week-over-week

> **Pro Tip:** Enable snapshotting for charges and subscriptions from day one to build historical trend data for financial reporting.

# Connecting Stripe to Scoop

1. Create a new dataset in Scoop
2. Select **Stripe** from the application list
3. Enter your Stripe API key (starts with `sk_`)
4. Choose your analysis template or customize
5. Save and extract data

## Getting Your API Key

1. Log in to your Stripe Dashboard
2. Go to **Developers** > **API Keys**
3. Use your **Secret key** (starts with `sk_live_` or `sk_test_`)
4. Copy the key and paste into Scoop

> **Security Notes:**
> - Use **Restricted keys** with read-only access for production
> - Create a key specifically for Scoop with only the permissions needed
> - Never share your secret key publicly

## Test vs Live Mode

- Keys starting with `sk_test_` access test data only
- Keys starting with `sk_live_` access real production data
- Test mode is great for initial setup and validation

# What Data You Get

## Charges
Individual payment transactions.

| Field | Description |
|-------|-------------|
| Charge ID | Unique identifier (prefixed with ST) |
| Amount | Charge amount (converted from cents) |
| Amount Refunded | Refund amount if applicable |
| Currency | 3-letter currency code |
| Customer ID | Associated customer |
| Status | succeeded, pending, failed |
| Paid | Whether payment succeeded |
| Refunded | Whether charge was refunded |
| Created Date | Transaction timestamp |
| Payment Method | How customer paid |

## Subscriptions
Recurring billing subscriptions.

| Field | Description |
|-------|-------------|
| Subscription ID | Unique identifier (prefixed with ST) |
| Customer ID | Subscriber's customer ID |
| Status | active, past_due, canceled, trialing, etc. |
| Period Start | Current billing period start |
| Period End | Current billing period end |
| Created Date | When subscription started |
| Canceled Date | When subscription was canceled |
| Plan Amount | Price per billing period |
| Plan Interval | month, year, week, day |

## Customers
Customer accounts in Stripe.

| Field | Description |
|-------|-------------|
| Customer ID | Unique identifier (prefixed with ST) |
| Email | Customer email |
| Name | Customer name |
| Phone | Phone number |
| Created Date | When customer was created |
| Balance | Account credit/debit |
| Delinquent | Has unpaid invoices |

## Invoices
Billing documents and statements.

| Field | Description |
|-------|-------------|
| Invoice ID | Unique identifier (prefixed with ST) |
| Customer ID | Billed customer |
| Subscription ID | Associated subscription |
| Status | draft, open, paid, void, uncollectible |
| Amount Due | Total billed |
| Amount Paid | Amount collected |
| Amount Remaining | Outstanding balance |
| Due Date | Payment deadline |

## Payouts
Bank transfers from Stripe to your account.

| Field | Description |
|-------|-------------|
| Payout ID | Unique identifier (prefixed with ST) |
| Amount | Transfer amount |
| Currency | Currency code |
| Arrival Date | Expected bank arrival |
| Created Date | When payout was initiated |
| Status | paid, pending, in_transit, failed, canceled |
| Type | bank_account or card |

# Analysis Examples

## Revenue Metrics
Track your payment performance:
- Daily/weekly/monthly revenue
- Refund rates and trends
- Payment success rates
- Average order value

## Subscription Health
Monitor recurring revenue:
- MRR/ARR calculations
- Churn rate by period
- Trial conversion rates
- Plan distribution

## Customer Insights
Understand your customer base:
- Acquisition trends
- Delinquency rates
- Account balance distribution
- Lifetime value segments

## Cash Flow
Track money movement:
- Payout timing and amounts
- Failed payout analysis
- Net cash flow trends

# Best Practices

- **Start with Charges**: Transaction data is the foundation for revenue analysis
- **Enable Snapshotting**: Build historical data for trend analysis
- **Track Subscriptions**: For SaaS, this is your MRR data
- **Monitor Delinquency**: Identify at-risk customers early
- **Use Test Mode First**: Validate your setup before production

# Troubleshooting

## Connection Issues
- Verify your API key is correct and active
- Ensure the key has read permissions for needed objects
- Check if you're using test vs live mode appropriately

## Missing Data
- Some data requires specific Stripe products (Billing, Connect)
- Historical data may be limited by your Stripe plan
- Check date filters if expecting more records

## Amount Display
- All amounts are automatically converted from cents to dollars
- Multi-currency support: amounts stay in original currency
- For conversions, check the currency field

## Rate Limits
Stripe allows 25 requests/second. If you see rate limit errors:
- Scoop automatically retries with backoff
- Large data sets may take longer to sync
- Contact support for persistent issues