Stripe Data Studio Connector Fields Reference

Account Name

The name of the Stripe account

Field Type:Dimension

Data Views:All

Charge Amount

Amount intended to be collected by this payment

Field Type:Metric

Data Views:Charges

Charge Amount Captured

Amount captured (can be less than the amount attribute on the charge if a partial capture was made)

Field Type:Metric

Data Views:Charges

Charge Amount Refunded

Amount refunded (can be less than the amount attribute on the charge if a partial refund was issued).

Field Type:Metric

Data Views:Charges

Charge Balance Transaction

ID of the balance transaction that describes the impact of this charge on your account balance (not including refunds or disputes)

Field Type:Dimension

Data Views:Charges

Charge Billing Address City

City, district, suburb, town, or village for billing address

Field Type:Dimension

Data Views:Charges

Charge Billing Address Country

Two-letter country code (ISO 3166-1 alpha-2) for billing address

Field Type:Dimension

Data Views:Charges

Charge Billing Address Line 1

Address line 1 (e.g., street, PO Box, or company name) for billing address

Field Type:Dimension

Data Views:Charges

Charge Billing Address Line 2

Address line 2 (e.g., apartment, suite, unit, or building) for billing address

Field Type:Dimension

Data Views:Charges

Charge Billing Address Postal Code

ZIP or postal code for billing address

Field Type:Dimension

Data Views:Charges

Charge Billing Address State

State, county, province, or region for billing address

Field Type:Dimension

Data Views:Charges

Charge Billing Email

Email address for billing

Field Type:Dimension

Data Views:Charges

Charge Billing Name

Full name or business name for billing

Field Type:Dimension

Data Views:Charges

Charge Billing Phone

Phone number for billing

Field Type:Dimension

Data Views:Charges

Charge Calculated Statement Descriptor

The full statement descriptor that is passed to card networks, and that is displayed on your customers’ credit card and bank statements

Field Type:Dimension

Data Views:Charges

Charge Captured

If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured

Field Type:Dimension

Data Views:Charges

Charge Created

Time at which the charge was created

Field Type:Dimension

Data Views:Charges

Charge Currency

Three-letter ISO currency code, in lowercase

Field Type:Dimension

Data Views:Charges

Charge Customer

ID of the customer this charge is for if one exists

Field Type:Dimension

Data Views:Charges

Charge Description

Description of the charge

Field Type:Dimension

Data Views:Charges

Charge Disputed

Whether the charge has been disputed

Field Type:Dimension

Data Views:Charges

Charge Failure Balance Transaction

ID of the balance transaction that describes the reversal of the balance on your account due to payment failure

Field Type:Dimension

Data Views:Charges

Charge Failure Code

Error code explaining reason for charge failure if available

Field Type:Dimension

Data Views:Charges

Charge Failure Message

Message to user further explaining reason for charge failure if available

Field Type:Dimension

Data Views:Charges

Charge ID

Unique identifier for the charge object

Field Type:Dimension

Data Views:Charges

Charge Invoice

ID of the invoice this charge is for if one exists

Field Type:Dimension

Data Views:Charges

Charge Object

String representing the object’s type. Objects of the same type share the same value

Field Type:Dimension

Data Views:Charges

Charge Paid

Is true if the charge succeeded, or was successfully authorized for later capture

Field Type:Dimension

Data Views:Charges

Charge Payment Intent

ID of the PaymentIntent associated with this charge, if one exists

Field Type:Dimension

Data Views:Charges

Charge Payment Method

ID of the payment method used in this charge

Field Type:Dimension

Data Views:Charges

Charge Receipt Email

This is the email address that the receipt for this charge was sent to

Field Type:Dimension

Data Views:Charges

Charge Receipt Number

This is the transaction number that appears on email receipts sent for this charge. This attribute will be null until a receipt has been sent

Field Type:Dimension

Data Views:Charges

Charge Receipt URL

This is the URL to view the receipt for this charge. The receipt is kept up-to-date to the latest state of the charge, including any refunds

Field Type:Dimension

Data Views:Charges

Charge Refunded

Whether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false

Field Type:Dimension

Data Views:Charges

Charge Shipping Address City

City, district, suburb, town, or village for shipping address

Field Type:Dimension

Data Views:Charges

Charge Shipping Address Country

Two-letter country code (ISO 3166-1 alpha-2) for shipping address

Field Type:Dimension

Data Views:Charges

Charge Shipping Address Line 1

Address line 1 (e.g., street, PO Box, or company name) for shipping address

Field Type:Dimension

Data Views:Charges

Charge Shipping Address Line 2

Address line 2 (e.g., apartment, suite, unit, or building) for shipping address

Field Type:Dimension

Data Views:Charges

Charge Shipping Address Postal Code

ZIP or postal code for shipping address

Field Type:Dimension

Data Views:Charges

Charge Shipping Address State

State, county, province, or region for shipping address

Field Type:Dimension

Data Views:Charges

Charge Shipping Carrier

The delivery service that shipped a physical product, such as Fedex, UPS, USPS, etc.

Field Type:Dimension

Data Views:Charges

Charge Shipping Name

Receipient name

Field Type:Dimension

Data Views:Charges

Charge Shipping Phone

Recipient phone

Field Type:Dimension

Data Views:Charges

Charge Statement Descriptor

For card charges, Charge Statement Descriptor Suffix instead. Otherwise, you can use this value as the complete description of a charge on your customers’ statements

Field Type:Dimension

Data Views:Charges

Charge Statement Descriptor Suffix

Provides information about the charge that customers see on their statements. Concatenated with the prefix (shortened descriptor) or statement descriptor that’s set on the account to form the complete statement descriptor

Field Type:Dimension

Data Views:Charges

Charge Status

The status of the payment is either succeeded, pending, or failed

Field Type:Dimension

Data Views:Charges

Charge Subscription ID

ID of the subscription associated with the charge

Field Type:Dimension

Data Views:Charges

Charge Subscription Product Name

The subscription product’s name

Field Type:Dimension

Data Views:Charges

Customer Address City

City, district, suburb, town, or village

Field Type:Dimension

Data Views:Customers

Customer Address Country

Two-letter country code (ISO 3166-1 alpha-2)

Field Type:Dimension

Data Views:Customers

Customer Address Line 1

Address line 1 (e.g., street, PO Box, or company name)

Field Type:Dimension

Data Views:Customers

Customer Address Line 2

Address line 2 (e.g., apartment, suite, unit, or building)

Field Type:Dimension

Data Views:Customers

Customer Address Postal Code

ZIP or postal code

Field Type:Dimension

Data Views:Customers

Customer Address State

State, county, province, or region

Field Type:Dimension

Data Views:Customers

Customer Balance

Current balance, if any, being stored on the customer

Field Type:Metric

Data Views:Customers

Customer Created

Time at which the customer was created

Field Type:Dimension

Data Views:Customers

Customer Currency

Three-letter ISO code for the currency the customer can be charged in for recurring billing purposes

Field Type:Dimension

Data Views:Customers

Customer Default Source

ID of the default payment source for the customer

Field Type:Dimension

Data Views:Customers

Customer Delinquent

If recurring invoice’s latest charge failed or if an invoice isn’t paid by its due date

Field Type:Dimension

Data Views:Customers

Customer Description

Description of the customer

Field Type:Dimension

Data Views:Customers

Customer Email

The customer’s email address

Field Type:Dimension

Data Views:Customers

Customer ID

Unique identifier for the customer object

Field Type:Dimension

Data Views:Customers

Customer Invoice Prefix

The prefix for the customer used to generate unique invoice numbers

Field Type:Dimension

Data Views:Customers

Customer Name

The customer’s full name or business name

Field Type:Dimension

Data Views:Customers

Customer Object

String representing the object’s type. Objects of the same type share the same value

Field Type:Dimension

Data Views:Customers

Customer Phone

The customer’s phone number

Field Type:Dimension

Data Views:Customers

Customer Shipping Address City

City, district, suburb, town, or village for shipping address

Field Type:Dimension

Data Views:Customers

Customer Shipping Address Country

Two-letter country code (ISO 3166-1 alpha-2) for shipping address

Field Type:Dimension

Data Views:Customers

Customer Shipping Address Line 1

Address line 1 (e.g., street, PO Box, or company name) for shipping address

Field Type:Dimension

Data Views:Customers

Customer Shipping Address Line 2

Address line 2 (e.g., apartment, suite, unit, or building) for shipping address

Field Type:Dimension

Data Views:Customers

Customer Shipping Address Postal Code

ZIP or postal code for shipping address

Field Type:Dimension

Data Views:Customers

Customer Shipping Address State

State, county, province, or region for shipping address

Field Type:Dimension

Data Views:Customers

Customer Shipping Name

Customer name for shipping address

Field Type:Dimension

Data Views:Customers

Customer Shipping Phone

Customer phone for shipping address

Field Type:Dimension

Data Views:Customers

Subscription Amount

Amount charged for the subscription

Field Type:Metric

Data Views:Subscriptions

Subscription Automatic Tax Enabled

Whether Stripe automatically computes tax on this subscription

Field Type:Dimension

Data Views:Subscriptions

Subscription Billing Cycle Anchor

Determines the date of the first full invoice, and, for plans with month or year intervals, the day of the month for subsequent invoices

Field Type:Dimension

Data Views:Subscriptions

Subscription Cancel At

A date in the future at which the subscription will automatically get canceled

Field Type:Dimension

Data Views:Subscriptions

Subscription Cancel At Period End

If the subscription has been canceled with the at_period_end flag set to true, cancel_at_period_end on the subscription will be true. You can use this attribute to determine whether a subscription that has a status of active is scheduled to be canceled at the end of the current period

Field Type:Dimension

Data Views:Subscriptions

Subscription Canceled At

Date at which a subscription was canceled. Will be null if subscription has not been canceled

Field Type:Dimension

Data Views:Subscriptions

Subscription Collection Method

Either charge_automatically, or send_invoice. When charging automatically, Stripe will attempt to pay this subscription at the end of the cycle using the default source attached to the customer. When sending an invoice, Stripe will email your customer an invoice with payment instructions and mark the subscription as active

Field Type:Dimension

Data Views:Subscriptions

Subscription Created

Date at which the subscription was created

Field Type:Dimension

Data Views:Subscriptions

Subscription Currency

The currency charged for the subscription

Field Type:Dimension

Data Views:Subscriptions

Subscription Current Period End

End of the current period that the subscription has been invoiced for. At the end of this period, a new invoice will be created

Field Type:Dimension

Data Views:Subscriptions

Subscription Current Period Start

Start of the current period that the subscription has been invoiced for

Field Type:Dimension

Data Views:Subscriptions

Subscription Customer

ID of the customer who owns the subscription

Field Type:Dimension

Data Views:Subscriptions

Subscription Description

Description of the subscription

Field Type:Dimension

Data Views:Subscriptions

Subscription Ended At

If the subscription has ended, the date the subscription ended

Field Type:Dimension

Data Views:Subscriptions

Subscription ID

The ID of the subscription

Field Type:Dimension

Data Views:Subscriptions

Subscription Interval

The frequency at which a subscription is billed. One of day, week, month or year

Field Type:Dimension

Data Views:Subscriptions

Subscription Object

String representing the object’s type. Objects of the same type share the same value

Field Type:Dimension

Data Views:Subscriptions

Subscription Product Name

The name of the product associated with the subscription

Field Type:Dimension

Data Views:Subscriptions

Subscription Start Date

Date when the subscription was first created. The date might differ from the Subscription Created due to backdating

Field Type:Dimension

Data Views:Subscriptions

Subscription Status

Possible values are incomplete, incomplete_expired, trialing, active, past_due, canceled, or unpaid

Field Type:Dimension

Data Views:Subscriptions

Subscription Trial End

If the subscription has a trial, the end of that trial

Field Type:Dimension

Data Views:Subscriptions

Subscription Trial Start

If the subscription has a trial, the beginning of that trial

Field Type:Dimension

Data Views:Subscriptions

Transaction Available On

The date the transaction’s net funds will become available in the Stripe balance

Field Type:Dimension

Data Views:Transactions

Transaction Created

Time at which the transaction was created

Field Type:Dimension

Data Views:Transactions

Transaction Currency

Three-letter ISO currency code, in lowercase

Field Type:Dimension

Data Views:Transactions

Transaction Description

Transaction description, if available

Field Type:Dimension

Data Views:Transactions

Transaction Exchange Rate

The exchange rate used, if applicable, for this transaction

Field Type:Dimension

Data Views:Transactions

Transaction Fee

Fees paid for this transaction

Field Type:Metric

Data Views:Transactions

Transaction Gross Amount

Gross amount of the transaction

Field Type:Metric

Data Views:Transactions

Transaction ID

Unique identifier for the transaction object

Field Type:Dimension

Data Views:Transactions

Transaction Net Amount

Net amount of the transaction

Field Type:Metric

Data Views:Transactions

Transaction Object

String representing the object’s type. Objects of the same type share the same value

Field Type:Dimension

Data Views:Transactions

Transaction Reporting Category

Category for understanding transactions from an accounting perspective. More details here: https://stripe.com/docs/reports/reporting-categories

Field Type:Dimension

Data Views:Transactions

Transaction Source

The Stripe object to which this transaction is related

Field Type:Dimension

Data Views:Transactions

Transaction Status

If the transaction’s net funds are available in the Stripe balance yet. Either available or pending

Field Type:Dimension

Data Views:Transactions

Transaction Type

Transaction type. Full list of possible values at: https://stripe.com/docs/api/balance_transactions/object

Field Type:Dimension

Data Views:Transactions