Skip to Content

Customer Reporting

Hey

So I have a customer that was trying to pull a report of all customer and their performance. so being able to see customers that have not bought anything in the past month. They have sales orders with free products so that counts towards a sales but I have been struggling to see if we can pull customers that have made no purchase over a time frame. I have already check customer invoice volume and sales order volume and they do not filter what i need to see. Would it be a KPI ? Could someone help!

Thanks

Alyssa

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Aug 26, 2015 at 07:07 AM

    Hello Alyssa,

    There is no report can fulfill your requirement directly. You can try to create a custom report in work center Business Analytics. Or, there is a indirect way you may try.

    1. Export the customer list into a excel.

    2. Run sales order volume report to show in a time period which customer created sales order.

    3. Export the report into excel. Compare these 2 lists, you will get the inactive customers.

    Hope it can anyhow bring an idea to you.

    Thanks,

    Adie

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 27, 2015 at 07:09 PM

    Thanks Adie! You just confirmed exactly what I needed!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 29, 2015 at 07:52 PM

    Hello Alyssa,

    I understand that you were trying to use the Invoice Volume report/Sales Order Volumen report to figure out which customers were inactive. In reports, be it standard or custom reports, the value # indicates 'unassigned'. So in either of the above mentioned reports, you can pull the following characteristic - Customers, Sales Orders. Invoices into the report pane, then select a time frame of your choice and then execute the report. If there are no associated sales orders, invoices for the customers then you can see # corresponding to those records.

    Another way of doing it is try if you can filter for # value for the sales orders or invoice characteristics from the Selection screen or from Edit Filter tabs.

    Thanks,

    GowriShankar

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.