File-Based Individual Booking Contributions

Owned by Jonathan Cohen
Last updated: Apr 17, 2024
2 min read

Overview

The purpose of this feed is to gather the number of court bookings, lessons and events per individually named person on a specific date. The intent is to gather counts for each category to build demographics around how many bookings are made.

Participants contribute per person per event bookings for a number of key metrics.

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

File Submission Attributes

The following criteria applies to the data submissions

Attribute

Detail

Attribute

Detail

Frequency

Monthly

Timeframe to included

<Start Of Month> through <End Of Month>

Inclusion Criteria

Only US Zipcodes should be included in 5 digit format

Effective Start/End Dates

Should be based on start_datetime/enddatetime

Contribution Grain

player_lname
player_fname
game_type
event_type
start_date_time
end_date_time

File Name Convention

Player files use the following naming convention

INDIVIDUAL-BOOKINGS-[SOURCENAME]-[YYYYMMDD].csv

Where:

  • SOURCENAME: The contributor name assigned by USTA.

  • YYYYMMDD: Effective date of contribution

Column Definitions

The following table lists the fields and formats.

Field

Sample Value

Required Y/N

Description

Field

Sample Value

Required Y/N

Description

source_name

CLUBSPARK

Y

Contributor code assigned by USTA

booking_external_id

12345678

Y

Contributor internal system Id

game_type

TENNIS

Y

TENNIS/PICKLEBALL/PADEL

created_on

10/18/2022 11:15 AM

Y

Contribution datetime

created_by

Kim Desdunes

Y

Contribution preparer email address

start_date_time

10/18/2022 11:15 AM

Y

court bookings, lesson

end_date_time

10/18/2022 11:15 AM

Y

court bookings, lesson

player_uaid

2018123456

N

USTA id

player_external_id

2018123456

N

Contribution external player id

player_lname

Smith

Y

Player Last Name

player_fname

John

Y

Player First Name

player_birthdate

2000-01-01

N

Player Birthdate

player_gender

M

N

MALE/FEMALE

player_zipcode

10536

N

5 digit code

player_addr1

1 Oak Street

N

String

player_addr2

Suite C

N

String

player_city

Anytown

N

String

player_state

NY

N

2 digit state code

player_zip

10019

N

5 digit zipcode

facility_name

Saw Mill Club

Y

String

facility_external_id

2018123456

N

Contributor unique id for facility

facility_id

2018123456

N

USTA id for facility

facility_addr1

1 Oak Street

Y

String

facility_city

Anytown

Y

String

facility_state

NY

Y

String

facility_zip

10019

Y

5 digit code

facility_total_no_of_tennis_courts

10

Y

Total number of courts at facility

facility_total_no_of_pickelball_courts

0

Y

Total number of courts at facility

facility_total_no_of_padel_courts

0

Y

Total number of courts at facility

event_type

LESSON

Y

COURT/LESSON/EVENT

event_name

Mixer Round Robin

N

String

event_external_id

2018123456

N

Contributor unique id for event

court_fee

5.00

N

Fee to book court (if any)

event_fee

100.00

N

Fee to book event or lesson (if any)

instructor_lname

McSporty

N

Coach last name

instructor_fname

Tad

N

Coach first name

instructor_birthdate

2000-01-01

N

YYYY-MM-DD

instructor_gender

M

N

MALE/FEMALE

instructor_zipcode

10019

N

5 digit zipcode

instructor_addr1

1 Main Street

N

String

instructor_addr2

Building 2

N

String

instructor_city

Anytown

N

String

instructor_state

NY

N

2 digit state code

instructor_zipcode

10019

N

5 digit zipcode

instructor_external_id

ABC12345

N

Contributor unique id for coach

instructor_uaid

2018654321

N

USTA id for coach

Example

INDIVIDUAL-BOOKINGS-[Source Name]-[Effective Date]

BOOKINGS-ACTIONSPORTS-20240630.csv

Where:

Source Name: ACTIONSPORTS

Effective Date: 2024-06-30

source_name,booking_external_id,game_type,created_on,created_by,start_date_time,end_date_time,player_uaid,player_external_id,player_lname,player_fname,player_birthdate,player_gender,player_zipcode,player_addr1,player_addr2,player_city,player_state,player_zip,facility_name,facility_external_id,facility_id,facility_addr1,facility_addr2,facility_city,facility_state,facility_zip,event_type,event_name,event_external_id,court_fee,event_fee,instructor_lname,instructor_fname,instructor_birthdate,instructor_gender,instructor_zipcode,instructor_addr1,instructor_addr2,instructor_city,instructor_state,instructor_zipcode,instructor_external_id,instructor_uaid ACTION_SPORTS,12345678,TENNIS,10/18/2022 11:15 AM,Kim Desdunes,10/18/2022 11:15 AM,10/18/2022 11:15 AM,2018123456,2018123456,Smith,John,2000-01-01,M,10536,1 Oak Street,Suite C,Anytown,NY,10019,Saw Mill Club,2018123456,2018123456,1 Oak Street,Suite C,Anytown,NY,10019,LESSON,Mixer Round Robin,2018123456,5,100,McSporty,Tad,2000-01-01,M,10019,1 Main Street,Building 2,Anytown,NY,10019,ABC12345,2018654321