Incorrect data from ONE_TIME_SNAPSHOT

Hi,

I need to calculate DAU, WAU, and MAU for our app and add these metrics to our corporate dashboard. To do this, I gathered data from App Sessions using the App Store Connect API.

A few days after requesting the reports, they were generated, and I was able to download them.

However, I noticed an issue: the data in the reports doesn't match across different granularities. The sum of sessions, unique devices, and total session duration varies across reports.

For example: sum of Total Session Duration is 52626 for DAILY report, 84553 for WEKLY and 155894 for MONTHLY

Is this expected behavior?

I’m struggling to understand why this inconsistency occurs.

Hi there. That's expected behavior, I'm afraid. If you're using different granularities, you'll have different results as the data will be calculated differently.

Have you tried comparing the API and data from App Store Connect console using the same aggregation?

Incorrect data from ONE_TIME_SNAPSHOT
 
 
Q