Offline Data

General Information

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

  • Customer calls the Call Center
  • Customer purchases an item from the physical store
  • Customer visits physical store

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

MANDATORY

2.

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

MANDATORY

3.Event TypeFor purchase data send “7”

MANDATORY

4.CategoryCategory Codes for Products must be identified

OPTIONAL

5.Event NameProduct Codes for Products must be identified

MANDATORY

6.Num1Purchase Amount

MANDATORY

7.Num2Total Sales = Total Amount Sold X Unit Price

MANDATORY

8.Var 1City, Business Unit, etc.

OPTIONAL

9.Var 2

OPTIONAL

10.Var 3

OPTIONAL

11.Var 4

OPTIONAL

12.Var 5

OPTIONAL

13.

EventName Attr1


OPTIONAL

14.

EventName Attr2


OPTIONAL

15.

EventName Attr3


OPTIONAL

16.EventName Attr4

OPTIONAL

17.EventName Attr5

OPTIONAL

18.EventName Attr6

OPTIONAL

19.EventName Attr7

OPTIONAL

20.EventName Attr8

OPTIONAL

21.EventName Attr9

OPTIONAL

22.EventName Attr10

OPTIONAL

23.EventTransaction Attr1 - AttrN

OPTIONAL

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.


Copyright 2020 Related Digital