App Store Connect Help
Summary Sales Report
Summary Sales Report shows aggregated sales and download data from the App Store for your apps and in-app purchases.
The following table shows columns for Summary Sales Report version 1_3.
To better understand the values below, view a sample Summary Sales Report.
Sample Summary Sales Report
Purchases
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
Country Code |
Currency of Proceeds |
---|---|---|---|---|---|---|
App One |
1F |
100 |
.70 |
.99 |
US |
USD |
100 app purchases were made in the United States. The Product Type Identifier column value “1F” indicates that these were universal app purchases. Customers paid .99 USD for each unit and you received .70 USD for each.
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
Country Code |
Currency of Proceeds |
Parent Identifier |
---|---|---|---|---|---|---|---|
In-App One |
IA1 |
50 |
.42 |
.69 |
GB |
GBP |
AppOne |
50 in-app purchases were made in Great Britain. The Product Type Identifier column value “IA1” indicates that these were In-App Purchases. Customers paid .69 GBP for each unit and you received .42 GBP for each. The Parent Identifier shows the SKU of the parent app.
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
Country Code |
Currency of Proceeds |
---|---|---|---|---|---|---|
App Bundle One |
1-B |
25 |
2.10 |
2.99 |
US |
USD |
25 app bundle purchases were made in the United States. The Product Type Identifier column value “1-B” indicates that these were app bundle purchases. Customers paid 2.99 USD for each unit and you received 2.10 USD for each.
Refunds
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|
App One |
1F |
-50 |
.7 |
-0.99 |
Refunds have negative values for Units and Customer Price, and positive values for Developer Proceeds.
Subscription Upgrade with Partial Credit (for sales before November 17, 2016).
Report on Day 1 of Initial Purchase
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|
1 Month Basic |
1AY |
1 |
7.00 |
9.99 |
Report on Day 25 of Upgrade
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|
1 Month Premium |
1AY |
1 |
19.83 |
28.32 |
When a subscriber upgrades, any remaining credit is applied to the cost of the new subscription, as long as the credit is not greater than the new price.
For example, Report on Day 1 shows a sale of a 1-month subscription for 9.99. On Day 25, the subscriber upgrades to a subscription priced at 29.99. Note that the upgrade goes into effect immediately. Because the pro-rated credit of 1.67 (9.99/30 days x 5 days left) is less than 29.99, the cost of the new subscription is recorded at only 28.32 (29.99 - 1.67).
Subscription Upgrade with Partial Credit (for sales after November 17, 2016).
Report on Day 1 of Initial Purchase
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|
1 Month Basic |
1AY |
1 |
7.00 |
9.99 |
Report on Day 25 of Upgrade
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|
1 Month Premium |
1AY |
1 |
21 |
29.99 |
1 Month Basic |
1AY |
-1 |
1.17 |
-1.67 |
When a subscriber upgrades, the pro-rated credit is refunded and the new subscription is charged at full price, as long as the credit is not greater than the new price.
For example, Report on Day 1 shows a sale of a 1-month subscription for 9.99. On Day 25, the subscriber upgrades to a subscription priced at 29.99. Note that the upgrade goes into effect immediately. The pro-rated credit of 1.67 (9.99/30 days x 5 days left) is refunded and the full price of 29.99 is charged.
Subscription Upgrade with Full Credit
Report on Day 1 of Initial Purchase
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|
1 Month Basic |
1AY |
1 |
21.00 |
29.99 |
Report on Day 15 of Upgrade
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|
1 Month Premium |
1AY |
-1 |
10.50 |
-15.00 |
1 Month Basic |
1AY |
1 |
7.00 |
9.99 |
When a subscriber upgrades and the remaining credit is greater than the cost of the new subscription then a refund is issued.
For example, Report on Day 1 shows a purchase of a 1-month subscription for 29.99. On Day 15, the subscriber upgrades to a 1-month subscription priced at 9.99. Because the pro-rated credit of 15.00 (29.99/30 days x 15 days left) is greater than 9.99, a full refund is issued for -15.00 and a new sale for 9.99 is recorded.
Developer codes
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
Promo Code |
---|---|---|---|---|---|
App Two |
1F |
5 |
0 |
0 |
CR-RW |
This row shows five sales in which customers used a developer code. Developer Proceeds and Customer Price are 0. The Promo Code column value will be “CR-RW.”
Completed app bundles
Row |
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
CMB |
---|---|---|---|---|---|---|
1 |
App Bundle One |
1-B |
25 |
2.10 |
2.99 |
CMB |
2 |
App One |
1F |
-25 |
.70 |
-.99 |
CMB-C |
3 |
App Two |
1F |
-25 |
.70 |
-.99 |
CMB-C |
A completed paid app bundle purchase creates two types of records:
-
One record for the bundle itself, indicated by the Product Type Identifier column value “1-B” (for iOS apps), or “F1-B” (for macOS apps) and the CMB column value “CMB”
-
A record for credits for the previously purchased apps, indicated by the CMB column value “CMB-C”
Every paid app CMB record has one or more corresponding CMB-C records. The Customer Price of the CMB record plus the sum of the corresponding CMB-C records equals the price the customer paid for completing the bundle. Credits, like refunds, have negative values for Units and Customer Price, and positive values for Developer Proceeds.
Row 1 shows 25 app bundle purchases. The previously purchased apps are shown as credits in rows 2 and 3, as indicated by the value “CMB-C” in the CMB column. Customers paid 1.01 USD to complete the bundle (2.99 + -.99 + -.99).
Please note, in the case of a free app CMB record, a negative unit value row will not be created for previously downloaded apps. Instead, the report will show only the record for the free app bundle purchase.
App updates
Title |
Version |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
---|---|---|---|---|---|
App Three |
2.4.9 |
7F |
75 |
0 |
0 |
75 app updates were made, as indicated by Product Type Identifier value “7F.” Developer Proceeds and Customer Price are 0. The Version is the version that customers upgraded from.
Gift purchases
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
Promo Code |
---|---|---|---|---|---|
App Three |
1F |
3 |
.70 |
.99 |
GP |
Three gift purchases were made, as indicated by Promo Code value “GP.”
Introductory Offers and Subscription Offers
Report on day of purchase
Title |
Product Type Identifier |
Units |
Developer Proceeds |
Customer Price |
Order Type |
---|---|---|---|---|---|
3 Month Basic |
1AY |
1 |
7.99 |
9.99 |
Pay Up Front Intro Offer |
3 Month Basic |
1AY |
1 |
.07 |
0.99 |
ExampleOfferID |
When a subscriber signs up for a pay up front introductory offer, the event is shown in the Summary Sales Report. In the example above, a subscriber purchases a 3 Month Basic pay up front introductory offer. Another subscriber redeems a subscription offer for the same SKU and the Order Type column is populated with the Promotional Offer ID.
Pre-Orders
Report on day of purchase
Title |
Units |
Developer Proceeds |
Customer Price |
Order Type |
---|---|---|---|---|
App One |
1 |
0.7 |
0.99 |
Pre-Order |
App One |
1 |
0.7 |
0.99 |
App One has 1 unit that originated from a pre-order, and another unit that originated after the app went live. Units that originated from a pre-order will have “Pre-Order” in the Order Type column. Units that were not from pre-orders will either have a blank field in the Order Type column, or be populated with a different Order Type value (such as a value for an Introductory Offer).
Report Field |
Report Data Type |
Values |
Notes |
---|---|---|---|
Provider |
CHAR(5) - APPLE |
Up to 5 Characters |
Service provider in your reports (typically Apple). |
Provider Country |
CHAR(2) - US |
Up to 2 Characters |
Service provider country code (typically U.S.). |
SKU |
VARCHAR(100) |
Up to 100 Characters |
Product identifier provided by you during app setup. |
Developer |
VARCHAR(4000) |
Up to 4000 Characters |
Provider name provided by you during the initial account setup. |
Name |
VARCHAR(600) |
Up to 600 Characters |
App name provided by you during app setup. |
Version |
VARCHAR(100) |
Up to 100 Characters |
Version number provided by you during app setup. |
Product Type Identifier |
VARCHAR(20) |
Up to 20 Characters |
Defines the type of transaction (for example, initial download or update). Learn about product type identifiers. |
Units |
DECIMAL(18,2) |
Up to 18 Characters |
Aggregated number of units. Negative values indicate refunds, or CMB credits for previously purchased apps when the CMB column shows "CMB-C". A value of 0 may indicate a partial refund. |
Developer Proceeds (per unit) |
DECIMAL(18,2) |
Up to 18 Characters |
Amount you receive per unit. This is the customer price minus applicable taxes and Apple’s commission, per Schedule 2 of your Paid Apps Agreement. |
Begin Date |
Date |
Date in MM/DD/YYYY |
Start date of report. |
End Date |
Date |
Date in MM/DD/YYYY |
End date of report. |
Customer Currency |
CHAR(3) |
Up to 3 Characters |
Three-character ISO code indicating the customer’s currency. Learn about currency codes. |
Country Code |
CHAR(2) |
Up to 2 Characters |
Two-character ISO country code indicating the App Store country or region through which the purchase was made. Learn about financial report regions and currencies. |
Currency of Proceeds |
CHAR(3) |
Up to 3 Characters |
The currency in which the customer is paid. Learn about currency codes. |
Apple Identifier |
DECIMAL(18,0) |
Up to 18 Characters |
Your app's Apple ID. |
Customer Price |
DECIMAL(18,2) |
Up to 18 Characters |
The price per unit billed to the customer, which you set for your app or in-app purchase in App Store Connect. *The customer price is inclusive of any applicable taxes we collect and remit per Schedule 2 of the Paid Apps Agreement. Negative values indicate refunds or CMB credits for previously purchased apps when the CMB column shows "CMB-C’". |
Promo Code |
VARCHAR(10) |
Up to 10 Characters |
If the transaction was part of a promotion, this field will contain a value. This field is empty for all non-promotional items. Learn about promotional codes. |
Parent Identifier |
VARCHAR(100) |
Up to 100 Characters |
SKU of the app associated with the in-app purchase. |
Subscription |
VARCHAR(10) |
Up to 10 Characters |
Defines whether an auto-renewable subscription is new or a renewal. When a previous subscriber resubscribes, it's classified as a renewal. |
Period |
VARCHAR(30) |
Up to 30 Characters |
Defines the duration of an auto-renewable subscription purchase: 7 days, 1 month, 2 months, 3 months, 6 months, and 1 year. |
Category |
VARCHAR(50) |
Up to 50 Characters |
Indicates the primary category of the app, such as Games. |
CMB |
VARCHAR(5) |
Up to 5 Characters |
If the transaction completes an app bundle, this field will contain a value of “CMB.” App credits for completed bundles will show a value of “CMB-C.” Otherwise this field is blank. |
Supported Platforms |
VARCHAR(12) |
Up to 12 Characters |
List of platforms that your app supports: iOS, macOS, tvOS, iOS and tvOS, visionOS, or iOS and visionOS. |
Device |
VARCHAR(10) |
Up to 10 Characters |
Type of device used for purchase or redownload: Values include iPhone, iPad, iPod touch, Desktop, Apple TV, or Apple Vision. |
Preserved Pricing |
VARCHAR(3) |
Up to 3 Characters |
For Renew events, if the price is preserved then this field equals “Yes”. Otherwise, it’s blank. |
Proceeds Reason |
VARCHAR(20) |
Up to 20 Characters |
If a subscription is active for more than a year, you receive 85% of the customer price (minus applicable taxes) and this field equals “Rate After One Year”. Otherwise, you receive 70% and the field is blank. |
Client |
VARCHAR(30) |
Up to 30 Characters |
Indicates where the purchase happened: App Store for iMessage, News, or blank. |
Order Type |
VARCHAR(30) |
Up to 30 Characters |
For pre-orders, indicates whether a purchase originated from a pre-order. For introductory subscription offers, displays offer pricing: Pay Up Front or Pay As You Go. For promotional subscription offers, displays the offer ID. For subscription offer codes and win-back offers, displays the offer code reference name you entered in App Store Connect when setting up the offer. |