Fields listing for App Store Connect

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

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

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

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.

Get the App Id.

Get the App Name.

Year, month, and day.

Day of the year

Week of the year

The type of download event that occured.

The version of the app that was downloaded.

The Campaign Token of the campaign created in App Analytics. Column available starting November 19, 2024.

The total number of downloads.

The device on which the app was downloaded.

The name of the product page or in-app event page that led the user to download the app.

The page type from where the app was downloaded.

The version of the platform on which the app was downloaded.

A flag indicating whether the download came from a pre-order.

Additional information about the source from which the app was downloaded.

The source from which the app was downloaded.

The download territory.

The Campaign Token of the campaign created in App Analytics. Column available starting November 19, 2024.

The total number of engagement.

The device on which the app was engagement.

The name of the product page or in-app event page that led the user to download the app.

The page type from where the app was engagement.

The version of the platform on which the app was engagement.

Additional information about the source from which the app was engagement.

The source from which the app was engagement.

The download territory.

The type of engagement.

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

Total number of promotional offers currently in a free trial.

Hour of the day

A user viewed your app icon in a list alongside other apps, including in search results, charts, and the Today, Apps, and Games tabs. Page views are not included in these counts.

The version of the app that was downloaded.

The Campaign Token of the campaign created in App Analytics. Column available starting November 19, 2024.

The number of unique devices on which events were generated, based on users who have agreed to share their data with Apple and developers.

The device on which the app was downloaded.

The type of download event that occured.

The name of the product page or in-app event page that led the user to download the app.

The page type from where the app was downloaded.

The version of the platform on which the app was downloaded.

Additional information about the source from which the app was downloaded.

The source from which the app was downloaded.

The download territory.

The total number of install.

Month and day

Month of the year

The user was presented with a dedicated page for your app or in-app event.

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

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

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

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

The user was presented with a dedicated page for your app or in-app event. This includes views of the product page in the App Store, as well as views of the in-app event page in the App Store.

Quarter of the year

Get the content of the review.

Get the created date.

Get the review rating.

Get the nickname of the reviewer.

Get the review territory.

Get the review title.

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

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

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

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

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

The price of your auto-renewable subscription.

The proceeds for each subscription.

Date the event occurred.

The randomly generated Subscriber ID that's unique to each customer and developer. This field will be null when a customer requests a refund after the 180-day countdown described in Subscriber ID Reset.

If a customer cancels all of their subscriptions with you and does not resubscribe within 180 days, the Subscriber ID will be deleted. If the same customer resubscribes after 180 days, then we create a new Subscriber ID and this field equals “Yes.” Otherwise, it is blank.Subscriber IDs are reset when an app is transferred to another developer account.

Type of introductory price: Pay Up Front, Pay As You Go, or Free Trial.

Duration of the marketing opt-in if applicable: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year.

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

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

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.

For refunds, the date of the original purchase.

For full or partial refunds, this field equals “Yes.” Otherwise, it's blank. Refunds with a positive customer price imply a refund reversal.

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

Apple ID of your subscription.

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

Title of your subscription.

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.

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

The aggregated number of units. A value of 0 may indicate a partial refund.

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.

Apple ID of your subscription.

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.

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

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

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

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.

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

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

Date the report as been pulled

The proceeds for each subscription.

Type of event that occurred. For more information, visit Subscription events.

Apple ID of your subscription.

Reason for a cancellation: Billing issue, Price increase, Canceled, Removed from Sale, or Other. For more information, visit Cancellation reasons.

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

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

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.

The total number of paid periods that the subscription has been active without cancellation. This does not include free trials, marketing opt-in bonus periods, or grace periods.

Date the event occurred.

For cancel events, the number of days from the start date to when a subscriber canceled, which could be in the middle of the period. This only applies to cancel events where cancellation reason equals ‘canceled.' Otherwise, it is blank.

For reactivate events, the number of days ago that the subscriber canceled.

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

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

Duration of the opt-in if applicable: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year.

If the subscription included a marketing opt-in then this field equals “Yes”. Otherwise, it is blank.

Title of your subscription.

Duration of the introductory price if applicable. For example: 3 Days, 7 Days, 2 Weeks, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year.

Type of introductory price: Pay Up Front, Pay As You Go, or Free Trial

Date of the initial subscription purchase.

The estimated number of paid service days recovered due to Billing Grace Period.

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

For upgrade, downgrade, and crossgrade events, the Apple ID of the previous subscription.

For upgrade, downgrade, and crossgrade events, the title of the previous subscription.

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.

An identifier that you set for your subscription offers in App Store Connect. This is the value entered in the Promotional Offer Product Code field when setting up a subscription offer. For details on implementation, visit Generating a Signature for Promotional Offers.

The Promotional Offer Reference Name used in App Store Connect when setting up the offer.

Number of events with the same values for the other fields.

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

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.

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

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

Title of your subscription.

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

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

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.

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

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.

Duration of the introductory price if applicable: For example, 3 Days, 1 Week, 2 Weeks, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year.

Version number provided by you during app setup.

Indicates the primary category of the app, such as Games.

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

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.

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.

Get the sales created date.

The currency in which the customer is paid.

Three-character ISO code indicating the customer’s currency. Learn about currency codes.

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 Applications Agreement. Negative values indicate refunds or CMB credits for previously purchased apps when the CMB column shows "CMB-C’".

Provider name provided by you during the initial account setup.

Amount you receive per unit. This is the customer price minus applicable taxes and Apple’s commission, per Schedule 2 of your Paid Applications Agreement.

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

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.

Defines the duration of an auto-renewable subscription purchase: 7 days, 1 month, 2 months, 3 months, 6 months, and 1 year.

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

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.

Product identifier provided by you during app setup.

Defines the type of transaction (for example, initial download or update).

If the transaction was part of a promotion, this field will contain a value. This field is empty for all non-promotional items.

Service provider in your reports (typically Apple)

Service provider country code (typically U.S.).

Defines whether an auto-renewable subscription is new or a renewal. When a previous subscriber resubscribes, it's classified as a renewal.

List of platforms that your app supports: iOS, tvOS, iOS and tvOS, or macOS.

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.

The user tapped on an impression or page for your app or in-app event.

A user viewed your app icon in a list alongside other apps, including in search results, charts, and the Today, Apps, and Games tabs. Page views are included in these counts.

The total number of install.

A user viewed your app icon in a list alongside other apps, including in search results, charts, and the Today, Apps, and Games tabs. Page views are not included in these counts.

The user was presented with a dedicated page for your app or in-app event.

The user tapped on an impression or page for your app or in-app event.

Week of the year

Week of the year

Year such as 2017.

Year and month.

Year, month, day, and hour.

Year and quarter.

Year and week.