Onboard trait values as numbers

[michaela7702973]

I'm familiar with creating and onboarding .sync and .overwrite files containing CRM data into Audience Manager but so far have only onboarded text values. We have a new use-case and would like to onboard numeric data from our CRM into Audience Manager and keep the trait values numeric and not convert it to text.

For example, currently all trait values we onboard are text.

userID123<tab>"classification"="a", "grade"="b"  >and so on. This works fine.

We'd like to onboard numeric trait values so as an example,

userID123<tab>"classification"="a", "grade"="b", "income"="100,000"

If I onboard a .sync similar to the above example I believe the 100,000 will be inserted as text. The ultimate goal if we're able to onboard numeric valuesis to create traits using operators such as income < 100,000 or income >= 100,000 and so on. We can define the range in the trait expression and have IDs qualify based on it.

Can Audience Manager onboard numeric values and how would it look like in a .sync or .overwrite file?

[r-seabrook · Accepted solution]

It should work exactly the same as any other sync or overwrite file

as long as you don't have a comma separator before thousand and million in the values, your < and > operators should work on onboarded values, same as for online data

[michaela7702973]

I uploaded an .overwrite with key-value pairs that has numbers. Then I made test traits that had some numeric operators like mykey>1000000 and a few others like it. I'm waiting for them to get populated to confirm it works as expected.