Booking Add-On ETL File Schema

• userId
• another identity attribute, such as email address

Required.

• If you aren’t using Personalization's multiple identities system, you must include a user ID for each record. The user ID must be one that the Personalization platform tracks so that it can attach events to the specific user profile.
• If you’re using Personalization's multiple identities system, you must include at least one identity attribute because ETL file loads don’t reference userID. You can include multiple identity attributes for a single user by adding multiple columns to the file. For more information, see Guidelines for Sending Multiple Identities in a Booking ETL File.

• user168515262
• jdoe@test.com

120

String

Required. The bookingId is a unique identifier for an individual booking and is a requirement for each record in the file. All line items from a booking must share a bookingID. Sort Booking Add-On ETL files by bookingID so that all records that share a bookingID are in consecutive rows.

860340254

255

String

Required. The bookingDate is the date of the transaction. Format booking date and time strings in the ISO 8601 format. Personalization stores all dates in UTC time.

2020-10-15

2020-01-09T11:24:59Z

1023

Date

Required. The productId represents the product in the catalog that is purchased as an add-on to a booking. If the ID doesn’t reflect an existing product in the catalog, Personalization creates an item in your catalog with the productId. The productId value must match the format of other product IDs that exist in your catalog, that you send through a Product ETL data feed, or that you track on your website.

prod001,

prod1101

255

String

Required. The price is the unit price for the add-on. Use a period as the decimal separator. Don’t include a thousand separator. Personalization multiplies the price by the quantity to determine the total cost of the booking record. For example, if the price is $1.10 and the quantity is 3, the total cost of the line item is $3.30.

150, 63.25, 10

1023

Decimal

Required. The quantity is the net quantity a user purchases. Personalization multiplies the quantity by the price to determine the total cost of the line item in the transaction. Personalization adds all line items for a single bookingID, which equals the total value of the order.

1, 50, 100

1023

Integer

The currency of the transaction. The currency must be consistent across all records in a transaction. If you don’t send a currency, the system assigns the currency defined in Catalog Setup for that dataset. Currency must be in ISO 4217 format and include three uppercase letters.

USD, AUD, EUR

3

String