How to export digital distribution sales spreadsheet, by product

How to do it

1) Go to the “Products” tab and select a product

In the left-hand side menu, click on the “Products” tab (1) within the Catalog section.
Use the search bar to locate the desired product and click on it to open more information.

2) Open the action menu to view sales

In the information window of the selected product, click the square button in the upper right corner to open an “action menu” (1). Select the option “View sales” (2).

3) Select the period

Select the “Start” (1) and “End” (2) 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” (3) to download a spreadsheet with the information displayed.

4) 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):  
  • _id
  • begin_date
  • end_date
  • import_date
  • country_code
  • country
  • isrc
  • track_title
  • upc
  • release_title
  • artist_name
  • label_name
  • composers
  • store_name
  • offer_type
  • sale_type
  • sales_product
  • monetization_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
  • distributor
  • distributor_date
  • report_name
  • units
  • sales_id
  • sale_type
  • asset_type
  • asset_id
  • owner_id
  • owner
  • percent
  • value
  • distributor_value
  • created_at
  • client_name
  • sales_date
  • isrc
  • upc
  • video_id
  • artist_name
  • release_title
  • track_title
  • country
  • country_code
  • label_name
  • store_name
  • monetization_type
  • usage_type

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

Any doubts, any suggestions? Contact us!

[page_tags]