Sky Sports fields in every export
Editorial records cover canonical URL, headline, standfirst, sport, competition where tagged, byline, publication timestamp, last updated timestamp, item type and the article identifier.
Item type separates match report, preview, news, analysis and video, because on a broadcaster a large share of output is video with little body text. Word count without that separation ranks the most watched output lowest, which is the same trap as on any broadcaster site.
Fixture and result records are kept as their own rows: sport, competition, date, kickoff time in local and UTC, teams, venue and final score where played. They are joined to editorial coverage on competition and date rather than merged into it.
Broadcast fields are recorded where published: which channel, which window, and whether the fixture is listed as live. Those sit in their own columns so a client can ask what was shown without that data contaminating a coverage count.
Then the usual context: front position from repeated observation, topic and team tags where published, word count for text items, video duration where relevant, and the collection timestamp on every row.