How can I perform a basket analysis on first-time customer orders?

JMcBurney
Tourist
4 0 1

I'm trying to do a basket analysis on customer first orders. I can export order line data from Shopify and perform a basket analysis with this data, however I don't think I can filter by first order. Without a filter, I figure that my options are either to get the data through a Shopify app, or somehow manipulate the data in Excel. I could hypothetically export all orders, and create a column that shows order number per customer, but I'm not really sure how to do this. There's the added complexity that the data is grouped by line item.

 

Is there an easier way to do a basket analysis on first orders? Is there a way to do this in Shopify that I am not seeing? Is there an app I can use which is comprehensive but not too expensive?

Replies 11 (11)

CloudlabSam
Shopify Partner
553 46 91

You can use our Report Toaster app to show the first order for each customer. Please feel free to take a look and we can help you create the report you need if necessary.

JMcBurney
Tourist
4 0 1

In addition to the first order export, is there an existing basket analysis template we could run off this data set? 

We could pair the export with the Shopify order line export, and vlookup order number. Just wondering if there are any pre-existing reports to make it cleaner and provide more insight.

mipler
Shopify Partner
29 2 9

We already created a similar report with Mipler Advanced Reports

 

Example of the report: https://prnt.sc/kpH4hWu0pRrK

Plus you can filter this report by order increment number for customer

 

 

CloudlabSam
Shopify Partner
553 46 91

Nice report. 

mipler
Shopify Partner
29 2 9

Don't worry. It's autogenerated demo data.

JMcBurney
Tourist
4 0 1

Same question as above. Would we have to export the data and look up the order line data in Shopify, or are there pre-existing basket analysis reports that we could run on the first order data set to provide more insight?

CloudlabSam
Shopify Partner
553 46 91

All of the data you need would be available in Report Toaster itself.

mipler
Shopify Partner
29 2 9

You can modify existing reports and build derived reports with a filter by the first order.

 

Examples:

 

Line items: https://prnt.sc/i3FmhSAs5Uu6

Sales by product by order number (pivot table):  https://prnt.sc/L9Q7VFURvSg2

 

ImaneLTB
Visitor
1 0 0

Hi there, I'm looking for the sequency number / order fact filter and I'm not able to find it. Would you be able to please explain how to create this view ; https://prnt.sc/L9Q7VFURvSg2 ?
I'm actually trying to find out how many customers ordered - as a first purchase - a product of a certain collection.
Thank you for your help

Dеnys_Mipler
Shopify Partner
56 0 2

Hi,

 

Thank you so much for contacting me!

The needed report has been created especially for you on your store by our team 🙂

I hope it is exactly what are you looking for!

Just Play in Analytics with Advanced Reports
Other Great Apps: [ Shopping Feeds | Instant Search ]
Socials: [ Facebook | Twitter | Blog ]

Milton_james1
New Member
11 0 0

Hey, I've given SuperU a try, and it's been fantastic for analyzing Shopify data. It's incredibly user-friendly. They even offer a 30-day free trial. I highly recommend checking it out for a better solution. I can share my experience and discuss with you. Here’s the website link of superU.