Versions Compared

Key

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

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 Integration 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:

...


ColumnDescription

1.

Time Stamp

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

Status
colourGreen
titleMANDATORY

2.

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

Status
colourGreen
titleMANDATORY

3.Event TypeFor purchase data send “7”

Status
colourGreen
titleMANDATORY

4.CategoryCategory Codes for Products must be identified

Status
colourYellow
titleOPTIONAL

5.Event NameProduct Codes for Products must be identified

Status
colourGreen
titleMANDATORY

6.Num1Purchase Amount

Status
colourGreen
titleMANDATORY

7.Num2Total Sales = Total Amount Sold X Unit Price

Status
colourGreen
titleMANDATORY

8.Var 1City, Business Unit, etc.

Status
colourYellow
titleOPTIONAL

9.Var 2

Status
colourYellow
titleOPTIONAL

10.Var 3

Status
colourYellow
titleOPTIONAL

11.Var 4

Status
colourYellow
titleOPTIONAL

12.Var 5

Status
colourYellow
titleOPTIONAL

13.

EventName Attr1


Status
colourYellow
titleOPTIONAL

14.

EventName Attr2


Status
colourYellow
titleOPTIONAL

15.

EventName Attr3


Status
colourYellow
titleOPTIONAL

16.EventName Attr4

Status
colourYellow
titleOPTIONAL

17.EventName Attr5

Status
colourYellow
titleOPTIONAL

18.EventName Attr6

Status
colourYellow
titleOPTIONAL

19.EventName Attr7

Status
colourYellow
titleOPTIONAL

20.EventName Attr8

Status
colourYellow
titleOPTIONAL

21.EventName Attr9

Status
colourYellow
titleOPTIONAL

22.EventName Attr10

Status
colourYellow
titleOPTIONAL

23.EventTransaction Attr1 - AttrN

Status
colourYellow
titleOPTIONAL

...

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.


Image Modified


...

Parent Topic: Sending Data to RMC

...