Looking for an overview of default fields Revenue Conduit syncs to your CRM? Here are the fields we map for you automatically as part of your standard marketing system that comes with each free trial subscription.
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 Date – Type: Date - The date of the account creation is stored. (Ex. The account was created on 5/12/2016.)
Average Days Between Orders – Type: 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 Value – Type: 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 Date – Type: 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 Value – Type: 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 Date – Type: 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 Value – Type: 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 Orders – Type: Text Input - The total number of orders made by the customer is stored. (Ex. Customer no.1 has 29 orders).
Total Value of Orders – Type: 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 Amount – Type: 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 Amount – Type: 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 Rating – Type: 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 Rating – Type: 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 Rating – Type: 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 1 – Type: Text Input - The shipping address line 1 of the customer is stored.
Shipping Address Line 2 – Type: Text Input - The shipping address line 1 of the customer is stored.
Shipping City – Type: Text Input - The city of the shipping address of a customer is stored. (Ex. Customer no.1 city is Dorchester).
Shipping Country – Type: Text Input - The country of the shipping address of a customer is stored. (Ex. Customer no.1 country is United States).
Shipping Postal Code – Type: Text Input - where the postal code of the shipping address of a customer is stored. (Ex. Customer no.1 postal code is 02124).
Shipping State – Type: Text Input - The state of the shipping address of a customer is stored. (Ex. Customer no.1 state is Massachusetts).
Billing Address Line 1 – Type: Text Input - The billing address line 1 of the customer is stored.
Billing Address Line 2 – Type: Text Input - The billing address line 1 of the customer is stored.
Billing City – Type: Text Input - The city of the billing address of a customer is stored. (Ex. Customer no.1 city is Dorchester).
Billing Country – Type: Text Input - The country of the billing address of a customer is stored. (Ex. Customer no.1 country is United States).
Billing Postal Code – Type: Text Input - The postal code of the billing address of a customer is stored. (Ex. Customer no.1 postal code is 02124).
Billing State – Type: Text Input - The state of the billing address of a customer is stored. (Ex. Customer no.1 state is Massachusetts).
All Stores – Type: List box - All stores are stored. (Ex. Customer no.1 made its order from store1, store2 and store3).
Last Store – Type: 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 Offered – Type: Text Input - The coupon code offered by a certain automation is stored.
Coupon Codes Used – Type: 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 Used – Type: 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 Bought – Type: 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 Bought – Type: 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 Bought – Type: 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 Bought – Type: 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 HTML – Type: 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 Bought – Type: 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 Bought – Type: 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 Bought – Type: 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 Tags – Type: 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 Bought – Type: List box - All the SKU’s bought by the customer is stored. (Ex. Customer bought product101 and its SKU is 1003251).
Vendors Bought – Type: 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 Categories – Type: 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 Counter – Type: Text Input - The counter for abandoned cart is stored.
Abandoned Cart Date – Type: Date - The abandoned card date is stored. (Ex. Customer no.1 had its abandoned cart last 5/12/2016).
Abandoned Cart Products – Type: 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 HTML – Type: 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 URL – Type: 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 URL – Type: 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 Name – Type: 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 Price – Type: 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 URL – Type: 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 Name – Type: 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 Price – Type: 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 URL – Type: 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 URL – Type: 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 Name – Type: 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 Price – Type: 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 URL – Type: 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 Cart – Type: Dropdown - Your current abandoned cart is stored.
Total Number of Cart Products – Type: 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 Cart – Type: 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 Status – Type: 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 Number – Type: Text Input - The number of the last order is stored. (Ex. Customer no.1 last order number is 108261).
Last Order Shipment Date – Type: 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 Source – Type: 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 Status – Type: Dropdown - The status of the customer’s last order is stored. (Ex. Customer no.1 last order status is successful).
Last Order Tracking Number – Type: 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 URL – Type: 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 Orders – Type: 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 URL– Type: 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 Name – Type: 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 Price – Type: 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 URL – Type: 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 URL – Type: 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 Name – Type: 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 Price – Type: 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 URL – Type: 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 URL– Type: 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 Price – Type: 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 URL – Type: 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).