Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Description |
---|---|---|---|
TIME | Year | year | Year, e.g. 2017 |
Quarter | quarter | ||
Year & month | yearmonth | Year and month, e.g. 2017|06 | |
Year & week (Sun-Sat) | yearweek | Year and week for US weeks, e.g. 2017|08 | |
Year & week (Mon-Sun) | yearweekiso | Year and week for ISO weeks, e.g. 2017|08 | |
Year of week (Sun-Sat) | yearofweek | Year of week for US weeks, e.g. 2017 | |
Year of week (Mon-Sun) | yearofweekiso | Year of week for ISO weeks, e.g. 2017 | |
Month | month | Month, e.g. 6 | |
Week (Sun-Sat) | week | US week number, e.g. 51 | |
Week (Mon-Sun) | weekiso | ISO week number, e.g. 51 | |
Day of week | dayofweek | ||
Day of week (Sun-Sat) | dayofweekname | Day of week name for US weeks, e.g. 0 Sunday | |
Day of week (Mon-Sun) | dayofweeknameiso | Day of week name for ISO weeks, e.g. 1 Sunday | |
Date | date | Date, e.g. 2017-01-31 | |
Day of month | dayofmonth | Day of month, e.g. 2 | |
Hour | hour | ||
Minute | minute | ||
ACCOUNT | Account ID | account_id | |
Account name | account_name | ||
CUSTOMER | Customer ID | customer_id | Unique identifier for the object |
Customer currency | customer_currency | Three-letter ISO code for the currency the customer can be charged in for recurring billing purposes | |
Customer email | customer_email | The customer's email address | |
Customer VAT ID | customer_vat_id | Unique identifier for the object | |
Customer is delinquent | customer_delinquent | When the customer's latest invoice is billed by charging automatically, delinquent is true if the invoice's latest charge is failed. When the customer's latest invoice is billed by sending an invoice, delinquent is true if the invoice is not paid by its due date | |
SOURCE | Source ID | source_id | Unique identifier for the object |
Source type | source_type | The type of the source. The type is a payment method | |
Source address line 1 | source_address_line_1 | Address line 1 (Street address/PO Box/Company name) | |
Source address line 2 | source_address_line_2 | Address line 2 (Apartment/Suite/Unit/Building) | |
Source address city | source_address_city | City/District/Suburb/Town/Village | |
Source address state | source_address_state | State/County/Province/Region | |
Source address country | source_address_country | Billing address country, if provided when creating card | |
Source address zip code | source_address_zip | ZIP or postal code | |
Source address zip code check | source_address_zip_check | If address_zip was provided, results of the check: pass, fail, unavailable, or unchecked | |
Source metadata | source_metadata | 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 | |
SOURCE CARD | Card brand | source_card_brand | Card brand. Can be American Express, Diners Club, Discover, JCB, MasterCard, UnionPay, Visa, or Unknown |
Card funding type | source_card_funding | Card funding type. Can be credit, debit, prepaid, or unknown | |
Card country code | source_card_country | Two-letter ISO code representing the country of the card. You could use this attribute to get a sense of the international breakdown of cards you've collected | |
Card holder name | source_card_name | Cardholder name | |
Card expiration month | source_card_exp_month | Two digit number representing the card's expiration month | |
Card expiration year | source_card_exp_year | Four digit number representing the card's expiration year | |
Card fingerprint | source_card_fingerprint | Uniquely identifies this particular card number. You can use this attribute to check whether two customers who've signed up with you are using the same card number, for example | |
Card tokenization method | source_card_tokenization | If the card number is tokenized, this is the method that was used. Can be apple_pay or google_pay | |
Card CVC check | source_card_cvc_check | If a CVC was provided, results of the check: pass, fail, unavailable, or unchecked | |
Card last 4 digits | source_card_last4 | The last four digits of the card | |
Card last 4 digits (dynamic) | source_card_last4_dynamic | (For tokenized numbers only.) The last four digits of the device account number | |
SHIPPING ADDRESS | Shipping carrier | shipping_carrier | The delivery service that shipped a physical product, such as Fedex, UPS, USPS, etc. If multiple carriers were used for this purchase, please separate them with commas |
Shipping tracking number | shipping_tracking_number | The tracking number for a physical product, obtained from the delivery service. If multiple tracking numbers were generated for this purchase, please separate them with commas | |
Shipping recipient name | shipping_recipient_name | The name of the customer | |
Shipping recipient phone | shipping_recipient_phone | The recipient's phone number | |
Shipping address line 1 | shipping_line_1 | Address line 1 (Street address/PO Box/Company name) | |
Shipping address line 2 | shipping_line_2 | Address line 2 (Apartment/Suite/Unit/Building) | |
Shipping zip code | shipping_address_zip | ZIP or postal code | |
Shipping city | shipping_address_city | City/District/Suburb/Town/Village | |
Shipping state | shipping_state | State/County/Province/Region | |
Shipping country | shipping_address_country | Billing address country, if provided when creating card | |
COUPON | Coupon ID | coupon_id | Unique identifier for the object |
Coupon duration | coupon_duration | One of forever, once, and repeating. Describes how long a customer who applies this coupon will get the discount | |
Coupon percent off | coupon_percent_off | Percent that will be taken off the subtotal of any invoices for this customer for the duration of the coupon. For example, a coupon with percent_off of 50 will make a $100 invoice $50 instead | |
Coupon redeem by date | coupon_redeem_by | Date after which the coupon can no longer be redeemed | |
Coupon is valid | coupon_valid | Taking account of the above properties, whether this coupon can still be applied to a customer | |
Coupon metadata | coupon_metadata | A set of key-value pairs that you can attach to a coupon object. It can be useful for storing additional information about the coupon in a structured format | |
APPLICATION | Application ID | app_id | Unique identifier for the object |
APPLICATION FEE | Application fee ID | app_fee_id | Unique identifier for the object |
Fee currency | app_fee_currency | Three-letter ISO currency code, in lowercase | |
Fee is refunded | app_fee_refunded | Whether the fee has been fully refunded. If the fee is only partially refunded, this attribute will still be false | |
Originating transaction ID | app_fee_orig_transaction | ID of the corresponding charge on the platform account, if this fee was the result of a charge using the destinationparameter | |
BALANCE | Balance type | balance_type | String representing the object's type. Objects of the same type share the same value |
Balance currency | balance_currency | Three-letter ISO currency code, in lowercase | |
BALANCE TRANSACTION | Transaction ID | transaction_id | Unique identifier for the object |
Transaction type | transaction_type | Transaction type: adjustment, advance, advance_funding, application_fee, application_fee_refund, charge, connect_collection_transfer, issuing_authorization_hold, issuing_authorization_release, issuing_transaction, payment, payment_failure_refund, payment_refund, payout, payout_cancel, payout_failure, refund, refund_failure, reserve_transaction, reserved_funds, stripe_fee, stripe_fx_fee, tax_fee, topup, topup_reversal, transfer, transfer_cancel, transfer_failure, or transfer_refund | |
Transaction status | transaction_status | If the transaction's net funds are available in the Stripe balance yet. Either available or pending | |
Transaction available date | transaction_available_date | The date the transaction's net funds will become available in the Stripe balance | |
Transaction currency | transaction_currency | Three-letter ISO currency code, in lowercase | |
Transaction description | transaction_description | An arbitrary string attached to the object. Often useful for displaying to users | |
First fee type | transaction_fee_type | Type of the fee, one of: application_fee, stripe_fee or tax | |
First fee description | transaction_fee_description | An arbitrary string attached to the object. Often useful for displaying to users | |
CHARGE | Charge ID | charge_id | Unique identifier for the object |
Charge type | charge_type | String representing the object's type. Objects of the same type share the same value | |
Charge status | charge_status | The status of the payment is either succeeded, pending, or failed | |
Charge currency | charge_currency | The status of the payment is either succeeded, pending, or failed | |
Charge description | charge_description | An arbitrary string attached to the object. Often useful for displaying to users | |
Charge on behalf of | charge_on_behalf_of | The account (if any) the charge was made on behalf of without triggering an automatic transfer | |
Charge is captured | charge_captured | If the charge was created without capturing, this Boolean represents whether it is still uncaptured or has since been captured | |
Charge is paid | charge_paid | true if the charge succeeded, or was successfully authorized for later capture | |
Charge is refunded | charge_refunded | Whether the charge has been fully refunded. If the charge is only partially refunded, this attribute will still be false | |
Charge statement descriptor | charge_statement | Extra information about a charge. This will appear on your customer's credit card statement. It must contain at least one letter | |
Charge failure code | charge_failure_code | Error code explaining reason for charge failure if available | |
Charge failure message | charge_failure_message | Message to user further explaining reason for charge failure if available | |
Charge receipt email | charge_receipt_email | This is the email address that the receipt for this charge was sent to | |
Charge receipt number | 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 | |
Charge transfer group | charge_transfer_group | A string that identifies this transaction as part of a group. See the Connect documentation for details | |
Charge metadata | charge_metadata | 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 | |
Outcome type | charge_outcome_type | Possible values are authorized, manual_review, issuer_declined, blocked, and invalid | |
Outcome network status | charge_outcome_network_status | Possible values are approved_by_network, declined_by_network, not_sent_to_network, and reversed_after_approval. The value reversed_after_approval indicates the payment was blocked by Stripe after bank authorization, and may temporarily appear as "pending" on a cardholder's statement | |
Outcome risk level | charge_outcome_risk_level | Stripe's evaluation of the riskiness of the payment. Possible values for evaluated payments are normal, elevated, highest. For non-card payments, and card-based payments predating the public assignment of risk levels, this field will have the value not_assessed. In the event of an error in the evaluation, this field will have the value unknown | |
Outcome reason | charge_outcome_reason | An enumerated value providing a more detailed explanation of the outcome's type. Charges blocked by Radar's default block rule have the value highest_risk_level. Charges placed in review by Radar's default review rule have the value elevated_risk_level. Charges authorized, blocked, or placed in review by custom rules have the value rule | |
Outcome seller message | charge_outcome_seller_message | A human-readable description of the outcome type and reason, designed for you (the recipient of the payment), not your customer | |
Fraud user report | charge_fraud_user_report | Assessments reported by you. If set, possible values of are safe and fraudulent | |
Fraud user details | charge_fraud_details | Information on fraud assessments for the charge | |
TRANSFER | Transfer ID | transfer_id | Unique identifier for the object |
Transfers currency | transfer_currency | Three-letter ISO currency code, in lowercase | |
Transfers description | transfer_description | An arbitrary string attached to the object. Often useful for displaying to users | |
Transfer is reversed | transfer_reversed | Whether the transfer has been fully reversed. If the transfer is only partially reversed, this attribute will still be false | |
Transfer source type | transfer_source_type | The source balance this transfer came from. One of card, financing, bank_account, or alipay_account | |
Transfer source transaction ID | transfer_source_transaction_id | Unique identifier for the object | |
Transfers destination payment ID | transfer_destination_payment_id | Unique identifier for the object | |
Transfer group ID | transfer_group_id | Unique identifier for the object | |
Transfer metadata | transfer_metadata | A set of key-value pairs that you can attach to a transfer object. It can be useful for storing additional information about the transfer in a structured format | |
DESTINATION ACCOUNT | Destination ID | destination_id | Unique identifier for the object |
INVOICE | Invoice ID | invoice_id | The ID of the invoice this invoice item belongs to |
Invoice currency | invoice_currency | Three-letter ISO currency code, in lowercase | |
Invoice description | invoice_description | An arbitrary string attached to the object. Often useful for displaying to users. Referenced as 'memo' in the Dashboard | |
Invoice period start time | invoice_period_start | Start of the usage period during which invoice items were added to this invoice | |
Invoice period end time | invoice_period_end | End of the usage period during which invoice items were added to this invoice | |
Invoice next payment attempt | invoice_next_payment_attempt | The time at which payment will next be attempted. This value will be null for invoices where billing=send_invoice | |
Invoice status | invoice_status | The status of the invoice. Can have the values "draft", "open", "paid", "void", and "uncollectible" | |
Invoice marked uncollectible | invoice_marked_uncollectible_at | The time that the invoice was marked uncollectible | |
Invoice metadata | invoice_metadata | 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 | |
Invoice receipt number | invoice_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 | |
Invoice statement descriptor | invoice_statement | Extra information about a charge. This will appear on your customer's credit card statement. It must contain at least one letter | |
TAX RATES | Tax rate id | tax_rate_id | Unique identifier for the object |
Tax rate description | tax_rate_description | An arbitrary string attached to the tax rate for your internal use only. It will not be visible to your customers | |
Tax rate name | tax_rate_name | The display name of the tax rates as it will appear to your customer on their receipt email, PDF, and the hosted invoice page | |
Tax rate jurisdiction | tax_rate_jurisdiction | The jurisdiction for the tax rate. You can use this label field for tax reporting purposes. It also appears on your customer’s invoice | |
INVOICE ITEM | Invoice item ID | invoice_item_id | Unique identifier for the object |
Invoice item currency | invoice_item_currency | Three-letter ISO currency code | |
Invoice item description | invoice_item_description | An arbitrary string attached to the object. Often useful for displaying to users | |
ORDER | Order ID | order_id | Unique identifier for the object |
Order status | order_status | Current order status. One of created, paid, canceled, fulfilled, or returned | |
Order currency | order_currency | Three-letter ISO currency code, in lowercase | |
Order email | order_email | The email address of the customer placing the order | |
Order shipping method | order_shipping_method | The shipping method to select for fulfilling this order. If specified, must be one of the ids of a shipping method in the shipping_methods | |
Order paid time | order_paid_time | ||
Order fulfilled time | order_fulfilled_time | ||
Order cancelled time | order_cancelled_time | ||
Order returned time | order_returned_time | ||
Order updated time | order_updated_time | ||
Order metadata | order_metadata | A set of key-value pairs that you can attach to a product object. It can be useful for storing additional information about the order in a structured format | |
SUBSCRIPTION | Subscription ID | subscription_id | Unique identifier for the object |
Subscription status | subscription_status | Possible values are trialing, active, past_due, canceled, or unpaid. A subscription still in its trial period is trialing and moves to active when the trial period is over. If subscription billing=charge_automatically it becomes past_due when payment to renew it fails and canceled or unpaid (depending on your subscriptions settings) when Stripe has exhausted all payment retry attempts. If subscription billing=send_invoice it becomes past_due when its invoice is not paid by the due date, and canceled or unpaid if it is still not paid by an additional deadline after that. Note that when a subscription has a status of unpaid, no subsequent invoices will be attempted (invoices will be created, but then immediately automatically closed.) | |
Subscription start time | subscription_start_time | Date of the last substantial change to this subscription. For example, a change to the items array, or a change of status, will reset this timestamp | |
Subscription end time | subscription_end_time | If the subscription has ended, the date the subscription ended | |
Subscription cancel time | subscription_cancel_time | If the subscription has been canceled, the date of that cancellation. If the subscription was canceled with cancel_at_period_end, canceled_atwill still reflect the date of the initial cancellation request, not the end of the subscription period when the subscription is automatically moved to a canceled state | |
Cancel at period end | subscription_cancel_period_end | Boolean indicating whether this subscription should cancel at the end of the current period | |
Subscription trial start time | subscription_trial_start | If the subscription has a trial, the beginning of that trial | |
Subscription trial end time | subscription_trial_end | Unix timestamp representing the end of the trial period the customer will get before being charged for the first time. This will always overwrite any trials that might apply via a subscribed plan | |
Subscription period start time | subscription_period_start | Start of the current period that the subscription has been invoiced for | |
Subscription period end time | subscription_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 | |
Subscription metadata | subscription_metadata | A set of key-value pairs that you can attach to a Subscription object. It can be useful for storing additional information about the subscription in a structured format | |
SUBSCRIPTION PLAN | Plan id | subscription_plan_id | Unique identifier for the object |
Product ID | product_id | Unique identifier for the object | |
Product name | subscription_product_name | A brief description of the product | |
Plan name | subscription_plan_name | A brief description of the plan, hidden from customers | |
Plan interval | subscription_plan_interval | One of day, week, month or year. The frequency with which a subscription should be billed | |
Plan statement descriptor | subscription_plan_statement | ||
Plan metadata | subscription_plan_metadata | 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 | |
SUBSCRIPTION ITEM | Subscription item ID | subscription_item_id | Unique identifier for the object |
Subscription item currency | subscription_item_currency | Three-letter ISO currency code | |
Subscription items description | subscription_item_description | An arbitrary string attached to the object. Often useful for displaying to users | |
PAYOUT | Payout ID | payout_id | Unique identifier for the object |
Payout type | payout_type | Can be bank_account or card | |
Payout status | payout_status | Only return payouts that have the given status: pending, paid, failed, or canceled | |
Payout currency | payout_currency | Three-letter ISO currency code, in lowercase | |
Payout arrival date | payout_arrival_date | Date the payout is expected to arrive in the bank. This factors in delays like weekends or bank holidays | |
Payout method | payout_method | The method used to send this payout, which can be standard or instant | |
Payout description | payout_description | An arbitrary string attached to the object. Often useful for displaying to users | |
Payout statement descriptor | payout_statement | Extra information about a payout to be displayed on the user's bank statement | |
Payout source type | payout_source_type | The source balance to use for this transfer. One of card, financing, bank_account, or alipay_account. For most users, this will default to card | |
Payout failure code | payout_failure_code | Error code explaining reason for payout failure if available | |
Payout failure message | payout_failure_message | Message to user further explaining reason for payout failure if available | |
Payout failure transaction ID | payout_failure_transaction_id | Unique identifier for the object | |
Payout metadata | payout_metadata | 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 | |
REFUND | Refund ID | refund_id | Unique identifier for the object |
Refund status | refund_status | Status of the refund. For credit card refunds, this can be succeeded or failed. For other types of refunds, it can be pending, succeeded, failed, or canceled | |
Refund currency | refund_currency | Three-letter ISO currency code, in lowercase | |
Refund reason | refund_reason | Reason for the refund. If set, possible values are duplicate, fraudulent, and requested_by_customer | |
Refund receipt number | refund_receipt_number | This is the transaction number that appears on email receipts sent for this refund | |
Refund metadata | refund_metadata | 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 | |
DISPUTE | Dispute ID | dispute_id | Unique identifier for the object |
Dispute status | dispute_status | Current status of dispute. Possible values are warning_needs_response, warning_under_review, warning_closed, needs_response, under_review, charge_refunded, won, or lost | |
Dispute reason | dispute_reason | Reason given by cardholder for dispute. Possible values are duplicate, fraudulent, subscription_canceled, product_unacceptable, product_not_received, unrecognized, credit_not_processed, general, incorrect_account_details, insufficient_funds, bank_cannot_process, debit_not_authorized, or customer_initiated | |
Dispute currency | dispute_currency | Three-letter ISO currency code, in lowercase | |
Dispute charge is refundable | dispute_charge_refundable | If true, it is still possible to refund the disputed payment. Once the payment has been fully refunded, no further funds will be withdrawn from your Stripe account as a result of this dispute | |
Dispute metadata | dispute_metadata | 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 | |
Has evidence | dispute_has_evidence | Whether evidence has been staged for this dispute | |
Evidence due by date | dispute_evidence_due_by | Date by which evidence must be submitted in order to successfully challenge dispute. Will be null if the customer's bank or credit card company doesn't allow a response for this particular dispute | |
Evidence is past due | dispute_evidence_past_due | Whether the last evidence submission was submitted past the due date. Defaults to false if no evidence submissions have occurred. If true, then delivery of the latest evidence is not guaranteed | |
REVIEW | Review ID | review_id | Unique identifier for the object |
DEPRECATED | Invoice is paid | invoice_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. Please note that this field will be removed on 2021-08-12 |
Invoice is forgiven | invoice_forgiven | Please note that this field will be removed on 2021-08-12 | |
Invoice is closed | invoice_closed | Please note that this field will be removed on 2021-08-12 |