Ecommerce Segment Conditions

```mediawiki

Ecommerce Segment Conditions

Overview

ActiveCampaign ecommerce segment conditions allow users to segment their contacts based on various ecommerce metrics. This feature is available with the following integrations:

• Shopify
• WooCommerce
• BigCommerce
• Square
• Custom 3rd party integrations

Important Notes

• The Square integration does not sync product category data.
• You must have at least one ecommerce integration connected to see ecommerce segment conditions in your account.

Available Ecommerce Segmenting Conditions

Only the following ecommerce segmenting conditions are available in Conditional Content:

• Contact’s total revenue
• Contact’s total number of orders
• Total number of products
• Price of last order
• Currency of last order
• Shipping method of last order
• Product count of last order
• ID of last product purchased
• Name of last product purchased
• Category of last product purchased

For Shopify and WooCommerce, you must run a historical sync before using the following segmentation options released on January 9, 2023:

• Product tag in last order
• Product tag in any order
• Sale product in last order
• Sale product in any order
• Product rating in last order
• Product rating in any order
• Product vendor in last order (Shopify Only)
• Product vendor in any order (Shopify Only)

Segment Conditions for All Ecommerce Integrations

Below are segment conditions available for Shopify, WooCommerce, BigCommerce, Square, and custom 3rd party ecommerce integrations.

Ecommerce Segment Condition Definitions

• Total revenue: Total amount of all completed purchases for a contact.
• Total orders: Total number of orders completed by a contact.
• Total products: Total number of products purchased by a contact.
• Last order date: Date of the most recent order completed by a contact.
• Last order price: Total price of the most recent order completed by a contact.
• Last order currency: Currency of the most recent order completed by a contact.
• Last order product count: Total number of products in the most recent order completed by a contact.
• Last product ID: ID of any product in the most recent order completed by the contact.
• Last product SKU: Product SKU in the most recent order completed by a contact.
• Last product name: Name of any product in the most recent order completed by a contact.
• Last product category: Category of the most recently added product in the most recent order completed by a contact. (Note: Square does not sync product category)
• Order date: Date of the order completed by a contact.
• Order time: Time of the order completed by a contact.
• Product name in Any Order: Searches for the product name in any order made by a contact.
• Product category in Any Order: Searches for contacts with at least one completed order that included a product with this product category. (Note: Square does not sync product category)
• Shipping method in Any Order: Searches for contacts who used this shipping method in a completed order.
• Currency in Any Order: Searches for contacts who had a completed order with this currency.
• Product ID in Any Order: Searches for contacts with at least one completed order that included a product with this product ID.
• Product SKU in Any Order: Searches for product SKU in any order completed by the contact.
• Has made a purchase: Searches for contacts who made 1 or more purchases from the selected store(s).
• Has not made a purchase: Searches for contacts who made 0 purchases from the selected store(s).
• Has opted into marketing: Searches for contacts who checked the “Accepts Marketing” checkbox.
• Has not opted into marketing: Searches for contacts who did not check the “Accepts Marketing” checkbox.
• Has used discount code: Searches for any contact from any store who have used the selected discount code in one or more orders. (Not available for BigCommerce)
• Has not used discount code: Searches for any contact who has not used a discount code in any order. (Not available for BigCommerce)

Segment Conditions for Shopify and WooCommerce Integrations

For Shopify and WooCommerce, you must run a historical sync before using the segmentation options released on January 9, 2023, listed in the Important Notes section.

Additional Ecommerce Segment Conditions

• Sale Product in Last Order: Searches for contacts with a product on sale in their last order.
• Product Average Rating in Last Order: Searches for contacts whose latest order has the Product Average Rating you specify.
• Product Vendor in Last Order (Shopify Only): Searches for contacts whose latest order has the Product Vendor you specify.
• Product Tag in Last Order: Searches for contacts whose latest order has the Product Tag you specify.
• Sale Product in Any Order: Searches for contacts with a product on sale in any order.
• Product Rating in Any Order: Searches for the specified Product Rating in any order completed by the contact.
• Product Vendor in Any Order (Shopify Only): Searches for the specified Product Vendor in any order completed by the contact.
• Product Tag in Any Order: Searches for the specified Product Tag in any order completed by the contact.
• Has abandoned cart: Searches for contacts with at least one abandoned cart from "any" or a specific connected store.
• Doesn't have abandoned cart: Searches for contacts with zero (0) abandoned carts.
• Has recovered abandoned cart: Searches for contacts with at least one recovered cart (a cart that was abandoned, then completed) from "any" or a specific connected store.
• Has not recovered abandoned cart: Searches for contacts who have zero (0) recovered carts.
• Total value of last abandoned cart: Searches for contacts whose latest abandoned cart has the value you specify.
• Product count of last abandoned cart: Searches for contacts whose latest abandoned cart has the number of items you specify.
• Product name in last abandoned cart: Searches for contacts whose latest abandoned cart included a product name that you specify.

Segment Conditions for Recurring Payments

Below are segment conditions for Recurring Payments available only for WooCommerce and API-connected stores only.

Requirements for WooCommerce Customers

• Ensure you are on version 2.6 or later of the WooCommerce integration.
• Install the Woo Subscriptions app in WooCommerce.

Ecommerce Segment Condition Definitions

• Recurring Payment - Anchor Date: Anchor dates are an optional add-on to Subscription Programs that set a day on which billing interval calculations should be made and schedule specific product ship dates.
• Recurring Payment - Billing Address City: Billing Address City.
• Recurring Payment - Billing Address Company: Billing Address Company.
• Recurring Payment - Billing Address Country: Billing Address Country.
• Recurring Payment - Billing Address Email: Billing Address Email.
• Recurring Payment - Billing Address First Name: Billing Address First Name.
• Recurring Payment - Billing Address Last Name: Billing Address Last Name.
• Recurring Payment - Billing Address Line 1: Billing Address Line 1.
• Recurring Payment - Billing Address Line 2: Billing Address Line 2.
• Recurring Payment - Billing Address Line 3: Billing Address Line 3.
• Recurring Payment - Billing Address Phone: Billing Address Phone.
• Recurring Payment - Billing Address Postal Codes: Billing Address Postal Codes.
• Recurring Payment - Billing Address Province: Billing Address Province.
• Recurring Payment - Billing Interval: How frequently the recurring payment is charged to the customer.
• Recurring Payment - Billing Interval Count: The amount of billing cycles remaining on the customer’s recurring payment.
• Recurring Payment - Cancel at Period End: If true, when the current period ends, recurring payment will not renew, recurring payment will be canceled.
• Recurring Payment - Cancelled Date: Date when a recurring payment was canceled.
• Recurring Payment - Currency: Currency used for recurring payment.
• Recurring Payment - Discount Amount: Any discounts used on the recurring payment.
• Recurring Payment - Email: Email address.
• Recurring Payment - Is Trial: Checks if a recurring payment is a trial, True or False.
• Recurring Payment - Last Payment Date: Date of last payment attempt.
• Recurring Payment - Last Payment Status: Status of most recent payment. (COMPLETED, DECLINED, PARTIALLY_REFUNDED, PENDING, or REFUNDED).
• Recurring Payment - Legacy Connection ID: Integer connection identifier matching the v3 DeepData Connection ID.
• Recurring Payment - Line Item Brand: A list of all brands (also known as vendors) across all line items in this recurring payment.
• Recurring Payment - Line Item Category: A list of all product categories across all line items in this recurring payment.
• Recurring Payment - Line Item Name: A list of all product names across all line items in this recurring payment.
• Recurring Payment - Line Item Sku: A list of all SKUs across all line items in this recurring payment.
• Recurring Payment - Line Item Store Primary ID: A list of all store primary IDs across all products in this recurring payment.
• Recurring Payment - Line Item Tag: A list of all tags across all line items in this recurring payment.
• Recurring Payment - Next Payment Date: Next date the customer will be billed.
• Recurring Payment - Note: Notes about the recurring payment.
• Recurring Payment - Origin Order ID: ID of the order that created this recurring payment.
• Recurring Payment - Payment Amount: The total amount per billing cycle, including taxes, discounts, and shipping.
• Recurring Payment - Payment Method: Method used for payment.
• Recurring Payment - Recurring Payment Status: Status of the Recurring Payment or Subscription. (PENDING, ACTIVE, PAUSED, EXPIRED, PAYMENT_FAILED, or CANCELLED).
• Recurring Payment - Renewal Date: The date when the recurring payment will next be billed for renewal.
• Recurring Payment - Shipping Address: Address details for shipping.
• Recurring Payment - Start Date: Recurring Payment start date.
• Recurring Payment - Store Created Date: Date the record was created in your store.
• Recurring Payment - Store External ID: A second identifier from the store, usually a key to some external system.
• Recurring Payment - Store Modified Date: Date the record was last modified in external service.
• Recurring Payment - Store Recurring Payment ID: ID of recurring payment in your store.
• Recurring Payment - Store's Customer ID: The identifier for the customer in the store.
• Recurring Payment - Tax Amount: The amount the customer pays in taxes each time they are billed.
• Recurring Payment - Total Cycles: Total number of times to run this billing cycle, 0 for infinite.

Segment Conditions for Browse Abandonment

Browse Abandonment segment conditions are available with the WooCommerce integration. They can be accessed in all segment builders in ActiveCampaign.

Ecommerce Segment Condition Definitions

• Abandonment date: Date the shopper's browsing session was abandoned.
• Browse session ID: Unique identifier for each browsing session.
• Email: Email address for the browser.
• Legacy connection ID: Unique identifier for connected integration.
• Max price: The highest price item in the browsing session.
• Max product view time: The longest time an individual product was browsed during the session.
• Minimum price: The lowest price item in the browsing session.
• Minimum product view time: The shortest time an individual product was browsed during the session.
• Product categories: The product categories that were browsed during the session.
• Product names: The product names that were browsed during the session.
• Product SKUs: The product SKUs that were browsed during the session.
• Product store primary IDs: Product ID in the store/system of record.
• Session length: The total length of the browsing session in seconds (from first product browsed to session abandonment).
• Session start date: The start date for the browsing session.
• Total amount: The total price for all of the products browsed during the browsing session.
• Total products viewed: The total product quantity count for the browsing session.

See Also

• ActiveCampaign Ecommerce Segment Conditions

```