Shopify

Shopify

GroupFieldID Has Conversion Is FormulaTypeDescription
Dataslayer DimensionsHub Accounthub_account Dimension
Dataslayer DimensionsConnector nameconnector_name Dimension
TimeTodaytoday Dimension
TimeDateday Dimension
TimeMonthmonth Dimension
TimeYearyear Dimension
TimeWeek (Starting on Monday)week Dimension
TimeYear-Monthyear_month Dimension
TimeYear-Week (Starting on Monday)year_week Dimension
StoreStore IDstore_id Dimension
StoreStore Namestore_name Dimension
OrdersOrder IDorder_id Dimension
OrdersOrder nameorder_name Dimension
OrdersOrder noteorder_note Dimension
OrdersOrder tagsorder_tags Dimension
OrdersOrder Sales Channelorder_sales_channel Dimension
OrdersOrder creation dateorder_creation_date Dimension
OrdersOrder creation hourorder_creation_hour Dimension
OrdersOrder processed dateorder_processed_date Dimension
OrdersOrder processed hourorder_processed_hour Dimension
OrdersOrder updated dateorder_updated_date Dimension
OrdersOrder updated hourorder_updated_hour Dimension
OrdersOrder closed dateorder_closed_date Dimension
OrdersOrder closed hourorder_closed_hour Dimension
OrdersOrder cancelled dateorder_cancelled_date Dimension
OrdersOrder cancelled hourorder_cancelled_hour Dimension
OrdersOrder location IDorder_location Dimension
OrdersOrder location nameorder_location_name Dimension
OrdersOrder location address 1order_location_address_1 Dimension
OrdersOrder location address 2order_location_address_2 Dimension
OrdersOrder location cityorder_location_city Dimension
OrdersOrder location ziporder_location_zip Dimension
OrdersOrder location provinceorder_location_province Dimension
OrdersOrder location countryorder_location_country Dimension
OrdersOrder location country codeorder_location_country_code Dimension
OrdersOrder Shipping Address 1order_shipping_address_1 Dimension
OrdersOrder Shipping Address 2order_shipping_address_2 Dimension
OrdersOrder Shipping Phoneorder_shipping_phone Dimension
OrdersOrder Shipping Post Codeorder_shipping_post_code Dimension
OrdersOrder Shipping Cityorder_shipping_city Dimension
OrdersOrder Shipping Provinceorder_shipping_province Dimension
OrdersOrder Shipping Countryorder_shipping_country Dimension
OrdersOrder Billing Address 1order_billing_address_1 Dimension
OrdersOrder Billing Address 2order_billing_address_2 Dimension
OrdersOrder Billing Phoneorder_billing_phone Dimension
OrdersOrder Billing Post Codeorder_billing_post_code Dimension
OrdersOrder Billing Countryorder_billing_country Dimension
OrdersOrder Billing Provinceorder_billing_province Dimension
OrdersOrder Billing Cityorder_billing_city Dimension
OrdersOrder Fulfillment Origin Address 1order_fulfillment_origin_address_1 Dimension
OrdersOrder Fulfillment Origin Address 2order_fulfillment_origin_address_2 Dimension
OrdersOrder Fulfillment Origin Post Codeorder_fulfillment_origin_post_code Dimension
OrdersOrder Fulfillment Origin Country Codeorder_fulfillment_origin_country_code Dimension
OrdersOrder Fulfillment Origin Province Codeorder_fulfillment_origin_province_code Dimension
OrdersOrder Fulfillment Origin Cityorder_fulfillment_origin_city Dimension
OrdersOrder Currencyorder_currency Dimension
OrdersOrder emailorder_email Dimension
OrdersOrder Discount reasonorder_discount_reason Dimension
OrdersOrder Shipping Descriptionorder_shipping_description Dimension
OrdersOrder Fulfillment Statusorder_fulfillment_status Dimension
OrdersOrder Landing Siteorder_landing_site Dimension
OrdersUTM Campaignorder_utm_campaign Dimension
OrdersUTM Sourceorder_utm_source Dimension
OrdersUTM Mediumorder_utm_medium Dimension
OrdersUTM Contentorder_utm_content Dimension
OrdersUTM Termorder_utm_term Dimension
ProductsSKUproduct_sku Dimension
ProductsProduct IDproduct_id Dimension
ProductsVariant IDvariant_id Dimension
ProductsProduct Nameproduct_name Dimension
ProductsProduct Titleproduct_title Dimension
ProductsVariant Titlevariant_title Dimension
ProductsProduct Tagsproduct_tags Dimension
ProductsProduct Priceproduct_price_dim Dimension
ProductsProduct Vendorproduct_vendor Dimension
ProductsProduct Typeproduct_type Dimension
ProductsProduct Image URLproduct_image_url Dimension
ProductsVariant requires shippingvariant_requires_shipping Dimension
CustomersCustomer IDcustomer_id Dimension
CustomersCustomer First Namecustomer_first_name Dimension
CustomersCustomer Last Namecustomer_last_name Dimension
CustomersCustomer Emailcustomer_email Dimension
CustomersIs returning Customerorder_have_customer Dimension
CustomersCustomer typecustomer_type Dimension
CustomersCustomer accepts marketingcustomer_accepts_marketing Dimension
CustomersCustomer has verified emailcustomer_verified_email Dimension
CustomersCustomer currencycustomer_currency Dimension
CustomersCustomer Countrycustomer_country Dimension
CustomersCustomer Country Codecustomer_country_code Dimension
CustomersCustomer Provincecustomer_province Dimension
CustomersCustomer Citycustomer_city Dimension
CustomersCustomer address 1customer_address1 Dimension
CustomersCustomer address 2customer_address2 Dimension
CustomersCustomer Companycustomer_company Dimension
Marketing EventsEvent IDevent_id Dimension
Marketing EventsEvent typeevent_type Dimension
Marketing EventsEvent started atevent_started_at Dimension
Marketing EventsEvent ended atevent_ended_at Dimension
Marketing EventsEvent scheduled to end atevent_scheduled_to_end_at Dimension
Marketing EventsEvent currencyevent_currency Dimension
Marketing EventsEvent manage URLevent_manage_url Dimension
Marketing EventsEvent preview urlevent_preview_url Dimension
Marketing EventsEvent UTM campaign IDevent_utm_campaign Dimension
Marketing EventsEvent UTM sourceevent_utm_source Dimension
Marketing EventsEvent UTM mediumevent_utm_medium Dimension
Marketing EventsEvent UTM contentevent_utm_content Dimension
Marketing EventsEvent UTM termevent_utm_term Dimension
Marketing EventsEvent budget typeevent_budget_type Dimension
Marketing EventsEvent descriptionevent_description Dimension
Marketing EventsEvent marketing channelevent_marketing_channel Dimension
Marketing EventsEvent is paidevent_paid Dimension
Marketing EventsEvent referring domainevent_referring_domain Dimension
Marketing EventsEvent breadcrumb IDevent_breadcrumb_id Dimension
Marketing EventsEvent marketing activity IDevent_marketing_activity_id Dimension
SalesTotal Salesfinal_price Metric
SalesGross Salesgross_price Metric
SalesNet Salesnet_price Metric
SalesGross Profitgross_profit Metric
SalesDiscountsdiscounts Metric
SalesShippingshipping MetricThe total shipping price of the order, excluding discounts and returns, in shop and presentment currencies.
SalesRefundsrefunds Metric
SalesTotal Taxtotal_tax Metric
SalesAverage Order Valueaverage_order_value Metric
OrdersTotal Orderstotal_orders Metric
OrdersDifferent items ordereddifferent_items_ordered Metric
OrdersTotal items ordereditems_ordered Metric
ProductsProduct priceproduct_price Metric
ProductsProduct quantity in stockproduct_quantity_inventory Metric
ProductsProduct price in stockproduct_total_price Metric
ProductsInventory item costinventory_item_cost Metric
CustomersCustomer Countcustomer_count Metric
CustomersReturning Customer Ratecustomer_returning_rate Metric
Marketing EventsMarketing event budgetevent_budget Metric