How to export a managed publisher sales spreadsheet

How it’s done

1) Access the “Administered Publisher” tab and select a period.

In the left side menu, click on the “Administered Publisher” tab (1) within the Revenue section.
Select the “Start” (2) and “End” (3) period for which you want to export a sales report. If no end date is selected, the system will use the date of the latest data available in the reports.
Select the type of information you wish to view (4):

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

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

2) Select the type of report you want to export

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

The exported spreadsheet contains the following information:

• Administered publisher (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]