Non-stitched profile data set records - Customer Journey Analytics | Community
Skip to main content
J
jlasso71
Level 2
November 27, 2024
Solved

Non-stitched profile data set records - Customer Journey Analytics

  • November 27, 2024
  • 2 replies
  • 1059 views

Hi there,

 

I have an AEP profile dataset with some million CRM records being connected to CJA. Most of profiles do not have events tied to the CRM ID, so we cannot view them in Analysis Workspace (as Adobe FAQ explains). However, the client needs to analyze all the customer records in CJA no matter they have had an event.

 

In order to solve this, we generated one "fake event" per customer and the solution worked. The problem of this solution is that we need to ingest some million fake records monthly to analyze CRM data with a (monthly) time window, which is not recommendable from both licensing and data cleansing perspective.

 

What would be the best fit approach to circumvent this limitation? 

 

Thanks in advance,

    Best answer by FarazHusain

    Hey @jlasso71 Events basically corresponds to hits in CJA. CJA is primarily built to work on event datasets, so if you only have a profile dataset, I would also recommend ingesting fake events such that these records are visible in CJA reports. 

     

    As far as I know, CJA is currently not designed to work solely on profile data sets. Maybe this could be raised as a feature request, but at the moment, you have to prepare the event data sets against the CRM ID; that's the only way, as per my knowledge.

    2 replies

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

    Hey @jlasso71 Events basically corresponds to hits in CJA. CJA is primarily built to work on event datasets, so if you only have a profile dataset, I would also recommend ingesting fake events such that these records are visible in CJA reports. 

     

    As far as I know, CJA is currently not designed to work solely on profile data sets. Maybe this could be raised as a feature request, but at the moment, you have to prepare the event data sets against the CRM ID; that's the only way, as per my knowledge.

      M
      mmarti
      February 17, 2025

      Hi @jlasso71, That's very interesting. Could you share how you did that? We want to do the same but haven't found information on how to proceed.

      Thank you!

      J
      jlasso71Author
      Level 2
      February 18, 2025

      Hi @mmarti ,

       

      We use a daily scheduled query in Query Service to extract unique customers (client_id) from a dataset and insert them into another dataset which is connected to CJA.

       

      It was something similar to the next query:

       

      INSERT INTO table_final
SELECT DISTINCT client_id,
	  now() as timestamp,
	  'CJA_event' as eventType,
	  event_id as _id
FROM table_origin
WHERE clientType = 'cliente'

       Hope it helps,

      Jose

        M
        mmarti
        May 23, 2025

        Hi Jose,

         

        Thank you for the info provided, it's really helpful. When it comes to define event_id, do you have any criteria or it's just a random value?

         

        Regards!

        Terms & ConditionsAccessibility statement

        Loading footer...