Articles in this section

Data Input Schemas

Each of our models require different data inputs to train the models and score the target populations. The following tables outline the events we use to gather that data.

 

Conversion Events - Schema

MG Field Name Type Description
RecipientId VARCHAR Unique customer identifier.
ConvTimeStamp NUMBER UNIX timestamp in seconds of when transaction event occurred.
ConvDiscountCode VARCHAR Discount code, if anything, used on purchase.
ConvSpend FLOAT Total amount of spend in a transaction.
ConvProducts VARCHAR Comma-separated array of each product purchased in a specific transaction.

 

Email Events - Schema

MG Field Name Type Description
RecipientId VARCHAR Unique customer identifier.
EmailTimeStamp NUMBER UNIX timestamp in seconds of when email was sent.
EmailCampaign VARCHAR Name of the campaign (preferably ID) associated with the email.
EmailClick NUMBER UNIX timestamp in seconds of when email was clicked.
EmailOptOut NUMBER UNIX timestamp in seconds of when unsub occured.
EmailOpen NUMBER UNIX timestamp in seconds of when email was opened.

 

Web / Other Engagement - Schema

MG Field Name Type Description
RecipientId VARCHAR Unique customer identifier.
WebTimeStamp NUMBER UNIX timestamp in seconds of when interaction occurred.
WebType VARCHAR Type of interaction (for example, page view, add to cart).
WebUTMCamp VARCHAR UTM campaign parameter associated with event.
WebUTMMedium VARCHAR UTM medium parameter associated with event.
WebUTMSource VARCHAR UTM source parameter associated with event.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.