A CSV file imported into Excel
CSV reports (CSV stands for “comma separated value”) provide detailed royalty revenue information of releases and tracks. Each row of data represents the number of units (usually plays or downloads) broken down by DSP, configuration, country and date.
By the 10th of each month, we consolidate the data from DSPs into one big report and make that available as a downloadable CSV file. CSV files are standard text files that applications like Excel, Google Sheets, Apple Numbers or Tableau can read to analyze and visualize data.
How do I get the CSV file?
- Log into your Labelcaster account and goto your Dashboard.
- Click the Detailed Report button. [On mobile you’ll first tap the Revenue Report button and then get to the Detailed Report button]
- Choose the beginning and end month then click Generate Report. It may take a few minutes as the data files can be quite large
What’s in the file exactly?
Here are the columns (fields) and descriptions that are contained in the CSV report 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 |
A bit on dates: we receive reports from DSPs at the beginning of each month for transactions (plays and downloads) that occured three 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.