How to export 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) Selecione o tipo de relatório deseja exportar

Na janela de diálogo, selecione o tipo de planilha conforme escolhido na tela anterior e pressione o botão “Exportar” para baixar sua planilha.

A planilha exportada possui as seguintes informações:

• Licenciamento (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

Gostou desta funcionalidade? Tem sugestões? Manda para a gente!!

[page_tags]