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 Magento

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

0 metrics144 dimensions

144 fields

All fields
Field	Details
Amount Refunded Order Item Amount refunded	Field ID`order_items/amount_refunded` DimensionNUMBER
Applied Rule Ids Order Item Applied rule ids	Field ID`order_items/applied_rule_ids` 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 Applied Rule Ids Increment Id	Field ID`orders/applied_rule_ids` DimensionTEXT
Order Base Currency Code Base Currency Code	Field ID`orders/base_currency_code` DimensionTEXT
Order Base Discount Amount Base Discount Amount	Field ID`orders/base_discount_amount` DimensionNUMBER
Order Base Discount Canceled Base Discount Canceled	Field ID`orders/base_discount_canceled` DimensionNUMBER
Order Base Discount Invoiced Base Discount Invoiced	Field ID`orders/base_discount_invoiced` DimensionNUMBER
Order Base Discount Refunded Base Discount Refunded	Field ID`orders/base_discount_refunded` DimensionNUMBER
Order Base Discount Tax Compensation Amount Base Discount Tax Compensation Amount	Field ID`orders/base_discount_tax_compensation_amount` DimensionNUMBER
Order Base Discount Tax Compensation Invoiced Base Discount Tax Compensation Invoiced	Field ID`orders/base_discount_tax_compensation_invoiced` DimensionNUMBER
Order Base Discount Tax Compensation Refunded Base Discount Tax Compensation Refunded	Field ID`orders/base_discount_tax_compensation_refunded` DimensionNUMBER
Order Base Grand Total Base Grand Total	Field ID`orders/base_grand_total` DimensionNUMBER
Order Base Shipping Amount Base Shipping Amount	Field ID`orders/base_shipping_amount` DimensionNUMBER
Order Base Shipping Incl Tax Base Shipping Incl Tax	Field ID`orders/base_shipping_incl_tax` DimensionNUMBER
Order Base Shipping Tax Amount Base Shipping Tax Amount	Field ID`orders/base_shipping_tax_amount` DimensionNUMBER
Order Base Subtotal Base Subtotal	Field ID`orders/base_subtotal` DimensionNUMBER
Order Base Subtotal Incl Tax Base Subtotal Incl Tax	Field ID`orders/base_subtotal_incl_tax` DimensionNUMBER
Order Base Tax Amount Base Tax Amount	Field ID`orders/base_tax_amount` DimensionNUMBER
Order Base To Global Rate Base To Global Rate	Field ID`orders/base_to_global_rate` DimensionNUMBER
Order Base To Order Rate Base To Order Rate	Field ID`orders/base_to_order_rate` DimensionNUMBER
Order Base Total Due Base Total Due	Field ID`orders/base_total_due` DimensionNUMBER
Order Billing Address Id Billing Address Id	Field ID`orders/billing_address_id` DimensionNUMBER
Order Created At Created At	Field ID`orders/created_at` DimensionYEAR_MONTH_DAY_SECOND
Order Currency Code Order Currency Code	Field ID`orders/order_currency_code` DimensionTEXT
Order Customer Email Customer Email	Field ID`orders/customer_email` DimensionTEXT
Order Customer Fullname Customer Fullname	Field ID`orders/customer_full_name` DimensionTEXT
Order Customer Group Id Customer Group Id	Field ID`orders/customer_group_id` DimensionNUMBER
Order Customer Id Customer Id	Field ID`orders/customer_id` DimensionNUMBER
Order Customer Is Guest Customer Is Guest	Field ID`orders/customer_is_guest` DimensionBOOLEAN
Order Discount Amount Discount Amount	Field ID`orders/discount_amount` DimensionNUMBER
Order Discount Canceled Discount Canceled	Field ID`orders/discount_canceled` DimensionNUMBER
Order Discount Invoiced Discount Invoiced	Field ID`orders/discount_invoiced` DimensionNUMBER
Order Discount Refunded Discount Refunded	Field ID`orders/discount_refunded` DimensionNUMBER
Order Discount Tax Compensation Amount Discount Tax Compensation Amount	Field ID`orders/discount_tax_compensation_amount` DimensionNUMBER
Order Discount Tax Compensation Invoiced Discount Tax Compensation Invoiced	Field ID`orders/discount_tax_compensation_invoiced` DimensionNUMBER
Order Discount Tax Compensation Refunded Discount Tax Compensation Refunded	Field ID`orders/discount_tax_compensation_refunded` DimensionNUMBER
Order Email Sent Email Sent	Field ID`orders/email_sent` DimensionBOOLEAN
Order Entity Id Entity Id	Field ID`orders/entity_id` DimensionNUMBER
Order Global Currency Code Global Currency Code	Field ID`orders/global_currency_code` DimensionTEXT
Order Grand Total Grand Total	Field ID`orders/grand_total` DimensionNUMBER
Order Increment Id Increment Id	Field ID`orders/increment_id` DimensionTEXT
Order is Virtual Increment Id	Field ID`orders/is_virtual` DimensionBOOLEAN
Order Item Base Amount Refunded Order Item Base amount refunded	Field ID`order_items/base_amount_refunded` DimensionNUMBER
Order Item Base Discount Amount Order Item Base discount amount	Field ID`order_items/base_discount_amount` DimensionNUMBER
Order Item Base Discount Invoiced Order Item Base discount invoiced	Field ID`order_items/base_discount_invoiced` DimensionNUMBER
Order Item Base Discount Tax Compensation Amount Order Item Base discount tax compensation amount	Field ID`order_items/base_discount_tax_compensation_amount` DimensionNUMBER
Order Item Base Original Price Order Item Base original price	Field ID`order_items/base_original_price` DimensionNUMBER
Order Item Base Price Order Item Base price	Field ID`order_items/base_price` DimensionNUMBER
Order Item Base Price Incl Tax Order Item Base price incl tax	Field ID`order_items/base_price_incl_tax` DimensionNUMBER
Order Item Base Row Invoiced Order Item Base row invoiced	Field ID`order_items/base_row_invoiced` DimensionNUMBER
Order Item Base Row Total Order Item Base row total	Field ID`order_items/base_row_total` DimensionNUMBER
Order Item Base Row Total Incl Tax Order Item Base row total incl tax	Field ID`order_items/base_row_total_incl_tax` DimensionNUMBER
Order Item Base Tax Amount Order Item Base tax amount	Field ID`order_items/base_tax_amount` DimensionNUMBER
Order Item Base Tax Invoiced Order Item Base tax invoiced	Field ID`order_items/base_tax_invoiced` DimensionNUMBER
Order Item Created At Order Item created at	Field ID`order_items/created_at` DimensionYEAR_MONTH_DAY_SECOND
Order Item Discount Amount Order Item discount amount	Field ID`order_items/discount_amount` DimensionNUMBER
Order Item Discount Invoiced Order Item discount invoiced	Field ID`order_items/discount_invoiced` DimensionNUMBER
Order Item Discount Percent Order Item discount percent	Field ID`order_items/discount_percent` DimensionNUMBER
Order Item Discount Tax Compensation Amount Order Item discount tax compensation amount	Field ID`order_items/discount_tax_compensation_amount` DimensionNUMBER
Order Item Id Order Item id	Field ID`order_items/item_id` DimensionNUMBER
Order Item Is Qty Decimal Order Item is qty decimal	Field ID`order_items/is_qty_decimal` DimensionNUMBER
Order Item Is Virtual Order Item is virtual	Field ID`order_items/is_virtual` DimensionNUMBER
Order Item Name Order Item name	Field ID`order_items/name` DimensionTEXT
Order Item No Discount Order Item no discount	Field ID`order_items/no_discount` DimensionNUMBER
Order Item Order Id Order Item order id	Field ID`order_items/order_id` DimensionNUMBER
Order Item Original Price Order Item original price	Field ID`order_items/original_price` DimensionNUMBER
Order Item Price Order Item price	Field ID`order_items/price` DimensionNUMBER
Order Item Price Incl Tax Order Item price incl tax	Field ID`order_items/price_incl_tax` DimensionNUMBER
Order Item Product Id Order Item product id	Field ID`order_items/product_id` DimensionNUMBER
Order Item Product Type Order Item product type	Field ID`order_items/product_type` DimensionTEXT
Order Item Qty Canceled Order Item qty canceled	Field ID`order_items/qty_canceled` DimensionNUMBER
Order Item Qty Invoiced Order Item qty invoiced	Field ID`order_items/qty_invoiced` DimensionNUMBER
Order Item Qty Ordered Order Item qty ordered	Field ID`order_items/qty_ordered` DimensionNUMBER
Order Item Qty Refunded Order Item qty refunded	Field ID`order_items/qty_refunded` DimensionNUMBER
Order Item Qty Shipped Order Item qty shipped	Field ID`order_items/qty_shipped` DimensionNUMBER
Order Item Row Invoiced Order Item row invoiced	Field ID`order_items/row_invoiced` DimensionNUMBER
Order Item Row Total Order Item row total	Field ID`order_items/row_total` DimensionNUMBER
Order Item Row Total Incl Tax Order Item row total incl tax	Field ID`order_items/row_total_incl_tax` DimensionNUMBER
Order Item Row Weight Order Item row weight	Field ID`order_items/row_weight` DimensionNUMBER
Order Item Sku Order Item sku	Field ID`order_items/sku` DimensionTEXT
Order Item Store Id Order Item store id	Field ID`order_items/store_id` DimensionNUMBER
Order Item Tax Amount Order Item tax amount	Field ID`order_items/tax_amount` DimensionNUMBER
Order Item Tax Invoiced Order Item tax invoiced	Field ID`order_items/tax_invoiced` DimensionNUMBER
Order Item Tax Percent Order Item tax percent	Field ID`order_items/tax_percent` DimensionNUMBER
Order Item Updated At Order Item updated at	Field ID`order_items/updated_at` DimensionYEAR_MONTH_DAY_SECOND
Order Item Weight Order Item weight	Field ID`order_items/weight` DimensionNUMBER
Order Payment Method Payment Method	Field ID`orders/payment_method` DimensionTEXT
Order Protect Code Protect Code	Field ID`orders/protect_code` DimensionTEXT
Order Quote Id Quote Id	Field ID`orders/quote_id` DimensionNUMBER
Order Remote Ip Remote Ip	Field ID`orders/remote_ip` DimensionTEXT
Order Shipping Amount Shipping Amount	Field ID`orders/shipping_amount` DimensionNUMBER
Order Shipping Canceled Shipping Canceled	Field ID`orders/shipping_canceled` DimensionNUMBER
Order Shipping City Shipping City	Field ID`orders/shipping_city` DimensionTEXT
Order Shipping Country Code Shipping Country Code	Field ID`orders/shipping_country_code` DimensionTEXT
Order Shipping Discount Amount Shipping Discount Amount	Field ID`orders/shipping_discount_amount` DimensionNUMBER
Order Shipping Discount Tax Compensation Amount Shipping Discount Tax Compensation Amount	Field ID`orders/shipping_discount_tax_compensation_amount` DimensionNUMBER
Order Shipping Incl Tax Shipping Incl Tax	Field ID`orders/shipping_incl_tax` DimensionNUMBER
Order Shipping Invoiced Shipping Invoiced	Field ID`orders/shipping_invoiced` DimensionNUMBER
Order Shipping Method Shipping Method	Field ID`orders/shipping_method` DimensionTEXT
Order Shipping Refunded Shipping Refunded	Field ID`orders/shipping_refunded` DimensionNUMBER
Order Shipping Region Shipping Region	Field ID`orders/shipping_region` DimensionTEXT
Order Shipping Region Code Shipping Region Code	Field ID`orders/shipping_region_code` DimensionTEXT
Order Shipping Tax Amount Shipping Tax Amount	Field ID`orders/shipping_tax_amount` DimensionNUMBER
Order Shipping Tax Refunded Shipping Tax Refunded	Field ID`orders/shipping_tax_refunded` DimensionNUMBER
Order Status Status	Field ID`orders/status` DimensionTEXT
Order Store Currency Code Store Currency Code	Field ID`orders/store_currency_code` DimensionTEXT
Order Store Id Store Id	Field ID`orders/store_id` DimensionNUMBER
Order Store Name Store Name	Field ID`orders/store_name` DimensionTEXT
Order Store To Base Rate Store To Base Rate	Field ID`orders/store_to_base_rate` DimensionNUMBER
Order Store To Order Rate Store To Order Rate	Field ID`orders/store_to_order_rate` DimensionNUMBER
Order Subtotal Subtotal	Field ID`orders/subtotal` DimensionNUMBER
Order Subtotal Canceled Subtotal Canceled	Field ID`orders/subtotal_cancelled` DimensionNUMBER
Order Subtotal Incl Tax Subtotal Incl Tax	Field ID`orders/subtotal_incl_tax` DimensionNUMBER
Order Subtotal Invoiced Subtotal Invoiced	Field ID`orders/subtotal_invoiced` DimensionNUMBER
Order Subtotal Refunded Subtotal Refunded	Field ID`orders/subtotal_refunded` DimensionNUMBER
Order Tax Amount Tax Amount	Field ID`orders/tax_amount` DimensionNUMBER
Order Tax Canceled Tax Canceled	Field ID`orders/tax_canceled` DimensionNUMBER
Order Tax Invoiced Tax Invoiced	Field ID`orders/tax_invoiced` DimensionNUMBER
Order Tax Refunded Tax Refunded	Field ID`orders/tax_refunded` DimensionNUMBER
Order Total Canceled Total Canceled	Field ID`orders/total_cancelled` DimensionNUMBER
Order Total Due Total Due	Field ID`orders/total_due` DimensionNUMBER
Order Total Invoiced Total Invoiced	Field ID`orders/total_invoiced` DimensionNUMBER
Order Total Item Count Total Item Count	Field ID`orders/total_item_count` DimensionNUMBER
Order Total Offline Refunded Total Offline Refunded	Field ID`orders/total_offline_refunded` DimensionNUMBER
Order Total Online Refunded Total Online Refunded	Field ID`orders/total_online_refunded` DimensionNUMBER
Order Total Paid Total Paid	Field ID`orders/total_paid` DimensionNUMBER
Order Total Qty Ordered Total Qty Ordered	Field ID`orders/total_qty_ordered` DimensionNUMBER
Order Total Refunded Total Refunded	Field ID`orders/total_refunded` DimensionNUMBER
Order Updated At Updated At	Field ID`orders/updated_at` DimensionYEAR_MONTH_DAY_SECOND
Order Weight Weight	Field ID`orders/weight` 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 Magento

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