Using the user_id to map to new values and uploading into Adobe Analytics | Community
Skip to main content
curtis_pond
curtis_pond
Level 3
November 24, 2024
Solved

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

  • November 24, 2024
  • 2 replies
  • 1303 views

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

    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 FarazHusain

    Yes, you can use classification in this case.

     

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

     

    2 replies

    FarazHusain
    Adobe Employee
    FarazHusainAdobe EmployeeAccepted solution
    Adobe Employee
    November 25, 2024

    Yes, you can use classification in this case.

     

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

     

      curtis_pond
      curtis_pondAuthor
      Level 3
      December 3, 2024

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

        A
        Adobe Employee
        atusingh17Adobe Employee
        Adobe Employee
        November 25, 2024

        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
          Adobe Employee
          FarazHusainAdobe Employee
          Adobe Employee
          November 25, 2024

          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.

            A
            Adobe Employee
            atusingh17Adobe Employee
            Adobe Employee
            November 25, 2024

            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.

              Terms & ConditionsAccessibility statement

              Loading footer...