Introduction

Datasources and destinations

Fields listing for Stripe

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

0 metrics197 dimensions

197 fields

All fields
FieldDetails
Account Id
Id of an account.
Field IDaccount/id
DimensionTEXT
Account name
Name of the account
Field IDaccount/name
DimensionTEXT
Balance Amount
Balance amount.
Field IDbalance/amount
DimensionNUMBER
Balance Bank Account Amount
Amount for bank account.
Field IDbalance/bank_account
DimensionNUMBER
Balance Card Amount
Amount for card.
Field IDbalance/card
DimensionNUMBER
Balance Currency
Balance currency. Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDbalance/currency
DimensionTEXT
Balance FPX Amount
Amount for FPX.
Field IDbalance/fpx
DimensionNUMBER
Balance Transaction Amount
Gross amount of this transaction (in cents). A positive value represents funds charged to another party, and a negative value represents funds sent to another party.
Field IDbalance_transaction/amount
DimensionNUMBER
Balance Transaction Available On
The date that the transaction’s net funds become available in the Stripe balance.
Field IDbalance_transaction/available_on
DimensionYEAR_MONTH_DAY
Balance Transaction Created On
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDbalance_transaction/created
DimensionYEAR_MONTH_DAY
Balance Transaction Currency
Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDbalance_transaction/currency
DimensionTEXT
Balance Transaction Exchange Rate
If applicable, this transaction uses an exchange rate. If money converts from currency A to currency B, then the amount in currency A, multipled by the exchange_rate, equals the amount in currency B. For example, if you charge a customer 10.00 EUR, the PaymentIntent’s amount is 1000 and currency is eur. If this converts to 12.34 USD in your Stripe account, the BalanceTransaction’s amount is 1234, its currency is usd, and the exchange_rate is 1.234.
Field IDbalance_transaction/exchange_rate
DimensionNUMBER
Balance Transaction Fee
Fees paid for this transaction. Represented as a positive integer when assessed.
Field IDbalance_transaction/fee
DimensionNUMBER
Balance Transaction ID
Unique identifier for the object.
Field IDbalance_transaction/id
DimensionTEXT
Balance Transaction Net
Net impact to a Stripe balance (in cents). A positive value represents incrementing a Stripe balance, and a negative value decrementing a Stripe balance. You can calculate the net impact of a transaction on a balance by amount - fee
Field IDbalance_transaction/net
DimensionNUMBER
Balance Transaction Reporting Category
Learn more about how reporting categories can help you understand balance transactions from an accounting perspective.
Field IDbalance_transaction/reporting_category
DimensionTEXT
Balance Transaction Status
The transaction’s net funds status in the Stripe balance, which are either available or pending.
Field IDbalance_transaction/status
DimensionTEXT
Balance Transaction Type
The transaction type.
Field IDbalance_transaction/type
DimensionTEXT
Balance Type
Should be available or pending
Field IDbalance/type
DimensionTEXT
Charge Amount
Amount intended to be collected by this payment. A positive integer representing how much to charge in the smallest currency unit (e.g., 100 cents to charge $1.00 or 100 to charge ¥100, a zero-decimal currency). The minimum amount is $0.50 US or equivalent in charge currency. The amount value supports up to eight digits (e.g., a value of 99999999 for a USD charge of $999,999.99).
Field IDcharge/amount
DimensionNUMBER
Charge Amount Captured
Amount in cents captured (can be less than the amount attribute on the charge if a partial capture was made).
Field IDcharge/amount_captured
DimensionNUMBER
Charge Amount Refunded
Amount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued).
Field IDcharge/amount_refunded
DimensionNUMBER
Charge Billing Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcharge/billing_address_line1
DimensionTEXT
Charge Billing Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcharge/billing_address_line2
DimensionTEXT
Charge Billing City
The charge's billing city.
Field IDcharge/billing_address_city
DimensionTEXT
Charge Billing Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcharge/billing_address_country
DimensionCOUNTRY_CODE
Charge Billing Email
The charge's billing phone.
Field IDcharge/billing_email
DimensionTEXT
Charge Billing Name
The charge’s billing name.
Field IDcharge/billing_name
DimensionTEXT
Charge Billing Phone
The charge's billing phone.
Field IDcharge/billing_phone
DimensionTEXT
Charge Billing Postal Code
ZIP or postal code.
Field IDcharge/billing_address_postal_code
DimensionTEXT
Charge Billing State
State, county, province, or region.
Field IDcharge/billing_address_state
DimensionTEXT
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. Allows you to see what the statement descriptor looks like after the static and dynamic portions are combined.
Field IDcharge/calculated_statement_descriptor
DimensionTEXT
Charge Created On
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDcharge/created
DimensionYEAR_MONTH_DAY
Charge Currency
The charge's currency
Field IDcharge/currency
DimensionTEXT
Charge Failure Code
Error code explaining reason for charge failure if available (see the errors section for a list of codes).
Field IDcharge/failure_code
DimensionTEXT
Charge Failure Message
Message to user further explaining reason for charge failure if available.
Field IDcharge/failure_message
DimensionTEXT
Charge ID
Unique identifier for the object.
Field IDcharge/id
DimensionTEXT
Charge Id of the payment method
ID of the payment method used in this charge.
Field IDcharge/payment_method
DimensionTEXT
Charge Is captured
If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured.
Field IDcharge/captured
DimensionBOOLEAN
Charge Is Disputed
The charge's disputed state
Field IDcharge/disputed
DimensionBOOLEAN
Charge Is Paid
true if the charge succeeded, or was successfully authorized for later capture.
Field IDcharge/paid
DimensionBOOLEAN
Charge Is Refunded
The charge's refunded state
Field IDcharge/refunded
DimensionBOOLEAN
Charge Receipt Email
The charge's receipt email
Field IDcharge/receipt_email
DimensionTEXT
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 IDcharge/receipt_number
DimensionTEXT
Charge Receipt URL
his 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. If the charge is for an Invoice, the receipt will be stylized as an Invoice receipt.
Field IDcharge/receipt_url
DimensionTEXT
Charge Shipping Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcharge/shipping_address_line1
DimensionTEXT
Charge Shipping Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcharge/shipping_address_line2
DimensionTEXT
Charge Shipping Carrier
The charge's shipping carrier.
Field IDcharge/shipping_carrier
DimensionTEXT
Charge Shipping City
The charge's shipping city.
Field IDcharge/shipping_address_city
DimensionTEXT
Charge Shipping Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcharge/shipping_address_country
DimensionCOUNTRY_CODE
Charge Shipping Name
The charge's shipping name.
Field IDcharge/shipping_name
DimensionTEXT
Charge Shipping Phone
The charge's shipping phone.
Field IDcharge/shipping_phone
DimensionTEXT
Charge Shipping Postal Code
ZIP or postal code.
Field IDcharge/shipping_address_postal_code
DimensionTEXT
Charge Shipping State
State, county, province, or region.
Field IDcharge/shipping_address_state
DimensionTEXT
Charge Shipping Tracking Number
The charge's shipping tracking number.
Field IDcharge/shipping_tracking_number
DimensionTEXT
Charge Statement Descriptor
For card charges, use statement_descriptor_suffix instead. Otherwise, you can use this value as the complete description of a charge on your customers’ statements. Must contain at least one letter, maximum 22 characters.
Field IDcharge/statement_descriptor
DimensionTEXT
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. Maximum 22 characters for the concatenated descriptor.
Field IDcharge/statement_descriptor_suffix
DimensionTEXT
Charge Status
The status of the payment is either succeeded, pending, or failed.
Field IDcharge/status
DimensionTEXT
Customer Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcustomer/line1
DimensionTEXT
Customer Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcustomer/line2
DimensionTEXT
Customer Automatic Tax Status
Surfaces if automatic tax computation is possible given the current customer location information.
Field IDcustomer/tax_supported
DimensionTEXT
Customer Balance
The current balance, if any, that’s stored on the customer. If negative, the customer has credit to apply to their next invoice. If positive, the customer has an amount owed that’s added to their next invoice.
Field IDcustomer/balance
DimensionNUMBER
Customer City
City, district, suburb, town, or village.
Field IDcustomer/city
DimensionTEXT
Customer Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcustomer/country
DimensionCOUNTRY_CODE
Customer Created On
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDcustomer/created
DimensionYEAR_MONTH_DAY
Customer currency
Name of the customer
Field IDcustomer/currency
DimensionTEXT
Customer Delinquent
Tracks the most recent state change on any invoice belonging to the customer.
Field IDcustomer/delinquent
DimensionBOOLEAN
Customer Discount
Describes the current discount active on the customer, if there is one.
Field IDcustomer/discount
DimensionTEXT
Customer email
Email of the customer
Field IDcustomer/email
DimensionTEXT
Customer ID
Id of a customer.
Field IDcustomer/id
DimensionTEXT
Customer Invoice Prefix
Describes the current discount active on the customer, if there is one.
Field IDcustomer/invoice_prefix
DimensionTEXT
Customer IP Tax Address
A recent IP address of the customer used for tax reporting and tax location inference.
Field IDcustomer/tax_ip_address
DimensionTEXT
Customer Name
The customer’s full name or business name.
Field IDcustomer/name
DimensionTEXT
Customer Next Invoice Sequence
The suffix of the customer’s next invoice number (for example, 0001).
Field IDcustomer/next_invoice_sequence
DimensionTEXT
Customer Phone
The customer’s phone number.
Field IDcustomer/phone
DimensionTEXT
Customer Postal Code
ZIP or postal code.
Field IDcustomer/postal_code
DimensionTEXT
Customer Shipping Address Line 1
Address line 1 (e.g., street, PO Box, or company name).
Field IDcustomer/shipping_address_line1
DimensionTEXT
Customer Shipping Address Line 2
Address line 2 (e.g., apartment, suite, unit, or building).
Field IDcustomer/shipping_address_line2
DimensionTEXT
Customer Shipping City
The customer’s shipping city.
Field IDcustomer/shipping_address_city
DimensionTEXT
Customer Shipping Country
Two-letter country code (ISO 3166-1 alpha-2).
Field IDcustomer/shipping_address_country
DimensionCOUNTRY_CODE
Customer Shipping Name
The customer’s shipping name.
Field IDcustomer/shipping_name
DimensionTEXT
Customer Shipping Phone
The customer’s shipping phone.
Field IDcustomer/shipping_phone
DimensionTEXT
Customer Shipping Postal Code
ZIP or postal code.
Field IDcustomer/shipping_address_postal_code
DimensionTEXT
Customer Shipping State
State, county, province, or region.
Field IDcustomer/shipping_address_state
DimensionTEXT
Customer State
State, county, province, or region.
Field IDcustomer/state
DimensionTEXT
Customer Tax Exempt
Describes the customer’s tax exemption status, which is none, exempt, or reverse. When set to reverse, invoice and receipt PDFs include the following text: “Reverse charge”.
Field IDcustomer/tax_exempt
DimensionTEXT
Customer Tax Location Country
The customer’s country as identified by Stripe Tax.
Field IDcustomer/tax_location_country
DimensionTEXT
Customer Tax Location Source
The data source used to infer the customer’s location.
Field IDcustomer/tax_location_source
DimensionTEXT
Customer Tax Location State
The customer’s state, county, province, or region as identified by Stripe Tax.
Field IDcustomer/tax_location_state
DimensionTEXT
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Default Price Amount
The ID of the Price object that is the default price for this product.
Field IDproduct/default_price
DimensionTEXT
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Invoice Amount Due
Final amount due at this time for this invoice. If the invoice’s total is smaller than the minimum charge amount, for example, or if there is account credit that can be applied to the invoice, the amount_due may be 0. If there is a positive starting_balance for the invoice (the customer owes money), the amount_due will also take that into account. The charge that gets generated for the invoice will be for the amount specified in amount_due.
Field IDinvoice/amount_due
DimensionNUMBER
Invoice Amount Paied
The amount, in cents, that was paid.
Field IDinvoice/amount_paid
DimensionNUMBER
Invoice Amount Remaining
The difference between amount_due and amount_paid, in cents.
Field IDinvoice/amount_remaining
DimensionNUMBER
Invoice Amount Shipping
This is the sum of all the shipping amounts.
Field IDinvoice/amount_shipping
DimensionNUMBER
Invoice Attempt Count
Number of payment attempts made for this invoice, from the perspective of the payment retry schedule. Any payment attempt counts as the first attempt, and subsequently only automatic retries increment the attempt count. In other words, manual payment attempts after the first attempt do not affect the retry schedule.
Field IDinvoice/attempt_count
DimensionNUMBER
Invoice Attempted
Whether an attempt has been made to pay the invoice. An invoice is not attempted until 1 hour after the invoice.created webhook, for example, so you might not want to display that invoice as unpaid to your users.
Field IDinvoice/attempted
DimensionBOOLEAN
Invoice Auto Advance
The Invoice auto advance state
Field IDinvoice/auto_advance
DimensionBOOLEAN
Invoice Billing Reason
Indicates the reason why the invoice was created.
Field IDinvoice/billing_reason
DimensionTEXT
Invoice Collection Method
Either charge_automatically, or send_invoice. When charging automatically, Stripe will attempt to pay this invoice using the default source attached to the customer. When sending an invoice, Stripe will email this invoice to the customer with payment instructions.
Field IDinvoice/collection_method
DimensionTEXT
Invoice Created At
Date fo the creation of the invoice.
Field IDinvoice/created
DimensionYEAR_MONTH_DAY
Invoice Currency
Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDinvoice/currency
DimensionTEXT
Invoice Due date
The date on which payment for this invoice is due. This value will be null for invoices where collection_method=charge_automatically.
Field IDinvoice/due_date
DimensionYEAR_MONTH_DAY
Invoice Effective At
The date when this invoice is in effect. Same as finalized_at unless overwritten. When defined, this value replaces the system-generated ‘Date of issue’ printed on the invoice PDF and receipt.
Field IDinvoice/effective_at
DimensionYEAR_MONTH_DAY
Invoice Ending Balance
Ending customer balance after the invoice is finalized. Invoices are finalized approximately an hour after successful webhook delivery or when payment collection is attempted for the invoice. If the invoice has not been finalized yet, this will be null.
Field IDinvoice/ending_balance
DimensionNUMBER
Invoice Hosted URL
The invoice url
Field IDinvoice/hosted_invoice_url
DimensionTEXT
Invoice ID
The Invoice ID
Field IDinvoice/id
DimensionTEXT
Invoice Is Paid
Whether payment was successfully collected for this invoice. An invoice can be paid (most commonly) with a charge or with credit from the customer’s account balance.
Field IDinvoice/paid
DimensionBOOLEAN
Invoice Is Paid Out Of Band
Returns true if the invoice was manually marked paid, returns false if the invoice hasn’t been paid yet or was paid on Stripe.
Field IDinvoice/paid_out_of_band
DimensionBOOLEAN
Invoice Item Amount
The Invoice Item Amount
Field IDinvoice_item/amount
DimensionNUMBER
Invoice Item Created At
The Invoice Item Created At
Field IDinvoice_item/date
DimensionYEAR_MONTH_DAY
Invoice Item Currency
The Invoice Item Currency
Field IDinvoice_item/currency
DimensionTEXT
Invoice Item ID
The Invoice Item Id
Field IDinvoice_item/id
DimensionTEXT
Invoice Item IS Discountable
The Invoice Item Is Discountable
Field IDinvoice_item/discountable
DimensionBOOLEAN
Invoice Item Period End
The Invoice Item Period End
Field IDinvoice_item/period_end
DimensionYEAR_MONTH_DAY
Invoice Item Period Start
The Invoice Item Period Start
Field IDinvoice_item/period_start
DimensionYEAR_MONTH_DAY
Invoice Item Proration
The Invoice Item Proration
Field IDinvoice_item/proration
DimensionBOOLEAN
Invoice Item Quantity
Quantity of units for the invoice item. If the invoice item is a proration, the quantity of the subscription that the proration was computed for.
Field IDinvoice_item/quantity
DimensionNUMBER
Invoice Item Subscription item
The subscription item that this invoice item has been created for, if any.
Field IDinvoice_item/subscription_item
DimensionTEXT
Invoice Item Unit Amount
Unit amount (in the currency specified) of the invoice item.
Field IDinvoice_item/unit_amount
DimensionNUMBER
Invoice Next Payment Attempt
The time at which payment will next be attempted. This value will be null for invoices where collection_method=send_invoice.
Field IDinvoice/next_payment_attempt
DimensionYEAR_MONTH_DAY
Invoice Number
A unique, identifying string that appears on emails sent to the customer for this invoice. This starts with the customer’s unique invoice_prefix if it is specified.
Field IDinvoice/number
DimensionTEXT
Invoice PDF
The link to download the PDF for the invoice. If the invoice has not been finalized yet, this will be null.
Field IDinvoice/invoice_pdf
DimensionTEXT
Invoice Period End
End of the usage period during which invoice items were added to this invoice.
Field IDinvoice/period_end
DimensionYEAR_MONTH_DAY
Invoice Period Start
Start of the usage period during which invoice items were added to this invoice.
Field IDinvoice/period_start
DimensionYEAR_MONTH_DAY
Invoice Post Payment Credit Note Amount
Total amount of all post-payment credit notes issued for this invoice.
Field IDinvoice/post_payment_credit_notes_amount
DimensionNUMBER
Invoice Pre Payment Credit Note Amount
Total amount of all pre-payment credit notes issued for this invoice.
Field IDinvoice/pre_payment_credit_notes_amount
DimensionNUMBER
Invoice Receipt Number
This is the transaction number that appears on email receipts sent for this invoice.
Field IDinvoice/receipt_number
DimensionTEXT
Invoice Starting Balance
Starting customer balance before the invoice is finalized. If the invoice has not been finalized yet, this will be the current customer balance. For revision invoices, this also includes any customer balance that was applied to the original invoice.
Field IDinvoice/starting_balance
DimensionNUMBER
Invoice Statement Descriptor
Extra information about an invoice for the customer’s credit card statement.
Field IDinvoice/statement_descriptor
DimensionTEXT
Invoice Status
The status of the invoice, one of draft, open, paid, uncollectible, or void. Learn more
Field IDinvoice/status
DimensionTEXT
Invoice Subscription Proration Date
Only set for upcoming invoices that preview prorations. The time used to calculate prorations.
Field IDinvoice/subscription_proration_date
DimensionNUMBER
Invoice Subtotal
Total of all subscriptions, invoice items, and prorations on the invoice before any invoice level discount or exclusive tax is applied. Item discounts are already incorporated.
Field IDinvoice/subtotal
DimensionNUMBER
Invoice Subtotal Excluding Tax
The integer amount in cents representing the subtotal of the invoice before any invoice level discount or tax is applied. Item discounts are already incorporated
Field IDinvoice/subtotal_excluding_tax
DimensionNUMBER
Invoice Tax
The amount of tax on this invoice. This is the sum of all the tax amounts on this invoice.
Field IDinvoice/tax
DimensionNUMBER
Invoice Total
Total after discounts and taxes.
Field IDinvoice/total
DimensionNUMBER
Invoice Total Excluding Tax
The integer amount in cents representing the total amount of the invoice including all discounts but excluding all tax.
Field IDinvoice/total_excluding_tax
DimensionNUMBER
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Price Billing Scheme
Describes how to compute the price per period.
Field IDprice/billing_scheme
DimensionTEXT
Price Created At
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDprice/created
DimensionNUMBER
Price Currency
Three-letter ISO currency code, in lowercase.
Field IDprice/currency
DimensionTEXT
Price Custom Unit Amount
Custom unit amount if set.
Field IDprice/custom_unit_amount
DimensionTEXT
Price Descritpion
A brief description or name for the price.
Field IDprice/nickname
DimensionTEXT
Price ID
Unique identifier for the price object.
Field IDprice/id
DimensionTEXT
Price Interval
Billing frequency (e.g., month, year) for recurring prices.
Field IDprice/recurring_interval
DimensionTEXT
Price Interval Count
Number of intervals between each billing period.
Field IDprice/recurring_interval_count
DimensionNUMBER
Price Is Active
Whether the price can be used for new purchases.
Field IDprice/active
DimensionBOOLEAN
Price Live Mode
Has the value true if the object exists in live mode or false if in test mode.
Field IDprice/livemode
DimensionBOOLEAN
Price Metadata (flattened)
Set of key-value pairs for structured data. Flattened from associative array.
Field IDprice/metadata
DimensionTEXT
Price Tax Behavior
Specifies whether the price is inclusive, exclusive, or unspecified of taxes.
Field IDprice/tax_behavior
DimensionTEXT
Price Tiers Mode
Defines if tiered pricing is used and how.
Field IDprice/tiers_mode
DimensionTEXT
Price Transform Quantity
Transform that is applied to the quantity before computing the amount due.
Field IDprice/transform_quantity
DimensionTEXT
Price Trial Period (Days)
Number of trial period days granted when subscribing.
Field IDprice/recurring_trial_period_days
DimensionNUMBER
Price Type
One of 'one_time' or 'recurring'.
Field IDprice/type
DimensionTEXT
Price Unit Amount
The unit amount in cents to be charged, represented as a whole integer.
Field IDprice/unit_amount
DimensionNUMBER
Price Unit Amount (Decimal)
The unit amount, represented as a decimal string with at most 12 decimal places.
Field IDprice/unit_amount_decimal
DimensionTEXT
Price Usage Type
Configures how the quantity per period is determined.
Field IDprice/recurring_usage_type
DimensionTEXT
Produce Tax Code ID
A tax code ID that identifies the product category for tax calculation purposes.
Field IDproduct/tax_code
DimensionTEXT
Product Active
Whether the product is currently available for purchase.
Field IDproduct/active
DimensionBOOLEAN
Product Description
The product’s description, meant to be displayable to the customer. Use this field to optionally store a long form explanation of the product being sold for your own rendering purposes.
Field IDproduct/description
DimensionTEXT
Product ID
Unique identifier for the object.
Field IDproduct/id
DimensionTEXT
Product Metadata (flattened)
Set of key-value pairs that you can attach to an object. This can be useful for storing additional information about the object in a structured format. Flattened from associative array.
Field IDproduct/metadata
DimensionTEXT
Product Name
The product’s name, meant to be displayable to the customer.
Field IDproduct/name
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
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. The timestamp is in UTC format.
Field IDsubscription/billing_cycle_anchor
DimensionYEAR_MONTH_DAY
Subscription Cancel At
A date in the future at which the subscription will automatically get canceled.
Field IDsubscription/cancel_at
DimensionYEAR_MONTH_DAY
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 IDsubscription/cancel_at_period_end
DimensionBOOLEAN
Subscription Canceled At
If the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel_at_period_end, canceled_at will reflect the time of the most recent update request, not the end of the subscription period when the subscription is automatically moved to a canceled state.
Field IDsubscription/canceled_at
DimensionYEAR_MONTH_DAY
Subscription Cancellation Details Comment
Additional comments about why the user canceled the subscription, if the subscription was canceled explicitly by the user.
Field IDsubscription/cancellation_details_comment
DimensionTEXT
Subscription Cancellation Details Feedback
The customer submitted reason for why they canceled, if the subscription was canceled explicitly by the user.
Field IDsubscription/cancellation_details_feedback
DimensionTEXT
Subscription Cancellation Details Reason
Why this subscription was canceled.
Field IDsubscription/cancellation_details_reason
DimensionTEXT
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 IDsubscription/collection_method
DimensionTEXT
Subscription Created At
Time at which the object was created. Measured in seconds since the Unix epoch.
Field IDsubscription/created
DimensionYEAR_MONTH_DAY
Subscription Currency
Three-letter ISO currency code, in lowercase. Must be a supported currency.
Field IDsubscription/currency
DimensionTEXT
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 IDsubscription/current_period_end
DimensionYEAR_MONTH_DAY
Subscription Current Period Start
Start of the current period that the subscription has been invoiced for.
Field IDsubscription/current_period_start
DimensionYEAR_MONTH_DAY
Subscription Days Until Due
Number of days a customer has to pay invoices generated by this subscription. This value will be null for subscriptions where collection_method=charge_automatically.
Field IDsubscription/days_until_due
DimensionNUMBER
Subscription Ended At
If the subscription has ended, the date the subscription ended.
Field IDsubscription/ended_at
DimensionYEAR_MONTH_DAY
Subscription ID
The Subscription Id
Field IDsubscription/id
DimensionTEXT
Subscription Next Pending Invoice item Invoice
Specifies the approximate timestamp on which any pending invoice items will be billed according to the schedule provided at pending_invoice_item_interval.
Field IDsubscription/next_pending_invoice_item_invoice
DimensionYEAR_MONTH_DAY
Subscription Pause Collection Behavior
The payment collection behavior for this subscription while paused. One of keep_as_draft, mark_uncollectible, or void.
Field IDsubscription/pause_collection_behavior
DimensionTEXT
Subscription Pause Collection Resume At
The time after which the subscription will resume collecting payments.
Field IDsubscription/pause_collection_resumes_at
DimensionYEAR_MONTH_DAY
Subscription Start Date
Date when the subscription was first created. The date might differ from the created date due to backdating.
Field IDsubscription/start_date
DimensionYEAR_MONTH_DAY
Subscription Status
Possible values are incomplete, incomplete_expired, trialing, active, past_due, canceled, or unpaid.
Field IDsubscription/status
DimensionTEXT
Subscription Trial End
If the subscription has a trial, the end of that trial.
Field IDsubscription/trial_end
DimensionYEAR_MONTH_DAY
Subscription Trial Start
If the subscription has a trial, the beginning of that trial.
Field IDsubscription/trial_start
DimensionYEAR_MONTH_DAY
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data

AI

Claude

Ask Claude about your Marketing data.
AI

ChatGPT

Ask ChatGPT about your Marketing data.
Spreadsheet

Excel

Easily track, report, and analyze your marketing KPIs in Excel.‍
Data lake

Azure Blob Storage

Quickly export your marketing data to Azure Blob Storage for secure storage and analysis, streamlining workflows and enhancing insights.
Data lake

Google Cloud Storage

Effortlessly export marketing data to Google Cloud Storage for secure, scalable storage and streamlined insights.
Data lake

Amazon S3

Unlock effortless data storage and management for your marketing team with seamless transfers to Amazon S3, simplifying workflows and accelerating insights.
Data warehousing

Snowflake

Effortlessly integrates your data in Snowflake, providing a seamless solution for storage, analysis, and real-time insights.
Data warehousing

Amazon Redshift

Access advanced analytics and insights by effortlessly connecting your marketing data to Amazon Redshift.
Data warehousing

Azure SQL

Effortlessly connect your marketing data to Azure SQL for immediate access to valuable insights.
Data warehousing

PostgreSQL

Effortlessly send data from multiple Marketing platforms to your PostgreSQL database with Catchr for seamless integration, storage, and management.
Data warehousing

MySQL

Seamlessly integrate your marketing data with MySQL to access valuable analytics and insights.
Visualization

Tableau

Empower your marketing teams with seamless data transfer to Tableau.
Visualization

Power BI

Whether it's social media analytics, email marketing results, or PPC campaign data, Catchr bridges the gap. Export your data to Power BI.
Data warehousing

Big Query

Unlock advanced analytics and insights by easily connecting your marketing data to BigQuery.
Visualization

Data Studio (formerly Looker Studio)

Catchr makes it super easy to visualize your marketing data into Data Studio (formerly Looker Studio).
Spreadsheet

Google Sheets

Effortlessly report, monitor, and analyze your marketing KPIs in Google Sheets.