Data onboarding file - Date format and Product arrays

Avatar

Avatar
Validate 1
Level 2
mandeepkang1981
Level 2

Likes

9 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
mandeepkang1981
Level 2

Likes

9 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
mandeepkang1981
Level 2

28-08-2018

I would like to on board CRM data into AAM

Just want to confirm a couple items

1. Date formatting

Preferred method is to use a counter instead of actual dates

For example.

Product purchase date = 8/20/2018. This will not allow us to build traits for days since last purchase = 8 days

Preffered method would be to create aggregations. 'Days since last purchase' = 8

Is this correct?

2. Product arrays

Would AAM accept product arrays. For example if a specific customer has purchased 12 items in the last 24 months. If we list these purchased items in an array would AAM be able to read the array?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor 2
MVP
Varun_Kalra
MVP

Likes

181 likes

Total Posts

286 posts

Correct reply

121 solutions
Top badges earned
Contributor 2
Contributor
Seeker
Ignite 10
Ignite 5
View profile

Avatar
Contributor 2
MVP
Varun_Kalra
MVP

Likes

181 likes

Total Posts

286 posts

Correct reply

121 solutions
Top badges earned
Contributor 2
Contributor
Seeker
Ignite 10
Ignite 5
View profile
Varun_Kalra
MVP

04-09-2018

Hi Mandeep,

1. That is correct there is no date format while getting signals, so you need to create the trait with this kind of expression : "Days since last purchase" <= "8" and use the same signal in onboarded files.

2. If you are sing one key with multiple values then you can use contains or matchesregx operator in expression builder tool, else you can create one trait per product.

Check these docs on operators: Order of Operations in Trait Builder

Working with Comparison Operators in Trait Builder

Thanks,

Varun Kalra

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 2
mandeepkang1981
Level 2

Likes

9 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
mandeepkang1981
Level 2

Likes

9 likes

Total Posts

18 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
mandeepkang1981
Level 2

04-09-2018