Big News: FounderDating is joining OneVest to build the largest community for entrepreneurs. Details here
Latest Notifications
You have no recent recommendations.
Name
Title
 
MiniBio
FOLLOW
Title
 Followers
FOLLOW TOPIC

Question goes here

1,300 Followers

  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur
  • Name
    Entrepreneur

What are some "Customer Purchase Frequency" analysis tools?

I own an on-demand ecommerce delivery platform and I'm interested in understanding how frequently my customers purchase from me. Specifically, I would like to know if there's a tool that can drill down all the way to the customer level. Example: once you select a certain time frame, the tool can tell all the customers who purchased from me during that time frame and the number of times they placed an order. Further, the tool can give insight on a customer by customer basis. For instance during June 1, 2016 and August 1, 2016, customer A purchased 4 times: June 12, June 23, July 3, and July 24.

Would truly appreciate any pointers here
Thanks
Kodjo

2 Replies

Monroe Asami
0
0
Monroe Asami Entrepreneur
Vice President at AS KNOW AS CO., LTD
Hopefully, you're not using spreadsheets to accomplish these goals. I would recommend learning how to wield your own database. Filemaker Pro works the best. Assuming the tables in your database contain the data needed to generate the desired result, all you need is a script (a simple automatic command that you create by yourself in Filemaker Pro) that tells the database what to do--namely, create a printable report or export the result in text format which you can open with spreadsheet software. You can easily accomplish the goals you wish to achieve. You just need all of your data clearly entered into a relational database. Each table contains the critical info you need to integrate everything. And each table contains the customer id, since it's the customer id which binds each table together. This is the key. Remember: avoid spreadsheets like the plague (except for showing the results of what you've exported from the database).
Randall Plitt
0
0
Randall Plitt Entrepreneur
General Manager at Advanced Bending Technologies
Hi Kodjo - I looked at your website, and based on what I see, you must have a reasonable database system backing up your order system. I would be surprised if that system didn't already have some sort of reporting tool for your customers, but I guess that's possible.

A "drill down" tool would depend greatly on what system your data is in now. I would imagine (and I could be completely wrong) that there is some sort of export tool in the system you are using to take orders. If you could, say, export a record of your orders as a csv file, then maybe your analysis could just be in excel. That would be the quick and dirty way if your system doesn't have that reporting ability already.

If your system is contained within something that you have a bit more access to (i.e. if you have access to the tables in the database), you should be able to write a few queries to pull the info you need. For example, let's say you knew the tables and structure and it was in some sort of SQL dataset. writing the queries to pull customer/order date info would likely be fairly straightforward.
Join FounderDating to participate in the discussion
Nothing gets posted to LinkedIn and your information will not be shared.

Just a few more details please.

DO: Start a discussion, share a resource, or ask a question related to entrepreneurship.
DON'T: Post about prohibited topics such as recruiting, cofounder wanted, check out my product
or feedback on the FD site (you can send this to us directly info@founderdating.com).
See the Community Code of Conduct for more details.

Title

Give your question or discussion topic a great title, make it catchy and succinct.

Details

Make sure what you're about to say is specific and relevant - you'll get better responses.

Topics

Tag your discussion so you get more relevant responses.

Question goes here

1,300 Followers

  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
  • Name
    Details
Know someone who should answer this question? Enter their email below
Stay current and follow these discussion topics?