What's Included in Vagaro's Power BI Template App – Vagaro Support

Report List

Appointments

Trend of booked appointments in Vagaro. Highlights online booked appointments and booking completion.
Sales

Trend of total sales as recorded in Vagaro. Includes transactions processed through payment processing and other payment methods.
Service Sales

Trend of sales for services.
Product Sales

Trend of sales for products.
Memberships Sales

Trend of sales for memberships
Package Sales

Trned of sales for packages.
Gift Certificate Sales

Trend of sales for gift certificates.
Service Add-Ons Sales

Trend of sales for service add-ons.
Class Add-Ons Sales

Trend of sales for class add-ons.
Location Performance

Key metrics by location.
Service Provider Performance

Key metrics by service provider
Appointment List

Table listing all appointments booked through Vagaro.
Transaction List

Table listing all transactions recorded in Vagaro.
Customer List

Key metrics per customer.
Membership List

List of all memberships recorded in Vagaro.

KPI Definitions

Metric	Definition	Report Pages
Total Appointments / Appointments	Total number of appointments booked through Vagaro	Appointments, Location Performance, Service Provider Performance, Customer List
Total Appointment Value	Dollar amount of appointments booked through Vagaro	Appointments, Appointment List
Cancellations & No Shows	Number of appointments that have current status of cancelled or no shows	Appointments, Location Performance, Service Provider Performance, Customer List
% Service Completed	% of appointments with service completed status out of all total appointments	Appointments
Total Sales	Dollar amount of sales as recorded in Vagaro	Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Transaction Count	Total number of transaction as recorded in Vagaro	Sales
Service Sales / Total Service Sales	Dollar amount of sales for services	Sales, Service Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Product Sales / Total Product Sales	Dollar amount of sales for products	Sales, Product Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Membership Sales / Total Membership Sales	Dollar amount of sales for memberships	Sales, Membership Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Gift Certificate Sales / Total Gift Certificate Sales	Dollar amount of sales for gift certificates	Sales, Gift Certificate Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Package Sales / Total Package Sales	Dollar amount of sales for packages	Sales, Package Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Other Sales	Dollar amount of sales for other purchase types	Sales
% Service Sales	% of total sales that were from services	Sales
% Product Sales	% of total sales that were from products	Sales
Credit Card	Dollar amount of sales that were from credit cards (specific pages will be filtered to their respective purchase type)	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
Cash	Dollar amount of sales that were from cash psymrnyd (specific pages will be filtered to their respective purchase type)	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
Check	Dollar amount of sales that were from checks (specific pages will be filtered to their respective purchase type)	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
ACH	Dollar amount of sales that were from ach payments	Sales
Pay Later	Dollar amount of sales that were from Buy Now, Pay Later (specific pages will be filtered to their respective purchase type)	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
Other	Dollar amount of sales that were from other payment methods (specific pages will be filtered to their respective purchase type)	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
Tax	Dollar amount of tax that was collected	Sales, Location Performance, Service Provider Performance
Tip	Dollar amount of tip that was collected	Sales, Location Performance, Service Provider Performance
Membership Redemptions	Dollar amount of memberships that were redeemed and used as payment method	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
Package Redemptions	Dollar amount of packages that were redeemed and used as a payment method	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
Gift Certificate Redemptions	Dollar amount of gift certificates that were redeemed and used as a payment method	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales
Discount	Dollar amount of discount that was applied to a sale	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales, Location Performance, Service Provider Performance
% Charge to Redemption	% of cash flow to total sale	Sales, Service Sales, Class Sales, Product Sales, Membership Sales, Package Sales Gift Certificate Sales, Service Add-Ons Sales, Class Add-Ons Sales, Location Performance, Service Provider Performance
Class Sales	Dollar amount of sales from classes	Class Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Service Add-Ons Sales / Total Service Add-Ons Sales	Dollar amount of sales from service add-ons	Service Sales, Service Add-Ons Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Class Add-Ons Sales / Total Class Add-Ons Sales	Dollar amount of sales from class add-ons	Class Add-Ons Sales, Location Performance, Service Provider Performance, Transaction List, Customer List
Online Booking Fee	Amount of booking fees charged during sale	Location Performance, Service Provider Performance