Reference

Pre-Order Report

Tip: To better understand the values below, view a sample report.

Sample Pre-Order Report

Pre-Orders

Title

PreOrder Start Date

Ordered

Canceled

Cumulative Ordered

Cumulative Canceled

Start Date

End Date

App One

12/6/2017

10

2

150

25

12/17/2017

12/25/20177

App One has 10 pre-orders and 2 cancelations for the selected date range of 12/17/2017 - 12/25/2017, and has a cumulative total of 150 pre-orders and 25 cancelations since the pre-order began on 12/06/2017.

Title

Ordered

Canceled

Start Date

End Date

Device

App Two

10

2

12/17/2017

12/25/2017

iPhone

App Two

5

1

12/17/2017

12/25/2017

iPad

App Two has 10 pre-orders and 2 cancelations on iPhone, and 5 pre-orders and 1 cancelation on iPad during the selected date range of 12/17/2017 - 12/25/2017.

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

Provided by you during the initial account setup.

Title

VARCHAR(600)

Up to 600 Characters

Provided by you during app setup.

Pre-Order Start Date

DATE

Date in MM/DD/YYYY

Date the app becomes available for pre-order.

Pre-Order End Date

DATE

Date in MM/DD/YYYY

Last date the app is available for pre-order, after which the app is available for sale.

Ordered

DECIMAL(18,2)

Up to 18 Characters

Aggregated number of pre-orders for the period.

Canceled

DECIMAL(18,2)

Up to 18 Characters

Aggregated number of canceled pre-orders for the period.

Cumulative Ordered

DECIMAL(18,2)

Up to 18 Characters

Total number of pre-orders since the start of the pre-order period.

Cumulative Canceled

DECIMAL(18,2)

Up to 18 Characters

Total number of canceled pre-orders since the start of the pre-order period.

Start Date

DATE

Date in MM/DD/YYYY

Start date of report.

End Date

DATE

Date in MM/DD/YYYY

End date of report.

Country Code

CHAR(2)

Up to 2 Characters

Two-character ISO country code indicating the App Store country or region of the pre-order. For more information, visit Financial report regions and currencies.

Apple Identifier

DECIMAL(18,0)

Up to 18 Characters

Apple ID for your app.

Device

VARCHAR(10)

Up to 10 Characters

Type of device used for purchase: Values include iPhone, iPad, iPod touch, Desktop, Apple TV, or Apple Vision.

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.

Category

VARCHAR(50)

Up to 50 Characters

Indicates the category of the app, such as Games.

Client

VARCHAR(30)

Up to 30 Characters

Indicates where the purchase happened: App Store, App Store for iMessage, or blank.