Ecwid fields

  • Updated on Sep 30, 2025
  • Published on Sep 30, 2025
Prev Next

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

Early Access8 metrics49 dimensions

BILLING

billing_first_name
Field label Billing first name
Description Billing address first name
Field type dimension
Data type string.text.value
billing_last_name
Field label Billing last name
Description Billing address last name
Field type dimension
Data type string.text.value
billing_street
Field label Billing street
Description Billing address street
Field type dimension
Data type string.text.value
billing_city
Field label Billing city
Description Billing address city
Field type dimension
Data type string.geo.city
billing_state_or_province_code
Field label Billing state or province code
Description Billing address state or province code
Field type dimension
Data type string.text.value
billing_state_or_province_name
Field label Billing state or province name
Description Billing address state or province name
Field type dimension
Data type string.text.value
billing_country_code
Field label Billing country code
Description Billing address country code in ISO 3166-1 alpha-2 format
Field type dimension
Data type string.geo.country.twolettercode
billing_country_name
Field label Billing country name
Description Billing address country name
Field type dimension
Data type string.geo.country
billing_postal_code
Field label Billing postal code
Description Billing address postal code
Field type dimension
Data type string.geo.zip

CUSTOMER

customer_email
Field label Customer email
Description Customer's email address
Field type dimension
Data type string.text.email
customer_id
Field label Customer ID
Description Unique customer identifier
Field type dimension
Data type string.text.value

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

ORDER

order_id
Field label Order ID
Description Unique order identifier
Field type dimension
Data type string.text.value
order_number
Field label Order number
Description Human-readable order number
Field type dimension
Data type string.text.value
order_payment_status
Field label Order payment status
Description Payment status of the order
Field type dimension
Data type string.text.value
order_fulfillment_status
Field label Order fulfillment status
Description Fulfillment status of the order
Field type dimension
Data type string.text.value
subtotal
Field label Subtotal
Description Cost of all products in the order (item's price x quantity) before any cost modifiers such as discounts, taxes, fees, etc. are applied
Field type metric
Data type float.currency.value
tax
Field label Tax
Description Sum of all taxes applied to products and shipping. If the order is modified after being placed, this value is not recalculated automatically
Field type metric
Data type float.currency.value
discount
Field label Discount
Description Total order discount. Includes both promotions and discount coupons
Field type metric
Data type float.currency.value
gift_card
Field label Gift card
Description Amount deducted from the Gift Card balance and applied to order total
Field type metric
Data type float.currency.value
total_before_gift_card
Field label Total before gift card
Description Order total before the Gift Card was applied
Field type metric
Data type float.currency.value
total_without_tax
Field label Total without tax
Description Order total without taxes. Calculates as total - tax
Field type metric
Data type float.currency.value
total
Field label Total
Description Order total cost with all cost modifiers: shipping costs, taxes, fees, and discounts
Field type metric
Data type float.currency.value
orders
Field label Orders
Description 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

STORE

store_name
Field label Store name
Description The name of the store
Field type dimension
Data type string.text.value
store_id
Field label Store ID
Description The unique identifier of the store
Field type dimension
Data type string.text.value
store_url
Field label Store URL
Description The URL of the store
Field type dimension
Data type string.text.url
store_currency
Field label Store currency
Description The default currency of the store
Field type dimension
Data type string.currency.code

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

order_created_date
Field label Order created date
Description Date when the order was created
Field type dimension
Data type string.time.date
order_created_datetime
Field label Order created datetime
Description Date and time when the order was created
Field type dimension
Data type string.time.datetime
order_modified_date
Field label Order modified date
Description Date when the order was last modified
Field type dimension
Data type string.time.date
order_modified_datetime
Field label Order modified datetime
Description Date and time when the order was last modified
Field type dimension
Data type string.time.datetime