Fuga Reporting

• Documentation
• DDEX XSD
• Example report XML
• Example report CSV

This page describes the technical interface between the FUGA platform and the platform of a consumer DSP (Digital Service Provider) to provide reports of sales.

Overview

A sales report contains a consolidated overview of sales transactions performed in a certain period. Each transaction sells an album or a track. The report then contains the amount of these transactions for each item together with the price of the item or the total revenue for all items. A conceptual example of a report would be:

• Start date: 2008-01-01
• End date: 2008-01-31
  
  
• Sold track Trouble 567 times, $2.5 each, $1,417.5 in revenue
• Sold album Parachutes 1483 times, $20 each, $2,9660 in revenue
• Sold track High Volume Mix 15 times, $1 each, $15 in revenue

There are two formats of reports FUGA can import. One is a CSV file; the other one a DDEX compliant XML. Either way, please send your reports by e-mail to sales_reports@independentip.com.

CSV report format

One way how to structure your reports is a CSV file. The file needs to contain the following columns (in order):

• Start date
• End date
• UPC - passed when the sold item is an album
• ISRC - passed when the sold item is a track
• Items sold - number of items sold
• Revenue - total revenue from selling that number of items; note that unlike the PriceConsumerPaidExcSalesTax value in the DDEX XML, this value states the total revenue from selling items with the provided UPC or ISRC
• Currency - the currency of the revenue (three letters ISO-4217 code)

Example of a CSV in the correct format can be found here.

DDEX XML report

This format is defined by the Digital Sales Report Message Suite Standard XSD. An example of a minimal XML we expect can be found here.