How to remove the existing onboarded trait users if expire set to "0" zero conditions? | Community
Skip to main content
V
Vijayakumar_Raju
Level 4
November 6, 2019
Solved

How to remove the existing onboarded trait users if expire set to "0" zero conditions?

  • November 6, 2019
  • 8 replies
  • 11980 views

Hi All,

I would like to understand on what way this .sync or .overwrite file works while doing the below case

Here I have a small scenario for your understand.

Step 1 - We have created the XYZ onboarded trait name with expire set to "0" conditions along with rules update (i.e.) "usera==1".

Step 2 - Instantly we upload the offline .sync file to that location, after 48 hours user "A" has realized under that XYZ onboarded trait.

Step 3 - Since, the user "A" is no more in our system after several days. we would like to remove that user "A" from the existing XYZ onboarded trait and the conditions from the file are set to be "usera==0"

My Query is?

On what way we can remove that user "A" who already realized on the existing XYZ onboarded trait long back and please note that conditions still on 0 expire.

Is it possible, If we use .sync file to upload with the "usera==0" or If we use .overwrite file to upload with the "usera==0"

or both will work or not?

Hope you understand my question !

Thanks,

Vijay

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by shweta_singh

    Hi Vijay,

    .overwrite file: It overwrites all of your existing visitor profiles and replaces them with the data in your file. You can use a .overwrite file to reset visitor traits or remove stale, obsolete traits.

    .sync file:  It appends new data to your existing visitor profiles. Sending in a .sync file does not erase or overwrite existing profiles

    For e.g.

    Day 1(.overwrite)

    1234 "gender"="m","age"="30","campaign"="upgrade eligible"
    User will be qualified for all the three traits

    Day 2(.overwrite)

    1234 "gender"="m","age"="30"

    User will be removed from trait "campaign"="upgrade eligible" but he will still be qualified for other two traits

    Day 3(.overwrite)

    1234 "campaign"="upgrade eligible"

    User will be only qualified for above trait and will be removed from"gender"="m","age"="30"

    Day 4(.sync)

    1234 "campaign"="upgrade eligible",state="Kerala"

    User 1234 will be qualified for both the traits.

    Let me know if any other additional information is required on .sync and .overwrite file.

    Regards,

    Shweta

    8 replies

    snielson
    Adobe Employee
    snielsonAdobe Employee
    Adobe Employee
    November 6, 2019

    Hi Vijay,

    If you would like to remove a single onboarded trait from User A, I would recommend one of the following:

    .Overwrite: Provide a .overwrite file with a row for User A. This row MUST contain all the signals / key-values of trait expressions that you would like the user to keep. Otherwise user A will lose more than just a single trait. Essentially whatever is uploaded is what their profile will now contain trait-wise.

    .Sync: If you know the trait ID that you would like removed, you can simply pass in the prefix "d_unsid" with the .sync file. Using d_unsid=<trait ID> will remove the onboarded trait from this users profile.

    Inbound Data File Contents: Syntax, Invalid Characters, Variables, and Examples

    V
    Vijayakumar_RajuAuthor
    Level 4
    November 7, 2019

    Thank you Shane for your quick response!

    I have gone through your reference link too...

    Here is my understand. Just correct me if I am wrong !

    Eg:

    • XYZ Trait ID = 2222222
    • A "User" ID = 454545

    Suppose If I want to remove this existing user from the XYZ trait id means, I need to go with the below onboarding ".sync" method.

         454545 <TAB> d_unsid=2222222, usera==0

    Thanks,

    Vijay

    S
    Adobe Employee
    shweta_singhAdobe Employee
    Adobe Employee
    November 7, 2019

    Hi vijayakumar.raju

    The method is right but it should be something like:

    454545 <TAB> d_unsid=2222222

    The reference user will be recognized in the system by user/CRM Id

    Regards,

    Shweta

    vijayakumarr869
    vijayakumarr869
    November 8, 2019

    Hi Shweta

    Sorry if my understand is correct as per your comment!

    I would like to add that user "A" into different onboarded traits (i.e.) ABC Trait ID on the same .sync file upload actions it means I want to remove from XYZ Trait ID and added to ABC Trait ID (rule for this abc trait id is "usera==0") on a single upload.

    Please suggest me, do I  need to add that user "A" into separate column something likes this on the same .sync file.

    454545 <TAB> d_unsid=2222222

    454545 <TAB> usera==0

    OR

    I need to add the syntax mentioned in the previous examples and upload

    454545 <TAB> d_unsid=2222222, usera==0

    OR

    I need to add two .sync file for the same user "A". First is for remove that user "A" from the Trait ID then upload. Again the second steps is to add the user "A" along with this syntax "usera==0" to upload with different .sync file.

    Thanks for your instant response.

    Regards,

    Vijay

    S
    Adobe Employee
    shweta_singhAdobe Employee
    Adobe Employee
    November 13, 2019

    Hi vijayakumarr86921646,

    You can upload the data using same sync file in format:

    454545 <TAB> d_unsid=2222222

    454545 <TAB> usera==0/d_sid=traitId

    This is mentioned in our doc as well.

    Inbound Data File Contents: Syntax, Invalid Characters, Variables, and Examples

    Regards,

    Shweta

      V
      Vijayakumar_RajuAuthor
      Level 4
      November 19, 2019

      Awesome its really help us and appreciated your response as well.

      One last question may be silly? Suppose If I have not loaded the file using .sync method shally I use directly  the .overwrite file mean what happens and what will be the draw back.

      Example, suppose if we have send 1st file with 100 id later again i need to modify or remove some user from the same first file feels like rework kind off, is that works if i can directly use the overwrite method for both newly added user and remove the users instantly.

      Cheers,

      Vijay

      S
      Adobe Employee
      shweta_singhAdobe EmployeeAccepted solution
      Adobe Employee
      November 22, 2019

      Hi Vijay,

      .overwrite file: It overwrites all of your existing visitor profiles and replaces them with the data in your file. You can use a .overwrite file to reset visitor traits or remove stale, obsolete traits.

      .sync file:  It appends new data to your existing visitor profiles. Sending in a .sync file does not erase or overwrite existing profiles

      For e.g.

      Day 1(.overwrite)

      1234 "gender"="m","age"="30","campaign"="upgrade eligible"
      User will be qualified for all the three traits

      Day 2(.overwrite)

      1234 "gender"="m","age"="30"

      User will be removed from trait "campaign"="upgrade eligible" but he will still be qualified for other two traits

      Day 3(.overwrite)

      1234 "campaign"="upgrade eligible"

      User will be only qualified for above trait and will be removed from"gender"="m","age"="30"

      Day 4(.sync)

      1234 "campaign"="upgrade eligible",state="Kerala"

      User 1234 will be qualified for both the traits.

      Let me know if any other additional information is required on .sync and .overwrite file.

      Regards,

      Shweta

        V
        Vijayakumar_RajuAuthor
        Level 4
        November 23, 2019

        Thank you very much Shweta for detail information.

        Now I understand better will do the R&D on this.

        Cheers,

        Vijay

        Terms & ConditionsAccessibility statement

        Loading footer...