Once imported, ChartMogul gives you complete visibility into your data as it exists in our platform through a series of data tables. To view these tables, navigate to Settings & Data > Sources, then select the source you want to view. Learn more about the data stored in each table and table column or export it to CSV.

• subscriber_id_reset — added to a customer that has reactivated after more than half a year in App Store Connect.
• ChartMogul adds the appname from subscriber reports as tags to customers.

Subscriber personal information such as name or email address

ChartMogul doesn’t store or report these data elements and uses a combination of the Vendor ID and Subscriber ID (and can be found in the External IDs section of the customer record) as the customer’s name. Read more.

Transaction and sales tax/VAT fees

ChartMogul can’t report on or deduct these from revenue metrics. You can, however, enable the Use Developer Proceeds instead of Customer Price for calculating MRR option.

Failed payments

ChartMogul can’t report these in the Failed Payments chart.

ChartMogul imports subscription-related data once every 24 hours.

ChartMogul does not import data at the same time each day. Therefore, data for a given App Store Connect source may be out-of-date by as much as 24 hours.

When ChartMogul generates an MRR movement 12 hours or more after the activity occurs in App Store Connect, it is not considered real-time and does not trigger a real-time email, Slack notification or webhook. Such delays may cause ChartMogul to generate an MRR movement after a daily recap email or Slack notification is sent, therefore excluding the update.

App Store Connect access tokens are only valid for 180 days.

Each time the access token expires, ChartMogul stops syncing with App Store Connect and displays an alert in the source configuration pop-up.

You will receive an in-app and email notification when the token expires. To restart syncing, generate a new access token and enter it in the Access Token field in the source configuration pop-up.

After entering the token, make sure to click on RE-SYNC in the pop-up.

App Store Connect only provides subscriber reports for the most recent 12 months.

During the initial import, ChartMogul can only import sales and refund transactions for customers who had an active subscription at some point in the previous 12 months.

• Customers with subscriptions that started more than 12 months ago (and are still active at the time of the initial import) will have a subscription state date of approx. 12 months ago.
  
  
• For example, if you added App Store Connect as a source on March 1, 2022, ChartMogul would import transactions from March 2021 onwards.
  
  
• A customer with an active subscription that started in January 2021 would have an approx. subscription start date of March 1, 2021.
  
  
• Customers whose subscriptions had expired before March 2021 would not be imported into ChartMogul.

After the initial import, however, if you manually re-sync your App Store Connect source, ChartMogul will retrieve and re-sync data for all of the transactions that have ever been imported.

Subscriber reports are sometimes delayed for several days.

When a report is not available, ChartMogul continues to check for the report as part of its daily sync. Once it’s available, ChartMogul imports the transactions and retroactively adjusts metrics as needed.

Not all transactions occurring on a specific day are included in that day’s subscriber report. Instead, they may be included in a future report.

ChartMogul imports the transactions and retroactively adjusts metrics as needed.

Subscriber reports don’t include cancellations, and there is no mechanism (e.g., webhook) through which subscription cancellation notifications are provided.

ChartMogul presumes all subscriptions are Active until:

• a refund has been processed within the subscription’s current service period,
• the subscription’s current service period ends without a renewal transaction, or
• no payment has been reported for more than three consecutive days after the expected renewal date.

ChartMogul then presumes the subscription has been canceled, changing its status and cancellation date accordingly and retroactively adjusting metrics as needed.

Subscriber reports don’t include plan switches.

ChartMogul reports plan switches as a cancellation followed by a reactivation. These activities may be grouped with Smart Activity Classification.

App Store Connect creates a Subscriber ID the first time a customer purchases a subscription, and the ID is used for subsequent purchases from the same customer.

However, after 180 days of inactivity, the Subscriber ID is deleted. If the same customer then re-subscribes, App Store Connect creates a new Subscriber ID and indicates that the ID has been reset for that customer.

ChartMogul creates a new customer record for each Subscriber ID it learns about. Therefore, when a former customer re-subscribers (after 180 days of inactivity), it creates a new customer with a new subscription instead of changing the existing customer’s status back to Active and classifying the MRR as Reactivation.

ChartMogul adds the subscriber_id_reset tag to these customers.