If I upload a classification file with no or blank values will it affect existing values in adobe analytics? | Community
Skip to main content
gkrish12345
gkrish12345
Level 2
November 5, 2022
Solved

If I upload a classification file with no or blank values will it affect existing values in adobe analytics?

  • November 5, 2022
  • 3 replies
  • 1807 views

For example imagine If I upload  the below data under product classification with "product id" being the key value in adobe analytics. 

 

product id        product name       product category

xyz                  iphone                   mobile

 

 

After few days I upload another classification file with with same product id but with empty or no value under product name and select "overwrite existing value" while uploading classification file

 

product id    product name          product category

xyz               

 

What output can i expect in adobe analytics report? Will it be 

 

xyz                  iphone                   mobile       

 

or

 

xyz       

Best answer by Jennifer_Dungan

I don't actually use the classification importer, but it seems like if you did such a thing, this would result in two conflicting rules...  but I don't know how what the final result would be....

 

Out of curiosity, is it your intention to "overwrite" or "delete" the original mapping? If so, you might want to look at https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-importer/t-delete-classification-data.html?lang=en where you would actually pass ~empty~ or ~deletekey~ to clear out an existing classification.


If the empty keys were done in error... you should consider exporting your rule set to see if you have conflicting classifications.. and may want to run a removal using the correct method to get rid of the conflicts, then re-import the correct rules.....

3 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
November 6, 2022

I don't actually use the classification importer, but it seems like if you did such a thing, this would result in two conflicting rules...  but I don't know how what the final result would be....

 

Out of curiosity, is it your intention to "overwrite" or "delete" the original mapping? If so, you might want to look at https://experienceleague.adobe.com/docs/analytics/components/classifications/classifications-importer/t-delete-classification-data.html?lang=en where you would actually pass ~empty~ or ~deletekey~ to clear out an existing classification.


If the empty keys were done in error... you should consider exporting your rule set to see if you have conflicting classifications.. and may want to run a removal using the correct method to get rid of the conflicts, then re-import the correct rules.....

yuhuisg
Community Advisor
yuhuisgCommunity Advisor
Community Advisor
November 7, 2022

You don't get 2 conflicting rules, because Classification Importer lets you import mappings of keys to classifications. So you're really overwriting the existing classification.

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
November 7, 2022

The thing is.. empty or null values aren't technically valid values.. I don't know if the system will handle that as an import... to clear a value you are supposed to pass a literal "~empty~"

yuhuisg
Community Advisor
yuhuisgCommunity Advisor
Community Advisor
November 7, 2022

Instead of pondering the outcome, your best bet is to upload a corrected set of classifications promptly, then let AA use that in its reports.

Unless you're asking out of curiosity.  😀 In that case, I believe you'll end up with reports using the blank values.

DavidGeist
Adobe Employee
DavidGeistAdobe Employee
Adobe Employee
February 20, 2024

I had this same questions, so I tested it out. In short, any blank value in a classification import will not overwrite an existing value. 

 

Step 1

I uploaded 2 classification values for a single key. 

KeyColorSize
A001BlueBig

 

After the upload processed you could see these classification dimension values as expected. 

 

Step 2

I uploaded a new file where Color changed but Size was blank.

KeyColorSize
A001Green 

 

The final result was 

KeyColorSize
A001GreenBig

 

Which proved that empty fields do not overwrite existing classification values. Only fields with a value will overwrite an existing classification value. 

    Terms & ConditionsAccessibility statement

    Loading footer...