cartToPurchase(%) by productID : purchases/addtocart

[kuramesh]

Can you pls share the cartToPurchase(%) by productID : purchases/addtocart query 

[kuramesh]

Might be you are not able to understand.

I have tutorial data in splunk

[ITWhisperer]

Yes, I do not have the tutorial data you mentioned

Instead of doing stats by productName, can you do them by productId?

[kuramesh]

Hi i have  tutorial data, already uploaded in Splunk, but i need quires to fetches the data. can you share the quires for below requested data.

Client purchase details:
         Provide details about client purchase details 

         1. Total Purchase split by product ID

         2. Product Names split by product ID

Purchase Statistics:
          Provide :

         1. cartToPurchase(%) by productID : purchases/addtocart

         2. viewsToPurchase(%) by productID : purchases/views (total event count AS view)

[ITWhisperer]

What queries have you tried so far?

[kuramesh]

sourcetype=access_* status=200 | chart count(eval(action="addtocart")) AS addtocart count(eval(action="purchase")) AS purchases by productName | eval percent=(purchases/addtocart )*100 

[ITWhisperer]

Is there a productId field in the data?

[kuramesh]

Its very urgent and critical if possible pls share your contact details so that i can contact you.

[kuramesh]

Yes,

Pls share the quires so that i can fetch report.

[ITWhisperer]

Try changing productName to productId in your search

sourcetype=access_* status=200 | chart count(eval(action="addtocart")) AS addtocart count(eval(action="purchase")) AS purchases by productId | eval percent=(purchases/addtocart )*100 

 and see what id does. This is a tutorial right? Presumably, you are trying to learn how to use splunk? One of the best ways to learn is by trying things and see what happens. 

[kuramesh]

Hi You has been failed to resolve my concern.

[kuramesh]

Hi have all the required data in splunk but i need separate query for below report.

Client purchase details:
         Provide details about client purchase details 

         1. Total Purchase split by product ID

         2. Product Names split by product ID

Purchase Statistics:
          Provide :

         1. cartToPurchase(%) by productID : purchases/addtocart

         2. viewsToPurchase(%) by productID : purchases/views (total event count AS view)

[kuramesh]

sourcetype=access_* status=200 | stats count AS views count(eval(action="addtocart")) AS addtocart
count(eval(action="purchase")) AS purchases by productName | eval
viewsToPurchases=(purchases/views)*100 | eval cartToPurchases=(purchases/addtocart)*100 | table
productName views addtocart purchases viewsToPurchases cartToPurchases | rename productName AS
"Product Name", views AS "Views", addtocart as "Adds To Cart", purchases AS "Purchases"

[ITWhisperer]

Please provide more detail as to what this question is about

[kuramesh]

I need to fetch below data from splunk, pls suggest.

Access Dashboard:
         1. Number of hits
         2. Top 20 category and top 20 domain
         3. Status code count

Client purchase details:
         Provide details about client purchase details 

         1. Total Purchase split by product ID

         2. Product Names split by product ID

Purchase Statistics:
          Provide :

         1. cartToPurchase(%) by productID : purchases/addtocart

         2. viewsToPurchase(%) by productID : purchases/views (total event count AS view)

[ITWhisperer]

Can you provide some sample events that you have in your splunk, preferably in code blocks </>