TL;DR
There is an attribution bug with Appointments:
-
When a customer pre-books online (no human booker) → API correctly attributes to the service provider -
When a cashier books the appointment → API attributes to the booker, not the service provider
We need a way to run a report based on the Service Provider the service was rendered with. So something like: ServiceDoneBy , ServiceProvider, ServiceWith
Long Version:
We run a wellness business that uses Square Appointments to manage service-based bookings across about 16 service providers. We rely on Square data to calculate weekly commissions, and I’ve run into an attribution issue that I’d love guidance on.
When I query the Reporting API’s SalesByServiceDate view (or the underlying Orders cube) using team_member_attributed_to_id, the field doesn’t reflect the team member who actually performed the service. According to the documentation, attribution priority is: ownership transfers → ticket assignment → appointment staff → payment collection. In practice, when our front-desk team member books or claims ownership of an appointment, that overrides the appointment staff assignment — even though the appointment was performed by a completely different provider.
Concrete example from the week of May 11–17, 2026:
• Provider N.C. performed 13 appointments based on my Square Appointments screenshots, totaling $1,567.50.
• The Reporting API only attributes 8 orders / $600 in net sales to her.
• The missing 5 orders (~$967.50) are attributed to J.T., who is the booker/front-desk person — not the service provider. Several of these orders explicitly show ‘Booked by J.T.’ in the appointment detail screen.
This affects my ability to calculate accurate provider commissions directly from the Reporting API, which would otherwise be a perfect fit for our weekly reporting workflow.
My questions:
1.. Is there a different dimension or measure in the Reporting API that exposes the underlying appointment staff per order line (Service Provider) — even if team_member_attributed_to_id stays as-is for other purposes?
2. Is there a setting in Square Appointments (or anywhere in the dashboard) that controls how attribution is prioritized? Specifically, is there a way to prioritize appointment staff over ticket assignment / ownership transfer for service-based businesses?
3. If no such setting exists today, is this on the roadmap? Many service businesses (salons, spas, wellness studios, etc.) need ‘who performed the service’ attribution for commission and payroll, separate from ‘who booked / managed the ticket.’
If helpful, I can share specific order IDs from the week of May 11–17 that illustrate the discrepancy. Happy to provide any additional detail.
Thanks for your time — really appreciate the work on the Reporting API; SalesByServiceDate is exactly the right shape for our use case, this attribution piece is the one thing standing in the way.