Reference

Subscription Report

The below table shows columns for Subscription Report Version 1_3.

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

Report Field

Data Type

Notes

App Name

String

Title of your subscription’s parent app.

App Apple ID

BigInt

Apple ID of your subscription’s parent app.

Subscription Name

String

Title of your subscription.

Subscription Apple ID

BigInt

Apple ID of your subscription.

Subscription Group ID

BigInt

Your subscription’s Group ID (formerly Family ID).

Standard Subscription Duration

Int

Duration of the standard subscription: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year.

Customer Price

Decimal

Retail Price displayed on the App Store and charged to the customer.

Customer Currency

String

Three-character ISO code indicating the customer’s currency. For more information, visit Currency codes.

Developer Proceeds

Decimal

The proceeds for each subscription.

Proceeds Currency

String

The currency in which your proceeds are earned. For more information, visit Currency codes.

Preserved Pricing

String

For Renew events, if the price is preserved then this field equals “Yes”. Otherwise, it is blank.

Proceeds Reason

String

For Renew events, if the subscription has been active for more than a year then 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.

Subscription Offer Name

String

The promotional offer reference name or the offer code reference name used in App Store Connect when setting up the subscription offer.

Promotional Offer ID

String

An identifier that you set for your subscription offers in App Store Connect. For Promotional Offers this is the value entered in the Promotional Offer Reference Name field when setting up the offer. For one-time use offer codes, this is the value entered in the Offer Code Reference Name field when setting up the offer. For custom offer codes this is the code shared with your users.

State

String

State field in the address submitted by the customer when signing up for their Apple ID. This field is not validated and may be blank.

Country

String

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

Device

String

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

Client

String

If the subscription was purchased from News then this field equals “News”. Otherwise, it is blank.

Active Standard Price Subscriptions

Int

Total number of auto-renewable standard paid subscriptions currently active, excluding free trials, subscription offers, introductory offers, and marketing opt-ins. Subscriptions are active during the period for which the customer has paid without cancellation.

Active Free Trial Introductory Offer Subscriptions

Int

Total number of introductory offer subscriptions currently in a free trial.

Active Pay Up Front Introductory Offer Subscriptions

Int

Total number of introductory offer subscriptions currently with a pay up front introductory price.

Active Pay as You Go Introductory Offer Subscriptions

Int

Total number of introductory offer subscriptions currently with a pay as you go introductory price.

Free Trial Promotional Offer Subscriptions

Int

Total number of promotional offers currently in a free trial.

Pay Up Front Promotional Offer Subscriptions

Int

Total number of promotional offers with a pay up front promotional price.

Pay As You Go Promotional Offer Subscriptions

Int

Total number of promotional offers with a pay as you go promotional price.

Marketing Opt-Ins

Int

Total number of subscriptions currently in a marketing opt-in bonus period.

Billing Retry

Int

Total number of subscriptions in the Billing Retry status. This indicates that the App Store is still attempting to automatically renew a subscription when billing issues arise (for example, an expired credit card). Available in reports for dates starting December 7, 2017.

Grace Period

Int

Total number of subscriptions in the Billing Grace Period state. This indicates that subscriber can continue accessing your content for a certain period of time (6 or 16 days) while Apple attempts to correct the billing issue.

Free Trial Offer Code Subscriptions

Int

Total number of offer code subscriptions currently in a free trial.

Pay Up Front Offer Code Subscriptions

Int

Total number of offer code subscriptions with a pay up front offer price.

Pay As You Go Offer Code Subscriptions

Int

Total number of offer code subscriptions with a pay as you go offer price.

Subscribers

Int

The number of subscribers who have access to the auto-renewable subscription including entitled family members. Note that this field is only populated when the record represents more than 3 subscriptions. Learn more.

Sample Subscription Report

Subscription Name

Customer Price

Developer Proceeds

Proceeds Reason

Active Subscriptions

Active Free Trials

Active Pay Up Front Subscriptions

Active Pay As You Go Subscriptions

Marketing Opt-Ins

Billing Retry

1 Month Basic

11.99

8.4

364

48

10

0

0

23

1 Month Basic

11.99

10.2

Rate After One Year

208

0

0

0

0

0

1 Month Premium

17.99

12.6

194

33

23

17

0

0

A total of 572 active subscriptions (364 + 208) for “1 Month Basic” at the regular price of 11.99. There are also 10 subscriptions with a Pay Up Front Introductory Price and 23 subscriptions in a Billing Retry status. The 208 subscriptions have been active for more than a year and receive 85% of the customer price, minus applicable taxes, as indicated by the “Proceeds Reason” column equaling “Rate After One Year.”

267 active subscriptions for “1 Month Premium” at the 17.99 price. There are also a total of 73 subscriptions with an Introductory Price (33 + 23 + 17).

Subscription Name

Standard Subscription Duration

Promotional Offer Name

Promotional Offer ID

Active Standard Price Subscriptions

Active Free Trial Introductory Offer Subscriptions

Active Pay Up Front Introductory Offer Subscriptions

Active Pay As You Go Introductory Offer Subscriptions

Active Free Trial Introductory Offer Subscriptions

Active Pay Up Front Promotional Offer Subscriptions

Active Pay As You Go Promotional Offer Subscriptions

Billing Retry

1 Month Basic

1 month

1 Month Basic Winback Offer A

ExampleOfferIDa

0

0

0

0

0

32

0

0

1 Month Basic

1 month

1 Month Basic Winback Offer B

ExampleOfferIDb

0

0

0

0

0

0

45

0

The above example shows two different subscription offers for “1 Month Basic.” 32 active subscriptions are on the Pay Up Front “1 Month Basic Winback Offer A” and 45 are on the Pay As You Go “1 Month Basic Winback Offer B.”