20 Dec 2022 09:45 PM - last edited on 21 Dec 2022 12:22 AM by MaciejNeumann
I am facing a situation where the funnel metrics data is mismatched (regardless of the different timeframes) with the individually created tile of each key user action (funnel chart created with the key user actions). In both charts/tiles, the same key user actions are used. I checked almost all the aggregations with the fold transformation but no luck.
What am I doing wrong?
@Babar_Qayyum FUNNEL works on USQL with it's limitations. So keep in mind when comparing the data
If still in doubt, try to narrow down the funnel filtering and investigate a particular session when you are sure it should be in the funnel but it's not. Most likely it will be due to the 200 action limit or due to other limits.
Yes, I am aware of the limitation of USQL. Apologies I could not understand the second point.
I tried to narrow it down and found different results e.g. today and the last 2 hours:
Afaik if the whole session is split into chunks of 200 actions. All actions in a funnel must be present in a single chunk afaik.
Also when comparing, I'd compare values for yesterday or at least 8 hour old data to ensure there are no live sessions anymore. Comparing metric data and USQL for last 2 hours makes no sense due to live sessions.
In your example for Today - you have a higher number in the Funnel for the first action. This is particularly interesting - what funnel conditions do you have? are you sure you are looking at the same actions? Any chance you are counting both route change and XHRs?
These are XHR actions and all are marked as a key user actions. I could not get the question what funnel conditions do you have?
I checked more extended periods in the historical data but a noticeable difference is there e.g. day before yesterday: