Content Analytics not populating tracked events

RaghavSh · ‎03-22-2023

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

Raghav
MVP 2023

Pooja_Patil · ‎04-06-2023

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 -

Create a campaign with tracking on and tracking profile selected, profile must be active. Please refer - How to configure a campaign
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
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
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
Once this is done, content will be delivered based on their schedules
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
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.
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.

View solution in original post

Pooja_Patil · ‎03-24-2023

@RaghavSh , have you looked into the link I shared for Content Experience - Campaigns ?

Tracking for content created from Content Publishing is only supported if the content is scheduled through a campaign. The code is there because that is how user actions are tracked, but action is only logged through cdaAnalytics if that content is associated with a campaign.

~BR

Pooja Patil

RaghavSh · ‎03-27-2023

@Pooja_Patil let me check on this.

But service now gives the same option for service portal and custom widgets, how is that possible? when we dont have campaigns on service portal?

Refer : https://docs.servicenow.com/bundle/tokyo-employee-service-management/page/product/employee-center/ta...

Raghav
MVP 2023

RaghavSh · ‎03-30-2023

@Pooja_Patil I created the content through campaigns, but still its not being tracked. Any other idea?

Raghav
MVP 2023

RaghavSh · ‎04-02-2023

@Pooja_Patil @Pooja Gupta1 any suggestion on this?

Raghav
MVP 2023

Pooja_Patil · ‎04-03-2023

@RaghavSh, If setup correctly the tracking data takes some time to move from browser buffer to server-side and to content analytics tables. Refer Content Analytics Data flow

1. Make sure tracking is on for the campaign and you selected tracking profile, Please refer - How to configure a campaign

2. Make sure content scheduled through the campaign is available on the portal

3. 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)

If you want to see analytics data immediately -

4. 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.

~BR

Pooja Patil

Please mark this as helpful and accepted solution if applicable.