Editing Ecommerce Segment Conditions (section)

= 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 ==
* [https://help.activecampaign.com/hc/en-us/articles/115001172204-ActiveCampaign-ecommerce-segment-conditions ActiveCampaign Ecommerce Segment Conditions]
```