Reports

Reports

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 and interrogate your revenue data.

To create a new report, go to your Reports index page and 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 format. Your saved reports are accessible from the Reports index page, stored for future use.

If you edit a saved report, be sure to hit the Save button before exporting, otherwise your changes will not be reflected in the data exported.

If you edit a saved report, be sure to hit the Save button before exporting, otherwise your changes will not be reflected in the data exported.

OVERVIEW

Here you give your report a name and select which Dataset to use as a source for your report. You can either export your Costs or Sales data, and 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.

FILTERS

You can refine the target data further by certain conditions using Filters. For example, you can extract data for sales generated only in the United States. Below are the different filters available.

As a rule of thumb, leaving a filter empty will not apply any restrictions on the data returned. So if you don’t select any contracts your report will pull data from all of your contracts relevant to the Fields you have selected.

Cat Type – Using this field, you can filter based on the catalogue type: work, track, or release.

Catalogue Groups – Using this field, you can filter based on the catalogue groups established in your settings and applied to your catalogue.

Companies – This will filter the data by the companies that are paying out royalties to the various payees, established in the overview section of a contract.

Contract Categories – This will filter the data based on the Contract Categories established in your settings and applied to your contracts, similar to Catalogue Groups.

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 – These 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.

When filtering by Release, you will have the option to include “Include Tracks Associated With Release” which will include the data for any tracks that are associated with the release you are filtering for.  For this to work, your tracks must be associated with the Release on the Release level. Any sales of associated tracks that were mapped to a different release in the mapping manager upon ingestion of a sales file will be excluded.

Release/Track Foreign ID – If you have entered Foreign IDs from external databases for your catalogue, you can use that to filter your reports with this field.

Release Dates – Release Dates are the date the release, track or work was released. You can filter the Release Dates in two different ways. Either you decide to filter on the Release 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 and end Release Date to filter on. All sales lines that apply to catalogue released in this time-span will be included in the export. Please note that in order to be able to accurately use this filter, the Release Dates on your releases, tracks and works will have to be complete on the overview tab of the track, work, or release.

Release/Track Label – If you administer multiple labels and have specified that on your releases, you can filter by Release Label using this field.

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 and 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.

You can get even more specific and filter for multiple conditions by clicking the +And button to add an extra field.  You can also use the +Or button below the filter field to add a second set of segments to filter for.  For instance, if you want to filter for Physical or Digital sales, you would create one filter field for the physical distribution channel, click the +Or button, then create a second filter for the digital distribution channel.

In order to get the most out of your Reports, it is important that you upload your sales data into the system as consistent, complete & accurate as possible. Read the articles on Templates & Uploading Sales Statements to find out how to do this.

FIELDS

Once you have selected your dataset and filters, 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, Cat No and 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 and you can give the fields your own custom name by amending the entry in the Header line. You can reorganize the columns of your Report by dragging and dropping your fields in a different order.

You can also add a field and give it a header name without designating a data field – delivering a blank column of data. This can be useful if you need to replicate the excel format of a different system.

The fields you are able to select will look familiar and 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 and 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 the Sales Output type (or Royalty type for publishers), the following additional five fields become available:

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.

When selecting a Sales Output / Royalty type report, the value fields Gross Amount, Net Amount and Units may be counted more than once. This is because some sales lines may be included in royalties calculations for more than one contract. One sales line with a value of $1 and 1 unit may be relevant to three contracts; if returned in a report that breaks down your data per all three contracts, the sales line will be mentioned three times and will look like $3 Gross Amount and 3 Units. Whilst this is correct, it can be misleading depending on what you are trying to understand. If you are looking to understand what your total Net Amount, Gross Amount or Units are; you should create a Sales Input / Income Data report instead.
Regarding Profit Share contracts, due to how balances are managed in these types of deals the Net Payable returned is the value calculated BEFORE the profit share split has been applied.