When we check the count for “Delivered” in the second API with the number of records from first APi, the counts do not match.
Can anyone help us know what is wrong? any pointers will be highly appreciated.
Data mismatch between Email event API and the Statistics API
one thing I’ve noticed is that there’s 2 sets of data coming back in the statistics API.
you’ll get a row for each time the email goes out. The big thing here is if you are sending out emails based on time zone, you’ll basically get one row for each time zone.
you’ll get a final row that wraps up the campaign information into one row. This will essentially be the sum of all rows from #1. You can identify this row by looking for the field: processingState and from what I can tell, it only comes in as: “processingState”: “DONE”