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
- On the Developer Console dashboard, click the Reporting tab.
- 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.
Updates to a closed transaction
The Amazon payment system won't update a transaction in a closed invoice. The system records the update 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
- On the Developer Console dashboard, click the Reporting tab.
- In the left menu, select Download Center.
- In the main panel, select Sales Reports.
- Select the month of the report that you want to download.
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:
|
hQygC+MjonyR2Z0TMY03nyxeVxqIHq3+rK39TGzhkk0= |
Receipt ID | String | Unique receipt identification for the transaction. Receipt ID is not available in the following scenarios:
|
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: Dec 04, 2024