Using Customer IDs
Easily select and use one of the three types of customer identifiers to sync data with Mixpanel:
Stripe Customer ID: Automatically generated unique identifier for each customer in Stripe.
Email: Customer's email address, ideal for cross-platform identification.
Metadata: Custom attributes stored in Stripe, which need to be synced with Mixpanel.
Events Synced to Mixpanel
With Vendo’s Stripe integration, the following standard events are synced seamlessly to Mixpanel, helping you track key customer interactions:
Trial Start: Triggered when a trial period begins as part of a subscription.
Trial Ended: Triggered when the trial period concludes.
Trial Extended: Triggered when a user extends their trial period.
Account Created: Triggered when a new customer record is created in Stripe (excludes guest purchases).
Payment Received: Triggered when a payment is successfully charged to a customer.
Payment Failed: Triggered when a customer's payment attempt is unsuccessful.
Payment Refunded: Triggered when a payment is refunded by the business.
Subscription Started: Triggered when the first payment for a subscription is received.
Subscription Cancel Requested: Triggered when a customer requests to cancel their subscription.
If the subscription is set to end on cancellation, it will remain active until the billing period ends.
If it is set to end immediately, the request will result in immediate cancellation.
Subscription Ended: Triggered when a subscription concludes.
MRR (Monthly Recurring Revenue): Triggered monthly, calculating recurring revenue based on all payment frequencies (daily, weekly, yearly). The net amount after Stripe fees is reported. Refunds are excluded.
Example: A customer with a $1,200 yearly subscription starting on January 1, 2024, will generate $100 MRR events on January 1, February 1, and so on.
User Properties
LTV (Lifetime Value): Total revenue generated by a customer. This is the net amount paid, after subtracting Stripe fees and refunds.
More user properties
Key Differences Between Stripe and Mixpanel Reporting
MRR
Mixpanel: Uses net payment amounts (Stripe fees are subtracted automatically).
Stripe: Shows invoice amounts, requiring manual subtraction of refunds.
LTV
Mixpanel: Reflects exact amounts paid, excluding refunds.
Stripe: May reflect invoice line items rather than payments.
Subscription Start
Subscriptions are tracked as starting when the first payment is received.
Known Issues
These are the known issues which we are working out solutions for in the upcoming versions:
Currency Adjustments:
For some currencies (e.g., GBP, EUR, USD, AUD), amounts must be divided by 100 (e.g.,3900 -> 39.00). However, this does not apply to all currencies, such as Vietnamese Dong in Stripe however, in Vendo all currencies are divided by 100 so125,000Vietnamese Dong will show up as1250.00Refund Timestamp Accuracy:
Rarely, refund events may not have the correct timestamp. This occurs because we rely on the "last updated at" field, which usually aligns with the refund event but may sometimes reflect updates to the original charge.