Recharge fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Recharge data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

31 metrics97 dimensions

BILLING

billing_first_name
Field label Billing first name
Description The first name of the customer for billing purposes
Field type dimension
Data type string.text.value
billing_last_name
Field label Billing last name
Description The last name of the customer for billing purposes
Field type dimension
Data type string.text.value
billing_company
Field label Billing company
Description The company name associated with the billing address, if applicable
Field type dimension
Data type string.text.value
billing_address_1
Field label Billing address 1
Description The primary street address for billing
Field type dimension
Data type string.geo.street
billing_address_2
Field label Billing address 2
Description The secondary street address for billing, if applicable
Field type dimension
Data type string.geo.street
billing_city
Field label Billing city
Description The city for the billing address
Field type dimension
Data type string.geo.city
billing_zip
Field label Billing zip
Description The postal code or ZIP code for the billing address
Field type dimension
Data type string.geo.zip
billing_province
Field label Billing province
Description The province or state for the billing address
Field type dimension
Data type string.text.value
billing_country_code
Field label Billing country code
Description The country code for the billing address
Field type dimension
Data type string.geo.country.twolettercode
billing_phone
Field label Billing phone
Description The phone number associated with the billing address
Field type dimension
Data type string.text.phone

CHARGE

charge_id
Field label Charge ID
Description The unique numeric identifier for the charge
Field type dimension
Data type string.text.value
charge_type
Field label Charge type
Description An indicator of the charge’s type, either checkout or recurring
Field type dimension
Data type string.text.value
charge_status
Field label Charge status
Description The status of the charge
Field type dimension
Data type string.text.value
charge_currency
Field label Charge currency
Description The code of the currency for this charge, such as USD
Field type dimension
Data type string.currency.code
charge_note
Field label Charge note
Description Notes associated with the charge
Field type dimension
Data type string.text.value
charge_payment_processor
Field label Charge payment processor
Description The payment processor used for the charge
Field type dimension
Data type string.text.value
charge_scheduled_at
Field label Charge scheduled at
Description The date when the charge is scheduled to process
Field type dimension
Data type string.time.date
charge_tags
Field label Charge tags
Description A comma-separated list of tags on the charge
Field type dimension
Data type string.text.value
charge_is_taxable
Field label Charge is taxable
Description A boolean indicator of the taxability of the charge
Field type dimension
Data type bool
charge_total_line_items_price
Field label Total line items price
Description The total price of all line items of the charge
Field type metric
Data type float.currency.value
charge_subtotal_price
Field label Subtotal price
Description The combined price of all line_items without taxes and shipping
Field type metric
Data type float.currency.value
charge_total_price
Field label Total price
Description The sum of all the prices of all the items in the charge, taxes and discounts included (must be positive)
Field type metric
Data type float.currency.value
charge_total_refunds
Field label Total refunds
Description The sum of all refunds that were applied to the charge
Field type metric
Data type float.currency.value
charge_total_tax
Field label Total tax
Description The total tax due associated with the charge
Field type metric
Data type float.currency.value
charge_total_discounts
Field label Total discounts
Description The sum of the discounts applied to the charge
Field type metric
Data type float.currency.value
charge_total_duties
Field label Total duties
Description The total cost of duties for the charge
Field type metric
Data type float.currency.value
charge_total_weight_grams
Field label Total weight grams
Description The total weight of the charge's line items in grams
Field type metric
Data type int.number.value
charge_orders
Field label Orders
Description The number of orders generated from this charge (>1 for prepaid Subscriptions)
Field type metric
Data type int.number.value
charges
Field label Charges
Description The number of charges
Field type metric
Data type int.number.value

CUSTOMER

customer_id
Field label Customer ID
Description The ID of the associated customer record
Field type dimension
Data type string.text.value
customer_email
Field label Customer email
Description The email address of the customer
Field type dimension
Data type string.text.email

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

LINE ITEM

purchase_item_id
Field label Purchase item ID
Description The Subscription or Onetime ID associated with the line_item
Field type dimension
Data type string.text.value
purchase_item_type
Field label Purchase item type
Description An indicator of the type of the purchase item
Field type dimension
Data type string.text.value
item_title
Field label Item title
Description The title of the product of this line_item
Field type dimension
Data type string.text.value
item_variant_title
Field label Item variant title
Description The name of a variant of the Product of this line_item
Field type dimension
Data type string.text.value
sku
Field label SKU
Description The SKU (stock keeping unit) of the product associated with the line_item
Field type dimension
Data type string.text.value
item_handle
Field label Item handle
Description A unique, human-friendly string for the product
Field type dimension
Data type string.text.value
taxable
Field label Taxable
Description A boolean indicating if the line_item is taxable or non-taxable
Field type dimension
Data type bool
unit_price_includes_tax
Field label Unit price includes tax
Description A boolean indicator if tax is included in the price of an item
Field type dimension
Data type bool
item_unit_price
Field label Item unit price
Description The unit price of the line_item
Field type metric
Data type float.currency.value
item_original_price
Field label Item original price
Description The original price of the line_item without discounts or taxes
Field type metric
Data type float.currency.value
item_quantity
Field label Item quantity
Description The quantity of the line_item
Field type metric
Data type int.number.value
item_tax_due
Field label Item tax due
Description The total tax due associated with the line_item
Field type metric
Data type float.currency.value
item_taxable_amount
Field label Item taxable amount
Description The taxable revenue associated with the line_item
Field type metric
Data type float.currency.value
item_total_price
Field label Item total price
Description The total price of the line_item including tax
Field type metric
Data type float.currency.value
item_grams
Field label Item grams
Description The weight of the item in grams
Field type metric
Data type int.number.value

ORDER

order_id
Field label Order ID
Description The unique numeric identifier for the order
Field type dimension
Data type string.text.value
order_type
Field label Order type
Description An indicator of the order’s type
Field type dimension
Data type string.text.value
order_status
Field label Order status
Description The status of creating the order
Field type dimension
Data type string.text.value
order_currency
Field label Order currency
Description The currency of the payment used to create the order
Field type dimension
Data type string.currency.code
order_tags
Field label Order tags
Description A comma separated list of tags on the order
Field type dimension
Data type string.text.value
order_note
Field label Order note
Description Notes associated with the order
Field type dimension
Data type string.text.value
order_is_prepaid
Field label Order is prepaid
Description A boolean representing if this order is generated from a prepaid purchase
Field type dimension
Data type bool
order_is_taxable
Field label Order is taxable
Description A boolean indicator of the taxability of the order
Field type dimension
Data type bool
total_line_items_price
Field label Total line items price
Description The total price of all line items of the order
Field type metric
Data type float.currency.value
subtotal_price
Field label Subtotal price
Description The subtotal price (sum of all line items * their quantity) of the order less discounts
Field type metric
Data type float.currency.value
total_price
Field label Total price
Description The total amount due of the order
Field type metric
Data type float.currency.value
total_refunds
Field label Total refunds
Description The total amount of refunds associated with the order
Field type metric
Data type float.currency.value
total_tax
Field label Total tax
Description The total tax due associated with the order
Field type metric
Data type float.currency.value
total_discounts
Field label Total discounts
Description The total discounted value of the order
Field type metric
Data type float.currency.value
total_duties
Field label Total duties
Description The total cost of duties for the order
Field type metric
Data type float.currency.value
total_weight_grams
Field label Total weight grams
Description The total weight of the order in grams
Field type metric
Data type int.number.value
orders
Field label Orders
Description The number of orders
Field type metric
Data type int.number.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SHIPPING

shipping_first_name
Field label Shipping first name
Description The first name for the shipping address
Field type dimension
Data type string.text.value
shipping_last_name
Field label Shipping last name
Description The last name for the shipping address
Field type dimension
Data type string.text.value
shipping_company
Field label Shipping company
Description The company name for the shipping address, if applicable
Field type dimension
Data type string.text.value
shipping_address_1
Field label Shipping address 1
Description The primary street address for shipping
Field type dimension
Data type string.geo.street
shipping_address_2
Field label Shipping address 2
Description The secondary street address for shipping, if applicable
Field type dimension
Data type string.geo.street
shipping_city
Field label Shipping city
Description The city for the shipping address
Field type dimension
Data type string.geo.city
shipping_zip
Field label Shipping zip
Description The postal code or ZIP code for the shipping address
Field type dimension
Data type string.geo.zip
shipping_province
Field label Shipping province
Description The province or state for the shipping address
Field type dimension
Data type string.text.value
shipping_country_code
Field label Shipping country code
Description The country code for the shipping address
Field type dimension
Data type string.geo.country.twolettercode
shipping_phone
Field label Shipping phone
Description The phone number associated with the shipping address
Field type dimension
Data type string.text.phone

STORE

store_name
Field label Store name
Description The name of the store
Field type dimension
Data type string.text.value

SUBSCRIPTION

subscription_id
Field label Subscription ID
Description Unique numeric identifier for the subscription
Field type dimension
Data type string.text.value
status
Field label Status
Description The status of the subscription
Field type dimension
Data type string.text.value
product_title
Field label Product title
Description The name of the product in a store’s catalog
Field type dimension
Data type string.text.value
variant_title
Field label Variant title
Description The name of the variant in a shop’s catalog
Field type dimension
Data type string.text.value
product_sku
Field label SKU
Description A unique identifier of the item in the fulfillment. In cases where SKU is blank, it will be dynamically pulled whenever it is used
Field type dimension
Data type string.text.value
cancellation_reason
Field label Cancellation reason
Description Reason provided for cancellation
Field type dimension
Data type string.text.value
cancellation_reason_comments
Field label Cancellation reason comments
Description Additional comment for cancellation. Maximum length is 1024 characters
Field type dimension
Data type string.text.value
expire_after_specific_number_of_charges
Field label Expire after specific number of charges
Description Set the number of charges until subscription expires
Field type dimension
Data type string.text.value
has_queue_charges
Field label Has queue charges
Description Retrieves true if there is queued charge. Otherwise, retrieves false
Field type dimension
Data type bool
is_prepaid
Field label Is prepaid
Description Value is set to true if it is a prepaid item
Field type dimension
Data type bool
is_swappable
Field label Is swappable
Description Value is set to true if it is not a prepaid item and if in customer portal settings swap is allowed for customers
Field type dimension
Data type bool
max_retries_reached
Field label Max retries reached
Description Retrieves true if charge has an error max retries reached. Otherwise, retrieves false
Field type dimension
Data type bool
next_charge_scheduled_at
Field label Next charge scheduled at
Description Date of the next charge for the subscription
Field type dimension
Data type string.time.date
order_interval_unit
Field label Order interval unit
Description The frequency unit used to determine when a subscription’s order is created
Field type dimension
Data type string.text.value
presentment_currency
Field label Presentment currency
Description The presentment currency of the subscription
Field type dimension
Data type string.currency.code
price
Field label Price
Description The price of the item before discounts, taxes, or shipping have been applied
Field type metric
Data type float.currency.value
quantity
Field label Quantity
Description The number of items in the subscription
Field type metric
Data type int.number.value
charge_interval_frequency
Field label Charge interval frequency
Description The number of units (specified in order_interval_unit) between each charge. For example, order_interval_unit=month and charge_interval_frequency=3, indicate charge every 3 months
Field type metric
Data type int.number.value
order_interval_frequency
Field label Order interval frequency
Description The number of units (specified in order_interval_unit) between each order. For example, order_interval_unit=month and order_interval_frequency=3, indicate order every 3 months. Max value: 1000
Field type metric
Data type int.number.value
subscriptions
Field label Subscriptions
Description The number of subscriptions
Field type metric
Data type int.number.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TIMESTAMP

created_date
Field label Created date
Description The date when the order was created
Field type dimension
Data type string.time.date
created_datetime
Field label Created datetime
Description The date and time when the order was created
Field type dimension
Data type string.time.datetime
updated_date
Field label Updated date
Description The date when the order was last updated
Field type dimension
Data type string.time.date
updated_datetime
Field label Updated datetime
Description The date and time when the order was last updated
Field type dimension
Data type string.time.datetime
processed_date
Field label Processed date
Description The date when the charge was processed
Field type dimension
Data type string.time.date
processed_datetime
Field label Processed datetime
Description The date and time when the charge was processed
Field type dimension
Data type string.time.datetime
cancelled_date
Field label Cancelled date
Description The date when the subscription was cancelled
Field type dimension
Data type string.time.date
cancelled_datetime
Field label Cancelled datetime
Description The date and time when the subscription was cancelled
Field type dimension
Data type string.time.datetime