ActiveCampaign ecommerce segment conditions

Sarah N

Last updated August 06, 2024 22:46

Marketing_Plus_Professional_Enterprise

In this article, you'll learn about ecommerce segmenting conditions available with the following integrations:

Shopify
WooCommerce
BigCommerce
Square
Custom 3rd party

Take Note

Square integration does not sync product category data
Only the following ecommerce segmenting conditions are available in Conditional Content:
- - Contact’s total revenue
  - Contact’s total # of orders
  - Total # 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	Definition
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 (Square does not sync product category)	Category of the most recently added product in the most recent order completed by a contact.
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 (Square does not sync product category)	Searches for contacts with at least 1 completed order that included a product with this 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 1 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). Will be able to filter by any connected Ecommerce store.
Has not made a purchase	Searches for contacts who made 0 purchases from the selected store(s). Will be able to filter by any connected Ecommerce store.
Has opted into marketing	Searches for contacts who checked the “Accepts Marketing” checkbox. Will be able to filter by any connected Ecommerce store.
Has not opted into marketing	Searches for contacts who did not check the “Accepts Marketing” checkbox. This will include contacts who were not added to your account via the Ecommerce integration. Will be able to filter by any connected Ecommerce store.
Has used discount code (Not available for BigCommerce)	Searches for any contact from any store who have used the selected discount code in one or more orders. The discount code does not show up until an order has been made with the code.
Has not used discount code (Not available for BigCommerce)	Searches for any contact who has not used a discount code in any order. This will include contacts who were not synced into ActiveCampaign from an Ecommerce integration. The discount code does not show up until an order has been made with the code.

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 Take Note section.

Below are segment conditions available for only Shopify, WooCommerce, and custom 3rd party ecommerce integrations. The conditions listed below are in addition to all segment conditions listed in the section above.

Ecommerce segment condition	Definition
Sale Product in Last Order	Searches for contacts who had 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 who had 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 connected Shopify/WooCommerce store or a connected specific Shopify/WooCommerce store. Will be able to filter by any connected Ecommerce store.
Doesn't have abandoned cart	Will look for contacts who have zero (0) abandoned carts. This includes contacts who: Did not abandon a cart AND never made any purchases. (Will include contacts who do not have any Ecommerce data) Did not abandon cart AND made 1 or more purchases from any connected Shopify/WooCommerce or a specific connected Shopify/WooCommerce store Will be able to filter by any connected Ecommerce store.
Has recovered abandoned cart	Searches for contacts with at least one recovered cart (a cart that was abandoned, then completed) from any connected Shopify/WooCommerce store or a specific Shopify/WooCommerce store. Will be able to filter by any connected Ecommerce store.
Has not recovered abandoned cart	Will look for contacts who have zero (0) recovered carts. This includes contacts who: Did not recover any carts AND never made any purchases (this includes contacts that do not have any ecommerce data) Did not recover any carts AND made 1 or more purchases Did not recover any carts AND abandoned at least 1 cart Did not recover any carts AND abandoned no carts Will be able to filter by any connected Ecommerce store.
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 included a product name that you specify.

The segment conditions below are also available for Shopify, WooCommerce, and custom third-party ecommerce integrations.

These conditions can be used in automations with the following triggers only:

Order Created
Order Updated
Recurring Payment Created
Recurring Payment Updated

Ecommerce segment condition	Definition
Order - Order status	Status of the order in ActiveCampaign. Order status must be one of the following: Pending, Completed, Abandoned, Recoverd, Waiting, Canceled, Refunded, Failed, or Returned.
Order - Connection Id	The globally unique identifier for integration to ActiveCampaign.
Order - Store's Order Id	The ID of the order in your store. ActiveCampiagn uses this as a primary identifier within a connection to know if an order you are sending is a new order or an updated order. This must be unique per connection ID. If an update operation is sent using an order ID that already exists, we will override the existing order, not create a new one.
Order - Order Number	The order number in your store. Generally, an order number is an easily readable number such as 1001, whereas a Store Order ID might be a globally unique identifier that requires technology to read.
Order - Cart ID	The ID of the cart associated with your order in your store.
Order - Store’s External Order ID	If your store has an external order ID, store it here. For example, if you are a WooCommerce store that dropships Amazon orders, your WooCommerce order ID will be the Store’s Order ID, but the Amazon Order ID will be the Store’s External Order ID.
Order - Creation Source	Whether the order was synced via active or historical syncing. The value must either be HISTORICAL or REAL_TIME.
Order - Email	Customer Email associated with the order. This email will be the email associated with the ActiveCampaign contact created for the order.
Order - Store’s customer ID	the ID for the customer in your store
Order - Store Created Date	When the order was created in your store. Must be in the format “2019-11-16T10:48:23Z”.
Order - Store Modified Date	The most recent date the order was updated in your store. Must be in the format “2019-11-16T10:48:23Z”.
Order - Store Status	Status of the order in your store.
Order - Notes	A list of notes assigned to this order.
Order - Location ID	ID for the store location.
Order - Shipping Method	Shipping method of the order.
Order - Order URL	URL for the order record in your store.
Order - Is Test Order	If true, this is a test order. If false or not set, this is a normal order.
Order - Accepts Marketing	If the customer opted into marketing.
Order - Customer Locale	Language & global region. This must be in the format EN_US (in this example, American English).
Order - Channel	Channel from where the sale came.
Order - Final Amount	Total order amount, expressed as a decimal number.
Order - Discounts amount	Total amount of any discounts applied to the order, expressed as a decimal number.
Order - Shipping Amount	Total amount charged for shipping on the order, expressed as a decimal number.
Order - Payment Method	Method used for payment.
Order - Shipping Address First Name	First name on shipping address.
Order - Shipping Address Last Name	Last name on shipping address.
Order - Shipping Address line 1	Shipping Address line 1.
Order - Shipping Address line 2	Shipping Address line 2.
Order - Shipping Address line 3	Shipping Address line 3.
Order - Shipping Address city	Shipping Address City.
Order - Shipping Address province	Shipping Address Province.
Order - Shipping Address country	Shipping Address Country.
Order - Shipping Address postal (zip code)	Shipping Address Postal (zip code).
Order - Shipping Address phone	Shipping Address Phone.
Order - Shipping Address company	Shipping Address Company.
Order - Shipping Address email	Shipping Address Email.
Order - Billing Address First Name	Billing Address First Name.
Order - Billing Address Last Name	Billing Address Last Name.
Order - Billing Address line 1	Billing Address line 1.
Order - Billing Address line 2	Billing Address line 2.
Order - Billing Address line 3	Billing Address line 3.
Order - Billing Address city	Billing Address City.
Order - Billing Address province	Billing Address Province.
Order - Billing Address country	Billing Address Country.
Order - Billing Address postal (zip code)	Billing Address Postal (zip code).
Order - Billing Address phone	Billing Address Phone.
Order - Billing Address company	Billing Address Company.
Order - Billing Address email	Billing Address Email.
Order - Discounts	A list of discounts. A discount comprises a Discount Code, Discount Amount, and Discount Type. Discount Code is a string such as “NEW50” that comes from your store. Discount Amount is a decimal representation of the amount discounted. Discount Type must be either SHIPPING or ORDER.
Order - SMS Marketing State (Shopify Only)	Whether the customer has opted in for SMS messaging. This field can only be written to; the data will be saved on the customer object. In order to read this field, use ActiveCampaign v3 API. Must be either NOT_SUBSCRIBED, PENDING, REDACTED, SUBSCRIBED, or UNSUBSCRIBED.
Order - SMS Opt In Level (Shopify Only)	The level at which the customer has opted in for SMS messaging. This field can only be written to; the data will be saved on the customer object. In order to read this field, use ActiveCampaign v3 API. Must be either CONFIRMED_OPT_IN, SINGLE_OPT_IN, or UNKNOWN.
Order - SMS Consent Updated Date (Shopify Only)	The last date the customer updated their SMS consent. This field can only be written to; the data will be saved on the customer object. To read this field, use the ActiveCampaign v3 API.

SMS fields do not sync from WooCommerce to ActiveCampaign.

Segment conditions for Recurring Payments

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

For WooCommerce customers:

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

The conditions listed below are in addition to all segment conditions listed in the section above. These conditions can only be used with the following automation in automations with the following triggers:

Order Created
Order Updated
Recurring Payment Created
Recurring Payment Updated

Ecommerce segment condition	Definition
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. The store primary ID is the primary and unique identifier for a product within the store.
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 Expiration	Date when the payment method for this recurring payment will expire (defaults to the 1st day of the month).
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 Line 1	Shipping Address Line 1.
Recurring Payment - Shipping Address Address Line 2	Shipping Address Line 2.
Recurring Payment - Shipping Address Address Line 3	Shipping Address Line 3.
Recurring Payment - Shipping Address City	Shipping Address City.
Recurring Payment - Shipping Address Company	Shipping Address Company.
Recurring Payment - Shipping Address Country	Shipping Address Country.
Recurring Payment - Shipping Address Email	Shipping Address Email.
Recurring Payment - Shipping Address First Name	Shipping Address First Name.
Recurring Payment - Shipping Address Last Name	Shipping Address Last Name.
Recurring Payment - Shipping Address Phone	Shipping Address Phone.
Recurring Payment - Shipping Address Postal Codes	Shipping Address Postal.
Recurring Payment - Shipping Address Province	Shipping Address Province.
Recurring Payment - Shipping Amount	Total amount 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. Within a connection, this serves as the primary identifier of this recurring payment record.
Recurring Payment - Store's Customer ID	The identifier for the customer in the store.
Recurring Payment - Store's Recurring Payment Status	Store’s Recurring Payment status. See a list of store statuses and how they map to ActiveCampaign.
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 (e.g. only bill customer 10 times, then stop).