1. ActiveCampaign Help Center
  2. Ecommerce
  3. Working with Ecommerce

ActiveCampaign ecommerce segment conditions

Avatar
Sarah N
Last updated

Marketing_Plus_Professional_Enterprise

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

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

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

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

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

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.
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 the 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 whether 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 where the sale came from
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 is made up of 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)		 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)		 Last date at which the customer updated their SMS consent. 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

 

  SMS fields do not sync from WooCommerce to ActiveCampaign.

Related to:

Was this article helpful?
6 out of 11 found this helpful

Have more questions? Submit a request

Start free trial