How To Find Your Top Spending Customers

Using the Full Picture Enquiry, you can easily see your top spending customers, as well as those which are most profitable or buy the biggest quantity of items from you. Enquiries is the place to answer any questions you have about customer spend.

Select device:

Desktop

Apple 

Android

Desktop

Download a PDF version

 

Step 1: Go to Enquiries

From the black navigation bar at the top of the screen, click Enquiries.

find your top spending customers - desktop 1

 

Step 2: Understand Enquiries

The Full Picture enquiry is the default selection from the 4 enquiry types.

You can navigate to these different enquiries using the report type drop down.

To find your biggest spending customers this YTD, we will be using the default enquiry type, Full Picture, and the default date range, YTD.

find your top spending customers - desktop 2

 

Step 3: How to view customers

On the left side of your screen, within the Customer section, click on the Name bubble to view a list of your Customers.

Note: you can also use the Parent Account bubble to see overall spend for that customer, as opposed to spend for each delivery address separately.

find your top spending customers - desktop 3

 

Step 4: Sort results

Your biggest spending customers by sales Value are automatically sorted in descending order.

You will also see other measurement types, such as Cost, Profit, GP% and Quantity. You can click on any of these table headers to sort by this measurement type in descending or ascending order.

find your top spending customers - desktop 4

Save your Report (Optional)

 

Step 5: Save Enquiry

You can also Save this enquiry for future reference.

To do so, click Save in the top right corner

find your top spending customers - desktop 5

 

Step 6: Add a description

Type in a name for this enquiry, e.g. ‘Customer Spend YTD - Rolling’ in the Description field.

Note: it is good to be as clear as possible when naming saved enquiries, to help you understand what the enquiry will show when you come back to it later.

find your top spending customers - desktop 7

 

Step 7: Choose your settings

To keep the numbers in the report relevant to the date you are viewing the report, check the Roll Dates checkbox.

Power Users, choose to save the report for all users to see, by checking the Save enquiry globally checkbox.

Note: If you do not choose to roll the dates for the report, you will always see the dates you saved when you reopen the report in the future. Your data will not change. YTD dates will roll as standard.

find your top spending customers - desktop 7

 

Step 8: Save

Click the Save button.

This saved enquiry will now appear on your Home Page and will automatically update with the latest sales data if you have chosen to roll your dates.

find your top spending customers - desktop 8

 

Step 9: Revisit Saved Enquiry

As confirmation that your Enquiry has been successfully saved, a green text box will appear in the bottom right corner of the screen.

To access this, and all of your previously saved Enquiries, tap on Saved Enquiries.

find your top spending customers - desktop 9

 

Step 10: Saved Enquiries

Your saved Enquiries will be listed in alphabetical order.

These will also be displayed on your sales-i homepage.

find your top spending customers - desktop 10

Apple

Download PDF version

 

Step 1: Tap Enquiries

From the navigation bar at the bottom of the screen, tap Enquiries.

How to find your top spending customers - ios 1

 

Step 2: Tap the new Enquiries button

You will see your saved searches appear on the Enquiries home page.

To start a new report, tap the red New Enquiry button in the top, right corner.

How to find your top spending customers - ios 2

 

Step 3: Tap Full Picture

There are 3 enquiry types: Full Picture, Variance, and Sales vs Gaps.

Each report formats the data in a unique way to help you extract the information you need.

To find your biggest spending customers this year-to-date, tap Full Picture, this will use the default date range, which is year-to-date.

How to find your top spending customers - ios 3

 

Step 4: Tap the name bubble

You will then see the Bubble screen.

Here, you can pick from the five main categories of bubbles: Customer, Sales Team, Calendar, Sales, and Product (you may have further categories depending on your data). Each helps you drill into your data from a different viewpoint.

To see your biggest spending customer, tap the Name bubble under the Customer category.

How to find your top spending customers - ios 4

 

Step 5: Results table

Your biggest spending customers year-to-date are now displayed by sales value.

These customers are automatically sorted in descending order in a results table.

How to find your top spending customers - ios 5

 

Step 6: Explanation

Also displayed are Profit, Quantity, Average Price, Sales Cost, GP, and Transaction Count.

These columns help you identify how much profit you are getting from your biggest customer, or what quantity of items they are buying from you.

Tap on any other column header to sort by that measurement instead.

How to find your top spending customers - ios 6

 

Step 7: Save the report

You can also save this enquiry for future reference.

To do so, tap the menu icon in the top right corner of the totals bar, then tap Save.

How to find your top spending customers - ios 7

 

Step 8: Name enquiry

In the Description field, enter a name for this enquiry, such as “Customer Spend YTD (Rolling)”.

It is helpful to be as clear as possible when naming saved enquiries to remind you what the enquiry will encompass when you open it later.

How to find your top spending customers - ios 8

 

Step 9: Tap Save

Tap Save.

This saved enquiry will now be accessible via the Saved Enquiries button on your Home Page and will automatically update with the latest sales data.

Note: When saving a report with a default date range, such as year-to-date, the report will automatically roll the dates forward to keep your data current.

How to find your top spending customers - ios 9

Android

Download PDF version

 

Step 1: Tap Enquiries

From the navigation bar at the bottom of the screen, tap Enquiries.

your top spending customers - android - 1

 

Step 2: Tap the new Enquiries button

You will see your saved searches appear on the Enquiries home page.

To start a new report, tap the red New Enquiry button in the top, right corner.

your top spending customers - android - 2

 

Step 3: Tap Full Picture

There are 3 Enquiry types: Full Picture, Variance, and Sales vs Gaps.

Each report formats the data in a unique way to help you extract the information you need.

To find your biggest spending customers this year-to-date, tap Full Picture, this will use the default date range, which is year-to-date.

your top spending customers - android - 3

 

Step 4: Tap the name bubble

You will then see the Bubble screen.

Here, you can pick from the five main categories of bubbles: Customer, Sales Team, Calendar, Sales, and Product (you may have further categories depending on your data). Each helps you drill into your data from a different viewpoint.

To see your biggest spending customer, tap the Name bubble under the Customer category.

your top spending customers - android - 4

 

Step 5: Results table

Your biggest spending customers year-to-date are now displayed by sales value.

These customers are automatically sorted in descending order in a results table.

your top spending customers - android - 5

 

Step 6: Explanation

Also displayed are Profit, Quantity, Average Price, Sales Cost, GP, and Transaction Count.

These columns help you identify how much profit you are getting from your biggest customer, or what quantity of items they are buying from you.

Tap on any other column header to sort by that measurement instead.

your top spending customers - android - 6

 

Step 7: Save the report

You can also save this enquiry for future reference.

To do so, tap the menu icon in the top right corner of the totals bar, then tap Save.

your top spending customers - android - 7

 

Step 8: Name Enquiry

In the Description field, enter a name for this enquiry, such as “Customer Spend YTD (Rolling)”.

It is helpful to be as clear as possible when naming saved enquiries to remind you what the enquiry will encompass when you open it later.

your top spending customers - android - 8

 

Step 9: Tap Save

Tap Save.

This saved enquiry will now be accessible via the Saved Enquiries button on your Home Page and will automatically update with the latest sales data.

Note: When saving a report with a default date range, such as year-to-date, the report will automatically roll the dates forward to keep your data current.

your top spending customers - android - 8

Need additional help?

Drop us an email regarding your query to support@purchase-i.com and we'll get back to you within 24 hours. Alternatively, speak to a sales-i representative on Live Chat.