How to export a licensing sales spreadsheet

How to do it

1) Access the “Licensing” tab and select a period

In the left-hand side menu, click on the “Licensing” tab (1) within the Revenue section.

Select the “Start” (2) and “End” (3) periods for which you want to export a sales report. If you do not select an end period, the system will consider the date of the last information contained in the reports.

Select the type of information you want to view:

• Sales: Information on the collection of the asset
• Distribution: Information on the distribution of amounts among the holders

Click on the actions button in the lower right corner and select “Export” (4) to download a spreadsheet with the information displayed.

2) Select the type of report you want to export

In the dialog window, select the spreadsheet type as chosen on the previous screen and press the “Export” button to download your spreadsheet.

The exported spreadsheet contains the following information:

• Licensing (CSV):  
  • _id
  • partner_client_id
  • account_name
  • deal_id
  • deal_scope_name
  • begin_date
  • end_date
  • import_date
  • country_code
  • country isrc
  • artist_name
  • release_title
  • store_name
  • distribution_channel
  • total_sales
  • partner_sales
  • net_sales
  • currency
  • currency_rate
  • real_total_sales
  • real_partner_sales
  • real_net_sales
  • units
  • distributor
  • client_name
  • report_name
  • report_id
  • created_at

Any doubts, any suggestions? Contact us!

[page_tags]