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

Create a new dataset in Scoop
Select Stripe from the application list
Enter your Stripe API key (starts with sk_)
Choose your analysis template or customize
Save and extract data

Getting Your API Key

Log in to your Stripe Dashboard
Go to Developers > API Keys
Use your Secret key (starts with sk_live_ or sk_test_)
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