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

Uploading an empty field (column) from a database in audience manager

Avatar

Avatar
Validate 1
Level 1
rafaelb
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
rafaelb
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
rafaelb
Level 1

19-04-2021

Hi Everyone,

 

We are about to do an integration from our first party data source with AAM, to avoid any future data reprocess, we would like to include all the fields in the scope, including several calculated fields. Given this calculated fields are not available yet, is it possible to include the columns for these fields associated to a client ID with a default value and then populate them when we have said variables available?. Here's an example of how we are hoping to upload the data.

 

Client ID         Ordered Items          CLV

123                           1                    Default Value

1234                         4                    Default Value

12345                       5                    Default Value

 

Thanks!

Audience Manager calculated database traits

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Varun_Kalra
MVP

Likes

175 likes

Total Posts

284 posts

Correct Reply

119 solutions
Top badges earned
Contributor
Seeker
Ignite 10
Ignite 5
Ignite 3
View profile

Avatar
Contributor
MVP
Varun_Kalra
MVP

Likes

175 likes

Total Posts

284 posts

Correct Reply

119 solutions
Top badges earned
Contributor
Seeker
Ignite 10
Ignite 5
Ignite 3
View profile
Varun_Kalra
MVP

21-04-2021

Hi Rafael,

 

Certainly you can do that. You could either leave the value as empty in the file or can use a default value for no availability of values in the meantime. Both of the following examples will work:

 

12345 ordered_items="5",clv="",ordered_product="abc"
12345 ordered_items="5",clv="null",ordered_product="abc"

 

In the first example the value is blank and in second one the value is a default string "null" or you could use any string like: "na" etc.

 

Thanks,

Varun Kalra

Answers (1)

Answers (1)

Avatar

Avatar
Level 1
arturradukevic453
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
arturradukevic453
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
arturradukevic453
Level 1

06-05-2021

Hello, please tell me how can I use the default option? don't quite understand ... thanks for the help in advance
Regards Artur