Unable to see event data in profile | Community
Skip to main content
arpan-garg
Community Advisor
arpan-gargCommunity Advisor
Community Advisor
March 25, 2023
Solved

Unable to see event data in profile

  • March 25, 2023
  • 2 replies
  • 2932 views

I have a use case where profile and event data are present in AWS Redshift database.  I created required schema using XDM profile, enabled the schema for profile and created dataset using schema , also enabled dataset for profile.

Same steps i did for the event data i.e. Created required schema using XDM experience event, enabled the schema for profile and created dataset using schema , also enabled dataset for profile.

 

After batch ingesting the data using the existing AWS Redshift connector i see all the data in profile correctly however the event data related to the profile is missing. Both profile schema and event schema has the same primary identity linked to the same namespace.

 

I checked monitoring and I see success. 

However one strange thing i noticed while ingesting event data (I see negative count of records ingested as attached below)

 

 

Any thoughts on why I am missing event data on profile ?

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 arpan-garg

Finally worked for me

 

To test, I created 2 profile Schemas(ProfileA, ProfileB) and 2 Experience Event schemas(Event A, Event B).

In the first set of schema(ProfileA,EventA) I just added a primary identity and later ingested the data.

In the second set of schema(ProfileB,EventB) I added a primary identity + Added a field group "AEP Web SDK Experience Event" in EventB schema

 

In the profile data ingested in set A, i can't see event data.

In the set B where I added field group "AEP Web SDK Experience Event" i could see event data in profile.

 

This made me reach to a conclusion that "AEP Web SDK Experience Event" field group is required in Experience Event schemas if we want to see event data in Profile.

 

@arijitg @_manoj_kumar_ and other community members - Is that true?

 

2 replies

arijitg
Adobe Employee
arijitgAdobe Employee
Adobe Employee
March 26, 2023

Hi @arpan-garg ,

 

Can you once check the timestamp for your events if they're older than 30 days?

Can you do a profile lookup on an identity where timestamp are within 30 days if you can see events listed?

By any chance did you load event dataset and then dropped and recreated the dataset and reloaded?

 

Regards,

Arijit Ghosh

arpan-garg
Community Advisor
arpan-gargCommunity AdvisorAuthor
Community Advisor
March 26, 2023

Hi @arijitg - I created a new dataset and a new schema and ingested the data with timestamp of yesterday. Still I see records being skipped and records ingested in negative

 

 

arpan-garg
Community Advisor
arpan-gargCommunity AdvisorAuthor
Community Advisor
March 26, 2023

I see this document from Adobe https://experienceleague.adobe.com/docs/experience-cloud-kcs/kbarticles/KA-19839.html?lang=en as per this its impossible to see event data ingested via csv. Is that true?

arpan-garg
Community Advisor
arpan-gargCommunity AdvisorAuthorAccepted solution
Community Advisor
March 27, 2023

Finally worked for me

 

To test, I created 2 profile Schemas(ProfileA, ProfileB) and 2 Experience Event schemas(Event A, Event B).

In the first set of schema(ProfileA,EventA) I just added a primary identity and later ingested the data.

In the second set of schema(ProfileB,EventB) I added a primary identity + Added a field group "AEP Web SDK Experience Event" in EventB schema

 

In the profile data ingested in set A, i can't see event data.

In the set B where I added field group "AEP Web SDK Experience Event" i could see event data in profile.

 

This made me reach to a conclusion that "AEP Web SDK Experience Event" field group is required in Experience Event schemas if we want to see event data in Profile.

 

@arijitg @_manoj_kumar_ and other community members - Is that true?

 

    Manoj_Kumar
    Community Advisor
    Manoj_KumarCommunity Advisor
    Community Advisor
    March 27, 2023

    Hello @arpan-garg 

    Yes, that is correct. The WEb SDK event  field group should be the part of Experience event schema.

    Manoj  | https://themartech.pro
      Terms & ConditionsAccessibility statement

      Loading footer...