Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Data onboarding file - Date format and Product arrays

mandeepkang1981
Level 2
Level 2

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?

1 Accepted Solution
Varun_Kalra
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

2 Replies
Varun_Kalra
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post