Introduction
Datasources and destinations
- Find all the data sources available at www.catchr.io/connectors
- Find all the destinations available at www.catchr.io/destinations
App Id Get the App Id. |
| ||||||
App Name Get the App Name. |
| ||||||
Year Year such as 2017. |
| ||||||
Year Quarter Year and quarter. |
| ||||||
Year month Year and month. |
| ||||||
Year week Year and week. |
| ||||||
Date Year, month, and day. |
| ||||||
Year month day hour Year, month, day, and hour. |
| ||||||
Quarter of the year Quarter of the year |
| ||||||
Month of the year Month of the year |
| ||||||
Week of the year Week of the year |
| ||||||
Month and day Month and day |
| ||||||
Day of the week Week of the year |
| ||||||
Day of the month Day of the year |
| ||||||
Hour of the day Hour of the day |
| ||||||
Review Rating Get the review rating. |
| ||||||
Review Title Get the review title. |
| ||||||
Review Content Get the content of the review. |
| ||||||
Review Reviewer Nickname Get the nickname of the reviewer. |
| ||||||
Review Created Date Get the created date. |
| ||||||
Review Territory Get the review territory. |
| ||||||
Summary Sales Service Provider Service provider in your reports (typically Apple) |
| ||||||
Summary Sales Service Provider Country Service provider country code (typically U.S.). |
| ||||||
Summary Sales Product Identifier Product identifier provided by you during app setup. |
| ||||||
Summary Sales Developer Name Provider name provided by you during the initial account setup. |
| ||||||
Summary Sales App Version Version number provided by you during app setup. |
| ||||||
Summary Sales Product Type Identifier Defines the type of transaction (for example, initial download or update). |
| ||||||
Summary Sales units 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. |
| ||||||
Summary Sales Customer Currency Three-character ISO code indicating the customer’s currency. Learn about currency codes. |
| ||||||
Summary Sales Country Code 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. |
| ||||||
Summary Sales Currency of Proceeds The currency in which the customer is paid. |
| ||||||
Summary Sales Customer Price 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’". |
| ||||||
Summary Sales Promo Code If the transaction was part of a promotion, this field will contain a value. This field is empty for all non-promotional items. |
| ||||||
Summary Sales Subscription Defines whether an auto-renewable subscription is new or a renewal. When a previous subscriber resubscribes, it's classified as a renewal. |
| ||||||
Summary Sales Period Defines the duration of an auto-renewable subscription purchase: 7 days, 1 month, 2 months, 3 months, 6 months, and 1 year. |
| ||||||
Summary Sales Category Indicates the primary category of the app, such as Games. |
| ||||||
Summary Sales CMB 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. |
| ||||||
Summary Sales Supported Platform List of platforms that your app supports: iOS, tvOS, iOS and tvOS, or macOS. |
| ||||||
Summary Sales Device Type of device used for purchase or redownload: iPhone, iPad, Apple TV, iPod touch, or Desktop. |
| ||||||
Summary Sales Preserve Pricing For Renew events, if the price is preserved then this field equals “Yes”. Otherwise, it’s blank. |
| ||||||
Summary Sales Proceeds Reason 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. |
| ||||||
Summary Sales Client Indicates where the purchase happened: App Store for iMessage, News, or blank. |
| ||||||
Summary Sales Order Type 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. |
| ||||||
Summary Sales Developer Proceeds (per unit) 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. |
| ||||||
Summary Sales Created Date Get the sales created date. |
| ||||||
Subscription Event Type of event that occurred. For more information, visit Subscription events. |
| ||||||
Subscription Event Name Title of your subscription. |
| ||||||
Subscription Event Apple ID Apple ID of your subscription. |
| ||||||
Subscription Event Group ID Your subscription’s Group ID (formerly Family ID). |
| ||||||
Subscription Event Standard Subscription Duration Duration of the standard subscription: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year. |
| ||||||
Subscription Event Offer Type Type of introductory price: Pay Up Front, Pay As You Go, or Free Trial |
| ||||||
Subscription Event Offer Duration 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. |
| ||||||
Subscription Event Marketing OptIn If the subscription included a marketing opt-in then this field equals “Yes”. Otherwise, it is blank. |
| ||||||
Subscription Event Marketing Opt-In Duration Duration of the opt-in if applicable: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year. |
| ||||||
Subscription Event Preserve Pricing For Renew events, if the price is preserved then this field equals “Yes”. Otherwise, it is blank. |
| ||||||
Subscription Event Proceeds Reason 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 Event Promotional Offer Name The Promotional Offer Reference Name used in App Store Connect when setting up the offer. |
| ||||||
Subscription Event Promotional Offer ID 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. |
| ||||||
Subscription Event Consecutive Paid Period 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. |
| ||||||
Subscription Event Original Start Date Date of the initial subscription purchase. |
| ||||||
Subscription Event Device Type of device used for initial subscription purchase: iPhone, iPad, Apple TV, iPod touch, or Desktop. |
| ||||||
Subscription Event Client If the subscription was purchased from News then this field equals “News”. Otherwise, it is blank. |
| ||||||
Subscription Event Client State 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. |
| ||||||
Subscription Event Client Country Two-character ISO country code indicating the App Store country or region for the purchase. For more information, visit Financial report regions and currencies |
| ||||||
Subscription Event Previous Subscription Name For upgrade, downgrade, and crossgrade events, the title of the previous subscription. |
| ||||||
Subscription Event Previous Subscription ID For upgrade, downgrade, and crossgrade events, the Apple ID of the previous subscription. |
| ||||||
Subscription Event Days Before Canceling 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. |
| ||||||
Subscription Event Cancellation Reason Reason for a cancellation: Billing issue, Price increase, Canceled, Removed from Sale, or Other. For more information, visit Cancellation reasons. |
| ||||||
Subscription Event Days Cancelled For reactivate events, the number of days ago that the subscriber canceled. |
| ||||||
Subscription Event Quantity Number of events with the same values for the other fields. |
| ||||||
Subscription Event Paid Service Days Recovered The estimated number of paid service days recovered due to Billing Grace Period. |
| ||||||
Subscription Event Date Date the event occurred. |
| ||||||
Subscription Name Title of your subscription. |
| ||||||
Subscription Apple ID Apple ID of your subscription. |
| ||||||
Subscription Group ID Your subscription’s Group ID (formerly Family ID). |
| ||||||
Standard Subscription Duration Duration of the standard subscription: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year. |
| ||||||
Subscription Promo Offer Name The promotional offer reference name used in App Store Connect when setting up the subscription offer. |
| ||||||
Subscription Promotional Offer ID 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. |
| ||||||
Subscription Customer Price Retail Price displayed on the App Store and charged to the customer. |
| ||||||
Subscription Customer Currency Three-character ISO code indicating the customer’s currency. For more information, visit Currency codes. |
| ||||||
Subscription Developer Proceeds The proceeds for each subscription. |
| ||||||
Subscription Proceeds Currency The currency in which your proceeds are earned. For more information, visit Currency codes. |
| ||||||
Subscription Preserved Pricing For Renew events, if the price is preserved then this field equals “Yes”. Otherwise, it is blank. |
| ||||||
Subscription Proceeds Reason 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 Client If the subscription was purchased from News then this field equals “News”. Otherwise, it is blank. |
| ||||||
Subscription Client Device Type of device used for subscription purchase: iPhone, iPad, Apple TV, iPod touch, or Desktop. |
| ||||||
Subscription Client State 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. |
| ||||||
Subscription Client Country Two-character ISO country code indicating the App Store country or region for the purchase. For more information, visit Financial report regions and currencies. |
| ||||||
Active Standard Price Subscriptions 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 Total number of introductory offer subscriptions currently in a free trial. |
| ||||||
Active Pay Up Front Introductory Offer Subscriptions Total number of introductory offer subscriptions currently with a pay up front introductory price. |
| ||||||
Active Pay as You Go Introductory Offer Subscriptions Total number of introductory offer subscriptions currently with a pay as you go introductory price. |
| ||||||
Free Trial Promotional Offer Subscriptions Total number of promotional offers currently in a free trial. |
| ||||||
Pay Up Front Promotional Offer Subscriptions Total number of promotional offers with a pay up front promotional price. |
| ||||||
Pay As You Go Promotional Offer Subscriptions Total number of promotional offers with a pay as you go promotional price. |
| ||||||
Subscription Marketing Opt-Ins Total number of subscriptions currently in a marketing opt-in bonus period. |
| ||||||
Subscription Billing Retry 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. |
| ||||||
Subscription Grace Period 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 Total number of offer code subscriptions currently in a free trial. |
| ||||||
Pay Up Front Offer Code Subscriptions Total number of offer code subscriptions with a pay up front offer price. |
| ||||||
Pay As You Go Offer Code Subscriptions Total number of offer code subscriptions with a pay as you go offer price. |
| ||||||
Subscribers 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. |
| ||||||
Subscription Date Date the report as been pulled |
| ||||||
Subscriber Subscription Name Title of your subscription. |
| ||||||
Subscriber Subscription Apple ID Apple ID of your subscription. |
| ||||||
Subscriber Subscription Group ID Your subscription’s Group ID (formerly Family ID). |
| ||||||
Subscriber Standard Subscription Duration Duration of the standard subscription: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year. |
| ||||||
Subscriber Subscription Promotional Offer Name The promotional offer reference name used in App Store Connect when setting up the subscription offer. |
| ||||||
Subscriber Subscription Promotional Offer ID 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. |
| ||||||
Subscriber Introductory Price Type Type of introductory price: Pay Up Front, Pay As You Go, or Free Trial. |
| ||||||
Subscription Subscription Offer Duration 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. |
| ||||||
Subscriber Marketing Opt-In Duration Duration of the marketing opt-in if applicable: 7 Days, 1 Month, 2 Months, 3 Months, 6 Months, or 1 Year. |
| ||||||
Subscriber Customer Price The price of your auto-renewable subscription. |
| ||||||
Subscriber Customer Currency Three-character ISO code indicating the customer’s currency. For more information, visit Currency codes. |
| ||||||
Subscriber Developer Proceeds The proceeds for each subscription. |
| ||||||
Subscriber Proceeds Currency The currency in which your proceeds are earned. For more information, visit Currency codes. |
| ||||||
Subscriber Preserved Pricing For Renew events, if the price is preserved then this field equals “Yes”. Otherwise, it is blank. |
| ||||||
Subscriber Proceeds Reason 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. |
| ||||||
Subscriber Client If the subscription was purchased from News then this field equals “News”. Otherwise, it is blank. |
| ||||||
Subscriber Client Device Type of device used for subscription purchase: iPhone, iPad, Apple TV, iPod touch, or Desktop. |
| ||||||
Subscriber Client Country Two-character ISO country code indicating the App Store country or region for the purchase. For more information, visit Financial report regions and currencies. |
| ||||||
Subscriber ID 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. |
| ||||||
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. |
| ||||||
Subscriber Refund For full or partial refunds, this field equals “Yes.” Otherwise, it's blank. Refunds with a positive customer price imply a refund reversal. |
| ||||||
Subscriber Units The aggregated number of units. A value of 0 may indicate a partial refund. |
| ||||||
Subscriber Purchase Date For refunds, the date of the original purchase. |
| ||||||
Subscriber Event Date Date the event occurred. |
| ||||||
Extracted Date The date where the extraction take times. |
| ||||||
Platform Name Return the platform name |
|
.svg){kind=logo}