Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Description |
---|---|---|---|
BALANCE | Balance amount | balance_amount | Gross amount of the transaction, in cents |
Card balance | balance_source_card | ||
Bank account balance | balance_source_bank | Current balance, if any, being stored on the customer's account. If negative, the customer has credit to apply to the next invoice. If positive, the customer has an amount owed that will be added to the next invoice. The balance does not refer to any unpaid invoices; it solely takes into account amounts that have yet to be successfully applied to any invoice. This balance is only taken into account as invoices are finalized. Note that the balance does not include unpaid invoices | |
Bitcoin receiver balance | balance_source_bitcoin | ||
BALANCE TRANSACTION | Transaction amount | transaction_amount | Gross amount of the transaction, in cents |
Transaction net | transaction_net | Net amount of the transaction, in cents | |
Transaction fee | transaction_fee | Fees (in cents) paid for this transaction | |
Transaction refund | transaction_refund | ||
Transaction charge (%) | transaction_charge_percent | ||
Transaction fee (%) | transaction_fee_percent | Fees (in cents) paid for this transaction | |
Transaction refund (%) | transaction_refund_percent | ||
Transaction average amount | transaction_average_amount | ||
Transaction average net | transaction_average_net | ||
Transaction average charge | transaction_average_charge | ||
Transaction average refund | transaction_average_refund | ||
Charge amount | transaction_charge_amount | Amount of the fee, in cents | |
Charge net | transaction_charge_net | Net amount of the transaction, in cents | |
Charge fee | transaction_charge_fee | Fees (in cents) paid for this transaction | |
Charge fee (%) | charge_fee_percent | ||
Charge average amount | charge_average_amount | ||
Charge average net | charge_average_net | ||
Charge average fee | charge_average_fee | ||
Transactions | transactions | ||
Charge transactions | transaction_charges | ||
Fee transactions | transaction_fees | ||
Refund transactions | transaction_refunds | ||
CUSTOMER | Customer balance | customer_account_balance | An integer amount in JPY that represents the account balance for your customer. Account balances only affect invoices. A negative amount represents a credit that decreases the amount due on an invoice; a positive amount increases the amount due on an invoice |
COUPON | Duration in months | coupon_duration_in_months | If duration is repeating, the number of months the coupon applies. Null if coupon duration is forever or once |
Amount off | coupon_amount_off | Amount (in the currency specified) that will be taken off the subtotal of any invoices for this customer | |
Max redeems | coupon_max_redeems | Maximum number of times this coupon can be redeemed, in total, across all customers, before it is no longer valid | |
Times redeemed | coupon_times_redeemed | Number of times this coupon has been applied to a customer | |
APPLICATION FEE | Fee amount | app_fee_amount | Amount earned, in cents |
Fee refunded amount | app_fee_amount_refunded | Amount, in cents | |
CHARGE | Charge amount | charge_amount | A positive integer in the smallest currency unit (e.g., 100 cents to charge $1.00 or 100 to charge ¥100, a zero-decimal currency) representing how much to charge. The minimum amount is $0.50 US or equivalent in charge currency |
Charge refunded amount | charge_amount_refunded | Amount in cents refunded (can be less than the amount attribute on the charge if a partial refund was issued) | |
Charge application fee | charge_app_fee | The application fee (if any) for the charge | |
TRANSFER | Transfer amount | transfer_amount | Amount in cents to be transferred |
Transfer reversed amount | transfer_amount_reversed | Amount in cents reversed (can be less than the amount attribute on the transfer if a partial reversal was issued) | |
INVOICE | Invoice due amount | 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 |
Invoice total | invoice_total | Total after discount | |
Invoice subtotal | invoice_subtotal | Total of all subscriptions, invoice items, and prorations on the invoice before any discount is applied | |
Invoice tax (%) | invoice_tax_percent | This percentage of the subtotal has been added to the total amount of the invoice, including invoice line items and discounts. This field is inherited from the subscription's tax_percent field, but can be changed before the invoice is paid | |
Invoice tax | invoice_tax | The amount of tax included in the total, calculated from tax_percent and the subtotal. If no tax_percent is defined, this value will be null | |
Invoice application fee | invoice_app_fee | The fee in cents that will be applied to the invoice and transferred to the application owner's Stripe account when the invoice is paid | |
Invoice payment attempts | invoice_payment_attempts | 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 | |
Starting customer balance | invoice_amount_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 | |
Ending customer balance | invoice_amount_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 | |
INVOICE ITEM | Invoice item tax | invoice_item_tax | The amount of tax included for the item, calculated from tax_percent and the subtotal |
Invoice item amount | invoice_item_amount | Amount (in the currency specified) of the invoice item | |
ORDER | Order amount | order_amount | A positive integer in the smallest currency unit (that is, 100 cents for $1.00, or 1 for ¥1, Japanese Yen being a zero-decimal currency) representing the total amount for the order |
Order returned amount | order_amount_returned | ||
Order application fee | order_app_fee | ||
SUBSCRIPTION | Subscription quantity | subscription_quantity | The quantity of the plan to which the customer is subscribed. For example, if your plan is $10/user/month, and your customer has 5 users, you could pass 5 as the quantity to have the customer charged $50 (5 x $10) monthly |
Application fee (%) | subscription_appfee_percent | A non-negative decimal between 0 and 100, with at most two decimal places. This represents the percentage of the subscription invoice subtotal that will be transferred to the application owner's Stripe account | |
Subscription tax (%) | subscription_tax_percent | A non-negative decimal (with at most four decimal places) between 0 and 100. This represents the percentage of the subscription invoice subtotal that will be calculated and added as tax to the final amount in each billing period. For example, a plan which charges $10/month with a tax_percent of 20.0 will charge $12 per invoice. To unset a previously-set value, pass an empty string | |
SUBSCRIPTION PLAN | Plan amount | subscription_plan_amount | A positive integer in cents (or 0 for a free plan) representing how much to charge on a recurring basis |
Plan interval count | subscription_plan_intervals | The number of intervals between subscription billings. For example, interval=month and interval_count=3 bills every 3 months | |
Plan trial days | subscription_plan_trial_days | Default number of trial days when subscribing a customer to this plan using trial_from_plan=true | |
PAYOUT | Payout amount | payout_amount | Amount (in cents) to be transferred to your bank account or debit card |
REFUND | Refund amount | refund_amount | Amount, in cents |
DISPUTE | Dispute amount | dispute_amount | Disputed amount. Usually the amount of the disputed_transaction, but can differ (usually because of currency fluctuation or because only part of the order is disputed) |
Evidence submissions | dispute_evidence_submissions | Evidence related to the dispute. This hash will contain exactly one non-null value, containing an evidence object that matches its reason |