Splunk Search

What is the best way to handle sequential event funnels?

andynu
Engager

Given a sequence of general to specific events (like product browsing a pages, followed by particular product pages). What is the best way to bring information from the browse events into the results for the product event?

log example

 time=1 session=1 pageType=browse name=NewStuff resultsCount=3
 time=2 session=1 pageType=product product=a
 time=3 session=1 pageType=product product=b

In the example a user hit a browse page with three products, and clicked through on two of them. I would like to transform those events into a table like this:

desire result

| session | srcBrowseName | Product |
| 1       | NewStuff      | a       |
| 1       | NewStuff      | b       |

Notice that I have to repeat data from the browse event for each of the product page events. I have an inkling that this could be accomplished with a subsearch, perhaps a subsearch of a |transaction session startswith="pageType=browse".

1 Solution

gkanapathy
Splunk Employee
Splunk Employee

Maybe:

pageType=product | join session usetime=true earliest=true [ pageType=browse | fields - resultsCount ]

is something like what you need?

View solution in original post

gkanapathy
Splunk Employee
Splunk Employee

Maybe:

pageType=product | join session usetime=true earliest=true [ pageType=browse | fields - resultsCount ]

is something like what you need?

andynu
Engager

Thanks!

pageType=product |join session usetime=t earlier=t [search pageType=browse | fields + resultCount]

Unfortunately |join seems to be very particular about which types of fields it will work on, some of my fields that in independent searches extracted matching field values did not work as the join parameter.

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...