Skip to main content

​
Problem

The count of users who performed an event, like App/Site Opened on a particular day, differs between data warehouses and the MoEngage dashboard.

​
Explanation

There may be slight discrepancies due to the following reasons:
  • The data warehouse export uses event_time (when the event occurred), while MoEngage Analytics and Segmentation use server time (when the event was received at MoEngage servers).
  • When an event is exported, its associated user profile (user ID and attributes) is also exported. If a profile merge, deletion, or update occurs shortly after the event is picked for export, these changes will not be reflected in the exported event. However, new events will contain the updated profile attributes.
  • The report on the MoEngage Dashboard is in the App’s Timezone, while MoEngage Automated Data Exports happen in the UTC Timezone. This difference should be accounted for when you generate reports on your end.
MoEngage Analytics works on unique users, whereas Exports contain raw data for all exported events. For more information, read Analyze the Volume of Data Exports.
If the difference is more than 10%, you must investigate it for data loss or other errors.
MoEngage supports multiple data warehouses as destinations to forward events directly to your tables. The data warehouses supported are:
  • Amazon Redshift
  • Google BigQuery (via GCS)
  • Snowflake
MoEngage also supports multiple cloud storage as destinations to forward events as JSON files in your buckets. The cloud storage supported are:
  • Amazon S3
  • Google Cloud Storages
  • SFTP