> For the complete documentation index, see [llms.txt](https://docs.perkville.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.perkville.com/features/reports/points-by-location.md).

# Points By Location

The Points By Location Report allows you to gauge the activity level at each of your locations. It provides valuable insights into how points are earned and redeemed across different locations, helping you manage and optimize your loyalty program.

**Columns in the Points By Location Report**

* **Location Name:** The name of the location where points were earned or redeemed.
* **POS Location ID:** The Point of Sale ID for the location in question (e.g., ABC Club Number, MindBody ID, ASF Club Number).
* **New Customers:** Count of customers that earned points for the first time in the date range.
* **Total Points Earned:** Total points earned for that location in a given time period.
* **Total Points Spent:** Total points redeemed for that location in a given time period.
* **Total Points Expired:** Total points expired for that location in a given time period.
* **Change in Point Balance during Queried Time Period**: The total points accumulated in a specific period, subtracting points spent or expired.
  * **Note:** To view the total outstanding point balance as of a specific date (e.g., December 31, 2025), leave the Start Date blank and enter only an End Date—this will return balances as of that end date rather than changes within a defined period.
* **Total Earn Transactions:** All transactions that earned points for that location in a given time period, excluding Registration Bonus.
* **Total Redeem Transactions:** All transactions that involved points being redeemed/removed for that location from a customer account for that location in a given time period. This does not include expiration transactions.
* **Total Expiration Transactions:** All transactions that expired points for that location in a given time period.

**Filters for the Points By Location Report**

Before running the report, you can apply the following filters to customize the data:

* **Start Date/End Date:** Define the date range for the report to include only the transactions that occurred within this period.
* **Hide cancelled members**: Exclude non-active members from the report. Only applicable to businesses using memberships.

**Generating the Report**

To generate the Points By Location Report:

1. Navigate to the Reports section in your Perkville dashboard.
2. Select Points By Location from the list of available reports.
3. Apply the desired filters and choose your date range.
4. Click **Run Report** to export the data as a CSV file for further analysis.

This report is essential for understanding the distribution of points activity across your locations, helping you assess and improve the performance of your loyalty program.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.perkville.com/features/reports/points-by-location.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.