Why Are “Page change” Events Not Returned in userAction Queries?

[Aboud1]

Hello Community,

We are noticing a discrepancy between the actions visible in the User Session timeline and the results returned from querying the userAction table.

Session contains the following visible events related to /en/home:

• Load → loading of page /en/home

• Page change → /en/home

From the session timeline, the total visible /en/home actions are 10.

However, when querying userAction, we are getting lower counts.

Query #1:

SELECT count(*)
FROM userAction
WHERE (
    targetUrl LIKE "%/en/home%"
    OR name = "loading of page /en/home"
)
AND application = "xxxxxx"
AND usersession.internalUserId = "xxxxxxxx"

Result: 7

Query #2:

SELECT count(*)
FROM userAction
WHERE (
    name = "loading of page /en/home"
    OR name = "/en/home"
)
AND application = "xxxxxxxx"
AND usersession.internalUserId = "xxxxxxxxxxxxxxxxxxxxx"

Result: 4

It seems that some “Page change” events visible in the session timeline are not queryable from the userAction table.

Has anyone faced similar behavior before?
Is there a recommended way to retrieve all visible session timeline actions (including Page change events) through queries?

Thanks.

Aboud

[sujit_k_singh]

Hi @Aboud1 

This is expected behavior. "Page change" events in the session timeline are route change detections that don't always get promoted to full user actions in the userAction table.

The userAction table only contains actions that triggered measurable network/rendering activity (Load, XHR, Custom actions). Route changes displayed in the timeline are visual markers — not queryable via USQL unless they generated actual XHR calls.

Try this to get closer:

SELECT count(*), type
FROM userAction
WHERE application = "xxxxxx"
AND usersession.internalUserId = "xxxxxxxx"
AND name LIKE "%/en/home%"
GROUP BY type

Also check if missing actions were captured as XHR type with auto-generated names rather than the page URL.

Thanks,

Sujit