Understanding your CSV Reports
Every reporting period, we receive royalty reports from a number of different retailers, streaming providers, and ad-based platforms. All of this data is compiled into one standardized format that is then uploaded to your account.
In addition, you can also export the raw data for you to use and compile however you would like. This is an overview that will help you understand your CSV Report.
Reporting Period: The Report Period means the month that generated the Monthly Report.
Sale Month: This will refer to the month of which the sale or stream occurred. Some partners do not report month but many do. further, you may see a previous month from a previous period on a report and that is if the partner is late to report. As an example, if we don’t receive royalties for a partner for June, it would show on the next quarterly report which would likely show royalties for July, and so on if they continue to be late.
Revenue Received By DSP: This mean in which month we as company received the money from the Store (Digital Service Provider) Ex. Spotify, Amazon, Etc.
Content-Type: This is where we list if the sale was a download or stream in some cases it can be User Generated Content , Ad-Funded Stream, Mechanical Royalty, Performance Royalties. The more the industry evolves, the more content types we will continue to add to the reporting.
UPC: The UPC that we assigned for your release when you leave on blank the field of the UPC and we autogenerate once we approved your release. This is an individual product identifier. Having this code will then match up to any sales or streams to your releases. Whenever this is reported, it is matched to your existing catalog.
ISWC: The ISWC (International Standard Musical Work Code) is a unique, permanent, and internationally recognized reference number for the identification of musical works.
Catalog Number: A catalog number (“cat number”) is the identification number a record label assigns to a release. It is used for tracking purposes by both the label and the distributor. It is composed of numbers and letters.
Album Name: in this column, you will find the album name of your release. The most common way to name an album is to name it after one of the songs on the album. This is called a “Title Track”. Pick a song on the album that seems to represent the entire theme the best, or just use the first or last track.
ISRC: The ISRC is like the UPC, this is an individual identifier for your track (song). Whenever this is reported, it is matched to your existing catalog.
Track Artist: here you will see the name of the artist or featuring artists that are collaborating on the song.
Record Label: you always going to see the name of the record label that artists below. for the interdependent artist that don’t have a Record Label, our system always going to show Independent or will show our Company Name in this field.
Product Type: Here will show if the content type was a Single, EP, Album, Compilation or Music Video
Quantity: If you had a Single and/or Album Release sale or stream, the individual count reported by a partner will be listed here. In the event a partner does not report this, then we place a 1. MOST partners report a track count.it can be complex to understand as you may see a lot of track counts but a little dollar amount. Every streaming provider has different pay rates for different territories for different times of the year so there is no set streaming rate for any partner.
Client_ID: This is a unique ID given by our software of accounting that designates to the artist or Record label that we are paying the royalties in each line item by our system. This represents the number of the row for the period. mean the person or entity that is in charge of the account of the distribution. this can be the artist, songwriter, Record Label or a Music Distribution Company.
Source Currency: is the currency that was paid to us.
Currency Rate: here you will be able to see the rate that was used at the moment to exchange the currency to USD. in some cases, we received other currency that is not USD Dollars than our bank with exchange money to USD. we pay our clients in USD.
Net Receivable: This is the net amount that we receive from the DSPS, like for example Spotify, Amazon, Etc
Client Reported: This is the column that will show the percentage that you are receiving.
Total($): This is the net amount owed to you for the period. All of the fees are taken out to show you exactly what it is you earned for the period.
Digital Service Provider: This column represents what DSP and where the royalty came from. You will see more than just download based retailers. Everything from Streaming providers, Download stores that Sale your music. Publishing Admin, as well as Mechanical Royalties and more. wherever the source came from, is where it would be listed here.
Territory: This is the territory designation that shows you where the sale (download) or stream occurred.
Aggregator/Licensor: DPM Network Music Distribution is usually listed here but in some cases, if we work with other distribution companies and your label or artist name is under them, you would see their Distribution name in this column.