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-22-2023

@RaghavSh ,

Please verify following -

You have at least one default Tracking Profile, Content Analytics > Tracking Profiles
Event tracking with “scheduled content” doesn’t work OOTB with any portal. It only works with campaign content
Widget must include cdaAnalytics provider and track events for it to queue anything to sn_cda_tracked_evt_agg

Which OOB widget events you are looking to track?

~

Pooja Patil

Please mark this as helpful or accepted solution if applicable.

RaghavSh · ‎03-22-2023

@Pooja_Patil the tracking profile is marked as active and default.

I am trying to track OOB upcoming events , video carousel widgets on EC pro portal.

Also these widgets have cdaAnalytics angular provider.

Any other lead?

Raghav
MVP 2023

Pooja_Patil · ‎03-23-2023

Both Upcoming Events (CD), Video Carousel (CD) instances on ec_pro_dashboard are Content Publishing widgets. Event (clickthrough and impression) tracking is only supported for contents scheduled through campaigns.

More on campaigns here - https://docs.servicenow.com/bundle/utah-employee-service-management/page/product/employee-center/con...

~

Pooja Patil

Please mark this as helpful or accepted solution if applicable.

RaghavSh · ‎03-23-2023

@Pooja_Patil then why do we have cdaAnalytics angular provider in upcoming events CD widget and the client controller capturing the "expanding event" of Upcoming Events (+) icon.

Raghav
MVP 2023