Stripe: Most-used fields

Stripe: Most-used fields#

The table below gives information about most-used fields that you can import from Stripe. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name

Adverity UI name

Description

Use in Adverity

Amount

Amount

The total amount of a transaction, typically expressed in the currency’s minor unit (e.g., cents for USD) in API responses, but major units in CSV reports.

metric

Amount Refunded

Amount Refunded

The portion of the original transaction amount that has been refunded.

metric

Captured

Captured

Indicates whether the funds for a charge have been successfully captured.

dimension

Converted Amount

Converted Amount

The amount after currency conversion, if applicable.

metric

Converted Amount Refunded

Converted Amount Refunded

The amount refunded after currency conversion, if applicable.

metric

Converted Currency

Converted Currency

The three-letter ISO currency code of the amount after conversion.

dimension

Created (UTC)

Created (UTC)

The date and time (in UTC) when the object was created.

dimension

Currency

Currency

The three-letter ISO currency code of the transaction.

dimension

Customer Description

Customer Description

A customizable description provided when creating or updating the customer, often used for internal notes.

dimension

Customer Email

Customer Email

The email address of the customer associated with the transaction.

dimension

Customer ID

Customer ID

Unique identifier for the customer.

dimension

Description

Description

A general description associated with the object or transaction.

dimension

Fee

Fee

The amount of the fee incurred for the transaction, typically expressed in the currency’s major unit in reports.

metric

Invoice ID

Invoice ID

Unique identifier for the invoice associated with the transaction.

dimension

Statement Descriptor

Statement Descriptor

Text displayed on the customer’s bank or card statement for the transaction.

dimension

Status

Status

The current state or outcome of an object or process (e.g., ‘succeeded’, ‘pending’, ‘failed’).

dimension

Tax

Tax

The total tax amount applied to a transaction or invoice.

metric

Transfer

Transfer

The unique identifier or amount related to a transfer of funds to a connected account or bank account.

dimension

activity_at

activity_at

Timestamp indicating when a specific activity or event occurred, often used in reports to define a time range.

dimension

activity_end_date

activity_end_date

The exclusive end date (as a Unix timestamp) for the activity data included in a report, typically representing the end of a reporting interval.

dimension

activity_start_date

activity_start_date

The inclusive start date (as a Unix timestamp) for the activity data included in a report, typically representing the beginning of a reporting interval.

dimension

amount

amount

The total amount of a transaction, typically expressed in the currency’s minor unit (e.g., cents for USD) in API responses, but major units in CSV reports.

metric

amount_refunded

amount_refunded

The portion of the original transaction amount that has been refunded.

metric

automatic_payout_effective_at

automatic_payout_effective_at

The date and time (in UTC) when an automatic payout is expected to arrive in the bank account, and when funds are deducted from the Stripe balance.

dimension

automatic_payout_id

automatic_payout_id

Unique identifier for the automatically created payout associated with a balance transaction.

dimension

available_on

available_on

The date when the net funds from a balance transaction become available in the Stripe balance.

dimension

available_on_utc

available_on_utc

The date and time (in UTC) when the net funds from a balance transaction become available in the Stripe balance.

dimension

balance_transaction_created_at_timestamp

balance_transaction_created_at_timestamp

Timestamp (in UTC) when the balance transaction was created and affected the Stripe balance.

dimension

balance_transaction_description

balance_transaction_description

A description of the balance transaction, providing details about its nature or purpose.

dimension

balance_transaction_id

balance_transaction_id

Unique identifier for the balance transaction, representing a movement of funds in the Stripe account.

dimension

balance_transaction_reporting_category

balance_transaction_reporting_category

A top-level categorization of balance transactions designed for financial accounting purposes.

dimension

billing_amount

billing_amount

The amount used for billing purposes, which might differ from the customer-facing amount due to currency conversion or other factors.

metric

billing_currency

billing_currency

The three-letter ISO currency code used for billing purposes.

dimension

blocked_by_default_high_risk_rule_count

blocked_by_default_high_risk_rule_count

The number of transactions blocked by Stripe’s default high-risk fraud prevention rules, often associated with Stripe Radar.

metric

blocked_by_radar_rule_count

blocked_by_radar_rule_count

The total count of transactions blocked by any custom or default rules configured within Stripe Radar for fraud prevention.

metric

blocked_by_stripe_count

blocked_by_stripe_count

The count of transactions blocked by Stripe’s overall fraud detection systems, which includes Radar and other internal mechanisms.

metric

captured

captured

Indicates whether the funds for a charge have been successfully captured.

dimension

card_brand

card_brand

The brand of the card used for the transaction (e.g., Visa, Mastercard, American Express).

dimension

card_country

card_country

The two-letter ISO country code of the card’s issuing bank.

dimension

card_funding

card_funding

The funding type of the card (e.g., credit, debit, prepaid).

dimension

card_input_method

card_input_method

The method by which the card details were provided (e.g., manually typed, swiped, or chip read).

dimension

card_present

card_present

Indicates whether the card was physically present during the transaction (e.g., via a card reader).

dimension

card_type

card_type

The type of payment card used (e.g., credit card, debit card).

dimension

category

category

A general category associated with the transaction or event.

dimension

charge_id

charge_id

Unique identifier for the charge associated with the transaction.

dimension

connected_account

connected_account

For Stripe Connect platforms, the unique identifier of the connected Stripe account involved in the transaction.

dimension

contribution

contribution

metric

converted_amount

converted_amount

The amount after currency conversion, if applicable.

metric

converted_amount_refunded

converted_amount_refunded

The amount refunded after currency conversion, if applicable.

metric

converted_currency

converted_currency

The three-letter ISO currency code of the amount after conversion.

dimension

count

count

A generic count of items or occurrences in a report or summary.

metric

currency

currency

The three-letter ISO currency code of the transaction.

dimension

customer_description

customer_description

A customizable description provided when creating or updating the customer, often used for internal notes.

dimension

customer_email

customer_email

The email address of the customer associated with the transaction.

dimension

customer_facing_amount

customer_facing_amount

The amount shown to the customer, particularly when the transaction currency differs from the merchant’s settlement currency.

metric

customer_facing_currency

customer_facing_currency

The three-letter ISO currency code for the amount displayed to the customer.

dimension

customer_id

customer_id

Unique identifier for the customer.

dimension

date

date

A general date field related to the transaction or event.

dimension

description

description

A general description associated with the object or transaction.

dimension

destination_id

destination_id

For Stripe Connect transfers, the unique identifier of the destination account.

dimension

dispute_id

dispute_id

Unique identifier for a dispute related to a charge.

dimension

event_type

event_type

The type of event that occurred, often related to webhooks (e.g., payment_intent.succeeded).

dimension

fee

fee

The amount of the fee incurred for the transaction, typically expressed in the currency’s major unit in reports.

metric

fee_category

fee_category

A categorization for the type of fee incurred.

dimension

fee_currency

fee_currency

The three-letter ISO currency code for the fee amount.

dimension

fee_id

fee_id

Unique identifier for a specific fee applied to a transaction.

dimension

fx_rate

fx_rate

The foreign exchange rate applied during a currency conversion.

dimension

gross

gross

The gross amount of the transaction before any fees or adjustments are applied.

metric

id

id

A unique identifier for the object.

dimension

incurred_at

incurred_at

Timestamp indicating when a cost or event was incurred.

dimension

invoice_id

invoice_id

Unique identifier for the invoice associated with the transaction.

dimension

issuer_authorized_count

issuer_authorized_count

The number of times a card issuer has authorized a transaction attempt.

metric

issuer_authorized_sum

issuer_authorized_sum

The cumulative sum of amounts for transactions that have been authorized by the card issuer.

metric

net

net

The net amount of the transaction after fees and other adjustments have been applied.

metric

net_amount

net_amount

The net amount of the transaction after fees and other adjustments have been applied.

metric

outcome_reason

outcome_reason

The specific reason for the outcome of a payment attempt or other event (e.g., ‘insufficient_funds’, ‘card_not_supported’).

dimension

outcome_type

outcome_type

The general type of outcome for a payment attempt, review, or other related process.

dimension

payout_description

payout_description

A description associated with the payout, often provided for reconciliation purposes.

dimension

payout_destination_id

payout_destination_id

The unique identifier for the bank account or card to which the payout was sent.

dimension

payout_expected_arrival_date

payout_expected_arrival_date

The date when the payout is expected to arrive in the destination bank account.

dimension

payout_id

payout_id

Unique identifier for the payout.

dimension

payout_reversed_at

payout_reversed_at

Timestamp indicating when a payout was reversed.

dimension

payout_status

payout_status

The current status of the payout (e.g., ‘pending’, ‘paid’, ‘failed’).

dimension

payout_type

payout_type

The type of payout (e.g., ‘bank_account’, ‘card’).

dimension

plan_name

plan_name

The name of the subscription plan to which a customer is subscribed.

dimension

refund_id

refund_id

Unique identifier for a refund.

dimension

reporting_category

reporting_category

A high-level category used to group balance transactions for financial reporting and analysis.

dimension

request_id

request_id

Unique identifier for the API request that created or modified the object, useful for tracing and debugging.

dimension

source

source

The source of funds for a payment or a generic identifier for the origin of an event.

dimension

source_id

source_id

Unique identifier for the source of funds, such as a PaymentMethod or token.

dimension

statement_descriptor

statement_descriptor

Text displayed on the customer’s bank or card statement for the transaction.

dimension

status

status

The current state or outcome of an object or process (e.g., ‘succeeded’, ‘pending’, ‘failed’).

dimension

subtotal_amount

subtotal_amount

The sum of all items on an invoice or order before taxes, discounts, or other charges are applied.

metric

tax

tax

The total tax amount applied to a transaction or invoice.

metric

tax_amount

tax_amount

The total amount of tax charged for a transaction.

metric

tax_rate

tax_rate

The percentage rate of tax applied to a transaction.

metric

total_amount

total_amount

The grand total amount of an invoice or transaction, including all line items, taxes, and fees.

metric

transaction_count

transaction_count

The total number of transactions within a given period or filter.

metric

transaction_sum

transaction_sum

The cumulative sum of amounts for transactions within a given period or filter.

metric

transfer

transfer

The unique identifier or amount related to a transfer of funds to a connected account or bank account.

dimension

type

type

A classification or category of the object or event.

dimension