Customer acquisition cost
SQL query for Stripe
Calculate the customer acquisition cost by dividing the sum of payouts and payment_intents by the total number of products.
SELECT (SUM(payouts) + SUM(payment_intents)) / COUNT(products) AS customer_acquisition_cost FROM payouts, products, payment_intents;
Stripe data model
Products
View 9 columns
IdString
NameString
TypeString
ActiveBoolean
ObjectString
CreatedInteger
UpdatedInteger
LivemodeBoolean
Default_priceString
Balance Transactions
Charges
Customers
Disputes
Events
Files
Invoices
Payouts
Prices
Payment Intents
Refunds
Shipping Rates
Subscriptions
Sub Accounts
Subscription Items
Balance Payout Reconciliation
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed