With the Reports feature you can export your sales data in a customised format. Think of it as your pivot table in the sky, where you can slice & interrogate your revenue data.
To create a new report, go to your Reports index page & hit the +Create button at the top right of the screen.
Once you have configured your report and saved it, you can Export your report which will send you an email with a link to download your target data in CSV. Your saved reports are accessible from the Reports index page, stored for future use.
Here you name your report & select which table of data to use as a source for your report. You can either export your Costs or Sales data, & in both instances, either before or after royalty calculations have been applied. As Costs are not available for Publishers, the Cost report options are thus not available for Publishers either.
Sales Input / Income Data: This is data from the sales statements, including statements that have not been processed for royalties.
Sales Output / Royalties: This draws data from the table of sales data created when royalties calculations have been applied. It will only include lines that contribute to the Net Payable value of a contract’s Closing Balance. If a royalty calculation has not run against a Sales line, it will have not have created a line in this table. So any incomplete or unreported lines are not available here.
Costs Input: This is data from the costs files entered or uploaded, including costs not yet processed for royalties.
Costs Output: This draws data from the table of costs data created after royalties calculations have run. Any costs not yet included in a royalty run will not be available here.
Once you have selected your dataset you can select the fields to pull data from. Each field you select here will represent a column in your Report export. Looking for a breakdown of your Net Amount per Release? Select fields for Net Amount and Cat No & Release Title. Looking for a breakdown of your number of Units per Territory? Select fields for Units and Territory. You can add as many fields as you like & you can give the fields your own custom name by amending the entry in the Header line. You can re-order the columns of your Report by dragging and dropping your fields in a different order.
The fields you are able to select will look familiar & represent the data that you imported and matched to these fields via your sales files and Templates. You can select value fields such as Net Amount, Gross Amount, Units and the Net / Gross Amount In Currency (being the value in the original currency before your exchange rate was applied). You can decide how to break down these values by adding category fields such as Source, Territory, Channel, Configuration, ISRC, Cat No & more. You can even select the Original values (such as the Original Configuration, Original Territory, …), which will use the raw data from your sales file before it was mapped to your Curve values.
If you create a report with Sales Output type (or Royalty type for publishers), the following additional five fields are available to select.
Calculation Type – Refers to the Deal Type in your contract terms. ie Gross Amount, Net Amount, PPD, Unit Rate or Unit Price.
Calculation Input – The input value used to calculate the royalty on, as determined by the selection above.
Participation Rate – The share of income Contracts were applied.
Royalty Rate – The royalty percentage due to your payee.
Unit Rate – In case you work with unit rates rather than percentage deals.
Net Payable – The total net amount added to the contract balance.
Refine the target data further by certain conditions using Filters. For example, you can extract data for sales generated only in the United States. These are the different filters available.
Period – Only sales lines reported in a chosen period or periods will be part of the export, even for Sales Input type reports. So sales lines not processed in the selected periods will not be in the Report.
Contract – Only sales lines regarding Tracks, Releases or Works linked to the filtered contracts will be part of the export. For Sales Input type reports it does not matter whether or not these sales lines have also been reported in a royalty period. For Sales Output type reports only sales lines reported in a run will be included.
Sales File – When you target a sales file, the report will export every line in the file that has matched to a Track, Release or Work. For Sales Input type reports it does not matter whether a line is processed in a royalty period, or if the mapped catalogue item is linked to a Contract – the line will still be included in the report. Leaving this filter blank will make the report extract data from every uploaded sales file.
Channel, Configuration, Territory, Price Category, Source, Sub-Source, Release, Tracks and Works all function in a similar way. Only sales linked to the filters you select will be included in the export. Please note that an exact spelling of Source and Sub-Source filters is needed or the filter won’t affect the results.
Sales Dates – Sales Dates are the date the download, stream, performance, etc was made. You can filter the Sales Dates in two different ways. Either you decide to filter on the Sales Dates in the past number of days or months, which will count back from the day you export your report. Or more specifically you can use a start & end Sales Date to filter on. All sales lines that fall in this time-span will be included in the export. Please note that in order to be able to accurately use this filter, the Sales Dates on your sales statements will have to be complete, either by pulling that data from the statement or by entering a date in the Standard Field when uploading a file.
Transaction Dates – Transaction Dates are the dates the payment of a sales statement hit your account. You can filter these in a similar way to the Sales Dates. Again, please note that in order to be able to accurately use Transaction Dates as a filter, your Transaction Dates need to be complete when uploading sales statements.