How to export digital mechanical sales spreadsheet, by report

How to do it

1) Access the “Digital Mechanicals” tab and select a period.

In the left-hand side menu, click on the “Digital Mechanicals” 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:

• Sales (CSV): 
  • begin_date,
  • end_date,
  • import_date,
  • country_code
  • country
  • iswc
  • song_title
  • song_composers
  • isrc
  • artist_name
  • release_title
  • store_name
  • offer_type
  • sale_type
  • usage_type
  • asset_type
  • total_sales
  • distributor_tax
  • distributor_net_sales
  • net_sales
  • currency
  • currency_rate
  • real_total_sales
  • real_distributor_net_sales
  • real_net_sales
  • units
  • distributor
  • client_name
  • report_name
  • report_id
  • created_at
• Distribution (CSV)
  • _id
  • owner
  • owner_id
  • units
  • percent
  • value
  • artist_name
  • song_title
  • iswc
  • codigo_ecad
  • asset_id
  • isrc
  • store_name
  • country
  • distributor
  • sales_id
  • created_at
  • report_name
  • report_id
  • sales_date
  • distributor_date
  • distributor_value
  • client_name

Done! Now you can export your information and be even more agile in your rights management!

Any doubts, any suggestions? Contact us!

[page_tags]