Follow

ActiveCampaign RC Settings: Settings & Fields Overview

Note: If the ActiveCampaign Fields you want to use in this feature are NOT showing up in Revenue Conduit, please click the Refresh Fields button in the top right corner and wait 1-2 minutes, then refresh the page. You may need to Logout of Revenue Conduit and log back in if they still aren’t refreshing. Here’s our full article on Refreshing Fields.

 

Shopping Cart

Account Creation DateType: Date - The date of the account creation is stored. (Ex. The account was created on 5/12/2016.

Average Days Between OrdersType: Text Input - The average days between orders made by the customers is stored. (Ex. The average days between the orders is 2 days, so every 2 days there will be orders.

Average Order ValueType: Text Input - The average order value made by the customer is stored. (Ex. Customer no.1 has an average order value of $250). 

First Order DateType: Date - The first order date of the customer is stored from the time you signed up in RC up to today. (Ex. The date 5/12/2016 where the customer made its first order). 

First Order ValueType: Text Input - The first order value of the customer is stored from the time you signed up in RC up to today. (Ex. The first order value of customer no.1 is $150.00). 

Last Order DateType: Date - The last order date of the customer is stored from the time you signed up in RC up to today. (Ex. The date 5/12/2016 where the customer made its last order). 

Last Order ValueType: Text Input - The last order value of the customer is stored from the time you signed up in RC up to today. (Ex. The last order value of customer no.1 is $150.00). 

Total Number of OrdersType: Text Input - The total number of orders made by the customer is stored. (Ex. Customer no.1 has 29 orders). 

Total Value of OrdersType: Text Input - The total value of orders made by the customer is stored. (Ex. Customer no.1 has a total of $1500.00 value of orders). 

New Lead Automation Conversion AmountType: Text Input - where the conversion amount under the new lead automation is stored. (Ex. Customer no.1 made $150.00 under the new lead automation). 

New Customer Automation Conversion AmountType: Text Input - The conversion amount under the new customer automation is stored. (Ex. Customer no.1 made $150.00 under the new customer automation). 

Monetary RatingType: Dropdown - The monetary rating 5-1 for each customer is stored. (Ex. Customer no.1 has the monetary rating of 1 which means the customer have a total order value of <$100.00. Note that you will be the one to set the desired equivalent for each rating). 

Order Frequency RatingType: Dropdown - The frequency rating 5-1 for each customer is stored. (Ex. Customer no.1 has the frequency rating of 1 which means the customer have a total number of orders of <=1. Note that you will be the one to set the desired equivalent for each rating). 

Order Recency RatingType: Dropdown - The recency rating 5-1 for each customer is stored. (Ex. Customer no.1 has the recency rating of 1 which means the customer last order was 361+ days ago. Note that you will be the one to set the desired equivalent for each rating). 

Shipping Address Line 1Type: Text Input - The shipping address line 1 of the customer is stored. 

Shipping Address Line 2Type: Text Input - The shipping address line 1 of the customer is stored. 

Shipping CityType: Text Input - The city of the shipping address of a customer is stored. (Ex. Customer no.1 city is Dorchester). 

Shipping CountryType: Text Input - The country of the shipping address of a customer is stored. (Ex. Customer no.1 country is United States). 

Shipping Postal CodeType: Text Input - where the postal code of the shipping address of a customer is stored. (Ex. Customer no.1 postal code is 02124). 

Shipping StateType: Text Input - The state of the shipping address of a customer is stored. (Ex. Customer no.1 state is Massachusetts). 

Billing Address Line 1Type: Text Input - The billing address line 1 of the customer is stored. 

Billing Address Line 2Type: Text Input - The billing address line 1 of the customer is stored. 

Billing CityType: Text Input - The city of the billing address of a customer is stored. (Ex. Customer no.1 city is Dorchester). 

Billing CountryType: Text Input - The country of the billing address of a customer is stored. (Ex. Customer no.1 country is United States). 

Billing Postal CodeType: Text Input - The postal code of the billing address of a customer is stored. (Ex. Customer no.1 postal code is 02124). 

Billing StateType: Text Input - The state of the billing address of a customer is stored. (Ex. Customer no.1 state is Massachusetts). 

All StoresType: List box - All stores are stored. (Ex. Customer no.1 made its order from store1, store2 and store3). 

Last StoreType: Dropdown - The last store is stored. (Ex. Customer made its order and the last time she made an order is from store1). 

Coupon Code X OfferedType: Text Input - The coupon code offered by a certain automation is stored. 

Coupon Codes UsedType: List box - The coupon codes that are used by the customers are stored. (Ex. Customer no.1 used the coupon code 20discount). 

Last Coupon Code UsedType: Text Input - The last coupon codes that was used by the customers is stored. (Ex. Customer no.1 last used this coupon code 10EasterSunday). 

Categories BoughtType: List box - The categories for certain products that were bought by the customer is stored. (Ex. Customer no.1 bought product 1 under category 1). 

Last Categories BoughtType: List box - The last categories for certain products that were bought by the customer is stored. (Ex. Customer no.1 bought its last product under category 1). 

Last Product BoughtType: Text Input - The last product bought by the customer is stored. (Ex. Customer no.1 bought its last product called product100). 

Last Product Types Bought Type: Multi Checkboxes - The type of the last product bought by the customer is stored. (Ex. Customer no.1 bought its last product and that product type is socks). 

Last Products BoughtType: Multi Checkboxes - The last products bought by the customer is stored. (Ex. Customer no.1 bought its last products called product100, produc101 and product102). 

Last Products Bought HTMLType: Text Area - The last products was bought in HTML by the customer is stored. (Ex. Customer no.1 bought its last products in HTML called product100, produc101 and product102). 

Last SKUs BoughtType: List box - The last SKU’s bought by the customer is stored. (Ex. Customer bought product101 and its SKU is 1003251). 

Last Total Number of Products Bought Type: Text Input - The total number of products bought by the customer is stored. (Ex. Customer no.1 last order was 5 product). 

Last Vendors BoughtType: List box - The last products bought by the vendor is stored. (Ex. Vendor no.1 bought its last products called product100, produc101 and product102). 

Product Types BoughtType: List box - The types of product bought by the customer is stored. (Ex. Customer no.1 bought several products with different product types like shirts, jeans and foot wear). 

Products Bought Type: List box - The products bought by the customer is stored. (Ex. Customer no.1 lifetime bought all these products product1, product2 and product3). 

Shopify Product TagsType: Multi Checkboxes - Shopify product tags are stored. (Ex. Customer no.1 bought product1 in a Shopify cart with the product tag of product_1). 

SKUs BoughtType: List box - All the SKU’s bought by the customer is stored. (Ex. Customer bought product101 and its SKU is 1003251). 

Vendors BoughtType: List box - All the products bought by the vendor is stored. (Ex. Vendor no.1 bought its all these products called product100, produc101 and product102). 

Abandoned Cart CategoriesType: List box - All the categories for abandoned cart is stored. (Ex. Customer no.1 has its product under category1 category2 and category3 for its abandoned cart). 

Abandoned Cart CounterType: Text Input - The counter for abandoned cart is stored. 

Abandoned Cart DateType: Date - The abandoned card date is stored. (Ex. Customer no.1 had its abandoned cart last 5/12/2016). 

Abandoned Cart ProductsType: List box - All the products for abandoned cart is stored. (Ex. Customer no.1 had product1, product2 and product3 for its abandoned cart). 

Abandoned Cart Products HTMLType: Text Area - The products in HTML for abandoned cart is stored. (Ex. Customer no.1 had its abandoned cart products in HTML called product100, produc101 and product102). 

Abandoned Cart URLType: Text Input - The URL for the abandoned cart is stored. (Ex. Customer no.1 had its abandoned cart and its url is http//:abandonedcart.com/abandoned-cart). 

Abandoned Product 1 Image URLType: Text Input - The image url of your first product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the first product has the image url of http://sampleimage.com/abandoned-cart). 

Abandoned Product 1 NameType: Text Input - The name of your first product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the first product name is Product101). 

Abandoned Product 1 PriceType: Text Input - The price of your first product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the price for its first product is $150.00). 

Abandoned Product 1 URLType: Text Input - The URL of your first product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the URL for its first product is of http://sampleproduct.com/abandoned-cart). 

Abandoned Product 2 Image URL Type: Text Input - The image url of your second product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the second product has the image url of http://sampleimage.com/abandoned-cart) 

Abandoned Product 2 NameType: Text Input - The name of your second product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the second product name is Product101). 

Abandoned Product 2 PriceType: Text Input - The price of your second product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the price for its second product is $150.00). 

Abandoned Product 2 URLType: Text Input - The URL of your second product in abandoned cart is stored. (Ex. Customer no.1 have 3 products on its abandoned cart and the URL for its second product is of http://sampleproduct.com/abandoned-cart). 

Abandoned Product 3 Image URLType: Text Input - The image url of your third product in abandoned cart is stored. (Ex. Customer no.1 have 4 products on its abandoned cart and the third product has the image url of http://sampleimage.com/abandoned-cart). 

Abandoned Product 3 NameType: Text Input - The name of your third product in abandoned cart is stored. (Ex. Customer no.1 have 4 products on its abandoned cart and the third product name is Product101). 

Abandoned Product 3 PriceType: Text Input - The price of your third product in abandoned cart is stored. (Ex. Customer no.1 have 4 products on its abandoned cart and the price for its third product is $150.00). 

Abandoned Product 3 URLType: Text Input - The URL of your third product in abandoned cart is stored. (Ex. Customer no.1 have 4 products on its abandoned cart and the URL for its third product is of http://sampleproduct.com/abandoned-cart). 

Current Abandoned CartType: Dropdown - Your current abandoned cart is stored. 

Total Number of Cart ProductsType: Text Input - The total number of cart products is stored. (Ex. Customer no.1 have a total of 17 abandoned cart products). 

Total Value of Abandoned CartType: Text Input - The total value of your abandoned cart is stored. (Ex. Customer no.1 made a total of $1500.00 for its abandoned cart). 

Last Order Fulfillment StatusType: Dropdown - The fulfillment status of the customer’s last order is stored. (Ex. Customer no. 1 had it its last order fulfillment status as success). 

Last Order NumberType: Text Input - The number of the last order is stored. (Ex. Customer no.1 last order number is 108261). 

Last Order Shipment DateType: Date - The shipment date of the customer’s last order is stored. (Ex. Customer no.1 made its last order and the shipment date was 5/12/2016). 

Last Order Shopify Order SourceType: Text Input - The order source with the shopify cart of the last order is stored. (Ex. Customer no.1 made its last order through the web). 

Last Order StatusType: Dropdown - The status of the customer’s last order is stored. (Ex. Customer no.1 last order status is successful). 

Last Order Tracking NumberType: Text Input - The tracking number of the customer’s last order is stored. (Ex. Customer no.1 made its last order with the tracking number 1653J6E230). 

Last Order Tracking URLType: Text Input - The tracking URL of the customer’s last order is stored. (Ex. Customer no.1 made its last order with the tracking URL http://tracking.com/track-lat-order). 

Total Number of Current OrdersType: Text Input - The total number of the current order is stored. (Ex. Customer no.1 have a total of 8 current orders). 

Last Products Bought Product 1 Image URLType: Text Input - The first image url of the last products bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the first product image url is http://sampleimage.com/product1). 

Last Products Bought Product 1 NameType: Text Input - The first product name of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the first product is named product1). 

Last Products Bought Product 1 PriceType: Text Input - The first product price of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the first product price is $150.00). 

Last Products Bought Product 1 URLType: Text Input - The first product url of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the first product url is http://sampleproduct.com/sample-url). 

Last Products Bought Product 2 Image URLType: Text Input - The second image url of the last products bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the second product image url is http://sampleimage.com/product1). 

Last Products Bought Product 2 NameType: Text Input - The second product name of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the second product is named product1). 

Last Products Bought Product 2 PriceType: Text Input - The second product price of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the second product price is $150.00). 

Last Products Bought Product 2 URLType: Text Input - The second product url of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the second product url is http://sampleproduct.com/sample-url). 

Last Products Bought Product 3 Image URLType: Text Input - The third image url of the last products bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the third product image url is http://sampleimage.com/product1). 

Last Products Bought Product 3 Name Type: Text Input - The third product name of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the third product is named product1). 

Last Products Bought Product 3 PriceType: Text Input - The third product price of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the third product price is $150.00). 

Last Products Bought Product 3 URLType: Text Input - The third product url of the last product bought by the customer is stored. (Ex. Customer no.1 have bought its last 3 products and the third product url is http://sampleproduct.com/sample-url).

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments