Shopify Field Reference

Sample

 

https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_7d&fields=order_id,order_current_total_price,order_email,order_updated_at&_renderer=csv

The Shopify connector lets you pull Shopify data on an object level (e.g. order, contact). If you specify the fields date_from and date_to it will filter for a date range in which the objects were created.

Sample query for order objects

https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_28d&fields=order_app_id,order_sales_channel,order_name,order_note,order_tags,order_cancelled_at,order_cancel_reason,order_closed_at,order_created_at,order_count,order_currency,order_current_total_discounts,order_total_discounts,order_total_discounts_set,order_current_total_price,order_current_subtotal_price,order_current_total_tax,order_total_price,order_email,order_financial_status,order_updated_at,order_line_items,order_fulfillable_quantity,order_shipping_address

Sample query for customer objects

https://connectors.windsor.ai/shopify?api_key=[your API key]&date_preset=last_28d&fields=customer_email,customer_created_at,customer_updated_at,customer_date,customer_first_name,customer_last_name,customer_state,customer_total_spent,customer_verified_email,customer_multipass_identifier,customer_tax_exempt,customer_phone,customer_currency,customer_id,customer_last_order_id,customer_last_order_name,customer_note,customer_orders_count,customer_tags&_renderer=powerbi

Fields

IDTypeNameDescriptionReport
account_idTEXTAccount IDShopify Account URL
account_nameTEXTAccount NameShopify Account URL
TEXTMarketing Event Breadcrumb IDThe breadcrumb ID of the event.marketing_event
budget_typeTEXTMarketing Event Budget TypeThe budget type of the event.marketing_event
customer_aovNUMERICCustomer Average Order ValueAverage order value is the average dollar amount customer spend each time an order is placed on your ecommerce website.customer
customer_created_atTIMESTAMPCustomer Created at (Timestamp)The date and time (ISO 8601 format) when the customer was created.customer
customer_currencyTEXTCustomer CurrencyThe three-letter code (ISO 4217 format) for the currency that the customer used when they paid for their last order. Defaults to the shop currency. Returns the shop currency for test orders.customer
customer_dateDATECustomer Created At (Date)The date and time (ISO 8601 format) when the customer information was last updated.customer
customer_default_addressOBJECTCustomer Default AddressThe customer's default address.customer
customer_emailTEXTCustomer E-Mail AddressThe unique email address of the customer. Attempting to assign the same email address to multiple customers returns an error.customer
customer_first_nameTEXTCustomer First NameThe customer's first name.customer
customer_idTEXTCustomer IDA unique identifier for the customer.customer
customer_last_nameTEXTCustomer Last NameThe customer's last name.customer
customer_last_order_idTEXTCustomer Last Order IDThe ID of the customer's last order.customer
customer_last_order_nameTEXTCustomer Last Order NameThe name of the customer's last order. This is directly related to the name field on the Order resource.customer
customer_multipass_identifierNUMERICCustomer Multipass IdentifierA unique identifier for the customer that's used with Multipass login.customer
customer_noteTEXTCustomer NoteA note about the customer.customer
customer_orders_countNUMERICCustomer Orders CountThe number of orders associated with this customer.customer
customer_phoneTEXTCustomer Phone NumberThe unique phone number (E.164 format) for this customer.customer
customer_stateTEXTCustomer stateThe state of the customer's account with a shop (Can be disabled, invited, enabled and declined)customer
customer_tagsTEXTCustomer TagsTags that the shop owner has attached to the customer, formatted as a string of comma-separated values.customer
customer_tax_exemptBOOLEANCustomer Tax ExemptWhether the customer is exempt from paying taxes on their order. If true, then taxes won't be applied to an order at checkout. If false, then taxes will be applied at checkout.customer
customer_total_spentNUMERICCustomer Total SpentThe total amount of money that the customer has spent across their order history.customer
customer_updated_atTIMESTAMPCustomer Updated at (Timestamp)The date and time (ISO 8601 format) when the customer information was last updated.customer
customer_verified_emailBOOLEANCustomer Email VerifiedWhether the customer has verified their email address.customer
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateThe date and time (ISO 8601 format) of the queried object.
day_of_monthTEXTDay of monthDay of the month
emailTEXTOrder EmailThe customers email address.orders
ended_atTIMESTAMPMarketing Ended AtThe event end datetime.marketing_event
event_typeTEXTMarketing Event TypeThe event type.marketing_event
line_item__discount_allocationsTEXTLine Item Discount AllocationsAn ordered list of amounts allocated by discount applications. Eachdiscount allocation is associated with a particular discount application.amount: The discount amount allocated to the line in the shop currency.discount_application_index: The index of the associated discount application in the order'sdiscount_applications list.amount_set: The discount amount allocated to the line item in shop and presentmentcurrencies.orders
line_item__dutiesTEXTLine Item DutiesA list of duty objects, each containing information about a duty on the line item.orders
line_item__fulfillable_quantityNUMERICLine Item Fulfillable QuantityThe amount available to fulfillorders
line_item__fulfillment_statusTEXTLine Item Fulfillment StatusHow far along an order is in terms line items fulfilled. Valid values:null, fulfilled, partial, and not_eligible.orders
line_item__gramsNUMERICLine Item GramsThe weight of the item in grams.orders
line_item__idTEXTLine Item IdThe ID of the line item.orders
line_item__nameTEXTLine Item NameThe name of the product variant.orders
line_item__priceNUMERICLine Item PriceThe price of the item before discounts have been applied in the shop currency.orders
line_item__product_idTEXTLine Item Product IdThe ID of the product that the line item belongs to. Can be null ifthe original product associated with the order is deleted at a later date.orders
line_item__propertiesTEXTLine Item PropertiesAn array of custom information for the item that has been added to the cart. Often used to provide product customization options.orders
line_item__quantityNUMERICLine Item QuantityThe number of items that were purchased.orders
line_item__refundable_quantityTEXTLine Item Refundable QuantityThe line item's quantity, minus the refunded quantity.orders
line_item__requires_shippingTEXTLine Item Requires ShippingWhether the item requires shipping.orders
line_item__skuTEXTLine Item SKUThe item's SKU (stock keeping unit).orders
line_item__tax_linesTEXTLine Item Tax LinesA list of tax line objects, each of which details a tax applied to the item.title: The name of the tax.price: The amount added to the order for this tax in the shop currency.price_set: The amount added to the order for this tax in shop and presentment currencies.rate: The tax rate applied to the order to calculate the tax price.channel_liable: Whether the channel that submitted the tax line is liable for remitting. Avalue of null indicates unknown liability for the tax line.orders
line_item__taxableTEXTLine Item TaxableWhether the item was taxable.orders
line_item__tip_payment_gatewayTEXTLine Item Tip Payment GatewayThe payment gateway used to tender the tip, such as shopify_payments. Present only on tips.orders
line_item__titleTEXTLine Item TitleThe title of the product.orders
line_item__total_discountNUMERICLine Item Total Discount SetThe total amount allocated to the line item in the shop currency. Instead of using this field, Shopify recommends using discount_allocations, which provides the sameinformation.orders
line_item__variant_available_for_saleBOOLEANLine Item Product Variant Available For SaleWhether the product variant is available for sale.orders
line_item__variant_barcodeTEXTLine Item Product Variant BarcodeThe value of the barcode associated with the product.orders
line_item__variant_compare_at_priceNUMERICLine Item Product Variant Compare At PriceThe compare-at price of the variant in the default shop currency.orders
line_item__variant_created_atTIMESTAMPLine Item Product Variant Created At DatetimeThe date and time when the variant was created.orders
line_item__variant_display_nameTEXTLine Item Product Variant Display NameDisplay name of the variant, based on product's title + variant's title.orders
line_item__variant_idTEXTLine Item Variant IDThe ID of the product variant.orders
line_item__variant_priceNUMERICLine Item Product Variant PriceThe price of the product variant in the default shop currency.orders
line_item__variant_sellable_online_quantityNUMERICLine Item Product Variant Sellable Online QuantityThe total sellable quantity of the variant for online channels. This doesn't represent the total available inventory or capture limitations based on customer location.orders
line_item__variant_selling_plan_group_countNUMERICLine Item Product Variant Selling Plan Group CountCount of selling plan groups associated with the product variant.orders
line_item__variant_tax_codeTEXTLine Item Product Variant Tax CodeThe tax code for the product variant.orders
line_item__variant_titleTEXTLine Item Variant TitleThe title of the product variant.orders
line_item__variant_unit_costNUMERICLine Item Product Variant Unit CostUnit cost associated with the inventory item. Note: the user must have 'View product costs' permission granted in order to access this field once product granular permissions are enabled.orders
line_item__variant_unit_cost_currencyTEXTLine Item Product Variant Unit Cost CurrencyCurrency of the money for unit cost associated with the inventory item.orders
line_item__variant_updated_atTIMESTAMPLine Item Product Variant Updated AtThe date and time (ISO 8601 format) when the product variant was last modified.orders
line_item__variant_weightNUMERICLine Item Product Variant WeightThe weight of the product variant in the unit system specified with weight_unit.orders
line_item__variant_weight_unitTEXTLine Item Product Variant Weight Unit (weight_unit)The unit of measurement that applies to the product variant's weight. If you don't specify a value for weight_unit, then the shop's default unit of measurement is applied. Valid values: g, kg, oz, lb.orders
line_item__vendorTEXTLine Item VendorThe name of the item's supplier.orders
manage_urlTEXTMarketing Event Manage URLThe manage URL of the event.marketing_event
marketing_activity_idTEXTMarketing Event Activity IDThe activity ID of the event.marketing_event
marketing_channelTEXTMarketing Event ChannelThe markerting channel of the event.marketing_event
marketing_event_budgetNUMERICMarketing Event BudgetThe budget of the event.marketing_event
marketing_event_currencyTEXTMarketing Event CurrencyThe currency of the event.marketing_event
marketing_event_descriptionTEXTMarketing Event DescriptionThe event description.marketing_event
marketing_event_paidBOOLEANMarketing Event PaidThe flag that indicates if an event is paid.marketing_event
monthTEXTMonthNumber of the month
order_app_idTEXTOrder App IDThe id of the application.orders
order_app_nameTEXTOrder App nameThe name of the application.orders
order_billing_addressTEXTOrder Billing AddressThe orders billing address.orders
order_billing_address_cityCITYOrder Billing Address CityThe orders billing address city.orders
order_billing_address_countryCOUNTRYOrder Billing Address CountryThe orders billing address country.orders
order_billing_matches_shippingBOOLEANOrder Billing Address Matches Shipping AddressWhether the billing address matches the shipping address.orders
order_can_mark_as_paidBOOLEANOrder Can Mark As PaidWhether the order can be manually marked as paid.orders
order_can_notify_customerBOOLEANOrder Can Notify CustomerWhether a customer email exists for the order.orders
order_cancel_reasonTEXTOrder Cancel ReasonThe reason why the order was canceled.orders
order_cancellation_staff_noteTEXTOrder Cancellation Staff NoteStaff provided note for the order cancellation.orders
order_cancelled_atTIMESTAMPOrder Cancelled AtThe date and time ( ISO 8601 format) when the order was canceled.orders
order_capturableBOOLEANOrder CapturableWhether payment for the order can be captured.orders
order_channel_handleTEXTOrder Channel HandleUnique string used as a public identifier for the channel definition associated with the channel that created the order.orders
order_client_ipTEXTOrder Client IPThe IP address of the API client that created the order.orders
order_closedBOOLEANOrder ClosedWhether the order is closed.orders
order_closed_atTIMESTAMPOrder Closed AtThe date and time (ISO 8601 format) when the order was closed.orders
order_confirmation_numberTEXTOrder Confirmation NumberA randomly generated alpha-numeric identifier for the order that may be shown to the customer instead of the sequential order name.orders
order_confirmedTEXTOrder ConfirmedWhether inventory has been reserved for the order.orders
order_countNUMERICOrder CountThe number of orders. Default value is 1, but for refunds, the value is zero.orders
order_created_atTIMESTAMPOrder Created AtThe autogenerated date and time (ISO 8601 format) when the order was created in Shopify. The value for this property cannot be changed.orders
order_currencyTEXTOrder CurrencyThe three-letter code (ISO 4217 format) for the shop currency.orders
order_current_discount_cartNUMERICOrder Current Discount CartThe current order-level discount amount after all order updates, in shop currency.orders
order_current_subtotal_line_items_quantityNUMERICOrder Current Subtotal Line Items QuantityThe current order-level discount amount after all order updates, in shop currency.orders
order_current_subtotal_priceNUMERICOrder Current Subtotal PriceThe current subtotal price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.orders
order_current_total_additional_fees_amountNUMERICOrder Current Total Additional Fees AmountThe total amount of additional fees after returns, in shop currency.orders
order_current_total_discountsNUMERICOrder Current Total DiscountsThe current total discounts on the order in the shop currency. The value of this field reflects order edits, returns, and refunds.orders
order_current_total_duties_amountNUMERICOrder Current Total Duties AmountThe total amount of duties after returns, in shop currency.orders
order_current_total_priceNUMERICOrder Current Total PriceThe current total price of the order in the shop currency. The value of this field reflects order edits, returns, and refunds.orders
order_current_total_taxNUMERICOrder Current Total TaxThe current total taxes charged on the order in the shop currency. The value of this field reflects order edits, returns, or refunds.orders
order_current_total_weightNUMERICOrder Current Total WeightThe total weight of the order after returns, in grams.orders
order_customer_idTEXTOrder Customer IDThe ID of the customer that placed the order.orders
order_customer_last_visit_sourceTEXTOrder Customer Last Visit SourceSource from which the customer visited the store, such as a platform (Facebook, Google), email, direct, a website domain, QR code, or unknown.orders
order_customer_last_visit_utm_campaignTEXTOrder Customer Last Visit UTM CampaignThe name of a marketing campaign gathered from the last customer visit (session) before an order is made.orders
order_customer_last_visit_utm_contentTEXTOrder Customer Last Visit UTM ContentThe name of a marketing content gathered from the last customer visit (session) before an order is made.orders
order_customer_last_visit_utm_mediumTEXTOrder Customer Last Visit UTM MediumThe name of a marketing medium gathered from the last customer visit (session) before an order is made.orders
order_customer_last_visit_utm_sourceTEXTOrder Customer Last Visit UTM SourceThe name of a marketing source gathered from the last customer visit (session) before an order is made.orders
order_customer_last_visit_utm_termTEXTOrder Customer Last Visit UTM TermThe name of a marketing term gathered from the last customer visit (session) before an order is made.orders
order_customer_number_of_ordersNUMERICOrder Customer Number Of OrdersThe number of orders that the customer has made at the store in their lifetime.orders
order_discount_codeTEXTOrder Discount CodeThe discount code used for the order.orders
order_discount_codesTEXTOrder Discount CodesThe discount codes used for the order.orders
order_editedBOOLEANOrder EditedWhether the order has had any edits applied.orders
order_emailTEXTOrder EmailThe customers email address.orders
order_estimated_taxesBOOLEANOrder Estimated TaxesWhether taxes on the order are estimated. This field returns false when taxes on the order are finalized and aren't subject to any changes.orders
order_financial_statusTEXTOrder Payment StatusThe status of payments associated with the order. Can only be set when the order is created.orders
order_fulfillableBOOLEANOrder FulfillableWhether there are line items that can be fulfilled. This field returns false when the order has no fulfillable line items.orders
order_fulfillable_quantityNUMERICOrder Fullfillable QuantityThe total number of units that can't be fulfilled. For example, if items have been refunded, or the item is not something that can be fulfilled, like a tip.orders
order_fulfillment_serviceTEXTOrder Fulfillment ServiceThe order fulfillment service.orders
order_fully_paidBOOLEANOrder Fully PaidWhether the order has been paid in full.orders
order_gross_salesNUMERICOrder Gross SalesThe order gross sales (before taxes, shipping, discounts, and returns).orders
order_has_timeline_commentBOOLEANOrder Has Timeline CommentWhether the merchant added a timeline comment to the order.orders
order_idTEXTOrder IDThe unique identifier of the orderorders
order_inventory_item_costNUMERICTotal inventory item cost of an orderTotal inventory item cost of an order.inventory_item
order_line_itemsOBJECTOrder Line ItemsThe line items of the order.orders
order_locationTEXTOrder Location Name (Deprecated)The fulfillment location that was assigned when the order was created.orders
order_merchant_editableBOOLEANOrder Merchant EditableWhether the order can be edited by the merchant. For example, canceled orders can’t be edited.orders
order_merchant_editable_errorsTEXTOrder Merchant Editable ErrorsA list of reasons why the order can't be edited. For example, `Canceled orders can't be edited`.orders
order_nameTEXTOrder nameThe name of the orderorders
order_net_salesNUMERICOrder Net SalesThe order net sales.orders
order_noteTEXTOrder noteAn optional note that a shop owner can attach to the order.orders
order_original_total_duties_amountNUMERICOrder Original Total Duties AmountThe total amount of duties before returns, in shop currency.orders
order_payment_gatewaysTEXTOrder Payment Methods (Gateways)A list of the names of all payment gateways used for the order.orders
order_physical_locationTEXTOrder Physical Location Name (Deprecated)The fulfillment location that was assigned when the order was created.orders
order_po_numberTEXTOrder PO NumberThe PO number associated with the order.orders
order_processed_atTIMESTAMPOrder Processed AtThe date and time when the order was processed.orders
order_product_priceNUMERICOrder Product PriceThe order price.orders
order_quantityNUMERICOrder QuantityThe order quantity.orders
order_refund_discrepancy_amountNUMERICOrder Refund Discrepancy AmountThe difference between the suggested and actual refund amount of all refunds that have been applied to the order. A positive value indicates a difference in the merchant's favor, and a negative value indicates a difference in the customer's favor.orders
order_refundableBOOLEANOrder RefundableWhether the order can be refunded.orders
order_refundsTEXTOrder RefundsId of refund assigned to the order.orders
order_refunds_netNUMERICAggregated Order Refunds Net(Equates to order_gross_sales - order_total_discounts - order_net_sales).orders
order_refunds_subtotalNUMERICOrder Refunds totalThe order total refunds.orders
order_refunds_total_taxNUMERICAggregated Order Refunds Total TaxThe total tax on the refund line items.orders
order_registered_source_urlTEXTOrder Registered Source URLThe URL of the source that the order originated from, if found in the domain registry.orders
order_requires_shippingBOOLEANOrder Requires ShippingWhether the order has shipping lines or at least one line item on the order that requires shipping.orders
order_restockableBOOLEANOrder RestockableWhether any line item on the order can be restocked.orders
order_return_statusTEXTOrder Return StatusThe order's aggregated return status for display purposes.orders
order_sales_channelTEXTOrder Sales Channel (A duplicate of `order_app_name`)The name of the application.orders
order_shipping_addressTEXTOrder Shipping AddressThe orders shipping address.orders
order_shipping_address_cityCITYOrder Shipping Address CityThe orders shipping address city.orders
order_shipping_address_countryCOUNTRYOrder Shipping Address CountryThe orders shipping address country.orders
order_source_identifierTEXTOrder Source IdentifierA unique POS or third party order identifier.orders
order_subtotal_priceNUMERICOrder Subtotal PriceThe sum of the prices for all line items after discounts and before returns, in shop currency. If taxesIncluded is true, then the subtotal also includes tax.orders
order_tagsTEXTOrder tagsTags attached to the orderorders
order_tax_exemptBOOLEANOrder Tax ExemptWhether taxes are exempt on the order.orders
order_taxes_includedBOOLEANOrder Taxes IncludedWhether taxes are included in the subtotal price of the order.orders
order_total_capturable_amountNUMERICOrder Total Capturable AmountThe authorized amount that's uncaptured or undercaptured, in shop currency. This amount isn't adjusted for returns.orders
order_total_discount_cartNUMERICOrder Total Discount CartThe total order-level discount amount, before returns, in shop currency.orders
order_total_discountsNUMERICOrder Total DiscountsThe total discounts applied to the price of the order in the shop currency.orders
order_total_discounts_setNUMERICOrder Total Discounts SetThe total discounts applied to the price of the order in shop currency. This includes both order and line level discounts.orders
order_total_outstanding_amountNUMERICOrder Total Outstanding AmountThe total amount not yet transacted for the order, in shop currency. A positive value indicates a difference in the merchant's favor (payment from customer to merchant) and a negative value indicates a difference in the customer's favor (refund from merchant to customer).orders
order_total_priceNUMERICOrder Total PriceThe sum of all line item prices, discounts, shipping, taxes, and tips in the shop currency. Must be positive.orders
order_total_tax_amountNUMERICOrder Total Tax AmountThe total tax amount before returns, in shop currency.orders
order_unpaidBOOLEANOrder UnpaidWhether no payments have been made for the order.orders
order_updated_atTIMESTAMPOrder Updated AtThe date and time (ISO 8601 format) when the order was last modified.orders
order_user_idTEXTOrder User IDThe ID of the user logged into Shopify POS who processed the order, if applicable.orders
preview_urlTEXTMarketing Event Preview URLThe preview URL of the event.marketing_event
product_created_at_datetimeTIMESTAMPProduct Created At DatetimeThe date and time the product was created.product
product_descriptionTEXTProduct DescriptionDescription of the product.product
product_handleTEXTProduct handleThe product handle.product
product_idTEXTProduct IDUnique identifier for the product.product
product_image_srcIMAGE_URLProduct Image URLThe image URL of the product.product
product_inventory_quantityNUMERICProduct Inventory QuantityThe product quantity in inventory.product
product_inventory_valueNUMERICProduct Inventory ValueThe sell value of the product inventory.product
product_priceNUMERICProduct PriceThe price of the product.product
product_published_atTIMESTAMPProduct published at datetimeThe date and time (ISO 8601 format) when the product was published. Can be null if unpublished.product
product_published_scopeTEXTProduct published scopeWhether the product is published to the Point of Sale channel (global) or not (web).product
product_statusTEXTProduct statusThe status of the product (active/archived/draft).product
product_tagsTEXTProduct TagsTags attached to the product.product
product_template_suffixTEXTProduct Template SuffixThe suffix of the Liquid template used for the product page.product
product_titleTEXTProduct TitleThe title of the product.product
product_typeTEXTProduct TypeThe type of the product.product
product_updated_at_datetimeTIMESTAMPProduct Updates At DatetimeThe date and time when the product was last modified. product
product_variant_barcodeTEXTProduct Variant BarcodeThe barcode, UPC, or ISBN number for the product.product
product_variant_compare_at_priceTEXTProduct Variant Compare At PriceThe original price of the item before an adjustment or a sale.product
product_variant_created_atTIMESTAMPProduct Variant Created AtThe date and time (ISO 8601 format) when the product variant was created.product
product_variant_fulfillment_serviceTEXTProduct Variant Fulfillment ServiceThe handle of a fulfillment service that stocks a product variant.product
product_variant_gramsNUMERICProduct Variant GramsThe weight of the product variant in grams.product
product_variant_idTEXTProduct Variant IDThe unique numeric identifier for the product variant.product
product_variant_inventory_item_idTEXTProduct Variant Inventory Item IDThe unique identifier for the inventory item, which is used in the Inventory API to query for inventory information.product
product_variant_inventory_managementTEXTProduct Variant Inventory ManagementThe fulfillment service that tracks the number of items in stock for the product variant.product
product_variant_inventory_policyTEXTProduct Variant Inventory PolicyWhether customers are allowed (continue) to place an order for the product variant when it's out of stock or not (deny).product
product_variant_option1TEXTProduct Variant Option 1The custom properties that a shop owner uses to define product variants. First option.product
product_variant_option2TEXTProduct Variant Option 2The custom properties that a shop owner uses to define product variants. Second option.product
product_variant_option3TEXTProduct Variant Option 3The custom properties that a shop owner uses to define product variants. Third option.product
product_variant_positionTEXTProduct Variant PositionThe order of the product variant in the list of product variants.product
product_variant_skuTEXTProduct Variant SKUA unique case-sensitive identifier for the product variant in the shop.product
product_variant_taxableBOOLEANProduct Variant Is TaxableWhether a tax is charged when the product variant is sold.product
product_variant_titleTEXTProduct Variant TitleThe title of the product variant.product
product_variant_updated_atTEXTProduct Variant Updated AtThe date and time when the product variant was last modified. Gets returned in ISO 8601 format.product
product_variant_weightNUMERICProduct Variant WeightThe weight of the product variant in the unit system specified with weight_unit (Product Variant Weight Unit).product
product_variant_weight_unitTEXTProduct Variant Weight UnitThe unit of measurement that applies to the product variant's weight.product
product_vendorTEXTProduct VendorThe vendor of the product.product
referring_domainTEXTMarketing Event Referring DomainThe referring domain of the event.marketing_event
remote_idTEXTMarketing Remote IDThe remote id.marketing_event
scheduled_to_end_atTIMESTAMPMarketing Event Scheduled To End AtThe scheduled end date of the event.marketing_event
skuTEXTVariant SKU numberThe product variant SKU number.orders
sourceTEXTSourceThe name of the Windsor connector returning the row
started_atTIMESTAMPMarketing Started AtThe event start datetime.marketing_event
todayDATETodayToday's date
utm_campaignTEXTMarketing Event UTM CampaignThe UTM campaign of the event.marketing_event
utm_mediumTEXTMarketing Event UTM MediumThe UTM medium of the event.marketing_event
utm_sourceTEXTMarketing Event UTM SourceThe UTM source of the event.marketing_event
variant_titleTEXTVariant TitleThe title of the product variant.orders
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20