Comment on page

Transaction Feed Parameters

ROIVENUE recognizes 42 different feed parameters - meaning you can measure customer interaction in 42 different ways. Go through the optional ones and choose which ones you are interested in.
If you understand the theory and wish to know more then check out the XML file structure with notes and descriptions that we made.
Required parameters
Optional parameters
Name
Description and examples
Site
The web domain where the order was generated. If the order isn't placed online the value will be "-".
Example value: example.cz
WebId
The unique ID of the online order captured by the web tracking software, for instance when Google Analytics is used, this is the transaction ID. ID must be unique. For offline orders it will be a dash -.
Example value: 15108766
OrderId
Internal unique order number. Can be the same as WebId. During all editing in the system this ID has to stay the same.
Example Value: 12001508xxx
UserId
User ID connected to the order. Must be hashed.If it is not possible to assign an ID to a user (e.g. the system does not create users for orders without a login) their hashed e-mail address is used. UserId will then be the same as userEmailAddress. UserId for offline orders can be null.
Example Value: e99f33420f577ee8
Status
This identifies the status of the order, it can be a numerical type or a textual description of the order status. Examples statuses are new/paid/returned. Unknown status shall be encoded with "-".
Example of values and states identified in ROIVENUE:
Created - The status when the order is initialized (put in the cart) - 0
Ordered - Accepted/created order - 0
Canceled - Cancellation (test or duplicate order) - 0
Shipped - Forwarded to dispatch - 0
Delivered - Delivered / Paid-in order - 1
Returned - Returned order, must be paired with original OrderID - 0
Undelivered - order was not delivered or picked up - 0.
Delivered
Status whether money was received.1 = YES,
0 = NO.
Example Value: 1|0
OrderedAt
The date when the order was completed. The date when the order was accepted into the ERP system. This should be the time when WebID was send to Google Analytics.
Example Value: 2015-04-25T09:00:00
CurrencyCode
ISO 4217 currency name, the whole order must be converted into a single currency.
Example Value: CZK|EUR|PLN
Profit
Trade margin / surcharge. Difference in sales and purchase prices. This is the gross profit on the order. If not filled in, counts as (Revenue - ProductsCost).
Example Value: 235
Revenue
Total revenue for sold goods. Value excludes VAT and other delivery, payment or shipping costs. From a business perspective, not a customer. (Total - (Tax + DeliveryCost + PaymentCost + ProcessingCost)). We can simplify this calculation by subtracting only tax and inputting the other costs as zero.
Example Value: 928.05
Name
Description and examples
UserBirthAt
Date of birth "YYYY-MM-DD".
Example Value: 1988-12-11
UserCountryCode
Country code identifying the user's country.
Example Value: CZ|SK
UserCity
The city where the order was delivered.
Example Value: Prague 2
UserPostalCode
ZIP code.
Example Value: 12200
UserLatitude
Latitude of the User or Delivery address.
Example Value: 12.458033
UserLongitude
Longitude of the User or delivery address.
Example Value: 31.113281
UserCreatedAt
The date the user account was created. For an unregistered user the order date will be applied.
Example Value: 2015-02-25T12:17:00
SourceSystem
Identifier of the system where the order was sourced from, ERP name.
Example Value: SAP ERP6.142
SalesChannel
Optional. If not filled in, the order behaves as "online".
Example Value: online|offline
PaymentType
Determines the payment method, e.g. cash, card, cupon delivery, ...
Example Values:
Payment in database on client side - Value (in export)
Cash or card at delivery - CashOnDelivery
In advance by card(Gopay, PayU) - Card.PayU
Bank account transfer - Bank.KB
On hire purchase - Installment
DeliveryType
Determines the delivery method, e.g. post, local pickup, ...
Example Values: DPD - Delivery.DPD
PPL - Delivery.PPL
Geis - Delivery.Geis
Czech Post - Delivery To Hand - Delivery.CP
Czech Post - Delivery To Post Office - Pickup.CP
Ulozenka - Pickup.Ulozenka
ProcessingType
This is the how the order was processed, e.g. quick checkout, login checkout, call, store, ...
Example Value: login | no-login
CreatedAt
Date and time when the product was first added to the cart. If CreatedAt is unknown, the value from OrderedAt is used.
Example Value: 2015-04-25T09:00:00
ModifiedAt
Date when the order was modified.
Example Value: 2015-04-25T11:11:00
UserEmailHash
Hash of the email address. For example MD5(LOWERCASE(email_address)). When the UserEmailHash is not populated then a UserId must be provided, bad data shall be encoded with "-".
Example Value: e99f33420f577ee8
ShippedAt
Datetime when the order was completed and dispatched to the customer (or prepared for pick up by the customer).
Example Value: 2015-04-26T13:00:00
DeliveredAt
Date the order was handed over to the customer (date of receipt of the shipment).
Example Value: 2015-04-27T10:00:00
ReturnedAt
Datetime when the order was returned by the customer.
Example Value: 2015-05-02T10:00:00
UserPhoneHash
Hash of the phone number, preferable in a standardised international format. For example MD5(+19207658943), bad data shall be encoded with "-".
Example Value: s11f12420f897cc8
DeliveryCost
Cost of delivered / undelivered shipment. Usually it has fixed values according to the type of transport. It is not the fee that your customer pays for delivery.
Example Value: 80
PaymentCost
Payment costs (e.g: for payment gate maintenance, costs for each type of payment) - fixed value.
Example Value: 15
ProcessingCost
Other costs for order processing. For example, packing.
Example Value: 0
UserGender
gender of the customer. Values: "m" or "f".
Example Value: m | f
UserSegment
Indicates the kind of the customer private - customer who is not a company private.partner.{xxx} - customer who is not a company with a special contract, {xxx} defines the contract type, for instance the discount level etc business – customer who is a company, and his price is the same as for private customers business.partner.{xxx} – companies, with a specific status, either they do have a special contract or a special price, {xxx} defines the contract type, for instance the discount level etc.
Example Value: customer.c15
ProductCost
Cost of purchasing goods excluding VAT.
Example Value: 235
Discount
Discount value including VAT. These include, for example, a discount obtained through a discount coupon, a discount on a product or an entire order. The discount value can be any positive number; it cannot be zero.
Example Value: 30
Delivery
Delivery costs, including VAT, that are charged to the client.
Example Value: 0
Surcharge
Extra charges to the customer, for instance payment fee, etc, including VAT.
Example Value: 0
ProductsQuantity
Number of products sold in the order.
Example Value: 1
ProductsDelivered
Number of products delivered, ProductsQuantity less ProductsReturned, or removed from the order when amended.
Example Value: 0
Tax
Tax of the products VAT and any other tax paid if applicable, tax is calculated only from the total less delivery and surcharge.
Example Value: 194.95
Total
Invoiced amount including all charges (postage, shipping, discounts and VAT) as seen by the customer. (ProductsRevenue + Delivery + Surcharge + Tax).
Example Value: 1123