Transactions & Sales Metrics
The Transactions & Sales Metrics dataset provides aggregated financial performance data for each Business Location over a defined reporting period. It captures revenue, transaction volume, and unique customer count — enabling store-level performance benchmarking, trend analysis, and market share comparisons.
All metrics are scoped to a Business Location and a specific time window defined by start_at and end_at.
Schema
business_location_id
String
No
UUID of the associated Business Location
001dd142-4627-4bcf-be8a-b048e...
revenue_amount
Float
No
Total revenue generated in the reporting period
2309.88
transaction_count
Integer
No
Total number of transactions in the reporting period
657
customer_count
Integer
No
Number of unique customers in the reporting period
599
start_at
Date
No
Start date of the reporting period (inclusive)
2024-03-01
end_at
Date
No
End date of the reporting period (inclusive)
2024-03-31
Notes
business_location_id — Foreign key referencing the id field in the Business Location schema. Use this to join financial metrics to location attributes such as address, category, and brand.
revenue_amount — Represents estimated total consumer spend at the location for the period, denominated in USD. Values are derived from anonymized transaction data and may reflect a modeled estimate rather than exact reported revenue.
customer_count vs transaction_count — A single customer may complete multiple transactions within the same reporting period. customer_count reflects unique cardholders, while transaction_count reflects the total number of individual purchase events. The ratio between the two can be used to derive repeat visit rate.
Reporting period — Data is typically delivered at monthly granularity, where start_at is the first day of the month and end_at is the last day. Always filter using both fields together to ensure period accuracy when querying across multiple records.
Last updated