Expected Stripe data

After you’ve connected your Stripe account, you can use the Data Warehouse Manager to easily track relevant data fields for analysis.

In this article, we’ll explore the main data tables that you can import from Stripe into Magento BI. After setup is completed, the following tables will be created in your data warehouse. Click the links in the Table Name column to learn more about the attributes in each table.

Table Name Description
Customers Customer objects allow you to perform recurring charges and track multiple charges that are associated with the same customer.
Charges This table contains information about charges to credit and debit cards, including the amount, currency, status, customer ID, and more.
Coupons This table contains information about a percent- or amount-off discount you may want to apply to a customer. Note that coupons only apply to invoices; they do not apply to one-off charges.
Invoices This table contains information about invoices including the amount owed, subscriptions, invoice items, any automatic proration adjustments, and more.
Plans This table contains the pricing information for different products and feature levels on your site. For example, you may have a $10/month plan for basic features and a $20/month plan for premium features.
Subscriptions This table contains the details of subscription plans your customers belong to. Attributes include customer ID, status, canceled/ended at dates, tax percent, trial information, and more.
Events Events let you know about something interesting that has just happened in an account. When an interesting event occurs, a new event object is created. For example, when a charge succeeds charge.succeeded event is created; or, when an invoice can't be paid an invoice.payment_failed event is created.
Note that many API requests may cause multiple events to be created. For example, if you create a new subscription for a customer, you will receive both a customer.subscription.created event and a charge.succeeded event.