Spreadsheet designed to work out which products are selling together most often
- or -
Post a project like this3017
$$$
- Posted:
- Proposals: 4
- Remote
- #1002342
- Awarded
Description
Experience Level: Expert
General information for the business: We sell cookie cutters online
Description of excel work: I have the last 12 months sales data and would like an excel table or similar (I am not an expert in excel so an expert would know the best way to represent this data) that will show me, for each product we sell, which products are sold in the same sale most often. This data will be used to recommend products to customers in our store via a "You might also like..." section (as shown on this page here: http://cookiecuttershop.com.au/products/haughty-tom-cat-cookie-cutter-c2082)
I have attached a sample of the data I will provide. There are 19,692 lines of data and 1875 unique products.
For each product I need to see the 10 products most often purchased in the same cart or order. If there aren't 10 products then just show me how many there are but I don't want to see more than 10, just the 10 most often sold with that product.
For example, the data I want to see is:
Item Cross Sell Item How Many Times Sold Together
C1257 C1711 25
C1001 12
M0510 12
C1511 11
C4000 10
C3004 9
C3003 7
C1200 3
C3030 3
D0501 3
Extra notes: I need this project completed by Monday 4th January. Please provide a quote on this job and also confirm that you will be able to meet this deadline and let me know about your experience with a similar project to this one.
Our website is www.cookiecuttershop.com.au
Description of excel work: I have the last 12 months sales data and would like an excel table or similar (I am not an expert in excel so an expert would know the best way to represent this data) that will show me, for each product we sell, which products are sold in the same sale most often. This data will be used to recommend products to customers in our store via a "You might also like..." section (as shown on this page here: http://cookiecuttershop.com.au/products/haughty-tom-cat-cookie-cutter-c2082)
I have attached a sample of the data I will provide. There are 19,692 lines of data and 1875 unique products.
For each product I need to see the 10 products most often purchased in the same cart or order. If there aren't 10 products then just show me how many there are but I don't want to see more than 10, just the 10 most often sold with that product.
For example, the data I want to see is:
Item Cross Sell Item How Many Times Sold Together
C1257 C1711 25
C1001 12
M0510 12
C1511 11
C4000 10
C3004 9
C3003 7
C1200 3
C3030 3
D0501 3
Extra notes: I need this project completed by Monday 4th January. Please provide a quote on this job and also confirm that you will be able to meet this deadline and let me know about your experience with a similar project to this one.
Our website is www.cookiecuttershop.com.au
Lisa M.
100% (68)Projects Completed
46
Freelancers worked with
29
Projects awarded
65%
Last project
13 Feb 2024
Australia
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies