File-Based Aggregate Retail Contributions
- Jonathan Cohen
- Abhineet Mittal
Overview
Participants contribute total buyer counts for a number of key metrics. Counts are broken down by zipcode + effective_start_date + effective_end_date.
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 Special Characters
File Submission Attributes
The following criteria applies to the data submissions
Attribute | Detail |
|---|---|
Frequency | Monthly |
Timeframe to included | Cummulative Year to Date based on Shipping date |
Inclusion Criteria | Only US Zipcodes should be included |
Effective Start/End Dates | Should be based on Shipping Date |
Aggregation Grain | effective_start_date, effective_end_date, 5 digit Zipcode YTD Cumulative Preferred: Jan 1 → End Of Reporting Month |
File Name Convention
Player files use the following naming convention
RETAIL-[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 | Required/Optional | Identifying | Format | Description | |
|---|---|---|---|---|---|
| 1 | source_name | Required | Yes | Text | Contributor (USTA will assign) |
| 2 | zip_code | Required | Yes | 5 digit zipcode - must include any leading zeros | Postal code |
| 3 | effective_start_date | Required | Yes | YYYY-MM-DD | Start of reported data (shipping date), Should always be jan 1 of the current year |
| 4 | effective_end_date | Required | Yes | YYYY-MM-DD | End of reported data (shipping date) - Should always be the last day of the reporting month, ie 2023-10-31 |
| 5 | all_racquet_buyers | Optional | No | Number | Distinct count of racquet Buyers |
| 6 | junior_racquet_buyers | Optional | No | Number | Distinct count of Junior racquet buyers |
| 7 | adult_racquet_buyers | Optional | No | Number | Distinct count of Adult racquet buyers |
| 8 | high_end_racquet_buyers | Optional | No | Number | Distinct count of High End Racquet buyers (>$100 purchase price) |
| 9 | racquets_purchased | Optional | No | Number | Total units sold for all racquet buyers |
| 10 | ball_buyers | Optional | No | Number | Distinct count of Ball buyers |
| 11 | total_balls_purchased | Optional | No | Number | Total CANS of balls sold for all ball buyers |
| 12 | all_shoe_buyers | Optional | No | Number | Distinct count of all shoe buyers |
| 13 | junior_shoe_buyers | Optional | No | Number | Distinct count of junior shoe buyers |
| 14 | adult_shoe_buyers | Optional | No | Number | Distinct count of adult shoe buyers |
| 15 | total_shoes_purchased | Optional | No | Number | Total units sold for all shoe buyers |
| 16 | total_unique_buyers | Required | No | Number | Total distinct count of all buyers (if filling out any optional fields above, this field should be populated) |
Example
RETAIL-ACTIONSPORTS-20240620.csv
Where:
Source Name: ACTIONSPORTS
Effective Date: 2024-06-20
source_name, zip_code, effective_start_date, effective_end_date, all_racquet_buyers, junior_racquet_buyers, adult_racquet_buyers, high_end_racquet_buyers, racquets_purchased, ball_buyers, total_balls_purchased, all_shoe_buyers, junior_shoe_buyers, adult_shoe_buyers, total_shoes_purchased, total_unique_buyers
ACTIONSPORTS, 10577, 2023-01-01, 2023-12-31, 1023, 523, 500, 245, 650, 980, 1120, 1590, 1000, 590, 950, 1650
On This Page: