Each month, as we receive reports from the streaming services, we process the data into detailed reports. By the 10th of each month, we’ll have the reports available to you and all participants. We provide detailed reporting on performance revenue as downloadable CSV files. CSV (or “comma separated value”) are standard text files that applications like Excel, Google Sheets, Apple Numbers or Tableau can read to analyze and visualize data.
Download the detailed revenue CSV file, by logging into your Labelcaster account and going to your Dashboard. From there, tap the Revenue Report button and then the Detailed report download button.
A bit on dates: we receive reports from DSPs at the beginning of each month for transactions (plays and downloads) that happened two full months prior. Some DSPs can be even slower. The Report Date is when money is allocated to accounts, not the stream or play date. For example, if you want to see how your music performed in August, you want to choose the report date from November then filter the sales_start_date for August. We suggest downloading all the available dates and filtering in your analytics software.
Here are the columns (fields) and descriptions that are contained in the CSV file.
| Column (field name) | Description |
|---|---|
| label | Record label name |
| report_date | Date of report when money is allocated to accounts (generally reporting is two months after streaming or downloads) |
| sales_start_date | Beginning period of transaction (when a stream, download, performance) occurred |
| sales_end_date | End period of transaction (when a stream, download etc. occurred) |
| UPC | 13 or 14 digit numeric pricing code for a release or grouped unit (e.g. an album, EP, compilation), Each UPC can have one or multiple tracks (ISRC) |
| release_title | Text name title for grouped unit with a single UPC (e.g. an album, EP, compilation) |
| release_artist | Artist name associated with a release/UPC |
| ISRC | Code for an individual track, can be associated with multiple UPCs if in different groups (e.g. a compilation album) |
| track_title | Text name title for an individual track (ISRC), can be associated with multiple UPCs if in different groups |
| track_artist | Artist for an individual track/ISRC |
| channel | Streaming service or sales platform, e.g. Spotify, Facebook, YouTube Art Track, that generated the revenue |
| configuration | Specific format of the sale, e.g. Premium Stream, Art Track (not always available) |
| type | Track or album |
| country_code | Alpha-2 letter ISO country code of sale, see https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes Note: WW means worldwide, not all DSPs provide country information |
| units | Number of sales (e.g. streams, downloads, etc.) |
| net_royalty_revenue | Sales generated (in EUR), i.e. gross revenue, less any marketplace costs, transaction charges and exchange fees, but before any Labelcaster commissions and fees are deducted |
| labelcaster_commission | Labelcaster commission (in EUR) |
| total_royalty_revenue | Net revenue (in EUR) minus Labelcaster commission and fees. This is the total amount earned before any splits. In other words, this is the amount from each track that split amounts are calculated from. |
| your_split | Net royalty payment/split amount (i.e. share) (in EUR) earned to the recipient before any recoupment |
| revenue_entry_id | a unique id code for each transaction |