Sales by Customer Report

If you want a summary of how much your customers purchased, and when those purchases occurred, consider using the “Sales by Customer” report. This report includes customer name, location, sales amount, units sold, and discounts applied. You can also narrow down the report by the number of items purchased, date last purchased, keyword, location, and much more.

Accessing the Report

There are two ways you can access this report. From the top of the screen, click on “Reports,” “Customer Reports,” and “Sales by Customer.”

Or, from the “Main Menu,” click on “Reports.”

Select “Customer Reports.”

Click on “Sales by Customer Report.”

Either way, you’ll end up at the following screen.

Report Fields

You can tweak these fields to filter the report or leave them as they are. 

If you want to change the date, enter it manually or select it from the calendar (accessed from the downward-facing arrows).

Customer Types

This field contains your list of customer types (ex. retail and wholesale). Select one to only view customers in that category or leave it set to “all” to include every customer type.

Birthdays and Anniversaries

Use these two fields to narrow down any customer birthdays or anniversaries. This is especially helpful if you’re planning on sending out special discounts to customers based on these criteria. Based on how often they’ve purchased from you, you can see if they might be more inclined to purchase from you again soon, and what items they might be interested in.

Who Purchased Specific Items or Dollar Amount Between Dates

You can further narrow down the report parameters here. There are plenty of options to “mix and match” your results. For example, you can include customers who purchased at least five items since May 3, 2022. Or, as another example, you can look for customers who purchased more than $50 worth of items in the last three months. These fields truly allow you to be as specific as possible.

You can even look for customers who bought items with specific descriptions or one of your own custom fields.

To narrow or expand your report, you may choose to include or exclude keywords and locations. You can also narrow down email parameters and define your report by when the customer was added to Artisan. 

Reading the Report

Customer Name

Lists the company name and first/last name in the customer record.

City / State

Lists the customer’s location.

Sales

The amount of sales the customer made during the time period.

Units

The number of items the customer purchased within the time period.

Discounts

Total amount of discounts applied to that customer during the time period.

Email

The customer’s email, if they have one in their customer record.