Business Insights supports Excel spreadsheets or CSV files for Custom Marker uploads. The upload file must contain the following fields: ts, group, and title. The following table provides field descriptions:
| Field | Description |
|---|---|
| ts |
A timestamp that represents the moment in time where the marker gets inserted in the event to which the upload file applies. The times must be in 24-hour format. Supported formats are:
Note: The times are specific to the timezone where you are located
currently. During uploading, the times get converted from the
uploader's local timezone to the event timezone. For example, if
the uploader timezone is UTC -0400 and the event venue timezone
is UTC -0700, the uploaded marker values get converted -0300
hours back (12/23/22 23:01 to 12/23/22 20:01).
|
| group | The group column represents a group name (e.g., Quarters/Scoring Plays/Periods). All markers with the same group name are grouped together. |
| title | The title column represents a display name of the marker (for example, kickoff). |
| ts | group | title |
|---|---|---|
| 10/21/22 20:00 | Periods | Start of match |
| 10/21/22 20:11 | Scoring Plays | Home team scores (1-0) |
| 10/21/22 20:18 | Scoring Plays | Visiting team scores (1-1) |
| 10/21/20:48 | Periods | End of first half (1-1) |
ts,group,title 10/21/22 20:00, Periods, Start of match 10/21/22 20:11, Scoring Plays, Home team scores (1-0) 10/21/22 20:18, Scoring Plays, Visiting team scores (1-1) 10/21/22/20:50, Periods, End of first half (1-1)