Using the user_id to map to new values and uploading into Adobe Analytics

[curtis_pond]

Hi Community!

My authenticated community website sends the user_id to Adobe via the value we capture on the data layer. user_id = 12345 (for example)

However, we do not capture how many months the user has been a Community member. We keep this attribute in our data warehouse. months_in_community = 3 (for example).

I would like to create a two_column report (user_id and months_in_community) to Adobe so I have the months_in_community value for analysis inside of Adobe reporting.
Is that type of mapping possible inside of Adobe, where I can add a new dimension based on an existing one? Not sure if it would be classification reports.

Thanks for any guidance!

Curtis

[FarazHusain · Accepted solution]

Yes, you can use classification in this case.

Key Column: Contains the user_id values.
Classification Column: Contains the corresponding months_in_community values.

• In Adobe Analytics, navigate to Admin > Report Suites, select the relevant report suite, and go to Edit Settings > Conversion > Conversion Classifications.
• Locate the variable (eVar) used to capture user_id.
• Add a new classification, naming it appropriately (e.g., "Months in Community").
• Prepare the file using these consideration - https://experienceleague.adobe.com/en/docs/analytics/components/classifications/classifications-impo...
• Use Classification Importer to upload such data https://experienceleague.adobe.com/en/docs/analytics/components/classifications/classifications-impo..., alternatively, for larger datasets or automated processes, you can use FTP import methods.

[curtis_pond]

Thank you @FarazHusain ! I was able to use this approach to complete my analysis. Thanks again for the detailed explanation.

[atuls41837987]

Since you do not have month_in_community data in Adobe Analytics, so you would first need to bring it in Analytics.
I would suggest using Data Source, to ingest data from Warehouse in Adobe Analytics.
Create a data file for Adobe Data Source that contains user_id (for correlation) and months_in_community (map it with any un-user AA variable), once you upload this file via processing mentioned Data Source documentation, you should have data available in Analysis workspace.
Doc: Data sources overview | Adobe Analytics

[FarazHusain]

The same can be done with classification. In any of the cases, they have to prepare the file and create a mapping for userID and the corresponding months_in_community. Classification will act more like a key-value pair; I don't think these same would work in the case of Data sources.

[atuls41837987]

Yes, you can user classification, however, classification lets you add data as dimensions only. So, if you want a report where you want to use user_id as dimension, against which you want to see the months_in_community (which is a number), as a metric, it would make sense and also be helpful in case you would want to create a calculated metric or segments (for use cases like, Ids greater than 3 etc.). It would still be Key (Dimension) value (metric) pair.
Classification can be used, if you want months_in_community data to be available as dimension for breakdown.

So, it depends on how you would want to see the data in Analytics.

[FarazHusain]

Yes, I agree. In this case, they can use months_in_community as a metric.

[curtis_pond]

Thank you @atuls41837987 ! This is also a solid solution, and one I might try in the future. For now, I think I can get by with the dimension approach but will definitely come back to this for the longer term approach. Appreciate you jumping in!