Follow

Standard Fields for ESP Campaigns

WhatCounts takes the product, customer, and order data from your eCommerce platform and organizes it into fields to be used within your ESP. Fields are the ingredients needed to create segmented marketing campaigns. Because each field has a corresponding merge tag, they are also used to personalize messages with dynamic content.

Our data integration allows us to push either 30 or 70+ fields depending on your ESP. Our full list of standard fields is listed alphabetically below. 

Field Name Description
WC_Average_Actual The actual average order value of the customer (from their entire lifetime).
WC_Average_Rank A customer's RFM rank for their average order value (from their entire lifetime).
WC_Bill_Addr1 Line 1 of the address which the most recent order was billed.
WC_Bill_Addr2 Line 2 of the address which the most recent order was billed.
WC_Bill_BName The business name in the billing address.
WC_Bill_City The city to which the most recent order was billed.
WC_Bill_Country The country to which the most recent order was billed.
WC_Bill_FName The first name in the billing address.
WC_Bill_LName The last name in the billing address.
WC_Bill_State The state to which the most recent order was billed.
WC_Bill_Zip The ZIP code to which the most recent order was billed.
WC_Category_History The listing of all categories from which a customer has purchased.
WC_Coupon_History All coupons used by this customer ordered by date (from most recent to least recent).
WC_Customer_Key Customer ID
WC_First_Order_Date The actual date of the customer's very first order with your store (or first order processed by Windsor Circle).
WC_FirstName The customer's first name from their billing information.
WC_Frequency_Actual The actual number of purchases a customer has made in their lifetime.
WC_Frequency_Rank A customer's RFM rank for their frequency of purchases (from entire lifetime).
WC_HotCombo_Image For a "Hot Combo" product recommendation, this is the URL for the picture of the recommended product.
WC_HotCombo_Link For a "Hot Combo" product recommendation, this is the URL for the page of the recommended product.
WC_HotCombo_Price For a "Hot Combo" product recommendation, this is the price of the recommended product.
WC_HotCombo_Title For a "Hot Combo" product recommendation, this is the title of the recommended product.
WC_Last_Order_Coupon_Amt The amount discounted from coupons from the most recent order.
WC_Last_Order_Coupon_Code The coupon codes applied to the most recent order. Codes will be separated by a colon. For example, “THANKS5:COMEBACK15”.
WC_Last_Order_Disc_Amt The amount discounted (excluding coupons) from the most recent order.
WC_Last_Order_Disc_Type The discount types (excluding coupons) applied to the most recent order. Each type will be separated by a colon.
WC_Last_Order_Total The total purchase price of the last order. This includes discounts, but excludes taxes and shipping costs.
WC_Monetary_Actual The actual amount spent by the customer in their entire lifetime (customer lifetime value).
WC_Monetary_Rank A customer's RFM rank for their Monetary Value (the total amount spent in their lifetime).
WC_Most_Recent_Order The most recent order ID.
WC_Predicted_OrderDate Using the average amount of days between the customer's past orders, this field is the predicted date of this customer's next order. This field is available for retained customers only.
WC_Purchase_History The list of all products purchased in the customer's lifetime. Product names are separated by commas.
WC_Purchase_History_SKU The date and SKU for all products purchased in a customer's lifetime. PSKU can be optionally added to the list. All SKUs are separated by colons and dates separated by semicolons. Ex: ";20130826:mysku1:mysku2:mypsku1:mypsku2:;20130807:mysku3:mypsku3:"
WC_Purchase_History_Store For clients with multiple sources, this field provides information on the most recent purchase store, the previous purchase store, and all stores from which this customer has purchased. Ex: "MostRecent:mywebsite.com;Previous:Ebay;Stores:mywebsite.com:Ebay:myothersite.com"
WC_Purchased_Category The list of categories each product was purchased in from the most recent order.
WC_Purchased_Image The URL of the image of the highest priced item in the customer's most recent order.
WC_Purchased_Last_Order A list of all products purchased in the customer's most recent order. For example, ";ProductTitle1:SKU1;ProductTitle2:SKU2;"
WC_Purchased_Link The URL of the product page of the highest priced item in the customer's most recent order.
WC_Purchased_ReplenishDate The estimated date that the WC_Purchased_Title should be reordered. This date is calculated by the average number of days the product is reordered by your customers. This is only applicable for WC_Purchased_Titles that are found to be replenishable.
WC_Purchased_Title The title of the highest priced item in the customer's most recent order.
WC_Recency_Actual The actual date of customer's most recent purchase.
WC_Recency_Rank A customer's RFM rank for their Recency (the number of days since their last purchase).
WC_RelatedItems_Image1 For the first "Related Items" product recommendation, this is the URL for the picture of the recommended product.
WC_RelatedItems_Image2 For the second "Related Items" product recommendation, this is the URL for the picture of the recommended product.
WC_RelatedItems_Image3 For the third "Related Items" product recommendation, this is the URL for the picture of the recommended product.
WC_RelatedItems_Image4 For the fourth "Related Items" product recommendation, this is the URL for the picture of the recommended product.
WC_RelatedItems_Image5 For the fifth "Related Items" product recommendation, this is the URL for the picture of the recommended product.
WC_RelatedItems_Link1 For the first "Related Items" product recommendation, this is the URL for the listing of the recommended product.
WC_RelatedItems_Link2 For the second "Related Items" product recommendation, this is the URL for the listing of the recommended product.
WC_RelatedItems_Link3 For the third "Related Items" product recommendation, this is the URL for the listing of the recommended product.
WC_RelatedItems_Link4 For the fourth "Related Items" product recommendation, this is the URL for the listing of the recommended product.
WC_RelatedItems_Link5 For the fifth "Related Items" product recommendation, this is the URL for the listing of the recommended product.
WC_RelatedItems_Price1 For the first "Related Items" product recommendation, this is the price of the recommended product.
WC_RelatedItems_Price2 For the second "Related Items" product recommendation, this is the price of the recommended product.
WC_RelatedItems_Price3 For the third "Related Items" product recommendation, this is the price of the recommended product.
WC_RelatedItems_Price4 For the fourth "Related Items" product recommendation, this is the price of the recommended product.
WC_RelatedItems_Price5 For the fifth "Related Items" product recommendation, this is the price of the recommended product.
WC_RelatedItems_Title1 For the first "Related Items" product recommendation, this is the title of the recommended product.
WC_RelatedItems_Title2 For the second "Related Items" product recommendation, this is the title of the recommended product.
WC_RelatedItems_Title3 For the third "Related Items" product recommendation, this is the title of the recommended product.
WC_RelatedItems_Title4 For the fourth "Related Items" product recommendation, this is the title of the recommended product.
WC_RelatedItems_Title5 For the fifth "Related Items" product recommendation, this is the title of the recommended product.
WC_RFM_Score The combined (cumulative) score for Recency, Frequency and Monetary Rankings.
For example, R = 1, F = 2, M = 3 so RFM Score = 6
WC_Segments All customer segments that Windsor Circle has assigned. This is where custom segments may be accessed.
WC_Ship_Addr1 Line 1 of the address which the most recent order was shipped.
WC_Ship_Addr2 Line 2 of the address which the most recent order was shipped.
WC_Ship_City The city to which the most recent order was shipped.
WC_Ship_BName The business name in the shipping address.
WC_Ship_Country The country to which the most recent order was shipped.
WC_Ship_FName The first name in the shipping address.
WC_Ship_LName The last name in the shipping address.
WC_Ship_Method The method by which the most recent order was shipped.
WC_Ship_State The state to which the most recent order was shipped.
WC_Ship_Zip The ZIP code to which the most recent order was shipped.
WC_Source The source of purchase from Web Analytics. For example, ";Source:YYYMMDD; Source:YYYMMDD; Source:YYYMMDD;", Ex: ";Google Product Search:20120828;Google Organic:20120826;Direct:20120214;Google Organic:20111104;"
WC_Spend_Actual The actual value of the customer's single largest order from their entire lifetime.
WC_Spend_Rank A customer's RFM rank for Spend (the amount of the largest single order of their lifetime).
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk