Participants contribute total bookings counts for a number of key metrics. Counts are broken down by zipcode + effective_start_date + effective_end_data.
In the event that you want to contribute player participation data, ie how many players have played during the collection period, use the following fields:
Aggregate data is serviced by file contribution only.
Please escape any special characters such as embedded quotes with a '\' (backslash) before including it in any field in the file. See https://ustadigital.atlassian.net/wiki/spaces/DEV/pages/39648460801
The following criteria applies to the data submissions
Timeframe to included
Cummulative Year to Date based on Reservation date
Only US Zipcodes should be included
Effective Start/End Dates
Should be based on Reservation Date
effective_start_date, effective_end_date, game_type, zipcode, facility_id
Player files use the following naming convention
SOURCENAME: The contributor name assigned by USTA.
YYYYMMDD: Effective date of contribution
The following table lists the fields and formats.
Contributor (USTA will assign)
Start of reported data (Reservation date), Should always be jan 1 of the current year
End of reported data (Reservation date) - should always be the last day of the reporting month, ie 2023-10-31
5 digit zipcode - must include any leading zeros
Unique id (or name) assigned by the participating vendor for the facility
Unique players based on aggregation grain. Includes unique players for court reservations, event reservations and lesson reservations.
Unique players based on aggregation grain. Includes unique players for court reservations only.
Unique players based on aggregation grain. Includes unique players for event reservations only.
Unique players based on aggregation grain. Includes unique players for lesson reservations only.
Total count of court reservations based on aggregation grain. (Includes repeats by individuals)
Total count of event reservations based on aggregation grain. (Includes repeats by individuals)
Total count of lesson reservations based on aggregation grain. (Includes repeats by individuals)
Source Name: ACTIONSPORTS
Effective Date: 2024-06-20
ACTION_SPORTS,2023-01-01,2023-01-31,TENNIS,10604,Star Tennis Academy,99,33,33,33,33,33,33
On This Page: