Introduction

Datasources and destinations

Find all the data sources available at www.catchr.io/connectors
Find all the destinations available at www.catchr.io/destinations

Fields listing for Bigcommerce

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

43 metrics103 dimensions

146 fields

All fields
Field	Details
Customers Address Count Customers Address Count	Field ID`customers/address_count` DimensionNUMBER
Customers Addresses Customers Addresses	Field ID`customers/addresses` DimensionTEXT
Customers Attribute Count Customers Attribute Count	Field ID`customers/attribute_count` DimensionNUMBER
Customers Authentication Customers Authentication	Field ID`customers/authentication` DimensionTEXT
Customers Company Customers Company	Field ID`customers/company` DimensionTEXT
Customers Customer Group Id Customers Customer Group Id	Field ID`customers/customer_group_id` DimensionNUMBER
Customers Date Created Customers Date Created	Field ID`customers/date_created` DimensionYEAR_MONTH_DAY_SECOND
Customers Date Modified Customers Date Modified	Field ID`customers/date_modified` DimensionYEAR_MONTH_DAY_SECOND
Customers Email Customers Email	Field ID`customers/email` DimensionTEXT
Customers First Name Customers First Name	Field ID`customers/first_name` DimensionTEXT
Customers Id Customers Id	Field ID`customers/id` DimensionNUMBER
Customers Last Name Customers Last Name	Field ID`customers/last_name` DimensionTEXT
Customers Notes Customers Notes	Field ID`customers/notes` DimensionTEXT
Customers Phone Customers Phone	Field ID`customers/phone` DimensionTEXT
Customers Registration Ip Address Customers Registration Ip Address	Field ID`customers/registration_ip_address` DimensionTEXT
Customers Tax Exempt Category Customers Tax Exempt Category	Field ID`customers/tax_exempt_category` DimensionTEXT
Date Year, month, and day.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY` DimensionYEAR_MONTH_DAY
Day of the month Day of the year	Field ID`_NORMALIZED_DATE_FIELD_DAY` DimensionDAY
Day of the week Week of the year	Field ID`_NORMALIZED_DATE_FIELD_DAY_OF_WEEK` DimensionDAY_OF_WEEK
Hour of the day Hour of the day	Field ID`_NORMALIZED_DATE_FIELD_HOUR` DimensionHOUR
Month and day Month and day	Field ID`_NORMALIZED_DATE_FIELD_MONTH_DAY` DimensionMONTH_DAY
Month of the year Month of the year	Field ID`_NORMALIZED_DATE_FIELD_MONTH` DimensionMONTH
Order Products Applied Discounts Order Products Applied Discounts	Field ID`order_products/applied_discounts` DimensionTEXT
Order Products Base Cost Price Order Products Base Cost Price	Field ID`order_products/base_cost_price` MetricNUMBER
Order Products Base Price Order Products Base Price	Field ID`order_products/base_price` MetricNUMBER
Order Products Base Total Order Products Base Total	Field ID`order_products/base_total` MetricNUMBER
Order Products Base Wrapping Cost Order Products Base Wrapping Cost	Field ID`order_products/base_wrapping_cost` MetricNUMBER
Order Products Bin Picking Number Order Products Bin Picking Number	Field ID`order_products/bin_picking_number` DimensionTEXT
Order Products Brand Order Products Brand	Field ID`order_products/brand` DimensionTEXT
Order Products Configurable Fields Order Products Configurable Fields	Field ID`order_products/configurable_fields` DimensionTEXT
Order Products Cost Price Ex Tax Order Products Cost Price Ex Tax	Field ID`order_products/cost_price_ex_tax` MetricNUMBER
Order Products Cost Price Inc Tax Order Products Cost Price Inc Tax	Field ID`order_products/cost_price_inc_tax` MetricNUMBER
Order Products Cost Price Tax Order Products Cost Price Tax	Field ID`order_products/cost_price_tax` MetricNUMBER
Order Products Depth Order Products Depth	Field ID`order_products/depth` DimensionTEXT
Order Products Ebay Item Id Order Products Ebay Item Id	Field ID`order_products/ebay_item_id` DimensionTEXT
Order Products Ebay Transaction Id Order Products Ebay Transaction Id	Field ID`order_products/ebay_transaction_id` DimensionTEXT
Order Products Event Date Order Products Event Date	Field ID`order_products/event_date` DimensionTEXT
Order Products Event Name Order Products Event Name	Field ID`order_products/event_name` DimensionTEXT
Order Products External Id Order Products External Id	Field ID`order_products/external_id` DimensionTEXT
Order Products Fixed Shipping Cost Order Products Fixed Shipping Cost	Field ID`order_products/fixed_shipping_cost` MetricNUMBER
Order Products Fulfillment Source Order Products Fulfillment Source	Field ID`order_products/fulfillment_source` DimensionTEXT
Order Products Gift Certificate Id Order Products Gift Certificate Id	Field ID`order_products/gift_certificate_id` DimensionNUMBER
Order Products Height Order Products Height	Field ID`order_products/height` DimensionTEXT
Order Products Id Order Products Id	Field ID`order_products/id` DimensionNUMBER
Order Products Is Bundled Product Order Products Is Bundled Product	Field ID`order_products/is_bundled_product` DimensionBOOLEAN
Order Products Is Refunded Order Products Is Refunded	Field ID`order_products/is_refunded` DimensionBOOLEAN
Order Products Name Order Products Name	Field ID`order_products/name` DimensionTEXT
Order Products Name Customer Order Products Name Customer	Field ID`order_products/name_customer` DimensionTEXT
Order Products Name Merchant Order Products Name Merchant	Field ID`order_products/name_merchant` DimensionTEXT
Order Products Option Set Id Order Products Option Set Id	Field ID`order_products/option_set_id` DimensionNUMBER
Order Products Order Address Id Order Products Order Address Id	Field ID`order_products/order_address_id` DimensionNUMBER
Order Products Parent Order Product Id Order Products Parent Order Product Id	Field ID`order_products/parent_order_product_id` DimensionNUMBER
Order Products Price Ex Tax Order Products Price Ex Tax	Field ID`order_products/price_ex_tax` MetricNUMBER
Order Products Price Inc Tax Order Products Price Inc Tax	Field ID`order_products/price_inc_tax` MetricNUMBER
Order Products Price Tax Order Products Price Tax	Field ID`order_products/price_tax` MetricNUMBER
Order Products Product Id Order Products Product Id	Field ID`order_products/product_id` DimensionNUMBER
Order Products Product Options Order Products Product Options	Field ID`order_products/product_options` DimensionTEXT
Order Products Quantity Order Products Quantity	Field ID`order_products/quantity` MetricNUMBER
Order Products Quantity Refunded Order Products Quantity Refunded	Field ID`order_products/quantity_refunded` MetricNUMBER
Order Products Quantity Shipped Order Products Quantity Shipped	Field ID`order_products/quantity_shipped` MetricNUMBER
Order Products Refund Amount Order Products Refund Amount	Field ID`order_products/refund_amount` MetricNUMBER
Order Products Return Id Order Products Return Id	Field ID`order_products/return_id` DimensionNUMBER
Order Products Sku Order Products Sku	Field ID`order_products/sku` DimensionTEXT
Order Products Total Ex Tax Order Products Total Ex Tax	Field ID`order_products/total_ex_tax` MetricNUMBER
Order Products Total Inc Tax Order Products Total Inc Tax	Field ID`order_products/total_inc_tax` MetricNUMBER
Order Products Total Tax Order Products Total Tax	Field ID`order_products/total_tax` MetricNUMBER
Order Products Type Order Products Type	Field ID`order_products/type` DimensionTEXT
Order Products Upc Order Products Upc	Field ID`order_products/upc` DimensionTEXT
Order Products Variant Id Order Products Variant Id	Field ID`order_products/variant_id` DimensionNUMBER
Order Products Weight Order Products Weight	Field ID`order_products/weight` DimensionTEXT
Order Products Width Order Products Width	Field ID`order_products/width` DimensionTEXT
Order Products Wrapping Cost Ex Tax Order Products Wrapping Cost Ex Tax	Field ID`order_products/wrapping_cost_ex_tax` MetricNUMBER
Order Products Wrapping Cost Inc Tax Order Products Wrapping Cost Inc Tax	Field ID`order_products/wrapping_cost_inc_tax` MetricNUMBER
Order Products Wrapping Cost Tax Order Products Wrapping Cost Tax	Field ID`order_products/wrapping_cost_tax` MetricNUMBER
Order Products Wrapping Id Order Products Wrapping Id	Field ID`order_products/wrapping_id` DimensionNUMBER
Order Products Wrapping Message Order Products Wrapping Message	Field ID`order_products/wrapping_message` DimensionTEXT
Order Products Wrapping Name Order Products Wrapping Name	Field ID`order_products/wrapping_name` DimensionTEXT
Orders Base Handling Cost Orders Base Handling Cost	Field ID`orders/base_handling_cost` MetricNUMBER
Orders Base Shipping Cost Orders Base Shipping Cost	Field ID`orders/base_shipping_cost` MetricNUMBER
Orders Base Wrapping Cost Orders Base Wrapping Cost	Field ID`orders/base_wrapping_cost` MetricNUMBER
Orders Billing Address Orders Billing Address	Field ID`orders/billing_address` DimensionTEXT
Orders Cart Id Orders Cart Id	Field ID`orders/cart_id` DimensionTEXT
Orders Channel Id Orders Channel Id	Field ID`orders/channel_id` DimensionNUMBER
Orders Coupon Discount Orders Coupon Discount	Field ID`orders/coupon_discount` MetricNUMBER
Orders Coupons Orders Coupons	Field ID`orders/coupons` DimensionTEXT
Orders Currency Code Orders Currency Code	Field ID`orders/currency_code` DimensionTEXT
Orders Currency Exchange Rate Orders Currency Exchange Rate	Field ID`orders/currency_exchange_rate` MetricNUMBER
Orders Currency Id Orders Currency Id	Field ID`orders/currency_id` DimensionNUMBER
Orders Customer Locale Orders Customer Locale	Field ID`orders/customer_locale` DimensionTEXT
Orders Customer Message Orders Customer Message	Field ID`orders/customer_message` DimensionTEXT
Orders Date Created Orders Date Created	Field ID`orders/date_created` DimensionYEAR_MONTH_DAY_SECOND
Orders Date Modified Orders Date Modified	Field ID`orders/date_modified` DimensionYEAR_MONTH_DAY
Orders Date Shipped Orders Date Shipped	Field ID`orders/date_shipped` DimensionYEAR_MONTH_DAY
Orders Default Currency Code Orders Default Currency Code	Field ID`orders/default_currency_code` DimensionTEXT
Orders Default Currency Id Orders Default Currency Id	Field ID`orders/default_currency_id` DimensionNUMBER
Orders Discount Amount Orders Discount Amount	Field ID`orders/discount_amount` MetricNUMBER
Orders Ebay Order Id Orders Ebay Order Id	Field ID`orders/ebay_order_id` DimensionTEXT
Orders External Id Orders External Id	Field ID`orders/external_id` DimensionTEXT
Orders External Source Orders External Source	Field ID`orders/external_source` DimensionTEXT
Orders Geoip Country Orders Geoip Country	Field ID`orders/geoip_country` DimensionTEXT
Orders Geoip Country Iso2 Orders Geoip Country Iso2	Field ID`orders/geoip_country_iso2` DimensionTEXT
Orders Gift Certificate Amount Orders Gift Certificate Amount	Field ID`orders/gift_certificate_amount` DimensionTEXT
Orders Handling Cost Ex Tax Orders Handling Cost Ex Tax	Field ID`orders/handling_cost_ex_tax` MetricNUMBER
Orders Handling Cost Inc Tax Orders Handling Cost Inc Tax	Field ID`orders/handling_cost_inc_tax` MetricNUMBER
Orders Handling Cost Tax Orders Handling Cost Tax	Field ID`orders/handling_cost_tax` MetricNUMBER
Orders Handling Cost Tax Class Id Orders Handling Cost Tax Class Id	Field ID`orders/handling_cost_tax_class_id` DimensionNUMBER
Orders Id Orders Id	Field ID`orders/id` DimensionNUMBER
Orders Ip Address Orders Ip Address	Field ID`orders/ip_address` DimensionTEXT
Orders Is Deleted Orders Is Deleted	Field ID`orders/is_deleted` DimensionBOOLEAN
Orders Is Email Opt In Orders Is Email Opt In	Field ID`orders/is_email_opt_in` DimensionBOOLEAN
Orders Items Shipped Orders Items Shipped	Field ID`orders/items_shipped` DimensionNUMBER
Orders Items Total Orders Items Total	Field ID`orders/items_total` DimensionNUMBER
Orders Order Is Digital Orders Order Is Digital	Field ID`orders/order_is_digital` DimensionBOOLEAN
Orders Order Source Orders Order Source	Field ID`orders/order_source` DimensionTEXT
Orders Payment Method Orders Payment Method	Field ID`orders/payment_method` DimensionTEXT
Orders Payment Status Orders Payment Status	Field ID`orders/payment_status` DimensionTEXT
Orders Products Orders Products	Field ID`orders/products` DimensionTEXT
Orders Refunded Amount Orders Refunded Amount	Field ID`orders/refunded_amount` MetricNUMBER
Orders Shipping Address Count Orders Shipping Address Count	Field ID`orders/shipping_address_count` DimensionNUMBER
Orders Shipping Addresses Orders Shipping Addresses	Field ID`orders/shipping_addresses` DimensionTEXT
Orders Shipping Cost Ex Tax Orders Shipping Cost Ex Tax	Field ID`orders/shipping_cost_ex_tax` MetricNUMBER
Orders Shipping Cost Inc Tax Orders Shipping Cost Inc Tax	Field ID`orders/shipping_cost_inc_tax` MetricNUMBER
Orders Shipping Cost Tax Orders Shipping Cost Tax	Field ID`orders/shipping_cost_tax` MetricNUMBER
Orders Shipping Cost Tax Class Id Orders Shipping Cost Tax Class Id	Field ID`orders/shipping_cost_tax_class_id` DimensionNUMBER
Orders Staff Notes Orders Staff Notes	Field ID`orders/staff_notes` DimensionTEXT
Orders Status Orders Status	Field ID`orders/status` DimensionTEXT
Orders Status Id Orders Status Id	Field ID`orders/status_id` DimensionNUMBER
Orders Store Credit Amount Orders Store Credit Amount	Field ID`orders/store_credit_amount` MetricNUMBER
Orders Subtotal Ex Tax Orders Subtotal Ex Tax	Field ID`orders/subtotal_ex_tax` MetricNUMBER
Orders Subtotal Inc Tax Orders Subtotal Inc Tax	Field ID`orders/subtotal_inc_tax` MetricNUMBER
Orders Subtotal Tax Orders Subtotal Tax	Field ID`orders/subtotal_tax` MetricNUMBER
Orders Tax Provider Id Orders Tax Provider Id	Field ID`orders/tax_provider_id` DimensionTEXT
Orders Total Ex Tax Orders Total Ex Tax	Field ID`orders/total_ex_tax` MetricNUMBER
Orders Total Inc Tax Orders Total Inc Tax	Field ID`orders/total_inc_tax` MetricNUMBER
Orders Wrapping Cost Ex Tax Orders Wrapping Cost Ex Tax	Field ID`orders/wrapping_cost_ex_tax` MetricNUMBER
Orders Wrapping Cost Inc Tax Orders Wrapping Cost Inc Tax	Field ID`orders/wrapping_cost_inc_tax` MetricNUMBER
Orders Wrapping Cost Tax Orders Wrapping Cost Tax	Field ID`orders/wrapping_cost_tax` MetricNUMBER
Orders Wrapping Cost Tax Class Id Orders Wrapping Cost Tax Class Id	Field ID`orders/wrapping_cost_tax_class_id` DimensionNUMBER
Quarter of the year Quarter of the year	Field ID`_NORMALIZED_DATE_FIELD_QUARTER` DimensionQUARTER
Week of the year Week of the year	Field ID`_NORMALIZED_DATE_FIELD_WEEK` DimensionWEEK
Week of the year (start Sunday) Week of the year	Field ID`_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY` DimensionWEEK
Year Year such as 2017.	Field ID`_NORMALIZED_DATE_FIELD_YEAR` DimensionYEAR
Year month Year and month.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_MONTH` DimensionYEAR_MONTH
Year month day hour Year, month, day, and hour.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR` DimensionYEAR_MONTH_DAY_HOUR
Year Quarter Year and quarter.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_QUARTER` DimensionYEAR_QUARTER
Year week Year and week.	Field ID`_NORMALIZED_DATE_FIELD_YEAR_WEEK` DimensionYEAR_WEEK

Explore destinations for your data

Introduction

Fields listing for Bigcommerce

Metrics & dimensions

Explore destinations for your data

Claude

ChatGPT

Excel

Azure Blob Storage

Google Cloud Storage

Amazon S3

Snowflake

Amazon Redshift

Azure SQL

PostgreSQL

MySQL

Tableau

Power BI

Big Query

Data Studio (formerly Looker Studio)

Google Sheets