Create a table where columns will be action, Jsessionid, status and it will return all the products which were successfully processed and action=purchase.

Write a query to search, which returns all web application events that include a purchase action and visualize the products statistics with the help of Splunk

Session IDs are called "UserSessions" in the marketing data. Rename JSESSIONID so that your report matches the marketing data

Remove the duplicate Usersessions

Use the top command to find the best-selling productIds for all time.

Use a command to find worst selling procductIDs