Reference

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 introductory or subscription offers, displays the type of transaction: Pay Up Front or Pay As You Go. For pre-orders, indicates whether a purchase originated from a pre-order. For promotional offers, displays the order ID. For offer codes, displays the offer code reference name you entered in App Store Connect when setting up the subscription offer.