My name is Rae and I work for Shopify. Welcome to the Community!
This is a great question. I understand how valuable this type of data is, so I’m glad you reached out.
The best way to collect this data directly from your Shopify admin is to go through each order one-by-one, like you mentioned. However, as a workaround, apps can also be used to collect this information. An app like Repeat Customer Insights is a great option to look into. Some other reporting apps like Better Reports or DeepMine may also help to collect this data as well.
All of these apps are created and supported by third party developers, so if you have any questions about using these apps or collecting data, I recommend reaching out to the developers about this directly. To find their contact information, please check out the app’s page in our App Store and the developer’s details will be listed under the ‘Support’ section on the right hand side of the page.
Let me know if this helps! If you have any other questions or concerns, please post them here and I’ll be glad to look into things further.
Personal print actually has a really great analytics panel for returning customer data!
If has info about shopping cart evolution along orders, products most likely to be purchased by returning customers, promotions most likely to be effective at creating returning customers.. and a bunch more.
We're actually using it to send some automated personalized thank you notes to our customers for about a year -which is actually what they put forward-, and it's working amazing for that! (Gave quite a push in terms of return rate and organic social media posts too)