Content Analytics not populating tracked events

[RaghavSh]

Hi Have installed "Content Analytics" and related plugins but "Tracked Events (sn_cda_tracked_evt_agg)" are not getting populated.

I am able to get the "Tracked Pages (sn_cda_tracked_page_agg)" data daily but Tracked Events are not there even when I have tried events/actions on OOB widgets on EC pro portal over last couple of days.

Since I am using OOB EC pro portal, it should track the events without any configurations.

@Pooja Gupta1 

[Pooja_Patil]

@RaghavSh, please let me know if you need further assistance with campaigns.

~BR

Pooja Patil

[RaghavSh]

@Pooja_Patil 

1. I have already followed all these steps.

2. I have tried triggering the import from "profile triggers" multiple times, it does not bring data immediately.  I think there is some other missing piece here.

[Pooja_Patil · Accepted solution]

Please note - 

Usually (unless it's a valid business case) when scheduling content from campaign you would not have schedule content for the content in content publishing, that just means you are scheduling two deliveries.

Here are the summarized steps - 

1. Create a campaign with tracking on and tracking profile selected, profile must be active. Please refer -  How to configure a campaign 
2. Campaign must have Campaign Targets populated so that content is delivered to them
   
   • Run Scheduled job > Content Experiences: Update Campaign Audience or it runs every hour 
3. After campaign targets are added, if campaign has non-portal contents (ex to-do or email), each non-portal content must have Targeted Content populated
   • Run Scheduled job > Content Experiences: Add Non-Portal Campaign Content or it runs every 4 hours
4. After targeted content is added to each non-portal content, you would run 
   • Content Experiences: Create To-dos (for to-do content) or it runs every hour
   • Content Experiences: Send Email Notifications (for email content) or it runs every hour
5. Once this is done, content will be delivered based on their schedules
6. Impersonate users from campaign targets and perform tracked actions on the content scheduled through the campaign and redirect to some other page so browser buffer is flushed to server side buffer  (or it will be automatically flushed approximately in 5 mins), then wait for approximately 15 mins or more. All the tracked events data is queued (first in browser buffer then in server-side buffer). Refer Content Analytics Data flow 

7.  After step 6, if you want to see analytics data immediately, there are jobs (profile triggers) that push the data to the content analytics tables. You can run these jobs from Scheduled Jobs (Content Publishing Profile and Content Experience Profile), this will trigger import.

8. After profile import is finished, campaign should start showing analytics data

**Note - All of this is automated through scheduled jobs, detailed steps here are only added to help understand the flow.

~BR

Pooja Patil

Please mark this as helpful and accepted solution so this is removed from unanswered queue and helps others.

[RaghavSh]

@Pooja_Patil Thanks a lot for your help.

I think I was missing step no.6 , where I need to wait for sometime.

[Faizel]

Hi @Pooja_Patil 

Is it possible the names of the scheduled jobs have been incorrectly typed in your post?

This product documentation lists all the components installed with Content Experiences and none of these jobs are mentioned.

https://docs.servicenow.com/bundle/utah-employee-service-management/page/product/employee-center/ref...

The docs above reference Content Automation: Update Campaign Audience NOT Content Experiences: Update Campaign Audience

Content Automation: Add Non-Portal Campaign Content NOT Content Experiences: Add Non-Portal Campaign Content

Content Automation: Create To-dos NOT Content Experiences: Create To-dos

Content Automation: Send Email Notifications NOT Content Experiences: Send Email Notifications