General Information

Some of your business’s key interactions with customers may happen offline. Sample “offline events” can include:

Offline Data Methods

These events don’t happen as a result of the customer visiting your website. There are alternate ways to bring in this data, using our Offline Data method:

  1. If the offline data is a data from an ongoing process like store purchases, you may want to schedule the file generation and put the file to FTP path for easy retrieval on your end.
  2. Both zip compressed and uncompressed files are supported.
  3. Columns must be separated with a ‘;’ (semicolon).
  4. Headers are optional.
  5. Encoding must be UTF-8.
  6. Text qualifier is “”.
    Fields must be ordered as follows:

ColumnDescription

1.

Time Stamp

Format: 2014-05-25 12:25:43

2.

Customer IDMust be the same ID received from Website/Mobile App

3.Event TypeFor purchase data send “7”

4.CategoryCategory Codes for Products must be identified

5.Event NameProduct Codes for Products must be identified

6.Num1Purchase Amount

7.Num2Total Sales = Total Amount Sold X Unit Price

8.Var 1City, Business Unit, etc.

9.Var 2

10.Var 3

11.Var 4

12.Var 5

13.

EventName Attr1


14.

EventName Attr2


15.

EventName Attr3


16.EventName Attr4

17.EventName Attr5

18.EventName Attr6

19.EventName Attr7

20.EventName Attr8

21.EventName Attr9

22.EventName Attr10

23.EventTransaction Attr1 - AttrN

In case you do not want to use the optional columns just leave them blank but do not forget to include the starting and ending semicolons. For example: let’s say you only want to send the Attr10 parameter. In that case you must put 2 semicolons for each leading column before the Attr10 column.

You can send Purchase ID as one of the Event Transaction Attributes, which are unlimited.

Once you have entered the required file based on the rules and standards mentioned above, you can validate the file and schedule an automatic upload by visiting Personalize > Settings > Offline Data Import and selecting New Definition.