Expected Stripe data
After you have connected your Stripe account, you can use the Data Warehouse Manager to easily track relevant data fields for analysis.
This topic explores the main data tables that you can import from Stripe into Commerce Intelligence. 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 that you may want to apply to a customer. 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 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 cannot be paid an invoice.payment\_failed event is created. |
NOTEMany API requests may cause multiple events to be created. For example, if you create a subscription for a customer, you receive both a
customer.subscription.created event and a charge.succeeded event.Previous pageConnecting Stripe
Next pageConnecting WooCommerce
