Ecommerce Segments

```mediawiki

Ecommerce Segments

Overview

ActiveCampaign ecommerce segment conditions allow users to segment their contacts based on various ecommerce-related criteria. 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 Segment 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 one or more purchases from the selected store(s).
• Has not made a purchase: Searches for contacts who made zero 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. (Note: Not available for BigCommerce)
• Has not used discount code: Searches for any contact who has not used a discount code in any order. (Note: 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 above.

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 specified Product Average Rating.
• Product Vendor in Last Order (Shopify Only): Searches for contacts whose latest order has the specified Product Vendor.
• Product Tag in Last Order: Searches for contacts whose latest order has the specified Product Tag.
• 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 abandoned carts.
• Has recovered abandoned cart: Searches for contacts with at least one recovered cart.
• Has not recovered abandoned cart: Searches for contacts who have zero recovered carts.
• Total value of last abandoned cart: Searches for contacts whose latest abandoned cart has the specified value.
• Product count of last abandoned cart: Searches for contacts whose latest abandoned cart has the specified number of items.
• Product name in last abandoned cart: Searches for contacts whose latest abandoned cart included a specified product name.

Segment Conditions for Recurring Payments

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

Requirements for WooCommerce Customers

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

Recurring Payment Segment Condition Definitions

• Recurring Payment - Anchor Date: Optional add-on to Subscription Programs for billing interval calculations.
• 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: Frequency of recurring payment charges.
• Recurring Payment - Billing Interval Count: Remaining billing cycles.
• Recurring Payment - Cancel at Period End: Indicates if the recurring payment will not renew.
• 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: Indicates if a recurring payment is a trial.
• Recurring Payment - Last Payment Date: Date of last payment attempt.
• Recurring Payment - Last Payment Status: Status of most recent payment.
• Recurring Payment - Legacy Connection ID: Integer connection identifier.
• Recurring Payment - Line Item Brand: List of all brands across all line items.
• Recurring Payment - Line Item Category: List of all product categories across all line items.
• Recurring Payment - Line Item Name: List of all product names across all line items.
• Recurring Payment - Line Item SKU: List of all SKUs across all line items.
• Recurring Payment - Line Item Store Primary ID: List of all store primary IDs across all products.
• Recurring Payment - Line Item Tag: List of all tags across all line items.
• Recurring Payment - Next Payment Date: Next billing date.
• 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: Total amount per billing cycle.
• Recurring Payment - Payment Method: Method used for payment.
• Recurring Payment - Shipping Address: Various fields related to shipping address.
• 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: Identifier from the store.
• Recurring Payment - Store Modified Date: Date the record was last modified.
• Recurring Payment - Store Recurring Payment ID: ID of recurring payment in your store.
• Recurring Payment - Store's Customer ID: Identifier for the customer in the store.
• Recurring Payment - Store's Recurring Payment Status: Status of the Recurring Payment.
• Recurring Payment - Tax Amount: Amount paid in taxes.
• Recurring Payment - Total Cycles: Total number of billing cycles.

Segment Conditions for Browse Abandonment

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

Browse Abandonment Segment Condition Definitions

• Abandonment date: Date the 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: Highest price item in the browsing session.
• Max product view time: Longest time an individual product was browsed.
• Minimum price: Lowest price item in the browsing session.
• Minimum product view time: Shortest time an individual product was browsed.
• Product categories: Product categories browsed during the session.
• Product names: Product names browsed during the session.
• Product SKUs: Product SKUs browsed during the session.
• Product store primary IDs: Product ID in the store/system of record.
• Session length: Total length of the browsing session in seconds.
• Session start date: Start date for the browsing session.
• Total amount: Total price for all products browsed.
• Total products viewed: Total product quantity count for the browsing session.

See Also

ActiveCampaign Help Article ```