How To Export and View a Comprehensive Overview of Sales and Reported/Unreported Totals

Need a more in depth overview of your sales and reported/unreported totals than what's shown by default in your Single account?

Not a problem! We make it easy to export a full breakdown of your sales that shows the individual data of each order, such as purchase date, fulfillment date, reported date, quantity, price, and much more. 

❗️This can be incredibly helpful if you need to double check reported totals, solve any potential discrepancy concerns, etc.!❗️

Exports will be delivered as .csv files to the email you are logged into Single. You can generate these in a few different ways...

 

1. All Orders

If you want to export a detailed breakdown of every order that has been placed in your store (not just music/products that have been set up in Single, but every product in your Shopify), you can do so by going to the Orders tab in your Single account. From there, click the "Export Order Data" button.

order_page.png

 

2. Digital Albums/Singles and Attachments

To generate a detailed export of sales for your individual digital albums/singles created in Single and either published as standalone products or attached to other products, go to the Digital Delivery tab of your Single account. From there, click on the release you would like to generate the export for. You will see an "Export Data" button next to each instance of the release (the standalone digital product, physical and digital attachments, etc.). Click that button on any instance of the release that you would like to receive an export for (this will deliver an individual report for each instance to your email).

digital.png

 

3. All Physical Albums

If you want to generate a detailed export of all your physical albums that are tagged for reporting in Single, go to the Physical Reporting tab in your Single account. From here, click the "Export Order Data" button.

Note: If you have multiple pages of releases, this will still generate an export for ALL physical albums tagged in your Single account, not just what appears on the page you are currently on.

Phys_All.png

 

4. Individual Physical Albums

To generate detailed exports of individual physical albums tagged for reporting in Single, go to the Physical Reporting tab in your Single account. Next, click on the album that you would like to generate an export for. From here, click the "Export Order Data" button.

Phys_Indv.png

 

❗️Pro tips❗️

To determine why sales did or did not report:

  1. Generate an export using one of the methods outlined above
  2. Download the export from your email
  3. Import the CSV into Google Sheets, Excel, or Numbers
  4. Go to view, then Freeze Header Row 1
  5. Sort A-Z by the “Type” column and delete “Merch” type purchases, as well as any physical or digital purchases that aren’t related to the problem you’re investigating
  6. Sort A-Z by relevant "Reported to" column
  7. Sort by "Country" column and delete all non-US purchases (if you are investigating chart reporting to Billboard)
  8. Sort by the "Quantity" column and remove any sales of 10+ albums
  9. Change any physical album quantities of 5-9 units to 4
  10. Sort by “Fulfilled” date column and delete any orders that have yet to be fulfilled
  11. Sort by “Refunded” column and delete any orders that have been refunded
  12. Sort by relevant “Reported” date column - are there sales that were fulfilled but didn’t report? (Excluding of course sales made the day of your export - eligible sales will be included in the next day’s report)

Common reasons why an eligible sale hasn't reported yet can be:

  • The album is still in pre sale status
  • The order has not yet been fulfilled in Shopify
  • The order was refunded
  • The order exceeded bulk quantity rules
  • It is still the same day the order was placed/fulfilled. Eligible sales will report the day following fulfillment.

You can quickly sort an export by what has and has not been reported by:

  1. Freezing the top header row of the sheet
  2. Going to the "Reported to Billboard" column (or whichever column for the respective chart you are wanting to see the reported status of) and sorting A-Z

You can quickly see what orders have been fulfilled, refunded, etc. by:

  1. Freezing the top header row of the sheet
  2. Going to the desired column (fulfilled, refunded, quantity, etc.) and sorting A-Z

For more information on chart eligibility, please see our dedicated articles:

Note: For more info on other factors that could result in your totals looking a bit off, check out our article HERE.

 

 

 

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request