Tracking Cross Sale
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=703
Printed Date: 30-November-2024 at 7:43pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Tracking Cross Sale
Posted By: MOlson
Subject: Tracking Cross Sale
Date Posted: 14-March-2007 at 4:48pm
|
Our marketing department asked the question, Can we track how many
purchases were made through the cross sale feature. She was wondering
because she spends a lot of time on this and just wanted to know if it
was worth her time. Anyone have any ideas? |
Replies:
Posted By: netprofits
Date Posted: 14-March-2007 at 5:34pm
|
As far as I know, PC doesn't track this information related to sales. You could run the Export Sales Data report and see which orders have multiple products. Then compare those products to see if they were related in cross sells. That's the only option I can see right now. ------------- NetProfits Internet Consulting Certified ProductCart Developer http://www.nicwebdesign.com" rel="nofollow - Our Site |
Posted By: thrion
Date Posted: 14-March-2007 at 10:58pm
| Although not a function of the cart, many analytics packages will tell you how many clicks you receive on any given page on your site, so you could get a report through your analytics package to at least see how many people are clicking on your cross selling items. |
Posted By: MOlson
Date Posted: 15-March-2007 at 11:10am
I like the idea, but how do I differentiate between cross sale clicks and direct views of that product? |
thrion wrote:Posted By: thrion
Date Posted: 15-March-2007 at 12:20pm
That's the downside. You can't track the sale, but what you track is the click on the cross selling item itself. You could then look at the number of times the cross sell link was clicked (not the number of times the product was viewed, but rather the number of times the cross selling link on the product details page was clicked) and compare it to the number of times that product was sold. If you see, for example, that for product ABC you have a cross selling product of DEF listed. Your analytics package tells you that on the page for ABC, the link to DEF was licked 14 times and PC says that you sold 7, you could make an assumption that 50% of the time people buy the cross selling product that they clicked on. Again, you are making an assumption, but it's a good place to start. Not perfect, but closer than what you have. |
Posted By: NWilliams
Date Posted: 15-March-2007 at 5:42pm
|
What I would do is edit the pcs_CrossSellingAccessories code to include an extra query string.. something like crossSellClick=1. At which point in viewPrd.asp you can check to see if the query string exists, and increment a counter in the Products table in the database. You would, of course, need to add an additional field to the Products table. All you'd really need to do is something like: (make sure you put this code in an area where the rs object isn't being used) If QueryString("crossSellClick")=1 Then Query="UPDATE products SET crossSellClicks=crossSellClicks+1 WHERE idProduct=" & pIdProduct set rs=server.CreateObject("ADODB.RecordSet") set rs=conntemp.execute(query) End If This wouldn't give you how many sales you make through the feature, but it would show you how many times the product has been viewed specifically by clicking a link from the accessories area of cross selling. At which point I believe you're back at square one with regard to probability of purchase (unless you're using discounted bundles [which if you are, you'd need to duplicate the above code in pcs_CrossSellingDiscounts]). Then from the admin panel you could edit the export area to add this field.. I can't give you any specifics on that, but the above would be the first step. If you wanted to track the actual sales, you could forward the crossSellClick value to the cart array or something similar. |
Posted By: MOlson
Date Posted: 15-March-2007 at 6:15pm
| Thank you, that's a really good idea. Even if I just knew how many clicks I got out of it, that would help. |