File-Based Aggregate Retail Contributions

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 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

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

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

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

Optional

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