Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field

Description

achAccountNumber

Customer’s banking account number (If paySource = CHECK)

achAccountType

Checking account type (‘Checking’ or ’Savings’) (If paySource = CHECK)

achRoutingNumber

Customer’s banking routing number (If paySource = CHECK)

acquisitionDate

The date the partial record was created

address1

Line 1 of the customer’s billing address

address2

Line 2 of the customer’s billing address

agentName

Name of the agent that completed the sale

agentNote

The most recent agent note added to the customer’s profile. If the customer type is New Sale, Upsell, Partial, or Decline, it is the agent note at time of order instead.

ani

The phone number that the sales call originated from

basePrice

The base price of the product

callTime

If the order was place via Order Entry, this will be the time the agent spent with the customer before the Sale or Disposition

campaignId

The numerical value assigned to the campaign the order came through on

campaignName

The assigned name of the campaign the order came through on

cancelReason

Reason the order was cancelled

cardExpiryDate

The customer’s card expiration date (MM/YY)

cardLast4

Last 4 digits of the card number

cardMonth

The month the customer’s card expires

cardType

The brand of the card (Visa, MasterCard, American Express, Discover, etc)

cardYear

The year the customer’s card expires

chargebackAmount

The amount chargebacked

chargebackDate

The date of the chargeback

chargebackNote

Notes assigned to the chargeback

chargebackReasonCode

Reason code assigned to the chargeback

city

The customer’s billing city

clientOrderId

The unique id assigned to an order

clientProductId

The Client ID value assigned to a base product. First item on the order.

clientPurchaseId

The unique id assigned to a subscription

clientTxnId

The unique id assigned to a transaction

For a refund or void this is the id of the original sale. If the actual id of the refund or void is needed then use refundClientTxnId.

clubDisplayName

Display name of the membership club product

clubName

The title of the Membership Club plugins

clubPassword

Value specific to Membership Club plugins

clubProductName

Base product name of the membership club product

clubUsername

Value specific to Membership Club plugins

contactOptIn

Boolean (‘1’ or ‘0’), represents if the customer has agreed to be contacted via Email and SMS

country

The customer’s billing country

couponCode

The coupon code the customer used on the order

currencyCode

Currency the customer used to pay for the order

custom1

The custom1 value passed in on Import Lead API or Import Order API

custom2

The custom2 value passed in on Import Lead API or Import Order API

custom3

The custom3 value passed in on Import Lead API or Import Order API

custom4

The custom4 value passed in on Import Lead API or Import Order API

custom5

The custom5 value passed in on Import Lead API or Import Order API

customerId

The unique customerId assigned to a customer

customerType

The customer type that triggered the Export Profile. This is configured in the Export Routing Section.

customFields

The data passed in via a campaign’s custom field. Will list all custom field values separated by commas

dateCreated

The date the order was created

dateRefunded

The date the refund was issued

declineReason

Decline reason returned by the processor

dnis

The phone number that was dialed

dob

The customer’s date of birth

doNotSellName

Boolean (‘1’ or ‘0’), represents if the customer is on your Do Not Sell list

emailAddress

The customer’s email address

firstName

The first name of the customer

fulfillmentStatus

Will send the fulfillment status for the fulfillment record (Hold, Pending, Pending Shipment, Shipped, Delivered, Cancelled, RMA Pending, Returned)

fullName

The full name of the customer

gatewayTitle

The title of the gateway

gender

The customer’s gender (Male or Female)

hasUpsells

Boolean (‘1’ or ‘0’), represents if the customer purchased any upsells on the order

ipAddress

The customer’s IP Address that was passed in for the order

lastName

The last name of the customer

marketingOptIn

memberId

Value specific to Membership Club plugins

nextBillDate

The next bill date of the subscription

offerSku

The SKU assigned to the product

orderCustomFields

Custom fields assigned to an order

orderId

The numeric id assigned to an order

orderStatus

Status of the order (Partial, Complete, Pending, Declined, Refunded)

orderTotal

The total price of the order, without upsells

originalClientOrderId

The initial unique id assigned to a subscription

originalOrderId

The initial numeric id assigned to a subscription

paySource

The pay source the customer used ('CREDITCARD','CHECK','ACCTONFILE','COD','PREPAID','APPLEPAY','GOOGLEPAY')

paySourceId

Pay Source ID used on the transaction

phoneNumber

The customer’s phone number

postalCode

The customer’s billing postal code

product1_billingCycleNumber

The current billing cycle the product1 purchase is on

product1_campaignProductId

The numerical value of the product1 offer listed inside the campaign

product1_crmId

The base product ID of the first item in the order

product1_description

Product Description set on the base product

product1_externalId

The external id of the product (Shopify, BigCommerce, etc…)

product1_id

The external or 3rd party Client ID of the base product of the first item in the order

product1_name

The assigned name of the product1 base product

product1_price

The price the customer paid for the current billing cycle for product1

product1_productCategoryId

The numerical value of the product category of the product1 offer

product1_productCategoryName

The name of the product category of the product1 offer

product1_qty

The quantity of the product1 offer that the customer purchased

product1_recurringstatus

If the offer is a recurring order, will send the purchase status for the product1 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)

product1_sku

The SKU for the product1 base product

product2_billingCycleNumber

The current billing cycle the product2 purchase is on

product2_campaignProductId

The numerical value of the product2 offer listed inside the campaign

product2_crmId

The base product ID of the second item in the order

product2_description

Product Description set on the base product

product2_externalId

The external id of the product (Shopify, BigCommerce, etc…)

product2_id

The external or 3rd party Client ID of the base product of the second item in the order

product2_name

The assigned name of the product2 base product

product2_price

The price the customer paid for the current billing cycle for product2

product2_productCategoryId

The numerical value of the product category of the product2 offer

product2_productCategoryName

The name of the product category of the product2 offer

product2_qty

The quantity of the product2 offer that the customer purchased

product2_recurringstatus

If the offer is a recurring order, will send the purchase status for the product2 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)

product2_sku

The SKU for the product2 base product

product3_billingCycleNumber

The current billing cycle the product3 purchase is on

product3_campaignProductId

The numerical value of the product3 offer listed inside the campaign

product3_crmId

The base product ID of the third item in the order

product3_description

Product Description set on the base product

product3_externalId

The external id of the product (Shopify, BigCommerce, etc…)

product3_id

The external or 3rd party Client ID of the base product of the third item in the order

product3_name

The assigned name of the product3 base product

product3_price

The quantity of the product3 offer that the customer purchased

product3_productCategoryId

The numerical value of the product category of the product3 offer

product3_productCategoryName

The name of the product category of the product3 offer

product3_qty

The quantity of the product3 offer that the customer purchased

product3_recurringstatus

If the offer is a recurring order, will send the purchase status for the product3 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)

product3_sku

The SKU for the product3 base product

product4_billingCycleNumber

The current billing cycle the product4 purchase is on

product4_campaignProductId

The numerical value of the product4 offer listed inside the campaign

product4_crmId

The base product ID of the forth item in the order

product4_description

Product Description set on the base product

product4_externalId

The external id of the product (Shopify, BigCommerce, etc…)

product4_id

The external or 3rd party Client ID of the base product of the forth item in the order

product4_name

The assigned name of the product4 base product

product4_price

The price the customer paid for the current billing cycle for product4

product4_productCategoryId

The numerical value of the product category of the product4 offer

product4_productCategoryName

The name of the product category of the product4 offer

product4_qty

The quantity of the product4 offer that the customer purchased

product4_recurringstatus

If the offer is a recurring order, will send the purchase status for the product4 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)

product4_sku

The SKU for the product4 base product

product5_billingCycleNumber

The current billing cycle the product5 purchase is on

product5_campaignProductId

The numerical value of the product5 offer listed inside the campaign

product5_crmId

The base product ID of the fifth item in the order

product5_description

Product Description set on the base product

product5_externalId

The external id of the product (Shopify, BigCommerce, etc…)

product5_id

The external or 3rd party Client ID of the base product of the fifth item in the order

product5_name

The assigned name of the product5 base product

product5_price

The price the customer paid for the current billing cycle for product5

product5_productCategoryId

The numerical value of the product category of the product5 offer

product5_productCategoryName

The name of the product category of the product5 offer

product5_qty

The quantity of the product5 offer that the customer purchased

product5_recurringstatus

If the offer is a recurring order, will send the purchase status for the product5 offer (‘Trial’,’Active’,’Recycle Billing’,’Recycle Failed’,’Complete’,’Cancelled’)

product5_sku

The SKU for the product5 base product

productCost

Advertiser’s cost to manufacture/acquire the product (Expense Value)

productId

The numerical value assigned to product on the CRM>Products page. First item on the order.

productRotationIds

List of rotations on the base product

pubId

The affiliate passed value that is marked as the “Is Publisher” value

purchaseId

The numeric id assigned to a subscription

refundReason

The stated reason the customer requested a refund

recurringPrice

The recurring price the customer will pay for the product

refundTxnId

The numeric id assigned to a refund or void

refundClientTxnId

The unique id assigned to a refund or void

responseType

Response ('SUCCESS','HARD_DECLINE','SOFT_DECLINE','PENDING','COD_PENDING')

rmaNumber

The RMA number assigned to a specific fulfillment record

salesTax

The sales tax the customer paid on the order

salesUrl

The Url of your landing page.

shipAddress1

Line 1 of the shipping recipient’s address

shipAddress2

Line 2 of the shipping recipient’s address

shipCity

The shipping recipient’s city

shipCountry

The shipping recipient’s country

shipFirstName

The first name of the shipping recipient

shipFullName

The full name of the shipping recipient

shipLastName

The last name of the shipping recipient

shippingCost

Advertiser’s cost to ship the product (Expense value)

shipPostalCode

The shipping recipient’s postal code

shipProfileId

The value that represents a specific shipping profile within a campaign

shipState

The shipping recipient’s state

sourceId

The affiliate Id value that represents the affiliate profile

sourceValue1

The source value 1 passed in on Import Lead API or Import Order API

sourceValue2

The source value 2 passed in on Import Lead API or Import Order API

sourceValue3

The source value 3 passed in on Import Lead API or Import Order API

sourceValue4

The source value 4 passed in on Import Lead API or Import Order API

sourceValue5

The source value 5 passed in on Import Lead API or Import Order API

state

The customer’s billing state

subAffId

The affiliate passed value that is marked as the “Is Sub Affiliate” value

timeCreated

The time the order was created

totalDiscount

The total discount applied to the order

totalPrice

Represents orderTotal + upsells + totalShipping

totalShipping

The total price the customer paid for shipping on the order

trackingNumber

The tracking number assigned to a specific fulfillment record

transactionId

The numeric id assigned to the transaction.

For a refund or void this is the id of the original sale. If the actual id of the refund or void is needed then use refundTxnId.

voiceLogNumber

Value that is passed in from a Phone Switch plugin