I am seeing some inconsistent outcomes for a custom metric I have created.
Custom metric is called ‘Progression’ and it was created to measure how efficiently our visitors are moving down the purchase funnel.
The combined ‘Progression’ metrics is the sum of multiple sub metrics reflecting visitors moving down the step of our purchase funnel:
- Top of funnel progression
- Middle of funnel progression
- Bottom of funnel progress
- Conversion initiation progression
When reviewing the output for all sessions, this metric seems to function correctly.
Note: The metric counts only when a session views a page lower in the purchase funnel than the session entry page. As such, not all sessions are eligible for each of the sub metrics.
Ex: A session starting on a bottom of the funnel landing page is not eligible to be considered “progression” if they visit a top of funnel page.
The issue I am having is that I see a zero for the final output for sessions not eligible for every sub metric.
Note: I see zeros in the UI for these sub metrics, but when I export, I see blank or missing values.
My theory is that Adobe Analytics is reporting a null or blank when a session is not eligible for a specific metric, and when the combined metric attempts to add up the component values it is not able to do so.
Can anyone confirm this is likely case? If so, is there a way around this issue as it is understood not all the sub metrics will have values for all sessions?
