I am wanting to gather some data from discount codes that we have used on our store in the past.
Some of the data that I am trying to gather is when a person applied code "DISCOUNTX" - what products did they buy. I can do this at the moment if the customer only purchased one product but if the customer has purchased multiple products it shows up as N/A in the report.
I am also looking to get information on the average spend for a customer that has used "DISCOUNTX".
Can anyone please assist me and let me know if these things are possible?
Solved! Go to the solution
This is an accepted solution.
Elias here with Shopify Support. That's a great question!
There are a few options to get data from discount codes for you to consider, so let's take a look at each of them.
A. You can obtain a detailed sales report under 'Analytics > Reports', then click into the Sales reports and choose Sales by discount. This report can list each of the discount codes, the number of uses, and the revenue from each code. However, to see the types of products associated with each discount code - You'll need to edit the columns and add the 'Product title'. You can also add the 'Customer name' column to get more details from your sales report.
B. You can filter your orders by searching for a specific discount code, then you can export the results onto a CSV. This way, you will have a spreadsheet of every order containing the discount code and every product purchased by the customer in their order.
C. There are also third-party apps, such as Better Reports or Easy Reports, which can generate tailored discount reports. Both of these apps have a free trial available for you to see if it's the right fit for you. If you need any assistance with these apps, you can always reach out to the developers through the contact information found in the Support section of their app's page.
I hope this provides a few options for you to explore. If you have any other questions on this topic, don't hesitate to let me know!