Splunksplunktransactionssession-analysisbusiness-metricsproduction-ready

Transaction Analysis

SPL queries for analyzing multi-event transactions including user sessions, request flows, and business process completions.


title: "Transaction Analysis" description: "SPL queries for analyzing multi-event transactions including user sessions, request flows, and business process completions." category: "Splunk" language: "spl" tags: ["splunk", "transactions", "session-analysis", "business-metrics", "production-ready"] createdAt: "2025-04-05" updatedAt: "2025-04-20"

Overview

Transaction commands group related events into logical units for end-to-end analysis. This enables conversion funnel tracking, distributed trace analysis, and bottleneck detection across multi-step business processes.

Code

| transaction session_id maxspan=30m maxpause=5m
| eval conversion=if(searchmatch("event=purchase"), 1, 0)
| stats avg(duration) as avg_session_time, sum(conversion)/count as rate

Notes

  • maxspan limits total transaction duration; maxpause limits gaps between events
  • searchmatch within transactions searches across all events in the group
  • mvcount(event_type) counts distinct steps in multi-event flows
  • Transaction commands are memory-intensive; use stats with earliest/latest for better performance at scale
  • For distributed tracing, correlate on trace_id rather than relying on time proximity