Developer Console

Sales Reports

Use the Appstore Developer Console to review and download sales reports for your apps.

Access sales reports

To access sales reports, use the following steps

  1. On the Developer Console dashboard, click the Reporting tab.
  2. In the left menu, click Units.

Sales reports page

For the year that you have selected, you can view the reports by Months (the default) or by Marketplace.

When you expand a section, the table contains entries for each marketplace (in the Month view) or each month (in the Marketplace view). The fields in the table correspond to the fields in the CSV file (see table below).

The unit sales reports provide the total units sold. The data can be filtered by year, month, app and marketplace. The IAP and subscription units associated with a specific app are also shown. The report includes units sold and units returned.

Sales data is updated every 6 hours. The timestamp at the top of the page indicates when the data was last updated.

Sales are finalized only at the end of the month after earnings reports are generated, so the sales figures are subject to change within a given month.

Active subscribers and Active subscriptions provides a snapshot of most recent information and do not change with duration. The started, ended and refunded subscriptions are based on the selected time period.

Downloadable sales reports

Starting with the January 2018 report, sales reports contain transactional data, but 2017 and earlier reports contain summary sales data. The CSV table has the same format for both old and new reports. However, the information in the table will vary based on whether the report covers 2018 and later years, or 2017 and earlier years.

In the CSV files for a transactional sales report (2018 and later), you can derive ASIN level earnings by summing up the earnings column.

In the CSV files for 2017 and earlier years, aggregate sales by App/IAP is provided. You can derive ASIN level earnings by summing up the sales price and applying appropriate royalty adjustments for prior years.

The transactional sales reports are grouped based on the month that the invoice was opened. However, there are exceptions, where the transaction is applied to an earlier or a later month. The following examples illustrate possible scenarios:

Early transactions in the month

The Amazon payment system generally does not close invoices exactly on the last day of the month. Invoices may remain open for the first few days of the next month. Transactions that occur early in the next month are mapped to that open invoice until it is closed.

For example, if the invoice for February closes on March 3, the transactions from March 1-3 are included in the February invoice.

Late adjustment for a closed transaction

The Amazon payment system will not adjust a transaction in a closed invoice. The system records the adjustments in the currently open invoice for that vendor.

For example, in February 2018, a refund is reported for a transaction that occurred in October 2017. Since the invoice for September 2017 is already closed, the transaction is mapped to the currently open invoice, which is February 2018.

Download CSV sales report files

To download a sales report file, use the following steps

  1. On the Developer Console dashboard, click the Reporting tab.
  2. In the left menu, select Download Center.
  3. In the main panel, select the type of the report you want to download.
  4. Select the month of the report that you want to download. For earnings and payments reports, you can download the reports for the entire year.

Fields in the sales report CSV file

The CSV file is a text file with a .csv file extension. The CSV file must use UTF-8 encoding to support localized strings.

The CSV file contains one header row, which displays the column titles. Each subsequent row in the file contains the information for one report item. The Invoice ID field defines a unique identifier for each line-item in the report.

The following table describes the fields for each entry (row) in the CSV file.

Field Type Description Example
Marketplace String The Amazon marketplace Amazon.com
Country/Region Code String Standard two-digit ISO country/region code for the origin of the transaction. Refer to this list US
Invoice Id String The unique Id for the invoice. This field is set to NA for 2017 and older summary data 8dd921637-b092f385a7ee4- 62c6494b3ed702
Transaction Id Integer The unique Id associated with this transaction. This field is set to NA for 2017 and older summary data as the sales information includes all transactions in a given day 21854260140446
Transaction Time String The date and time of the transaction. Format is MM/DD/YY HH:MM:SS XST, with 00-23 as the range of hours. XST is the time zone associated with the marketplace of the transaction. For 2017 and older data, this field indicates the date of sale. 05/21/18 14:39 PST
Transaction Type String The transaction type is either Charge, Refund, Chargeback , or Chargeback reversal Charge
Adjustment Yes or No This field is set to Yes if the transaction is an adjustment. For 2017 and older data, if the transaction type is Refund, this field will show a null value. Yes
ASIN Alphanumeric String Amazon Standard Identification Number (ASIN) for the App/In-App/Subscription. C00006M4PF
Vendor SKU String String of up to 150-characters that can include the characters a-z, A-Z, 0-9, underscores, periods, and dashes. The SKU is case-sensitive. com.gamevendor.fungame
Title String The title of the app or game. Smashemup Truck Game
Item Name String Name of the app, game, subscription, in-app item or in-game item. Smashemup Truck Game
Item Type String The type of the item. Values include Subscription, In-App, Game, In-Game, or Application. An Application refers to an app purchase, which is a new app installation that is unique to an Amazon account. Application items do not include app updates. Application
In-App Subscription Term String The term of the subscription. The term can be Weekly, BiWeekly, Monthly, BiMonthly, Quarterly, SemiAnnually, or Annually. This field is applicable only if the item type is Subscription.
This field is not applicable to Twitch.
Weekly
In-App Subscription Status String The status can be TRIAL, PAID, Introductory Price - All Customers, or Promotional Price - Lapsed Customers. This field is applicable only if the item type is Subscription. For more details, see In-App Subscription Status.
This field is not applicable to Twitch.
TRIAL
Units Integer Number of units included in this transaction. 1
Usage Time String The usage time for an Underground app (in seconds). This field is applicable only to Appstore underground products. To calculate the number of units, divide the usage time by 60. For example, usage time of 1200 is 20 units.
This field is not applicable to Twitch.
1200
Marketplace Currency String The marketplace determines the currency of the transaction. See the Marketplace Timezones table. USD
Sales Price Marketplace Currency Selling price that the customer sees after any discounts, not including sales tax. For underground apps, sales price represents the earnings based on number of minutes of app usage. Sales and earnings are the same for Underground apps. For adjustments, the sales price for the original item is shown. The actual adjusted amount or absolute refunded amount might be different than the sales price (such as a partial refund). For refunds and chargebacks (Transaction type - Refund, Chargeback), the equivalent sales price will be negative. 4.99
Estimated Earnings Marketplace Currency Estimate earnings after deducting for Amazon royalties from this transaction. For adjustments and refunds, earnings are shown based on the adjusted amount or the refunded amount. Refunds that are deducted from vendor's account are shown as negative values for reports having earnings corresponding to period from Nov'19 onwards. 3.49
App User ID String Unique customer identification for the transaction. App User ID is not available in the following scenarios:
  • Item Type is “Application”
  • Adjustment (Yes/No) is “Yes”
  • The subscription is in "Paused" status
hQygC+MjonyR2Z0TMY03nyxeVxqIHq3+rK39TGzhkk0=
Receipt ID String Unique receipt identification for the transaction. Receipt ID is not available in the following scenarios:
  • Item Type is “Application”
  • Adjustment (Yes/No) is “Yes”
  • The subscription is in "Paused" status
EgL-HstEAXhMfTuQ5_NkhQicjp_sRpJ5Lic78cF-3HY=:1:13
Digital Order ID String Unique order identification for the transaction. d01-6680198-0475238
Device Type String The type of device in which the customer makes purchases. The type category 'Others' includes app purchases made on uncategorized device types (eg., app purchases through the web). Fire TV
Sales channel String Identifier field used to delineate Quick Subscribe related purchases (Subscription and Application). Field value 'QS' indicates that the transaction is Quick Subscribe related. QS

In-app subscription status

The possible values for the in-app subscription status field described are as follows:

  • TRIAL — Orders that are free of cost.
  • PAID — All paid orders except for introductory price and promotional price orders, described below.
  • Introductory Price - All Customers — Orders paid at an introductory price that was available to all customers (new and lapsed).
  • Promotional Price - Lapsed Customers — Orders paid at a promotional price that was available to lapsed customers only.

The introductory and promotional price values correspond to the promotional pricing plan configured by the developer.

Consider the following example.

  • A subscription plan is configured to offer a monthly free trial, followed by an introductory price for the first three months, followed by the regular plan.
  • The promotion type is classified as "Introductory Price - All Customers".

When a new customer purchases the subscription, the in-app subscription status of those orders appear as listed in the following table.

Order Order Details In-App Subscription Status
1st order Free trial purchase TRIAL
2nd order Renewal with Introductory price Introductory Price - All Customers
3rd order Renewal with Introductory price Introductory Price - All Customers
4th order Renewal with Introductory price Introductory Price - All Customers
5th and subsequent orders Renewal with Regular price PAID

Last updated: Sep 09, 2024